public void changeData(Connection con){
try {
System.out.println("开始改变数据");
Statement stm=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE , ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stm.executeQuery("select * from student");
rs.next();
rs.updateInt(1,100);
rs.updateString(2, "Tom");
rs.updateString(3, "true");
rs.updateString(4, "cs");
rs.updateRow();
System.out.println("改变数据结束");
} catch (SQLException e) {
e.printStackTrace();
}
}
会报出错误java.sql.SQLException: 对只读结果集的无效操作: updateInt
select sid,sname,agender,sdept from scott.student