workreport.java

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

/*
 * Created on 2004-5-9
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.cmmi2pms.pmc.report;

/**
 * @author DengJun1
 *
 * 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 WorkReport {
	private String projectid;
	private String projectname;
	private String userid;
	private String username;
	
	private String reportid;
	private String tasknum;
	
	private String title;
	
	private String reporttime;
	private String describ;
	
	private String hasred;
	private String mark;
	private String review;
	private String nextjob;
	
	public void getReportInfo(String theReportid){
		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;
			ResultSet rs_1 = null;
			
			String sql="select projectid,userid,reporttime,title,discrib,hasred,mark,review,nextjob ";
				   sql+="from pmc_workreportlist where reportid="+theReportid;
			System.out.println(sql);
			rs=dbf.executeQuery(sql);
		
			if(rs.next()){
				this.setProjectid(rs.getString("projectid"));
				this.setUserid(rs.getString("userid"));
				this.setReporttime(rs.getString("reporttime"));
				this.setTitle(rs.getString("title"));
				this.setDescrib(rs.getString("discrib"));
				this.setReportid(theReportid);
				this.setHasred(rs.getString("hasred"));
				this.setMark(rs.getString("mark"));
				this.setReview(rs.getString("review"));
				this.setNextjob(rs.getString("nextjob"));
			}
			
			sql="select projectName from project where projectID="+this.getProjectid();
			System.out.println(sql);
			rs_1=dbf.executeQuery(sql);
			if(rs_1.next()) this.setProjectname(rs_1.getString("projectName"));
				
			sql="select Username from employee where userID="+this.getUserid();
			System.out.println(sql);
			rs_1=dbf.executeQuery(sql);
			if(rs_1.next()) this.setUsername(rs_1.getString("Username"));
			
			
		}
		catch(Exception e){
			System.out.println("error in getReportInfo:"+e.getMessage());
		}
	}
	
	public String createWorkReport(AddWorkReportForm theWorkReportForm){
				
		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(theWorkReportForm.getReporttime());  
			java.sql.Date myReportTime = new java.sql.Date(d.getTime());
		
			String sql="INSERT INTO pmc_workreportlist(projectid,userid,reporttime,title,discrib,hasred) VALUES (?,?,?,?,?,?)";
			System.out.println(sql);
			dbf.setSql(sql);
			dbf.setString(1,theWorkReportForm.getProjectid());
			dbf.setInt(2,Integer.parseInt(theWorkReportForm.getUserid()));
			dbf.setDate(3,myReportTime);	
			dbf.setString(4,theWorkReportForm.getTitle());
			dbf.setString(5,theWorkReportForm.getDiscrib());
			dbf.setInt(6,0);
			dbf.execute();
				
			String myReportTime1=myReportTime+"  ";
			String myReportTime2=myReportTime1.substring(0,4)+myReportTime1.substring(5,7)+myReportTime1.substring(8,10);
			String querySql = "SELECT reportid ";
				   querySql += "FROM pmc_workreportlist where userid =" + theWorkReportForm.getUserid();
				   querySql += " and reporttime =" + myReportTime2 ;
		
			ResultSet rs = null;
			rs=dbf.executeQuery(querySql);
			
			if(rs.next()){
				this.userid = rs.getString("reportid");
			}
				
		}
		catch (Exception e)  	
		{
			System.out.println("Exception in createWorkReport:" + e.getMessage());
		}
		return this.getUserid();
	}//public String createWorkReport
	
	public void setProjectid(String projectid){
			this.projectid=projectid;
	}
	public String getProjectid() {
			return projectid;
	}
	
	public void setProjectname(String projectname){
			this.projectname=projectname;
	}
		public String getProjectname() {
			return projectname;
	}
	
	public void setUserid(String userid){
			this.userid=userid;	
	}
	public String getUserid(){
			return userid;
	}
	public void setUsername(String username){
			this.username=username;	
	}
	public String getUsername(){
			return username;
	}
	public void setReportid(String reportid){
			this.reportid=reportid;		
	}
	public String getReportid(){
			return reportid;
	}
	public void setTasknum(String tasknum){
		this.tasknum=tasknum;		
	}
	public String getTasknum(){
		return tasknum;
	}
	public void setReporttime(String reporttime){
		this.reporttime=reporttime;
	}
	public String getReporttime(){
		return  reporttime;
	}
	public void setDescrib(String describ){
		this.describ=describ;
	}
	public String getDescrib(){
		return describ;
	}
	public void setTitle(String title){
		this.title=title;
	}
	public String getTitle(){
		return title;
	}
	public void setHasred(String hasred){
		this.hasred=hasred;
	}
	public String getHasred(){
		return hasred;
	}
	public void setMark(String mark){
		this.mark=mark;
	}
	public String getMark(){
		return mark;
	}
	public void setReview(String review){
		this.review=review;
	}
	public String getReview(){
		return review;
	}
	public void setNextjob(String nextjob){
		this.nextjob=nextjob;
	}
	public String getNextjob(){
		return nextjob;
	}
}