JDBC--这段修改语句显示执行成功,但是数据库的数据并没有改变,求指教
public int[] updates(int[] nums) throws SQLException, ClassNotFoundException{
link();
String sql="update grade set gradeid=gradeid+1 where gradeid=?";
pstmt=con.prepareStatement(sql);
for (int i = 0; i < nums.length; i++) {
pstmt.setInt(1,nums[i]);
pstmt.addBatch();
}
int[] num=pstmt.executeBatch();
close();
return num;
}
public static void main(String[] args) throws ClassNotFoundException, SQLException {
int[] nums={93,21};
StusDao sd=new StusDao();
int[] num=sd.updates(nums);
System.out.println(num);
for (int i = 0; i < num.length; i++) {
System.out.println(num[i]);
}
}