Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from asd");
while (rs.next()){
rs.updateDouble("c",5);
rs.updateRow();
}
ResultSet rs=stmt.executeQuery("select * from asd");
while (rs.next()){
rs.updateDouble("c",5);
rs.updateRow();
}
我改的程序如下:
/* Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("SELECT * FROM xingming");
while (rs.next()){
if(rs.getInt("学号")==Integer.parseInt(s1)){
rs.updateString("姓名", s2);
rs.updateString("性别", s3);
rs.updateInt("成绩", Integer.parseInt(s4));
rs.updateString("地址", s5);
rs.updateRow();
}
}*/