📄 querydaoimpl.java
字号:
Debug.println("[QueryDAOImpl]getBusinessInfo--->>>Exception:" +
sqle.getMessage());
}
finally{
try{
this.closePreparedStatement();
} catch(Exception e){
}
try{
this.closeResultSet();
} catch(Exception e){
}
try{
this.closeStatement();
} catch(Exception e){
}
try{
this.closeConnection();
} catch(Exception e){
}
}
return querytBusinessInfoModel;
}
/**
* 获得变更查询结果
* 应用: get change_item,in_change
*/
public ArrayList getChangeList(String orderID,String BID) throws
AppException{
boolean flag = false;
String sql = null;
ArrayList queryResultList = new ArrayList();
QueryPageChangeFieldDefine queryPageChangeFieldDefine = null;
int pageCount = 0;
String strTemp;
try{
conn = Common.getConnection();
stmt = conn.createStatement();
//是否正常数据
if(orderID == null){
Debug.println(
"[QueryDAOImpl]getChangeList----->orderID is null!");
return queryResultList;
}
//Modified by chen danyu 2004-04-03 因in_change中存在bid=030181等的数据，同时将子表的变更信息查询出来，但不能查询出子表单个字段的变更记录
sql = "SELECT * FROM "
+ TableNameUtil.IN_CHANGE
+ " a,(SELECT SUBSTR(field003,LENGTH(field003)-7,8) AS fieldtemp,field004 as field_explain,format_type FROM "
+ TableNameUtil.CHANGE_ITEM
+ " WHERE field001 ='"
+ BID
+ "') b WHERE a.field003='"
+ orderID
+ "' AND a.field002 like '"
+ BID.substring(0,4) + "%"
+
"'AND (a.field007 = b.fieldtemp(+)) AND (a.field004='gsgsjin_basis02' or a.field004='老数据变更' or a.field004='数据变更') ORDER BY a.field006,a.field007";
Debug.println("[QueryDAOImpl]getChangeList--->>>sql:" + sql);
rs = stmt.executeQuery(sql);
Debug.println("[QueryDAOImpl]getChangeList--->>>star!");
//Modified by chen danyu 2004-04-03 为了解决变更查询中出现字段名而不是中文说明的问题
String bid = "";
String in_tableName = "";
String in_fieldName = "";
String out_subTable = "";
for(int i = 0;rs.next();i++){
queryPageChangeFieldDefine = new QueryPageChangeFieldDefine();
queryPageChangeFieldDefine.setSN(rs.getString("field001"));
bid = rs.getString("field002");
queryPageChangeFieldDefine.setBID(bid);
queryPageChangeFieldDefine.setInnerID(rs.getString("field003"));
in_tableName = rs.getString("field004");
queryPageChangeFieldDefine.setTableName(in_tableName);
queryPageChangeFieldDefine.setRecordNum(rs.getString("field005"));
queryPageChangeFieldDefine.setOperaDate(rs.getString("field006"));
out_subTable = rs.getString("field011");
queryPageChangeFieldDefine.setSubTableName(out_subTable);
in_fieldName = rs.getString("field007");
//下面的程序被陈丹宇注释，因不用显示子表单个字段的变更记录
//调用getFieldExplain（）取得对应的中文说明
//in_fieldName = getFieldExplain(bid,in_tableName,in_fieldName,out_subTable);
queryPageChangeFieldDefine.setChangeItem(in_fieldName);
queryPageChangeFieldDefine.setValueBefChange(rs.getString("field008"));
queryPageChangeFieldDefine.setValueAftChange(rs.getString("field009"));
queryPageChangeFieldDefine.setOperator(rs.getString("field010"));
queryPageChangeFieldDefine.setExplain(rs.getString("field_explain"));
queryPageChangeFieldDefine.setFormatType(rs.getString("format_type"));
queryResultList.add(queryPageChangeFieldDefine);
}
Debug.println("[QueryDAOImpl]getChangeList--->>>end!");
} catch(SQLException sqle){
Debug.println("[QueryDAOImpl]getChangeList--->>>Exception:" +
sqle.getMessage());
}
finally{
try{
this.closePreparedStatement();
} catch(Exception e){
}
try{
this.closeResultSet();
} catch(Exception e){
}
try{
this.closeStatement();
} catch(Exception e){
}
try{
this.closeConnection();
} catch(Exception e){
}
}
Debug.println("[QueryDAOImpl]getChangeList--->>>queryResultList.size():" + queryResultList.size());
return queryResultList;
}
/**
* 获得查询结果
* 应用: 超级查询 查询basisc02
*/
public ArrayList getSuperQuery(String tempSql,int nowPageNum,int listNum) throws
AppException{
boolean flag = false;
String sql = null;
ArrayList queryResultList = new ArrayList();
QuerySuperResultModel querySuperResultModel = null;
int pageCount = 0;
String strTemp;
String strTemp2;
try{
conn = Common.getConnection();
stmt = conn.createStatement();
//是否正常数据
if(tempSql == null){
Debug.println(
"[QueryDAOImpl]getSuperQuery----->tempSql is null!");
return queryResultList;
}
/*
field001 sn
field002 bid
field003 内部序号
field004 注册号
field009 企业名称
field020 企业类型
field033 住址
field019 负责人
field038 联系电话
field105 管辖单位
field104 登记机关
field099 核准日期
field037 邮政编码
field067 经营范围
field096 成立日期
处罚文号
field110 吊销,注销时间
*/
sql = "select * from (select rownum as rownumcode,result.* from (SELECT resultTable.field004,field006,resultTable.field023,resultTable.field160,resultTable.field110,resultTable.field096,resultTable.field067,resultTable.field033,resultTable.field037,resultTable.field038,resultTable.field019,resultTable.field002,resultTable.field020,resultTable.field009,resultTable.field003,resultTable.field001,resultTable.field104,resultTable.field105,resultTable.field155,resultTable.field161,resultTable.content,resultTable.ztfl,resultTable.changeflag FROM (select field004,field006,field023,field110,field096,field067,field033,field037,field038,field019,field002,field020,field009,field003,field001,field104,field105,field155,field099,field016,FIELD050,To_Number(decode((field049),null,0,field049)) as field049,field160,field161,FIELD134,FIELD014,FIELD097,FIELD011,FIELD022,FIELD021,FIELD073,b.content,DECODE((SELECT COUNT(*) FROM in_change WHERE field003=a.field003),0,'0') AS changeflag,d.nr as ztfl from "
+ TableNameUtil.GSGSJIN_BASIS02
+ " a,"
+ TableNameUtil.GSGSJOUT_CODING_ECONOMY
+ " b,a_bm_ztfl d where a.field020 = b.coding(+) and a.field023=d.bm(+)) resultTable" //yuxiaogang20040401修改：去掉了限制条件a.field023 is not null and
+ " where 1=1 ";
sql += tempSql;
sql += ") result ) where rownumcode>=" + ((nowPageNum - 1) * listNum + 1) + " and rownumcode<=" + (nowPageNum * listNum);
Debug.println("[QueryDAOImpl]getSuperQuery--->>>sql:" + sql);
rs = stmt.executeQuery(sql);
Debug.println("[QueryDAOImpl]getSuperQuery--->>>star!");
for(int i = 0;rs.next();i++){
querySuperResultModel = new QuerySuperResultModel();
querySuperResultModel.setSN(PubFunc.decodeGB(rs.getString("field001")));
querySuperResultModel.setBID(PubFunc.decodeGB(rs.getString("field002")));
querySuperResultModel.setInnerID(PubFunc.decodeGB(rs.getString("field003")));
querySuperResultModel.setRegID(PubFunc.decodeGB(rs.getString("field004")));
querySuperResultModel.setCorporationName(PubFunc.decodeGB(rs.getString("field009")));
querySuperResultModel.setCorporationType(PubFunc.decodeGB(rs.getString("field020")));
querySuperResultModel.setCorporationTypeName(PubFunc.decodeGB(rs.getString("content")));
querySuperResultModel.setState(PubFunc.decodeGB(rs.getString("field006")));//add by 20040524
strTemp = PubFunc.decodeGB(rs.getString("field002"));
strTemp2 = PubFunc.decodeGB(rs.getString("field006"));
if(strTemp != null && "01".equals(strTemp.substring(0,2))){
querySuperResultModel.setCorporationState("名称");
/* else
if("1".equals(strTemp)){
querySuperResultModel.setCorporationState("登记");
} else
if("03".equals(strTemp)){
querySuperResultModel.setCorporationState("变更");
} else
if("04".equals(strTemp)){
querySuperResultModel.setCorporationState("备案");
} else
if("05".equals(strTemp)){
querySuperResultModel.setCorporationState("改制");
} else
if("06".equals(strTemp)){
querySuperResultModel.setCorporationState("迁入迁出");
} else
if("07".equals(strTemp)){
querySuperResultModel.setCorporationState("年检");
} else
if("08".equals(strTemp)){
querySuperResultModel.setCorporationState("注销");
} else
if("09".equals(strTemp)){
querySuperResultModel.setCorporationState("吊销");
}*/
} else if(strTemp != null && strTemp2 != null && "02".equals(strTemp.substring(0,2))){
if("1".equals(strTemp2)){
querySuperResultModel.setCorporationState("登记");
} else
if("2".equals(strTemp2)){
querySuperResultModel.setCorporationState("注销");
} else
if("3".equals(strTemp2)){
querySuperResultModel.setCorporationState("吊销");
} else
if("4".equals(strTemp2)){
querySuperResultModel.setCorporationState("迁入");
} else
if("5".equals(strTemp2)){
querySuperResultModel.setCorporationState("迁出");
}
} else{
querySuperResultModel.setCorporationState("");
}
querySuperResultModel.setPrincipal(PubFunc.decodeGB(rs.getString("field019")));
querySuperResultModel.setPhonenumber(PubFunc.decodeGB(rs.getString("field038")));
querySuperResultModel.setPostalcode(PubFunc.decodeGB(rs.getString("field037")));
querySuperResultModel.setAbode(PubFunc.decodeGB(rs.getString("field033")));
querySuperResultModel.setWorkArea(PubFunc.decodeGB(rs.getString("field067")));
querySuperResultModel.setPracticeDate(PubFunc.decodeGB(rs.getString("field096")));
querySuperResultModel.setPunishID("");
querySuperResultModel.setLogoutRevokeDate(PubFunc.decodeGB(rs.getString("field110")));
//是否变更
strTemp = rs.getString("changeflag");
if(strTemp != null && !"".equals(strTemp.trim())){
if("0".equals(strTemp.trim())){
querySuperResultModel.setChangeFlag("未变更");
} else{
querySuperResultModel.setChangeFlag("已变更");
}
} else{
querySuperResultModel.setChangeFlag("已变更");
}
querySuperResultModel.setZTFL(PubFunc.decodeGB(rs.getString("ztfl")));
queryResultList.add(querySuperResultModel);
Debug.println("[QueryDAOImpl]getSuperQuery--->>>i:" + i);
}
Debug.println("[QueryDAOImpl]getSuperQuery--->>>end!");
} catch(SQLException sqle){
Debug.println("[QueryDAOImpl]getSuperQuery--->>>Exception:" +
sqle.getMessage());
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -