project.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.sa.project;

/**
 * @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 Project {
//	--------------------------------------------------------- Instance Variables

	 /** projectID property */
	 private String projectID;
	 
	 private String projectCode;

	 /** description property */
	 private String description;

	 /** startTime property */
	 private String startDate;
	 
	 private String endDate;

	 /** stage property */
	 private String stage;

	 /** projectName property */
	 private String projectName;

	 /** PM property */
	 private String PM;
	 
	 private String PMID;
	 
	 
	 private String depart;
	 
	 private String departID;
	 
	 private String id;
	 
	 private String budget;
	 
	 private static Logger logger = Logger.getLogger ("Project") ;
	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());
		}
	}	

	 
	 
	 //private AddProjectForm theProjectForm;

	 // --------------------------------------------------------- Methods
          
     
     public int createProject(ProjectForm theProjectForm) {
     	
     	int newProjectID = 0;
		
		try{
			//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
			//Get an instance reference to the DbFacade object
			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());  
	
			newProjectID = CommonFuncs.getCurrentID("projectID","project");
			
			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 (?,?,?,?,?,?,?,?,?,?)");
		    
		    dbf.setInt(1,newProjectID);
			dbf.setString(2,theProjectForm.getProjectCode());
			dbf.setString(3,theProjectForm.getProjectName());
			dbf.setInt(4,Integer.parseInt(theProjectForm.getDepartID()));
			dbf.setInt(5,Integer.parseInt(theProjectForm.getBudget()));
			dbf.setInt(6,Integer.parseInt(theProjectForm.getPM()));
			dbf.setString(7,theProjectForm.getDescription());
			dbf.setDate(8,startDate);
			dbf.setDate(9,endDate);
			dbf.setString(10,theProjectForm.getStage());
			//dbf.setString(5,"R&D");
			dbf.execute();
			//List results of changes.  
			
			logger.info("project" + theProjectForm.getProjectName() + "is created");
		    
		    return newProjectID;
		}
		catch (Exception e)   	
		{
			logger.error("Exception in createProject:" + e.getMessage());
			return newProjectID;
		}finally
		{
			close();
		}
     }
     
	public void getProjectInfor(String 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 = "SELECT name,DepartName, PM,projectCode,projectName,depart,Description,StartDate,endDate,Stage,Budget ";
					sql += "FROM project,employee,department where project.PM = employee.userID and project.depart=department.departID ";
					sql += " and projectID =" + projectID + " order by startDate";
					
					ResultSet rs = null;
					rs=dbf.executeQuery(sql);	
					
					logger.info("executeQuery" + sql + "in getProjectInfor");			
			
					if (rs.next())
					{
						this.projectID = projectID;
						this.projectCode = rs.getString("projectCode");
						this.projectName = rs.getString("projectName");
						this.PM = rs.getString("name");
						this.PMID = rs.getString("PM");
						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.departID = rs.getString("Depart");
        				this.budget = rs.getString("Budget");        					
					}
			}
			catch (Exception e)   	
			{
				logger.error("Exception in getProjectInfor:" + e.getMessage());
			}finally
		        {
			       close();
		        }
	}
	
	
	public void delProject(String projectID) {
		try{
					//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
					//Get an instance reference to the DbFacade object
					dbf = new SqlDB();
					ResultSet rs = null;
					System.out.println("before executeQuery");
					String sql = "delete FROM project where projectID = " + projectID ;
					dbf.setSql(sql);
					dbf.execute();	
					
					logger.info("execute" + sql + "in delProject");								
			}
			catch (Exception e)   	
			{
				logger.error("Exception in getProjectInfor:" + e.getMessage());
			}finally
		        {
			       close();
		        }
	}
	
	public void updateProject(ProjectForm theProjectForm) {
		try{
					//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
					//Get an instance reference to the DbFacade object
					dbf = new SqlDB();
					ResultSet rs = null;
					String sql = "update project set projectCode = '"+ theProjectForm.getProjectCode() + "',";
					sql += "projectName = '" + theProjectForm.getProjectName() + "',";
					sql += "PM = " + theProjectForm.getPM() + ",";
					sql += "depart = " + theProjectForm.getDepartID() + ",";
					sql += "startDate = '" + theProjectForm.getStartDate() + "',";
					sql += "endDate = '" + theProjectForm.getEndDate() + "',";
					sql += "stage = '" + theProjectForm.getStage() + "',";
					sql += "budget = " + theProjectForm.getBudget();
					sql += " where projectID = " + theProjectForm.getProjectID();
					
					logger.info("------before execute:" + sql + "in updateProject");
					dbf.setSql(sql);
					dbf.execute();	
					
					logger.info("-----after execute:" + sql + "in updateProject");											
			}
			catch (Exception e)   	
			{
				logger.error("Exception in getProjectInfor:" + e.getMessage());
			}finally
		        {
			       close();
		        }
	}
	
	public void updateView(ProjectForm theProjectForm) {
		try{
					//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
					//Get an instance reference to the DbFacade object
					dbf = new SqlDB();
					ResultSet rs = null;
					String sql = "update project set description = '"+ theProjectForm.getDescription() + "' ";
					sql += " where projectID = " + theProjectForm.getProjectID();
					
					logger.info("------before execute:" + sql + "in updateView");
					dbf.setSql(sql);
					dbf.execute();	
					
					logger.info("-----after execute:" + sql + "in updateView");											
			}
			catch (Exception e)   	
			{
				logger.error("Exception in updateViewInfor:" + e.getMessage());
			}finally
		        {
			       close();
		        }
	}

	
	/** 
	  * Returns the projectID.
	  * @return String
	  */
	 public String getProjectID() {
		 return projectID;
	 }

	 /** 
	  * Set the projectID.
	  * @param projectID The projectID to set
	  */
	 public void setProjectID(String projectID) {
		 this.projectID = projectID;
	 }
	 
	 public String getProjectCode() {
		 return projectCode;
	 }

	
	 public void setProjectCode(String projectCode) {
		 this.projectCode = projectCode;
	 }

	 /** 
	  * Returns the description.
	  * @return String
	  */
	 public String getDescription() {
		 return description;
	 }

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

	 /** 
	  * Returns the startTime.
	  * @return String
	  */
	 public String getStartDate() {
		 return startDate;
	 }

	 /** 
	  * Set the startTime.
	  * @param startTime The startTime to set
	  */
	 public void setStartDate(String startDate) {
		 this.startDate = startDate;
	 }
	 
	  public String getEndDate() {
		 return endDate;
	 }

	 /** 
	  * Set the startTime.
	  * @param startTime The startTime to set
	  */
	 public void setEndDate(String endDate) {
		 this.endDate = endDate;
	 }

	 /** 
	  * Returns the stage.
	  * @return String
	  */
	 public String getStage() {
		 return stage;
	 }

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

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

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

	 /** 
	  * Returns the PM.
	  * @return String
	  */
	 public String getPM() {
		 return PM;
	 }

	 /** 
	  * Set the PM.
	  * @param PM The PM to set
	  */
	 public void setPM(String PM) {
		 this.PM = PM;
	 }
	 
	 public String getPMID() {
		 return PMID;
	 }

	 /** 
	  * Set the PM.
	  * @param PM The PM to set
	  */
	 public void setPMID(String PMID) {
		 this.PMID = PMID;
	 }
	 
	public String getDepart() {
			 return depart;
	}
    
	public void setDepart(String depart) {
				 this.depart = depart;
	}
	
	public String getDepartID() {
			 return departID;
	}
    
	public void setDepartID(String departID) {
				 this.departID = departID;
	}
	
	public String getId() {
			 return id;
	}
    
	public void setId(String theId) {
				 this.id = theId;
	}
	
	public String getBudget() {
			 return budget;
	}
    
	public void setBudget(String budget) {
				 this.budget = budget;
	}
	

}