employee.java

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

package com.cmmi2pms.sa.user;

/**
 * @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 org.apache.log4j.Logger;


public class Employee {
//	--------------------------------------------------------- Instance Variables

	
	 private String userID;
	 
	 private String name;
	 
	 private String password;
     private String permissions;
     private String userName;
     private String depart;
     private String position;
     private String email;
     private String phone;
     private String mobile;
     
     
     private static Logger logger = Logger.getLogger ("Employee") ;
     
     public void getUserInforByUserName(String userName) {
		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,name,permission,password ";
					sql += "from employee ";
					sql += " where username ='" + userName  + "'";
					rs=dbf.executeQuery(sql);	
					logger.info(" getUserInforByUserName" + sql);				
			
					if (rs.next())
					{
						this.userID = rs.getString("userID");
						this.name = rs.getString("name");
						this.userName = userName;
						this.permissions = rs.getString("permission");
						this.password = rs.getString("password");						    					
					}
			}
			catch (Exception e)   	
			{
				logger.error("Exception in getUserInforByUserName:" + e.getMessage());
			}
	}


	//private AddProjectForm theProjectForm;

	 // --------------------------------------------------------- Methods
    /* 
     
     
     public void createDepart(ProjectForm theProjectForm) {
		
		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();
			
			java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd",java.util.Locale.CHINA);
	
			java.util.Date d = sdf.parse(theProjectForm.getStartDate());  
	
			java.sql.Date startDate = new java.sql.Date(d.getTime());
			
			d = sdf.parse(theProjectForm.getEndDate());  
	
			java.sql.Date endDate = new java.sql.Date(d.getTime());
			
			String pmID = getAField("employee","userID","Name='" + theProjectForm.getPM() +"'");
			String departmentID = getAField("department","departID ","departName='" + theProjectForm.getDepartID() +"'");

			dbf.setSql("INSERT INTO `project` VALUES (?,?,?,?,?,?,?,?,?)");
		    
		    System.out.println("before sql");
			
			dbf.setString(1,theProjectForm.getProjectID());
			dbf.setString(2,theProjectForm.getProjectName());
			dbf.setInt(3,Integer.parseInt(departmentID));
			dbf.setInt(4,Integer.parseInt(theProjectForm.getBudget()));
			dbf.setInt(5,Integer.parseInt(pmID));
			dbf.setString(6,theProjectForm.getDescription());
			dbf.setDate(7,startDate);
			dbf.setDate(8,endDate);
			dbf.setString(9,theProjectForm.getStage());
			//dbf.setString(5,"R&D");
			dbf.execute();
			//List results of changes.  
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createProject:" + e.getMessage());
		}
     }
     
	public void getProjectInfor(String projectID) {
		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 projectID,projectName,description,DepartName,starttime,name,stage FROM project,employee,depart ";
					//sql = sql + " where project.PM = employee.userID and project.depart = depart.departID and projectID = '" + projectID + "'";
					System.out.println("before executeQuery");
					String sql = "SELECT name,DepartName, projectID,projectName,Description,StartDate,endDate,Stage,Budget";
					sql += "FROM project,employee,department where project.PM = employee.userID and project.depart=department.departID  order by startDate";
					rs=dbf.executeQuery(sql);	
					System.out.println("after executeQuery");				
			
					if (rs.next())
					{
						this.projectID = projectID;
						this.projectName = rs.getString("projectName");
						this.PM = rs.getString("name");
						this.startDate = rs.getString("startDate");
						this.endDate = rs.getString("endDate");
						this.description = rs.getString("description"); 
						this.stage = rs.getString("stage"); 
						this.depart = rs.getString("DepartName");
        				this.budget = rs.getString("Budget");        					
					}
			}
			catch (Exception e)   	
			{
				System.out.println("Exception in getProjectInfor:" + e.getMessage());
			}
	}
	
	
	public void delProject(String projectID) {
		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;
					System.out.println("before executeQuery");
					String sql = "delete FROM project where projectID = '" + projectID + "'";;
					dbf.setSql(sql);
					dbf.execute();	
					System.out.println("after executeQuery");					
			}
			catch (Exception e)   	
			{
				System.out.println("Exception in getProjectInfor:" + e.getMessage());
			}
	}
	
	*/

	 /** 
	  * Returns the projectName.
	  * @return String
	  */
	 public String getName() {
		 return name;
	 }

	 /** 
	  * Set the projectName.
	  * @param projectName The projectName to set
	  */
	 public void setName(String name) {
		 this.name = name;
	 }

		 
	public String getUserID() {
			 return userID;
	}
    
	public void setUserID(String userID) {
				 this.userID = userID;
	}	
	
	public String getUserName() {
			 return userName;
	}
    
	public void setUserName(String userName) {
				 this.userName = userName;
	}	
	
	public String getPassword() {
			 return password;
	}
    
	public void setPassword(String password) {
				 this.password = password;
	}	
	
	public String getPermissions() {
			 return permissions;
	}
    
	public void setPermissions(String permissions) {
				 this.permissions = permissions;
	}	
	
	public String getPosition() {
			 return position;
	}
    
	public void setPosition(String position) {
				 this.position = position;
	}	
	
	public String getDepart() {
			 return depart;
	}
    
	public void setDepart(String depart) {
				 this.depart = depart;
	}	
	
	public String getPhone() {
			 return phone;
	}
    
	public void setPhone(String phone) {
				 this.phone = phone;
	}	
	
	public String getMobile() {
			 return mobile;
	}
    
	public void setMobile(String mobile) {
				 this.mobile = mobile;
	}	
	
	public String getEmail() {
			 return email;
	}
    
	public void setEmail(String email) {
				 this.email = email;
	}	

}