workreportlist.java

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

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

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


import com.cmmi2pms.common.comdb.*;

/**
 * @author DengJun1
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class WorkReportList {
	
	private WorkReport[] workReports;
	
	public void getAllWorkReport(){
		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 reportid,projectid,userid,reporttime,title,discrib,hasred,mark,review,nextjob ";
				   sql+="from pmc_workreportlist";
			System.out.println(sql);
			rs=dbf.executeQuery(sql);
			
			ArrayList reportArrayList = new ArrayList();
			while (rs.next()){
				WorkReport aWorkReport=new WorkReport();
				aWorkReport.setReportid(rs.getString("reportid"));
				aWorkReport.setProjectid(rs.getString("projectid"));
				aWorkReport.setReporttime(rs.getString("reporttime"));
				aWorkReport.setUserid(rs.getString("userid"));
				aWorkReport.setTitle(rs.getString("title"));
				aWorkReport.setDescrib(rs.getString("discrib"));
				aWorkReport.setHasred(rs.getString("hasred"));
				aWorkReport.setMark(rs.getString("mark"));
				aWorkReport.setReview(rs.getString("review"));
				aWorkReport.setNextjob(rs.getString("nextjob"));
				
				sql="select projectName from project where projectID="+aWorkReport.getProjectid();
				System.out.println(sql);
				rs_1=dbf.executeQuery(sql);
				if(rs_1.next()) aWorkReport.setProjectname(rs_1.getString("projectName"));
				
				sql="select Username from employee where userID="+aWorkReport.getUserid();
				System.out.println(sql);
				rs_1=dbf.executeQuery(sql);
				if(rs_1.next()) aWorkReport.setUsername(rs_1.getString("Username"));
				
				reportArrayList.add(aWorkReport);				
			}
			workReports=new WorkReport[reportArrayList.size()];
			reportArrayList.toArray(workReports);
			
			if(rs!=null) rs.close();
			if(rs_1!=null) rs_1.close();
			if(dbf!=null) dbf.close();
		}
		catch( Exception e){
			System.out.println("getAllWorkReport error:"+e.getMessage());
		}
	}
	
	
	public void getMyWorkReport(String userid){
		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 reportid,projectid,reporttime,title,discrib,hasred,mark,review,nextjob ";
				   sql+="from pmc_workreportlist ";
				   sql+="where userid="+userid;
			System.out.println(sql);
			rs=dbf.executeQuery(sql);
			
			ArrayList reportArrayList = new ArrayList();
			while (rs.next()){
				WorkReport aWorkReport=new WorkReport();
				aWorkReport.setReportid(rs.getString("reportid"));
				aWorkReport.setProjectid(rs.getString("projectid"));
				aWorkReport.setReporttime(rs.getString("reporttime"));
				aWorkReport.setUserid(userid);
				aWorkReport.setTitle(rs.getString("title"));
				aWorkReport.setDescrib(rs.getString("discrib"));
				aWorkReport.setHasred(rs.getString("hasred"));
				aWorkReport.setMark(rs.getString("mark"));
				aWorkReport.setReview(rs.getString("review"));
				aWorkReport.setNextjob(rs.getString("nextjob"));
			
				sql="select projectName from project where projectID="+aWorkReport.getProjectid();
				System.out.println(sql);
				rs_1=dbf.executeQuery(sql);
				if(rs_1.next()) aWorkReport.setProjectname(rs_1.getString("projectName"));
			
				sql="select Username from employee where userID="+aWorkReport.getUserid();
				System.out.println(sql);
				rs_1=dbf.executeQuery(sql);
				if(rs_1.next()) aWorkReport.setUsername(rs_1.getString("Username"));
				
				reportArrayList.add(aWorkReport);				
			}
			workReports=new WorkReport[reportArrayList.size()];
			reportArrayList.toArray(workReports);
			
			if(rs!=null) rs.close();
			if(rs_1!=null) rs_1.close();
			if(dbf!=null) dbf.close();	
		}
		catch( Exception e){
			System.out.println("getMyWorkReport error:"+e.getMessage());
		}
	}
	
	public WorkReport[] getWorkReports(){
		return  workReports;
	}
	public void setWorkReports(WorkReport[] workReports){
		this.workReports=workReports;
	}

}