bussusermanager.java

一个小公司要求给写的很简单的任务管理系统。

package com.wykj.buss;


import java.util.*;
import java.sql.*;
import com.wykj.model.*;
import com.wykj.database.ConnectDB;
import com.wykj.util.Util;
public class BussUserManager{
  Connection conn = null;
  public BussUserManager() {

  }

  public ArrayList getUserList(String userName,String password){
    ArrayList list = new ArrayList();
     Statement stmt = null;
     ResultSet rset = null;
    try {
      conn = new ConnectDB().getConnection();
      stmt = conn.createStatement();
      String sql = "select * from 用户表  where 1=1 ";
      if (userName != null){
        sql += "and 姓名='"+userName+"' and 密码='"+password+"'";
      }
      System.out.println(sql);
       rset = stmt.executeQuery(sql);
      while (rset.next()){
        UserModel um = new UserModel();
        um.setUserID(rset.getString(1));
        um.setUserName(rset.getString(2));
        um.setFlag(rset.getString(3));
        um.setPassword(rset.getString(4));
        list.add(um);
      }
    }catch (Exception ex) {
      System.out.print("BussUserManager.getUserList 读取用户表错误！");
    }finally {
      try {
        if (rset != null)rset.close();
      }catch (Exception ex){
      }
      try {
        if (stmt != null)stmt.close();
     }catch (Exception ex){

     }
     try {
      if (conn != null)conn.close();
     }catch (Exception ex){
     }

    }
    return list;
  }

}