tasklist.java

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

/*
 * Created on 2004-4-18
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.cmmi2pms.pp.task;

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

import com.cmmi2pms.common.comdb.*;

import org.apache.log4j.Logger;

/**
 * @author lxj
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class TaskList {
	
	private Task[] tasks;
	
	private SqlDB dbf;
	private ResultSet rs;
	
	private static Logger logger = Logger.getLogger ("TaskList") ;
	
	private void close()
	{
		try
		{
			if(rs!=null) rs.close();
			if(dbf!=null) dbf.close();
		}
		catch(SQLException sqle)
		{
			logger.error("Close SqlDB error: "+sqle.getMessage());
		}
	}
	
	public void getAllTask(int projectId)
	{
		try
		{
			dbf=new SqlDB();
			String sql = "SELECT * FROM pp_scheme where projectid= "+projectId +" order by planstart";
			logger.debug(sql);
			rs=dbf.executeQuery(sql);
			
			
			int rowNum = 0;
			
			ArrayList taskArrayList = new ArrayList();
			Task aTask;
			while (rs.next()){
				
				rowNum++;				
				aTask = new Task();
				logger.debug(""+rowNum);	
				aTask.setTaskId(rs.getInt("taskid"));
				aTask.setProjectId(Integer.valueOf(rs.getString("projectId")).intValue());
				aTask.setTaskName(rs.getString("taskname"));
				aTask.setPlanStart(rs.getDate("planstart").toString());
				aTask.setDesc(rs.getString("describ"));
				aTask.setPlanEnd(rs.getDate("planend").toString());
				
				java.sql.Date realdate;
				if((realdate=rs.getDate("realstart"))==null)
				{
					aTask.setRealStart(null);
				}else
				{
					aTask.setRealStart(realdate.toString());
				}
				if((realdate=rs.getDate("realend"))==null)
				{
					aTask.setRealEnd(null);
				}else
				{
					aTask.setRealEnd(realdate.toString());
				}
				aTask.setFormerTask(rs.getString("formertask"));
				aTask.setWsbId(rs.getString("WBSID"));
				aTask.setIsLandMask(rs.getBoolean("landmask"));
				aTask.setManagerName(rs.getString("manager"));
				aTask.setTaskLoad(rs.getInt("taskload"));
				aTask.setHarves(rs.getString("harvest"));
				taskArrayList.add(aTask);
				
				logger.debug("rowNum:" + rowNum);	
			}
			tasks = new Task[taskArrayList.size()];
			taskArrayList.toArray(tasks);
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in getAllTask:" + e.getMessage());
		}finally
		{
			close();
		}
				
	}
	
	public Task[] getTasks()
	{
		return tasks;
	}
	
	public void setTasks(Task[] theTasks)
	{
		this.tasks = theTasks;
	}
	 

}