pagedefinedaoimpl.java

来自「一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs」· Java 代码 · 共 1,598 行 · 第 1/4 页

JAVA
1,598 行
字号
1234
      }
      catch (Exception e) {
      }
      try {
        this.closeResultSet();
      }
      catch (Exception e) {
      }
      try {
        this.closeStatement();
      }
      catch (Exception e) {
      }
      try {
        this.closeConnection();
      }
      catch (Exception e) {
      }
    }

    return pageDefineShowList;
  }

  /**
   * 得到定义页面
   * 应用:
   */
  public PageDefineModel getPageDefineShowMsg(String code) throws
      AppException {
    String sql = null;
    PageDefineModel pageDefineModel = null;

    try {
      conn = Common.getConnection();
      stmt = conn.createStatement();

      //是否正常数据
      if (code == null) {
        Debug.println(
            "[PageDefineDAOImpl]getPageDefineShowMsg------->code is null!");
        return pageDefineModel;
      }

      sql = "select * from "
          + TableNameUtil.UNIVERSAL_PAGE_DEFINE
          + " where code='"
          + code
          + "'";

      Debug.println("[PageDefineDAOImpl]getPageDefineShowMsg--->>>sql:" +
                    sql);
      rs = stmt.executeQuery(sql);

      if (rs.next()) {
        pageDefineModel = new PageDefineModel();
        pageDefineModel.setCode(PubFunc.decodeGB(rs.getString("code")));
        pageDefineModel.setExplain(PubFunc.decodeGB(rs.getString(
            "explain")));
        pageDefineModel.setRowcolSign(PubFunc.decodeGB(rs.getString(
            "rowcolSign")));
        pageDefineModel.setClass1(PubFunc.decodeGB(rs.getString(
            "class1")));
        pageDefineModel.setClass2(PubFunc.decodeGB(rs.getString(
            "class2")));
        pageDefineModel.setClass3(PubFunc.decodeGB(rs.getString(
            "class3")));
//                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")));
      }

      Debug.println("[PageDefineDAOImpl]getPageDefineShowList--->>>ok!");
    }
    catch (Exception 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 pageDefineModel;
  }

  /**
   * 得到该页面所有记录
   * 应用:
   */
  public HashMap getTableCode(String pageCode, String rowColSign) throws
      AppException {
    String sql = null;
    ArrayList tableList = null;
    HashMap tableCodeMap = new HashMap();
    PageDefineDataModel pageDefineDataModel = null;
    int i = 0;
    try {
      conn = Common.getConnection();
      stmt = conn.createStatement();

      //是否正常数据
      if (pageCode == null || rowColSign == null) {
        Debug.println(
            "[PageDefineDAOImpl]getTableCode------->pageCode or model is null!");
        return tableCodeMap;
      }

      Debug.println("[PageDefineDAOImpl]getTableCode--->>>start!");

      sql = "select B.CODE,B.PAGE_CODE,B.UNIT_CODE,B.UNIT_TYPE,B.INPUT_VALUE,B.UNIT_STYLE,B.UNIT_WIDTH,B.UNIT_HEIGHT,B.FONT_TYPE,B.FONT_SIZE,B.FONT_STYLE,B.FONT_COLOR,B.UNIT_ROWSPAN,B.UNIT_COLSPAN,B.UNIT_ROWCOLENDPOINT,B.UNIT_POSITION,B.OUTPUT_VALUE,B.LEFT_HAVENO_SIGN,B.RIGHT_HAVENO_SIGN,B.TOP_HAVENO_SIGN,B.BOTTOM_HAVENO_SIGN,B.LOGIC_MARK,B.POSITIONLOCK,B.TYPELOGIC,B.POSITIONLEFT,B.POSITIONTOP,B.DATA_TYPE,B.DATA_FORMAT,B.UNIT_CLASS,B.EDIT_ITEM from "
          + TableNameUtil.UNIVERSAL_PAGE_DEFINE
          + " A,"
          + TableNameUtil.UNIVERSAL_PAGEELEMENT_DEFINE
          + " b where A.CODE=B.PAGE_CODE and A.ROWCOLSIGN='"
          + rowColSign
          + "' and b.PAGE_CODE='"
          + pageCode
          + "' order by B.UNIT_CODE";

      Debug.println("[PageDefineDAOImpl]getTableCode--->>>sql:" +
                    sql);
      rs = stmt.executeQuery(sql);

      while (rs.next()) {
        tableList = new ArrayList();
        tableList.add(PubFunc.decodeGB(rs.getString("UNIT_CODE"))); //0
        tableList.add(PubFunc.decodeGB(rs.getString("UNIT_TYPE"))); //1
        if (rs.getString("INPUT_VALUE") == null) {
          tableList.add(PubFunc.decodeGB("")); //2
        }
        else {
          tableList.add(PubFunc.decodeGB(rs.getString("INPUT_VALUE"))); //2
        }
        tableList.add(PubFunc.decodeGB(rs.getString("OUTPUT_VALUE"))); //3
        tableList.add(PubFunc.decodeGB(rs.getString("UNIT_STYLE"))); //4
        tableList.add(PubFunc.decodeGB(rs.getString("UNIT_WIDTH"))); //5
        tableList.add(PubFunc.decodeGB(rs.getString("UNIT_HEIGHT"))); //6
        tableList.add(PubFunc.decodeGB(rs.getString("UNIT_CLASS"))); //7
        tableList.add(PubFunc.decodeGB(rs.getString("FONT_COLOR"))); //8
        tableList.add(PubFunc.decodeGB(rs.getString("UNIT_POSITION"))); //9
        tableList.add(PubFunc.decodeGB(rs.getString("UNIT_ROWSPAN"))); //10
        tableList.add(PubFunc.decodeGB(rs.getString("UNIT_COLSPAN"))); //11
        tableList.add(PubFunc.decodeGB(rs.getString("UNIT_ROWCOLENDPOINT"))); //12
        tableList.add(PubFunc.decodeGB(rs.getString("LEFT_HAVENO_SIGN"))); //13
        tableList.add(PubFunc.decodeGB(rs.getString("RIGHT_HAVENO_SIGN"))); //14
        tableList.add(PubFunc.decodeGB(rs.getString("TOP_HAVENO_SIGN"))); //15
        tableList.add(PubFunc.decodeGB(rs.getString("BOTTOM_HAVENO_SIGN"))); //16
        tableList.add(PubFunc.decodeGB(rs.getString("LOGIC_MARK"))); //17
        tableList.add(""); //18
        tableList.add(PubFunc.decodeGB(rs.getString("POSITIONLOCK"))); //19
        tableList.add(PubFunc.decodeGB(rs.getString("TYPELOGIC"))); //20
        tableList.add(PubFunc.decodeGB(rs.getString("POSITIONLEFT"))); //21
        tableList.add(PubFunc.decodeGB(rs.getString("POSITIONTOP"))); //22
        tableList.add(PubFunc.decodeGB(rs.getString("DATA_TYPE"))); //23
        tableList.add(PubFunc.decodeGB(rs.getString("DATA_FORMAT"))); //24
        tableList.add(PubFunc.decodeGB(rs.getString("FONT_TYPE"))); //25
        tableList.add(PubFunc.decodeGB(rs.getString("FONT_SIZE"))); //26
        tableList.add(PubFunc.decodeGB(rs.getString("FONT_STYLE"))); //27
        tableList.add(PubFunc.decodeGB(rs.getString("EDIT_ITEM"))); //28
        tableList.add(PubFunc.decodeGB(rs.getString("CODE"))); //29
        tableCodeMap.put( (Object)new Integer(i++), tableList);

        /*
                         pageDefineDataModel=new PageDefineDataModel();
         pageDefineDataModel.setCode(PubFunc.decodeGB(rs.getString("CODE"))); //0
                         pageDefineDataModel.setUnitType(PubFunc.decodeGB(rs.getString("UNIT_TYPE"))); //1
                         pageDefineDataModel.setInputValue(PubFunc.decodeGB(rs.getString("INPUT_VALUE"))); //2
                         pageDefineDataModel.setOutPutValue(PubFunc.decodeGB(rs.getString("OUTPUT_VALUE"))); //3
                         pageDefineDataModel.setUnitStyle(PubFunc.decodeGB(rs.getString("UNIT_STYLE"))); //4
                         pageDefineDataModel.setUnitWidth(PubFunc.decodeGB(rs.getString("UNIT_WIDTH"))); //5
                         pageDefineDataModel.setUnitHeight(PubFunc.decodeGB(rs.getString("UNIT_HEIGHT"))); //6
                         pageDefineDataModel.setUnitClass(PubFunc.decodeGB(rs.getString("UNIT_CLASS"))); //7
                         pageDefineDataModel.setFontColor(PubFunc.decodeGB(rs.getString("FONT_COLOR"))); //8
                         pageDefineDataModel.setUnitPosition(PubFunc.decodeGB(rs.getString("UNIT_POSITION"))); //9
                         pageDefineDataModel.setUnitRowspan(PubFunc.decodeGB(rs.getString("UNIT_ROWSPAN"))); //10
                         pageDefineDataModel.setUnitColSpan(PubFunc.decodeGB(rs.getString("UNIT_COLSPAN"))); //11
                         pageDefineDataModel.setUnitRowColEndPoint(PubFunc.decodeGB(rs.getString("UNIT_ROWCOLENDPOINT"))); //12
                         pageDefineDataModel.setLeftHaveNOSign(PubFunc.decodeGB(rs.getString("LEFT_HAVENO_SIGN"))); //13
                         pageDefineDataModel.setRightHaveNOSign(PubFunc.decodeGB(rs.getString("RIGHT_HAVENO_SIGN"))); //14
                         pageDefineDataModel.setTopHaveNOSign(PubFunc.decodeGB(rs.getString("TOP_HAVENO_SIGN"))); //15
                         pageDefineDataModel.setBottomHavenoSign(PubFunc.decodeGB(rs.getString("BOTTOM_HAVENO_SIGN"))); //16
                         pageDefineDataModel.setLogicMark(PubFunc.decodeGB(rs.getString("LOGIC_MARK"))); //17
                         pageDefineDataModel.setPositionLock(PubFunc.decodeGB(rs.getString("POSITIONLOCK"))); //19
                         pageDefineDataModel.setTypeLogic(PubFunc.decodeGB(rs.getString("TYPELOGIC"))); //20
                         pageDefineDataModel.setPositionLeft(PubFunc.decodeGB(rs.getString("POSITIONLEFT"))); //21
                         pageDefineDataModel.setPositionTop(PubFunc.decodeGB(rs.getString("POSITIONTOP"))); //22
                         pageDefineDataModel.setDataType(PubFunc.decodeGB(rs.getString("DATA_TYPE"))); //23
                         pageDefineDataModel.setDataFormat(PubFunc.decodeGB(rs.getString("DATA_FORMAT"))); //24
                         pageDefineDataModel.setFontType(PubFunc.decodeGB(rs.getString("FONT_TYPE"))); //25
                         pageDefineDataModel.setFontSize(PubFunc.decodeGB(rs.getString("FONT_SIZE"))); //26
                         pageDefineDataModel.setFontStyle(PubFunc.decodeGB(rs.getString("FONT_STYLE"))); //27
                         tableList.add(pageDefineDataModel);
         */
      }
      Debug.println("[PageDefineDAOImpl]getTableCode--->>>ok!");
    }
    catch (Exception ex) {
      Debug.println(
          "[PageDefineDAOImpl]getTableCode--->>>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 tableCodeMap;
  }

  /**
   * 单逻辑结果
   * 应用:
   */
  public String getLogicResult(String sql) throws
      AppException {
    PageDefineModel pageDefineModel = null;
    String result = "";
    try {
      conn = Common.getConnection();
      stmt = conn.createStatement();

      //是否正常数据
      if (sql == null) {
        Debug.println(
            "[PageDefineDAOImpl]getLogicResult------->sql is null!");
        return result;
      }

      Debug.println("[PageDefineDAOImpl]getLogicResult--->>>sql:" +
                    sql);
      rs = stmt.executeQuery(sql);

      if (rs.next()) {
        result = PubFunc.decodeGB(rs.getString(1));
        if (result == null || "".equals(result)) {
          result = ""; //原始：result = "0";被yuxiaogang于20040406修改
        }
      }

      Debug.println("[PageDefineDAOImpl]getLogicResult--->>>result:" + result);

    }
    catch (Exception ex) {
      Debug.println(
          "[PageDefineDAOImpl]getLogicResult--->>>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 result;
  }

  /**
   * 获得页面元素的编码
   * 应用:
   */
  public HashMap getInputCode(String sql) throws
      AppException {
    PageDefineModel pageDefineModel = null;
    ArrayList logicResultList = null;
    HashMap logicMap = new HashMap();
    String result = "";
    int i = 0;
    try {
      conn = Common.getConnection();
      stmt = conn.createStatement();

      //是否正常数据
      if (sql == null) {
        Debug.println(
            "[PageDefineDAOImpl]getInputCode------->sql is null!");
        return logicMap;
      }

      Debug.println("[PageDefineDAOImpl]getInputCode--->>>sql:" +
                    sql);
      rs = stmt.executeQuery(sql);

      while (rs.next()) {
        logicResultList = new ArrayList();
        logicResultList.add( (PubFunc.decodeGB(rs.getString(1))).trim());
        logicResultList.add( (PubFunc.decodeGB(rs.getString(2))).trim());
        logicMap.put( (Object)new Integer(i++), logicResultList);
      }

      Debug.println("[PageDefineDAOImpl]getInputCode--->>>logicMap:" +
                    logicMap.size());

    }
    catch (Exception ex) {
      Debug.println(
          "[PageDefineDAOImpl]getInputCode--->>>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 logicMap;
  }

  /**
   * 得到表关键字段的sn
   *应用:修改生成形成报表记录数据
   */
  private String getTableSN(String tableName, String fieldCode) throws
      AppException {
    boolean flag = false;
    String sql = null;
    String tableSN = "10000001";

    int intPar = 0;
    try {
1234

pagedefinedaoimpl.java - 源码说明

本页面展示了「一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.」中的 pagedefinedaoimpl.java 源码文件，采用 Java 编程语言编写，共 1,598 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与JSP相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?