mareportlist.java

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

package com.cmmi2pms.ma;

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

import com.cmmi2pms.common.comdb.*;

public class MaReportList 
{
	private MaReport[] maReportList;
	
	public MaReportList(String projId,int flag)
	{
		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="";
			if(flag==1)	sql = "SELECT * FROM  MA_MAReport where projectID = '" + projId + "' and MAReportCheck = 0";
			rs=dbf.executeQuery(sql);					
			MaReport aMaReport;
			int numOfMaReport = 0;
			MaReport[] temp=new MaReport[100];
			while ((rs.next()) && (numOfMaReport < 100))
			{	
				aMaReport=new MaReport(MaObject.tranMaObject(rs.getString("maObject")),projId,false);			
				
				aMaReport.setMaReportId(rs.getString("MAReportId"));
				aMaReport.setAnalysisResult(rs.getString("AnalysisResult"));
				aMaReport.setRemedy(rs.getString("Remedy"));
				aMaReport.setMode(1);
				
				temp[numOfMaReport] = aMaReport;		
				numOfMaReport++;
				System.out.println("numOfMaReport=" + numOfMaReport);	
			}
			maReportList=new MaReport[numOfMaReport];
			System.arraycopy(temp,0,maReportList,0,numOfMaReport);
			if(rs!=null) rs.close();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createMaReportList:" + e.getMessage());
		}

	}
	
	public MaReport[] getMaReportList() 
	{
		return maReportList;
	}

	public void setMaReportList(MaReport[] maReportList) 
	{
		this.maReportList = new MaReport[maReportList.length];
		System.arraycopy(maReportList,0,this.maReportList,0,maReportList.length);
	}
	
	public MaReport findMaReport(String name,String id)
	{
		System.out.println(name+id);
		for(int i=0;i<maReportList.length;i++)
		{
			System.out.println(maReportList[i].getMaObjectName()+maReportList[i].getMaReportId());
			if ((maReportList[i].getMaObjectName().equals(name))&&(maReportList[i].getMaReportId().equals(id)))
				return maReportList[i];
		}
		return null;
	} 
	
}