usermanager.java~31~

来自「小型超市进销存系统 登录界面 进货登记 销售登记 库存查询 jbu」· JAVA~31~ 代码 · 共 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 (resultSet != null) {
            try {
              resultSet.close();
            } catch (Exception exception) {}
          }
          if (statement != null) {
            try {
              statement.close();
            } catch (Exception exception) {}
          }
          if (connection != null) {
            try {
              connection.close();
            } catch (Exception exception) {}
          }

        }


    return true;
  }
}