p219au100dao.java

来自「wincvs 的使用配置的东西」· Java 代码 · 共 82 行

/* **************************************************************** */
/* System Name : 億乕僞儖仌僌儖乕僾僂僄傾僾儘僕僃僋僩
 * File   Name : 僐儞僥儞僣偺僷僗曄姺僣乕儖(p129aw009DAO.java)
 * Compiler    : JDK 1.5.0
 * Description : 僆儔僋儖僷僗儚乕僪曄峏張棟僋儔僗
 * ----------------------------------------------------------------
 * Modification History
 * Date         Name            Description
 * -----------  --------------  -----------------------------------
 * 2007/11/XX                   Initial Release
 * ----------------------------------------------------------------
 */
/* **************************************************************** */
package model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class p219au100DAO {

  private String uid;  //僆儔僋儖儐乕僓ID
  private String new_pwd;  //怴乮曄峏屻乯僷僗儚乕僪

  /******************************************************************
   * 怴乮曄峏屻乯僷僗儚乕僪傪庢摼偡傞
   * @return new_pwd 怴乮曄峏屻乯僷僗儚乕僪
   * @version
   ******************************************************************/
  public String getNewPwd() { return new_pwd; }
  /******************************************************************
   * 怴乮曄峏屻乯僷僗儚乕僪傪愝掕偡傞
   * @param new_pwd 怴乮曄峏屻乯僷僗儚乕僪
   * @version
   ******************************************************************/
  public void setNewPwd(String new_pwd) { this.new_pwd = new_pwd; }
  /******************************************************************
   * 僆儔僋儖儐乕僓ID傪庢摼偡傞
   * @return uid 僆儔僋儖儐乕僓ID
   * @version
   ******************************************************************/
  public String getUid() { return uid; }
  /******************************************************************
   * 僆儔僋儖儐乕僓ID傪愝掕偡傞
   * @param uid 僆儔僋儖儐乕僓ID
   * @version
   ******************************************************************/
  public void setUid(String uid) { this.uid = uid; }


  /******************************************************************
   * Truncate張棟
   * @param con Connection
   * @return boolean Truncate張棟僗僥乕僞僗抣
   * @throws exception Exception 幚峴帪僄儔乕
   * @version
   ******************************************************************/
  public boolean dat_updusrDAO(Connection con) throws Exception {
    //
    PreparedStatement pstmt = null;
    try {
      String  SQL_ALTER_USER_PWD = " alter user "+this.getUid()+" identified by  "+this.getNewPwd();
      pstmt = con.prepareStatement(SQL_ALTER_USER_PWD);
      // 峏怴SQL偺幚峴
      int cnt = pstmt.executeUpdate();
      return true;
    }
    catch (SQLException ext){
      ext.printStackTrace();
      return false;
    }
    finally {
      try {
        if (pstmt != null) {
           pstmt.close();
        }
      }
      catch (Exception e) {}
    }
  }
}