jsp按条件修改数据库信息,根据学生的ID,修改学生的姓名,性别等信息。java代码部分,求高手帮助

2025-04-18 15:43:24
推荐回答(1个)
回答1:

public boolean updUser(Connection conn,UserForm form) throws SQLException{
Statement stmt = null;

try{
conn.setAutoCommit(false);
stmt = conn.createStatement();
stmt.executeUpdate("update user " +
"set name='"+form.getName()+"',"+
"cunkuanjine='"+form.getCunkuanjine()+"',"+
"cunkuanriqi='"+form.getCunkuanriqi()+"',"+
"sex='"+form.getSex()+"',"+
"qukuanjine='"+form.getQukuanjine()+"',"+
"qukuanriqi='"+form.getQukuanriqi()+"' where id="+form.getId());

stmt.close();
conn.commit();
conn.setAutoCommit(true);
return true;
}catch(SQLException e){
e.printStackTrace();
conn.rollback();
conn.setAutoCommit(true);
return false;
}

}

一个修改用户的方法,两个参数,一个是jdbc Connection 对象,一个是存有用户属性的form,根据你自己的需要改一改吧