userlist.java

本人课程设计时做的一个用struts框架实现的基于cmmi2的项目管理系统的原型。还有部分功能尚未实现

/*
 * Created on 2004-4-18
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.cmmi2pms.sa.user;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;


import com.cmmi2pms.common.comdb.*;
import org.apache.log4j.Logger;

/**
 * @author lxj
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class UserList {
	
	private User[] users;
	
	private static Logger logger = Logger.getLogger ("UserList") ;
	
	public void getAllUser(){
		try{
			
			//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
			//Get an instance reference to the DbFacade object
			SqlDB dbf = null;
			dbf = new SqlDB();
			ResultSet rs = null;
			String sql = "SELECT userID,password,username,permission,name,employee.departID,DepartName,position,email,phone,mobile "
			              + "from employee,department where employee.departID=department.departID and isAvailable>0 order by userid";
			rs=dbf.executeQuery(sql);
			
			
			int rowNum = 0;
			ArrayList userArrayList = new ArrayList();
			while ((rs.next())){				
				User aUser = new User();
				Integer rowNumInt = new Integer(rowNum);
				System.out.println(rowNumInt.toString());	
				aUser.setUserID(rs.getInt("userID"));
				aUser.setUsername(rs.getString("username"));
				aUser.setPassword(rs.getString("password"));
				aUser.setPermission(rs.getString("permission"));
				aUser.setName(rs.getString("name"));
				aUser.setDepartID(rs.getInt("departID"));
				aUser.setDepartName(rs.getString("DepartName"));
				aUser.setPosition(rs.getString("position"));
				aUser.setEmail(rs.getString("email"));
				aUser.setPhone(rs.getString("phone"));
				aUser.setMobile(rs.getString("mobile"));
				userArrayList.add(aUser);		
				rowNum++;
				//System.out.println("rowNum:" + rowNum);	
			}
			users = new User[userArrayList.size()];
			userArrayList.toArray(users);
		/*
			users = new User[rowNum];					
	
			rs.beforeFirst();
			User aUser = new User();
			for (int i = 0; i < rowNum; i++)
			{
				aUser = new User();
				aUser.setUserID(rs.getString("userID"));
				aUser.setUserName(rs.getString("userName"));
				aUser.setStartTime(rs.getString("description"));
				users[i] = aUser;			
			}
		*/
		}
		catch (Exception e)   	
		{
			logger.error("Exception in getAllUser:" + e.getMessage());
		}
				
	}

	public User[] getUsers(){
		return users;
	}
	
	public void setUsers(User[] theUsers){
			this.users = theUsers;
	}
	 

}