reporttasklist.java

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

/*
 * Created on 2004-5-22
 *
 * 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 ReportTaskList {
	
	private ReportTask[] reportTasks;
	
	public void getProjectTasks(String theProjectid){
		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 rs1 = null;
			
			String sql="select taskid from pp_workloadestimate where projectid="+theProjectid;
				   sql+=" and trackid=0";
			System.out.println(sql);
			rs=dbf.executeQuery(sql);
			
			ArrayList taskArrayList=new ArrayList();
			while(rs.next()){
				
				ReportTask aTask=new ReportTask();
				aTask.setTaskid(rs.getString("taskid"));
				aTask.getPPTaskInfo(theProjectid,aTask.getTaskid());
				
				taskArrayList.add(aTask);
			}
			
			reportTasks=new ReportTask[taskArrayList.size()];
			taskArrayList.toArray(reportTasks);
			
			if(rs!=null) rs.close();
			if(rs1!=null) rs1.close();
			if(dbf!=null) dbf.close();
		}
		
		catch (Exception e){
			System.out.println("exception in getAllTasks ："+e.getMessage());
		}
	}
	
	public void getAllTasks(String theProjectid,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;
			
			String sql="select taskid,curstate,wl_curweek from pmc_workreport where reportid="+theReportid;
			System.out.println(sql);
			rs=dbf.executeQuery(sql);
			
			ArrayList taskArrayList=new ArrayList();
			while(rs.next()){
				ReportTask aReportTask=new ReportTask();
				aReportTask.setTaskid(rs.getString("taskid"));
				aReportTask.getPPTaskInfo(theProjectid,aReportTask.getTaskid());
				aReportTask.setCurstate(rs.getString("curstate"));
				aReportTask.setWl_curweek(rs.getString("wl_curweek"));				
				
				taskArrayList.add(aReportTask);
			}
			
			reportTasks=new ReportTask[taskArrayList.size()];
			taskArrayList.toArray(reportTasks);
			
			if(rs!=null) rs.close();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e){
			System.out.println("exception in getAllTasks ："+e.getMessage());
		}
	}
	
	public void setReportTasks(ReportTask[] reportTasks){
		this.reportTasks=reportTasks;
	}
	
	public ReportTask[] getReportTasks(){
		return reportTasks;
	}
	

}