📄 altermgr.java
字号:
package com.cmmi2pms.cm.configalter;
import org.apache.log4j.Logger;
import java.util.*;
import com.cmmi2pms.common.comdb.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.io.*;
import java.text.*;
/** class AlterMgr.
* 管理所有配置项的属性,调用的页面应在生成该对象时提供projectid,userid以供使用
* @author LinRong
* @version 1.0
*/
public class AlterMgr
{
private String prjid;
private int userid;
private ConfigAlterAttr[] ConfigAlterList;
private static Logger logger = Logger.getLogger ("AlterMgr") ;
private String ipAddr = new String("192.168.15.150");
/**
* 获取当前日期的字符串形式
*/
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页面
*/
/**/
public AlterMgr (String prjid,int userid)
{
this.prjid = prjid;
this.userid=userid;
}
protected String idToName (int theid) throws SQLException,Exception
{
String sqlStr = new String();
SqlDB dbf = null;
ResultSet rs = null;
//if (theid == null)
// return ("");
//logger.info("theid is "+theid);
if (theid==0) return("");
dbf = new SqlDB();
sqlStr = "select username from employee where userid =?";
dbf.setSql(sqlStr);
//System.out.println(" sql statement is set in idToName");
dbf.setInt(1,theid);
rs = dbf.executeQuery();
//logger.info("dbg execute suc in id to name");
rs.absolute(1);
String _res =new String(rs.getString(1));
rs.close();
dbf.close();
return (_res);
}
/**
* 获得当前已有的变更项的属性列表,用于所有配置变更项简单信息的罗列
*@retn:ConfigAlterAttr[]
*/
public ConfigAlterAttr[] getAlterAttrList()
{
String tmp = new String("");
int i;
SqlDB dbf = null;
ResultSet rs = null;
//ConfigAlterAttr[] ConfigAlterList;
int alterNum = 0;
try
{
//System.out.println("Set sql statements in method getAlterAttrList");
dbf = new SqlDB();
//System.out.println("new dbf finished");
tmp = tmp+"select DISTINCT A.alterapplyid,A.alteritemid,A.level,A.requisttype,C1.name,A.status,";
tmp = tmp+"A.approvaldate,A.closedate,A.validatorid,A.analyserid,A.approverid ,A.appdate ";
tmp = tmp+"from cm_alternation AS A, employee AS C1, employee AS C2 ,employee AS C3,employee AS C4 ";
tmp = tmp+"where A.projectid = ? and C1.userid = A.proposerid ";
dbf.setSql(tmp);
//System.out.println(" sql statement is set,executing in method getAlterAttrList");
dbf.setString(1,prjid);
rs = dbf.executeQuery();
while( rs.next())
{
alterNum++;
}
//logger.info(" the total is "+ alterNum);
//System.out.println("Execute successful");
ConfigAlterList = new ConfigAlterAttr[alterNum];
rs.absolute(1);
for ( i = 0;i < alterNum;i++)
{
//System.out.println("\n");
//System.out.println("record "+(i+1)+"\n");
ConfigAlterList[i] = new ConfigAlterAttr();
ConfigAlterList[i].setalterapplyid(rs.getInt(1));//A.alterapplyid
//System.out.println("alterid:" + rs.getInt(1));
ConfigAlterList[i].setalteritem(rs.getString(2));//A.itemid
//System.out.println("title:"+rs.getString(2));
ConfigAlterList[i].setlevel(rs.getString(3));//A.level
//System.out.println("level:"+rs.getString(3));
ConfigAlterList[i].setrequisttype(rs.getString(4));//A.requisttype
//System.out.println("requistType:"+rs.getString(4));
ConfigAlterList[i].setproposer(rs.getString(5));//A.proposerid
//System.out.println("proposer:"+rs.getString(5));
ConfigAlterList[i].setstatus(rs.getString(6));//A.status
//System.out.println("status:"+rs.getString(6));
ConfigAlterList[i].setapprovaldate(rs.getString(7));//A.approvaldate
//System.out.println("approvalDate:"+rs.getString(7));
ConfigAlterList[i].setclosedate(rs.getString(8));//A.closedate
//System.out.println("closeDate:"+rs.getString(8));
//logger.info("validatorid:"+rs.getInt(9));
ConfigAlterList[i].setvalidator(idToName(rs.getInt(9)));//A.validator
System.out.println("validator:"+idToName(rs.getInt(9)));
ConfigAlterList[i].setanalyser(idToName(rs.getInt(10)));//A.analyser
//System.out.println("analyser:"+idToName(rs.getInt(10)));
ConfigAlterList[i].setapprover(idToName(rs.getInt(11)));//A.approver
//System.out.println("approver:"+idToName(rs.getInt(11)));
ConfigAlterList[i].setappdate(rs.getString(12));//A.appdate;
//System.out.println("applyDate:"+rs.getString(12));
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(ConfigAlterList);
}
/**
* 获得某个变更项的所有数据,
*/
public ConfigAlterAttr getDetailInfo(int alterid)
{
String tmp = new String("");
int i;
SqlDB dbf = null;
ResultSet rs = null;
ConfigAlterAttr detailInfo = new ConfigAlterAttr();
int alterNum;
try
{
System.out.println("getDetailInfo is invoked");
dbf = new SqlDB();
tmp = tmp+"select DISTINCT A.alterapplyid,A.alteritemid,A.level,A.requisttype,C1.name,A.status,";
tmp = tmp+"A.approvaldate,A.closedate,A.validatorid,A.analyserid,A.approverid ,A.appdate,";
tmp = tmp+"A.reason,A.content,A.validatereport,A.analysisreport,A.approvereport,A.alterreport ";
tmp = tmp+"from cm_alternation AS A, employee AS C1, employee AS C2 ,employee AS C3,employee AS C4 ";
tmp = tmp+"where C1.userid = A.proposerid ";
tmp = tmp+" and A.alterapplyid =?";
dbf.setSql(tmp);
dbf.setInt(1,alterid);
rs = dbf.executeQuery();
//System.out.println("Sql executes successfully");
rs.absolute(1);
detailInfo.setalterapplyid(alterid);//A.alterapplyid
//System.out.println("alterid:"+alterid);
detailInfo.setalteritem(rs.getString(2));//A.itemid
//System.out.println("title:"+rs.getString(2));
detailInfo.setlevel(rs.getString(3));//A.level
//System.out.println("level:"+rs.getString(3));
detailInfo.setrequisttype(rs.getString(4));//A.requisttype
//System.out.println("requistType:"+rs.getString(4));
detailInfo.setproposer(rs.getString(5));//A.proposerid
//System.out.println("proposer:"+rs.getString(5));
detailInfo.setstatus(rs.getString(6));//A.status
//System.out.println("status:"+rs.getString(6));
detailInfo.setapprovaldate(rs.getString(7));//A.approvaldate
//System.out.println("approvalDate:"+rs.getString(7));
detailInfo.setclosedate(rs.getString(8));//A.closedate
//System.out.println("closeDate:"+rs.getString(8));
detailInfo.setvalidator(idToName(rs.getInt(9)));//A.validator
//System.out.println("validator:"+idToName(rs.getInt(9)));
detailInfo.setanalyser(idToName(rs.getInt(10)));//A.analyser
//System.out.println("analyser:"+idToName(rs.getInt(10)));
detailInfo.setapprover(idToName(rs.getInt(11)));//A.approver
//System.out.println("approver:"+idToName(rs.getInt(11)));
detailInfo.setappdate(rs.getString(12));//A.appdate;
//System.out.println("applyDate:"+rs.getString(12));
detailInfo.setreason(rs.getString(13));//A.reason
//System.out.println("reason:"+rs.getString(13));
detailInfo.setcontent(rs.getString(14));
//System.out.println("context:"+rs.getString(14));
detailInfo.setvalidatereport(rs.getString(15));
//System.out.println("validateReport:"+rs.getString(15));
detailInfo.setanalysisreport(rs.getString(16));
//System.out.println("analysisReport:"+rs.getString(16));
detailInfo.setapprovereport(rs.getString(17));
//System.out.println("approveReport:"+rs.getString(17));
detailInfo.setalterreport(rs.getString(18));
//System.out.println("alterReport:"+rs.getString(18));
}
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(detailInfo);
}
/**
* 返回已有的配置变更数,用于计算配置变更id
*/
public int getAlterItemNum()
{
int i = 0;
String sqlStr;
SqlDB dbf = null;
ResultSet rs = null;
try
{
////PooledConnectionMgr.getInstance().initialize(30,ipAddr,3306,"CMMI2PM");
//System.out.println("Set sql statements and excute it in method getAlterItemNum");
dbf = new SqlDB();
//System.out.println("new dbf finished");
sqlStr = new String("select * from cm_alternation");
dbf.setSql(sqlStr);
// System.out.println(" sql statement is set,executing in method getAlterItemNum");
rs = dbf.executeQuery();
while( rs.next())
{
i++;
}
//System.out.println("SQL execute successfully in getAlterItemNum");
}
catch(SQLException se)
{
se.printStackTrace();
}catch(Exception ex)
{
ex.printStackTrace();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -