81,094
社区成员
发帖
与我相关
我的任务
分享
public boolean mm(String user,String oldpsw,String newpsw){
String dlsql = "SELECT * FROM person WHERE user=? and psw=?";
String xgsql = "UPDATE person SET psw=? WHERE user=?";
boolean flag = false;
try{
stmt = conn.prepareStatement(dlsql);
stmt.setString(1,user);
stmt.setString(2,oldpsw);
rs = stmt.executeQuery();
if(rs.next()){
stmt.close();
stmt = conn.prepareStatement(xgsql);
stmt.setString(1,newpsw);
stmt.setString(2,user);
int k = stmt.executeUpdate();
if(k > 0){
flag = true;
}else{
flag = false;
}
}
}catch(Exception e){
System.out.println("修改异常");
System.err.println(e.getMessage());
}
return flag;
}