hr.java

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

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

/**
 * @author lxj
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */

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


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


public class Hr {
//	--------------------------------------------------------- Instance Variables

	private int project;
	
	private int user;
	
	private String Role;

	private String responsibility;
			
	private int isAvailable;

	private String username;
	private String name;

	 
	private static Logger logger = Logger.getLogger ("User") ;

	private SqlDB dbf;
	private ResultSet rs;

    //增加一个关闭resultset与SqlDB的方法
	private void close()
	{
		try
		{
			if(rs!=null) rs.close();
			logger.debug("close the resultset");
			if(dbf!=null) dbf.close();
			logger.debug("close the sqldb");
		}
		catch(SQLException sqle)
		{
			logger.error("Close SqlDB error: "+sqle.getMessage());
		}
	}	
     
     public void createHr(HrForm theHrForm,int projectid) {
		
		try{
			//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
			//Get an instance reference to the DbFacade object
			dbf = new SqlDB();
			
			
			
			//String pmID = getAField("employee","userID","Name='" + theUserForm.getPM() +"'");
			//String departmentID = getAField("department","departID ","departName='" + theUserForm.getDepartID() +"'");

			dbf.setSql("INSERT INTO `projectMember` VALUES (?,?,?,?,?)");
		    
		    	dbf.setInt(1,projectid);
			dbf.setInt(2,theHrForm.getUser());
			dbf.setString(3,theHrForm.getRole());
			dbf.setString(4,theHrForm.getResponsibility());
			dbf.setInt(5,1);
			//dbf.setString(5,"R&D");
			dbf.execute();
			//List results of changes.  
			
			logger.info("user" + theHrForm.getUser() + "is created");
		}
		catch (Exception e)   	
		{
			logger.error("Exception in createHr:" + e.getMessage());
		}finally
		{
			close();
		}
     }

	public void getHrInfor(int project,int userID) {
		try{
					//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
					//Get an instance reference to the DbFacade object
					dbf = new SqlDB();
					
			       String sql = "SELECT Role,responsibility from projectMember where project='" + project
			              +"' and user='" + userID + "' ";
							
					rs=dbf.executeQuery(sql);	
					logger.info("executeQuery" + sql + "in getHrInfor");			
			
					if (rs.next())
					{
						this.project = project;
						this.user = userID;
						this.Role = rs.getString("Role");
						this.responsibility = rs.getString("responsibility"); 
					}
					sql = "select name from employee where userID='" + userID + "' ";
					ResultSet rs1 = null;
					rs1=dbf.executeQuery(sql);	
					logger.info("executeQuery" + sql + "in getHrInfor");			
			
					if (rs1.next())
					{
						this.name = rs1.getString("name");
					}
			}
			catch (Exception e)   	
			{
				logger.error("Exception in getUserInfor:" + e.getMessage());
			}finally
		        {
			       close();
		        }
	}

	public void updateHr(HrForm theHrForm,int projectid) {
		try{
					//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
					//Get an instance reference to the DbFacade object
					dbf = new SqlDB();
					String sql = "update projectMember set Role = '" + theHrForm.getRole() + "',";
					sql += "responsibility = '" + theHrForm.getResponsibility() ;
					sql += "' where user = " + theHrForm.getUser() + " and project=" + projectid;
					
					logger.info("------before execute:" + sql + "in updateHr");
					dbf.setSql(sql);
					dbf.execute();	
					
					logger.info("-----after execute:" + sql + "in updateHr");											
			}
			catch (Exception e)   	
			{
				logger.error("Exception in getHrInfor:" + e.getMessage());
			}finally
		        {
			       close();
		        }
	}

	public void delHr(int userID,int projectid) {
		try{
					//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
					//Get an instance reference to the DbFacade object
					dbf = new SqlDB();
					System.out.println("before executeQuery");
					String sql = "update projectmember set isAvailable=0 where user= " + userID + " and project=" + projectid;
					dbf.setSql(sql);
					dbf.execute();	
					
					logger.info("execute" + sql + "in delHr");								
			}
			catch (Exception e)   	
			{
				logger.error("Exception in getHrInfor:" + e.getMessage());
			}finally
		        {
			       close();
		        }
	}
	

	public int getProject() {
		return project;
	}

	public void setProject(int project) {
		this.project = project;
	}

	 public int getUser() {
		 return user;
	 }

	
	 public void setUser(int user) {
		 this.user = user;
	 }
	 
	public String getRole() {
		return Role;
	}

	
	public void setRole(String Role) {
		this.Role = Role;
	}

	public String getResponsibility() {
		return responsibility;
	}
	
	public void setResponsibility(String responsibility) {
		this.responsibility = responsibility;
	}

	public int getIsAvailable() {
		return isAvailable;
	}

	public void setIsAvailable(int isAvailable) {
		this.isAvailable = isAvailable;
	}
	
	 public String getUsername() {
		 return username;
	 }

	
	 public void setUsername(String username) {
		 this.username = username;
	 }

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

}