예제 #1
0
  /**
   * 修改密码
   *
   * @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();
          }
        });
  }
예제 #2
0
  /** 删除心情提醒 */
  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();
          }
        });
  }
예제 #3
0
  /**
   * 修改密码
   *
   * @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();
          }
        });
  }