/**
* 修改密码
*
* @param tableName
* @param username
* @param password
*/
public void fogetPwd(final String tableName, final String username, final String password) {
String procedure = "{call " + SP_PERSON_INFO_FORGET_PWD + "(?, ?, ?)}";
SqlExecuteUtil.executeProcedure(
procedure,
new Object[] {tableName, username, password},
new ProcedureExecutor() {
@Override
public void execute(CallableStatement stmt) throws SQLException {
stmt.execute();
}
});
}
/** 删除心情提醒 */
public void deleteMoodTips(int pid) {
String procedure = "{call " + SP_MOOD_TIPS_DELETE_BY_PID_AND_TYPE + "(?, ?)}";
SqlExecuteUtil.executeProcedure(
procedure,
new Object[] {pid, 1},
new ProcedureExecutor() {
@Override
public void execute(CallableStatement stmt) throws SQLException {
stmt.execute();
}
});
}
/**
* 修改密码
*
* @param pid
* @param pwd 密码
*/
public void modifyPassword(final int pid, final String pwd) {
String procedure = "{call " + SP_PERSON_INFO_MODIFY_PWD + "(?, ?)}";
SqlExecuteUtil.executeProcedure(
procedure,
new Object[] {pid, pwd},
new ProcedureExecutor() {
@Override
public void execute(CallableStatement stmt) throws SQLException {
stmt.execute();
}
});
}