department.java

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

package com.cmmi2pms.sa.department;

/**
 * @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.*;


public class Department {
//	--------------------------------------------------------- Instance Variables

	 /** projectID property */
	 private String departID;

	 /** description property */
	 private String departName;

	//private AddProjectForm theProjectForm;

	 // --------------------------------------------------------- Methods
    /* 
     private String getAField(String table,String theField,String condition){
     		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 = "SELECT "+ theField+" FROM "+table+" where " + condition ;
					rs=dbf.executeQuery(sql);	
					System.out.println("after executeQuery");				
			
					if (rs.next())
					{
						return rs.getString("projectName");						
					}
			}
			catch (Exception e)   	
			{
				System.out.println("Exception in getProjectInfor:" + e.getMessage());
				return null;
			}
			
			return null;
     }
     
     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 getDepartName() {
		 return departName;
	 }

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

		 
	public String getDepartID() {
			 return departID;
	}
    
	public void setDepartID(String departID) {
				 this.departID = departID;
	}	

}