usermanager.java

资金源码管理系统,用java开发的,有用的人可以试试看

package asset;

import java.sql.*;

/**
 * 此类用于用户登录及用户信息管理控制
 */
public class UserManager {

  // 表示与数据库的连接
  private Connection con = ConnectionManager.getConnection();

  // 表示执行静态 sql 语句的对象
  private Statement stmt;

  // 表示返回的结果集
  private ResultSet rs;

  // 表示执行的 sql 语句
  private StringBuffer sql;

  // 此方法用于判断用户是否是合法用户
  public boolean canLoad(String name, String pwd) throws SQLException {
    // 标志能否登录
    boolean flag = false;

    stmt = con.createStatement();
    rs = stmt.executeQuery("select pwd from OPERATOR where name='" + name + "'");

    while (rs.next()) {
      String pwd1 = rs.getString(1);
      if (pwd1.equals("")) {
        return flag;
      }
      else {
        if (pwd1.equals(pwd)) {
          flag = true;
        }
      }
    }
    ConnectionManager.closeResultSet(rs);
    ConnectionManager.closeStatement(stmt);
    return flag;
  }
  // 此方法用于添加新用户
  public void addToOperator(String name,String pwd) throws SQLException {
      sql = new StringBuffer("insert into operator(name,pwd) values('"+name+"','"
            +pwd+"')");
      System.out.println(sql.toString());
      stmt = con.createStatement();
      stmt.executeUpdate(sql.toString());
      ConnectionManager.closeResultSet(rs);
      ConnectionManager.closeStatement(stmt);
  }

  // 此方法用于修改用户信息
  public void updateOperator(String name,String pwd) throws SQLException {
      sql = new StringBuffer("update operator set pwd = '"+pwd+"' where name = '"+name+"'");
      stmt = con.createStatement();
      stmt.executeUpdate(sql.toString());
      ConnectionManager.closeResultSet(rs);
      ConnectionManager.closeStatement(stmt);
    }
}