📄 querydaoimpl.java
字号:
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]getSuperQuery--->>>queryResultList.size():" + queryResultList.size());
return queryResultList;
}
/**
* 获得表达式查询结果
* 应用: 超级查询
*/
public ArrayList getSuperBiaodashiQuery(String tempSql,int nowPageNum,int listNum,String basisorsub) 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 吊销,注销时间
*/
if("basis".equals(basisorsub)){
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 DECODE(field004,'*','',field004) as 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,To_Number(decode((field192),null,0,field192)) as field192,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\u00D0\u00DE\u00B8\u00C4\u00A3\u00BA\u00C8\u00A5\u00B5\u00F4\u00C1\u00CB\u00CF\u00DE\u00D6\u00C6\u00CC\u00F5\u00BC\u00FEa.field023 is not null and
+ " where ";
sql += tempSql;
sql += ") result ) where rownumcode>=" + ((nowPageNum - 1) * listNum + 1) + " and rownumcode<=" + (nowPageNum * listNum);
} else{
sql = "select * from (select rownum as rownumcode,result.* from (select * from v_basis02_sub02 where ";
sql += tempSql;
sql += " ) result ) where rownumcode>=" + ((nowPageNum - 1) * listNum + 1) + " and rownumcode<=" + (nowPageNum * listNum);
}
Debug.println("[QueryDAOImpl]getSuperBiaodashiQuery--->>>sql:" + sql);
rs = stmt.executeQuery(sql);
Debug.println("[QueryDAOImpl]getSuperBiaodashiQuery--->>>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]getSuperBiaodashiQuery--->>>i:" + i);
}
Debug.println("[QueryDAOImpl]getSuperBiaodashiQuery--->>>end!");
} catch(SQLException sqle){
Debug.println("[QueryDAOImpl]getSuperBiaodashiQuery--->>>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]getSuperBiaodashiQuery--->>>queryResultList.size():" + queryResultList.size());
return queryResultList;
}
/**
* 获得查询结果
* 应用: 未年检企业(未通过) 查询basisc02
*/
public ArrayList getUnPassYearCheckup(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]getUnPassYearCheckup----->tempSql is null!");
return queryResultList;
}
/*
field001 sn
field002 bid
field003 内部序号
field004 注册号
field009 企业名称
field020 企业类型
field033 住址
field019 负责人
field038 联系电话
field105 管辖单位
field104 登记机关
field099 核准日期
field037 邮政编码
field067 经营范围
field096 成立日期
处罚文号
field110 吊销,注销时间
*/
//SELECT * FROM (SELECT ROWNUM AS rownumcode,a.* FROM (SELECT * FROM "
sql = "SELECT * FROM (SELECT ROWNUM AS rownumcode,result.* FROM (select a.* FROM (SELECT * FROM "
+ TableNameUtil.GSGSJIN_BASIS02
+ " where 1=1 ";
sql += tempSql;
sql += " result) WHERE rownumcode>=" + ((nowPageNum - 1) * listNum + 1) + " and rownumcode<=" + (nowPageNum * listNum);
Debug.println("[QueryDAOImpl]getUnPassYearCheckup--->>>sql:" + sql);
rs = stmt.executeQuery(sql);
Debug.println("[QueryDAOImpl]getUnPassYearCheckup--->>>star!");
for(int i = 0;rs.next();i++){
querySuperResultModel = new QuerySuperResultModel();
querySuperResultModel.setSN(PubFunc.decodeGB(rs.getString("field001")));
strTemp = PubFunc.decodeGB(rs.getString("field002"));
strTemp2 = PubFunc.decodeGB(rs.getString("field006"));
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")));
/////////////////////////////////////////////////////////////////////////////////
/*
if(strTemp != null && strTemp.length() > 2){
strTemp = strTemp.substring(0,2);
if("01".equals(strTemp)){
querySuperResultModel.setCorporationState("名称");
} else
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -