Question

加上while(rs.next()) 就出提取违反顺序 错误

public String del(Vector<String> v)
{

//从连接池获取数据库连接
conn= StartConPoolBean.connPool.getConnection();
//SQL 语句
String querySQL = "DELETE BASE_USER WHERE USER_ID = ?";

try {

ps = conn.prepareStatement(querySQL);

// 参数赋值 迭代器
Iterator<String> 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 "删除成功";
}
提取违反顺序 该怎么改啊？

Answer 1

while(rs.hasNext()){
　　rs.next();
　　}