📄 pagedefinedaoimpl.java
字号:
}
catch (Exception e) {
}
try {
this.closeConnection();
}
catch (Exception e) {
}
}
return flag;
}
/**
* 修改定义页面
* 应用:修改定义页面
*/
public String editPageDefine(PageDefineModel pageDefineModel, String oldCode) throws
AppException {
boolean flag = false;
String sql = null;
String code = "";
try {
conn = Common.getConnection();
// conn.setAutoCommit(false);
stmt = conn.createStatement();
//是否正常数据
if (pageDefineModel == null) {
Debug.println(
"[PageDefineDAOImpl]editPageDefine----->pageDefineModel is null!");
code = PubFunc.toSql(pageDefineModel.getCode(), 0);
return code;
}
code = PubFunc.toSql(pageDefineModel.getCode(), 0);
/*
CODE VARCHAR2(12) NOT NULL PRIMARY KEY, //页面编号query001
EXPLAIN VARCHAR2(200) NULL, //说明
ROWCOLSIGN VARCHAR2(8) NULL, //页面生成行列分类
CLASS1 VARCHAR2(8) NULL, //类型（1报表，2执照，3通知，4查询）
CLASS2 VARCHAR2(8) NULL, //（报表：1横向，2纵向； 执照：1执照预览 ，2执照打印）
CLASS3 VARCHAR2(8) NULL, //业务类型
CONTENT CLOB NULL, //页面生成结果
PAGE_WIDTH VARCHAR2(8) NULL, //页面宽度
PAGE_STYLE VARCHAR2(200) NULL, //页面样式
BUILD_DATE VARCHAR2(30) NULL, //生成日期
ORDERID VARCHAR2(8) NULL //排列顺序号
*/
sql = "update "
+ TableNameUtil.UNIVERSAL_PAGE_DEFINE
+ " set code='"
+ PubFunc.toSql(pageDefineModel.getCode(), 0)
+ "',explain='"
+ PubFunc.toSql(pageDefineModel.getExplain(), 0)
+ "',rowcolsign='"
+ PubFunc.toSql(pageDefineModel.getRowcolSign(), 0)
+ "',class1='"
+ PubFunc.toSql(pageDefineModel.getClass1(), 0)
+ "',class2='"
+ PubFunc.toSql(pageDefineModel.getClass2(), 0)
+ "',class3='"
+ PubFunc.toSql(pageDefineModel.getClass3(), 0)
+ "',page_width='"
+ PubFunc.toSql(pageDefineModel.getPageWidth(), 0)
+ "',page_style='"
+ PubFunc.toSql(pageDefineModel.getPageStyle(), 0)
+ "',build_date='"
+ PubFunc.toSql(pageDefineModel.getBuildDate(), 0)
+ "',orderid='"
+ PubFunc.toSql(pageDefineModel.getOrderID(), 0)
+ "' where code='"
+ PubFunc.toSql(oldCode, 0)
+ "'"
;
Debug.println("[PageDefineDAOImpl]editPageDefine--->>>sql:" + sql);
stmt.executeUpdate(sql);
// conn.commit();
}
catch (SQLException sqle) {
Debug.println("[PageDefineDAOImpl]editPageDefine--->>>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 code;
}
/**
* 修改定义页面数据
* 应用:修改定义页面数据
*/
public boolean editPageElementDefine(PageDefineDataModel pageDefineDataModel) throws
AppException {
boolean flag = false;
String sql = null;
String code = "";
try {
conn = Common.getConnection();
// conn.setAutoCommit(false);
stmt = conn.createStatement();
//是否正常数据
if (pageDefineDataModel == null) {
Debug.println(
"[PageDefineDAOImpl]editPageElementDefine----->pageDefineDataModel is null!");
return flag;
}
code = PubFunc.toSql(pageDefineDataModel.getCode(), 0);
sql = "update "
+ TableNameUtil.UNIVERSAL_PAGEELEMENT_DEFINE
+ " set positionLeft='"
+ PubFunc.toSql(pageDefineDataModel.getPositionLeft(), 0)
+ "',positionTop='"
+ PubFunc.toSql(pageDefineDataModel.getPositionTop(), 0)
+ "' where code='"
+ PubFunc.toSql(pageDefineDataModel.getCode(), 0)
+ "'"
;
Debug.println("[PageDefineDAOImpl]editPageElementDefine--->>>sql:" + sql);
stmt.executeUpdate(sql);
// conn.commit();
}
catch (SQLException sqle) {
Debug.println("[PageDefineDAOImpl]editPageElementDefine--->>>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 flag;
}
/**
* 定义页面列表
* class1 类型 如报表
* class2 分类
* class3 业务类型
* 应用:
*/
public ArrayList getPageDefineShowList(String category1, String category2,
String BID) throws
AppException {
String sql = null;
ArrayList pageDefineShowList = null;
PageDefineModel pageDefineModel = null;
try {
//是否正常数据
if (category1 == null || category2 == null || BID == null) {
Debug.println(
"[PageDefineDAOImpl]getPageDefineShowList------->category1 or category2 or BID is null!");
return pageDefineShowList;
}
if ("".equals(category2)) {
sql = "SELECT a.code,a.page_code,a.explain,a.order_id,a.bid,a.djjg,a.gxdw,a.page_type,a.category1,a.category2,a.category3,rowcolSign,page_width,build_date,page_style FROM "
+ TableNameUtil.UNIVERSAL_QUERY_PAGEDEFINE
+ " a,"
+ TableNameUtil.UNIVERSAL_PAGE_DEFINE
+ " b"
+
" where a.page_code=b.code and page_type='2' and a.category1='"
+ category1
+ "' and a.bid like'"
+ BID
+
"%' order by a.category1,a.category2,a.category3,a.bid,a.order_id ";
}
else
if ("".equals(BID)) {
sql = "SELECT a.code,a.page_code,a.explain,a.order_id,a.bid,a.djjg,a.gxdw,a.page_type,a.category1,a.category2,a.category3,rowcolSign,page_width,build_date,page_style FROM "
+ TableNameUtil.UNIVERSAL_QUERY_PAGEDEFINE
+ " a,"
+ TableNameUtil.UNIVERSAL_PAGE_DEFINE
+ " b"
+
" where a.page_code=b.code and a.page_type='2' and a.category1='"
+ category1
+ "' and a.category2='"
+ category2
+ "' order by a.order_id ";
}
else {
sql = "SELECT a.code,a.page_code,a.explain,a.order_id,a.bid,a.djjg,a.gxdw,a.page_type,a.category1,a.category2,a.category3,rowcolSign,page_width,build_date,page_style FROM "
+ TableNameUtil.UNIVERSAL_QUERY_PAGEDEFINE
+ " a,"
+ TableNameUtil.UNIVERSAL_PAGE_DEFINE
+ " b"
+
" where a.page_code=b.code and page_type='2' and a.category1='"
+ category1
+ "' and a.category2='"
+ category2
+ "' and a.bid like'"
+ BID
+ "%' order by order_id";
}
Debug.println("[PageDefineDAOImpl]getPageDefineShowList--->>>sql:" +
sql);
conn = Common.getConnection();
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
pageDefineShowList = new ArrayList();
while (rs.next()) {
pageDefineModel = new PageDefineModel();
Debug.println("page_code:" +rs.getString("page_code"));
pageDefineModel.setCode(rs.getString("page_code"));
Debug.println("explain:" +rs.getString("explain"));
pageDefineModel.setExplain(rs.getString("explain"));
Debug.println("rowcolSign:" +rs.getString("rowcolSign"));
pageDefineModel.setRowcolSign(rs.getString("rowcolSign"));
Debug.println("category1:" +rs.getString("category1"));
pageDefineModel.setClass1(rs.getString("category1"));
Debug.println("category2:" +rs.getString("category2"));
pageDefineModel.setClass2(rs.getString("category2"));
Debug.println("BID:" +rs.getString("BID"));
pageDefineModel.setClass3(rs.getString("BID"));
// pageDefineModel.setContent(PubFunc.decodeGB(rs.getString(
// "content")));
Debug.println("page_width:" +rs.getString("page_width"));
pageDefineModel.setPageWidth(rs.getString(
"page_width"));
Debug.println("page_style:" +rs.getString("page_style"));
pageDefineModel.setPageStyle(rs.getString(
"page_style"));
Debug.println("build_date:" +rs.getString("build_date"));
pageDefineModel.setBuildDate(rs.getString(
"build_date"));
Debug.println("order_ID:" +rs.getString("order_ID"));
pageDefineModel.setOrderID(rs.getString(
"order_ID"));
pageDefineShowList.add(pageDefineModel);
Debug.println(
"[PageDefineDAOImpl]getPageDefineShowList--->>>code:" +
rs.getString("code") + " size:" + pageDefineShowList.size());
}
Debug.println(
"[PageDefineDAOImpl]getPageDefineShowList--->>>pageDefineShowList.size():" +
pageDefineShowList.size());
}
catch (SQLException ex) {
Debug.println(
"[PageDefineDAOImpl]getPageDefineShowList--->>>Exception:" +
ex.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 pageDefineShowList;
}
/**
* 定义页面列表
* 应用:
*/
public ArrayList getPageDefineShowList() throws
AppException {
String sql = null;
ArrayList pageDefineShowList = null;
PageDefineModel pageDefineModel = null;
try {
conn = Common.getConnection();
stmt = conn.createStatement();
sql = "SELECT * FROM "
+ TableNameUtil.UNIVERSAL_QUERY_PAGEDEFINE
+ " a,"
+ TableNameUtil.UNIVERSAL_PAGE_DEFINE
+
" b WHERE a.page_code=b.code AND page_type='2' order by order_id"
;
Debug.println("[PageDefineDAOImpl]getPageDefineShowList--->>>sql:" +
sql);
rs = stmt.executeQuery(sql);
pageDefineShowList = new ArrayList();
while (rs.next()) {
pageDefineModel = new PageDefineModel();
pageDefineModel.setCode(PubFunc.decodeGB(rs.getString("page_code")));
pageDefineModel.setExplain(PubFunc.decodeGB(rs.getString(
"explain")));
pageDefineModel.setRowcolSign(PubFunc.decodeGB(rs.getString(
"rowcolSign")));
pageDefineModel.setClass1(PubFunc.decodeGB(rs.getString(
"category1")));
pageDefineModel.setClass2(PubFunc.decodeGB(rs.getString(
"category2")));
pageDefineModel.setClass3(PubFunc.decodeGB(rs.getString(
"BID")));
// pageDefineModel.setContent(PubFunc.decodeGB(rs.getString(
// "content")));
pageDefineModel.setPageWidth(PubFunc.decodeGB(rs.getString(
"page_width")));
pageDefineModel.setPageStyle(PubFunc.decodeGB(rs.getString(
"page_style")));
pageDefineModel.setBuildDate(PubFunc.decodeGB(rs.getString(
"build_date")));
pageDefineModel.setOrderID(PubFunc.decodeGB(rs.getString(
"orderID")));
pageDefineShowList.add(pageDefineModel);
Debug.println(
"[PageDefineDAOImpl]getPageDefineShowList--->>>code:" +
rs.getString("code") + " size:" + pageDefineShowList.size());
}
Debug.println(
"[PageDefineDAOImpl]getPageDefineShowList--->>>pageDefineShowList.size():" +
pageDefineShowList.size());
}
catch (SQLException ex) {
Debug.println(
"[PageDefineDAOImpl]getPageDefineShowList--->>>Exception:" +
ex.getMessage());
}
finally {
try {
this.closePreparedStatement();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -