usermanager.java~35~

来自「这是本人刚刚得到的JBuilder9软件开发项目实践的源码」· JAVA~35~ 代码 · 共 76 行

package jxc;

/**
 * <p>Title: jxc demo</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author cwx
 * @version 1.0
 */

import java.sql.*;

public class UserManager {
  public UserManager() {
  }

  /**
   * 处理用户登录
   * @param strName 用户名称
   * @param strPwd  密码
   * @return 登录是否成功
   */
  static public boolean login(String strName, String strPwd){
    Connection conn = null;
    PreparedStatement stmt = null;
    ResultSet rs = null;

    try {
      conn = ConnectionManager.getConnection();
      stmt = conn.prepareStatement("select * from User where name=?");

      stmt.setString(1, strName);
      rs = stmt.executeQuery();
      if (rs.next()) {
        String strPwd2 = rs.getString("pwd");
        strPwd2.trim();
        //检查密码
        if (!strPwd2.equals(strPwd)) {
          System.err.println(strName+"密码错误!");
          return false;
        }

        //验证通过
        return true;
      }
      else {
        System.err.println(strName+"用户不存在!");
        return false;
      }
    }
    catch (java.sql.SQLException e) {
      System.err.println(e);
    }
    finally {
      if (rs != null) {
        try {
          rs.close();
        } catch (Exception exception) {}
      }
      if (stmt != null) {
        try {
          stmt.close();
        } catch (Exception exception) {}
      }
      if (conn != null) {
        try {
          conn.close();
        } catch (Exception exception) {}
      }
    }


    return true;
  }
}