81,122
社区成员




String selsql = "select * from login where username = ? and password = ?";
Connection con = DBTool.getConnection();
PreparedStatement selstm = con.prepareStatement(selsql);
String username = ActionContext.getContext().getSession()
.get("username").toString();
System.out.println(username);
selstm.setString(1, username);
selstm.setString(2, this.getOldpwd());
ResultSet selrs = selstm.executeQuery();
if (selrs.next()) {
System.out.println("存在此用户");
String updatesql = "update login set password = '?' where username = '?'";
PreparedStatement updatestm = con.prepareStatement(updatesql);
updatestm.setString(1, this.getNewpwd2());
updatestm.setString(2, username);
System.out.println(updatesql);
int num = updatestm.executeUpdate(updatesql);
System.out.println(num);
if (num == 1) {
System.out.println("修改成功");
return SUCCESS;
} else {
System.out.println("修改失败");
return ERROR;
}
} else {
System.out.println("原始密码错误");
return ERROR;
}
String selsql = "select * from login where username = ? and password = ?";
String selsql = "select * from login where username=? and password=?";
public String execute() throws Exception {
String selsql = "select * from login where username = ? and password = ?";
Connection con = DBTool.getConnection();
PreparedStatement selstm = con.prepareStatement(selsql);
String username = ActionContext.getContext().getSession()
.get("username").toString();
System.out.println(username);
selstm.setString(1, username);
selstm.setString(2, this.getOldpwd());
ResultSet selrs = selstm.executeQuery();
if (selrs.next()) {
System.out.println("存在此用户");
String updatesql = "update login set password = ? where username = ?";
PreparedStatement updatestm = con.prepareStatement(updatesql);
updatestm.setString(1, this.getNewpwd2());
updatestm.setString(2, username);
System.out.println(updatesql);
int num = updatestm.executeUpdate(updatesql);
System.out.println(num);
if (num == 1) {
System.out.println("修改成功");
return SUCCESS;
} else {
System.out.println("修改失败");
return ERROR;
}
} else {
System.out.println("原始密码错误");
return ERROR;
}
}