执行
rs = st.executeQuery("select TASK_CODE,TASK_NAME from TASK where TASK_ID="+task_id);
list.add(rs.getString(1));
list.add(rs.getString(2));
抛异常:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor position.
改为这样就好了:
rs = st.executeQuery("select TASK_CODE,TASK_NAME from TASK where TASK_ID="+task_id);
while(rs.next()){
list.add(rs.getString(1));
list.add(rs.getString(2));
}
原因:
虽然"select TASK_CODE,TASK_NAME from TASK where TASK_ID="+task_id查询的结果就一条,
但默认的是游标在第一条记录之前,所以要访问第一条纪录,需要先rs.next();