加上while(rs.next()) 就出提取违反顺序 错误public String del(Vector v){//从连接池获取数据库连接conn= StartConPoolBean.connPool.getConnection();//SQL 语句String querySQL = "DELETE BASE_USER WHERE USER_ID = ?"; 

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/01 16:32:16
加上while(rs.next()) 就出提取违反顺序 错误public String del(Vector v){//从连接池获取数据库连接conn= StartConPoolBean.connPool.getConnection();//SQL 语句String querySQL =
xTQkP~ҧj:6p0k>,;a&ΎQ(T9:+Zencc%i:Ej$99wMIz`An@) [4qg?:rJKEYF-PTlWU~k"XcolqLIAaPv&wm8IȰHAƉlIyK@dx1zlZ`b #\5_lh=x!MȈ'k8RC+C1(<”(:qya|*_7a=!fPCZh1oeq.@r3.vDqڈbpKE$X f1D1kBocC&qUi0 ~RuEVi0l#:ȘOoHa9ܶT͕  s%G F\JNwy0He g0X @W41mռ3[JjN* {'{*!#JRs?7H

加上while(rs.next()) 就出提取违反顺序 错误public String del(Vector v){//从连接池获取数据库连接conn= StartConPoolBean.connPool.getConnection();//SQL 语句String querySQL = "DELETE BASE_USER WHERE USER_ID = ?"; 
加上while(rs.next()) 就出提取违反顺序 错误
public String del(Vector v)
{
//从连接池获取数据库连接
conn= StartConPoolBean.connPool.getConnection();
//SQL 语句
String querySQL = "DELETE BASE_USER WHERE USER_ID = ?";

 try {

ps = conn.prepareStatement(querySQL);

// 参数赋值 迭代器
Iterator it = v.iterator();

ps.setString(1, it.next());


// 结果集
ResultSet rs = ps.executeQuery();
while(rs.next())
{

rs.getString("USER_ID");
}

// 关闭
StartConPoolBean.connPool.free(rs, ps, conn);

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return "无法删除";
}
return "删除成功";
}
提取违反顺序 该怎么改啊?

加上while(rs.next()) 就出提取违反顺序 错误public String del(Vector v){//从连接池获取数据库连接conn= StartConPoolBean.connPool.getConnection();//SQL 语句String querySQL = "DELETE BASE_USER WHERE USER_ID = ?"; 
while(rs.hasNext()){
  rs.next();
  }