configauditmgr.java

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

package com.cmmi2pms.cm.configaudit;

import java.util.*;
import com.cmmi2pms.common.comdb.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.io.*;
import java.text.*;

/**
 *this class is use for manager the configAudit attrbute
 *@author: Lin Rong.
 *@version:0.01
 */
public class ConfigAuditMgr
{
	private String prjid;
    private int userid;

    /**
    * 获取当前日期的字符串形式
    */
    private String getCurrentDateStr()
    {
    	DateFormat df = DateFormat.getDateInstance();
		long currentT =System.currentTimeMillis();
		Date thedate= new Date (currentT);
		String dataStr = df.format(thedate);
		return(dataStr);
    }

    /**
    *构造函数
    *@param:String prjid,项目id.int userid,用户id.ConfigAlterAttr[] ConfigAlterList,传入参数.方法在此填入属性值返回给jsp页面
    */
    /**/
    ConfigAuditMgr (String prjid,int userid)
    {
    	this.prjid = prjid;
    	this.userid=userid;
    } 

	/**
    * 获得当前已有的配置审计项的属性列表
    *@retn:ConfigAuditAttr[]
    */
    public ConfigAuditAttr[] getConfigAuditAttrList()
    {
       	String tmp = new String("");
    	int i;
    	SqlDB dbf = null;
        ResultSet rs = null;
    	ConfigAuditAttr[] ConfigAuditList = null;
        int auditNum = 0;

    	try
    	{
    		dbf = new SqlDB();
    	   	tmp = tmp+"select A.auditid,A.auditdate,A.checklistitem1,A.checklistitem2";
    	    tmp = tmp+"A.problemreport,A.problemnum,A.approvepreport,c.name";
    	    tmp = tmp+"from cm_configaudit AS A,project AS B, employee AS C ";
    	    tmp = tmp+"where A.projectid = B.projectid and C.userid = A.approverid ";
    	    tmp = tmp+"and  B.projectid =?";
    	    dbf.setSql(tmp);
            dbf.setString(1,prjid);
            rs = dbf.executeQuery();
            while(	rs.next())
            {
            	auditNum++;
            }

            ConfigAuditList = new ConfigAuditAttr[auditNum];
            rs.absolute(1);
            for ( i = 0;i < auditNum;i++)
            {
            	ConfigAuditList[i] = new ConfigAuditAttr();
            	ConfigAuditList[i].setauditid(rs.getInt(1));//A.auditid
        	    ConfigAuditList[i].setauditdate(rs.getString(2));//A.auditdate
        	    ConfigAuditList[i].setchecklistitem1(rs.getInt(3));//A.checklistitem1
        	    ConfigAuditList[i].setchecklistitem2(rs.getInt(4));//A.checklistitem2
        	    ConfigAuditList[i].setproblemreport(rs.getString(5));//A.problemreport
        	    ConfigAuditList[i].setproblemnum(rs.getInt(6));//A.problemnum
        	    ConfigAuditList[i].setapprovereport(rs.getString(7));//A.approvepreport
        	    ConfigAuditList[i].setapprover(rs.getString(8));//A.approver
        	    if (!rs.next()) break;
           }

        }
        catch(SQLException se)
	    {
	        se.printStackTrace();
	    }
	    catch(Exception ex)
	    {
			ex.printStackTrace();
		}
		finally
		{
			try
			{
				if(rs!=null) rs.close();
	            if(dbf!=null) dbf.close();
        	}
        	catch(SQLException se)
			{
				se.printStackTrace();
			}
        }
        return(ConfigAuditList);
    }

    
}