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

来源:学生作业帮助网 编辑:作业帮 时间:2024/04/28 08:31:22
加上while(rs.next()) 就出提取违反顺序 错误public String del(Vector v){//从连接池获取数据库连接conn= StartConPoolBean.connPool.getConnection();//SQL 语句String querySQL =

加上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();
  }