systemparamdao.java

WAP PUSH后台源码,WAP PUSH后台源码

          + Function.writeDBEncode(model.getStatPicturePath()) + "', '"
          + Function.writeDBEncode(model.getSmallPicturePath()) + "', '"
          + Function.writeDBEncode(model.getSystemCode()) + "', '"
          + Function.writeDBEncode(model.getSystemState()) + "')";
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "INSERT INTO WAP_SYSTEM_PARAM (ID, SYSTEM_NAME, MANAGE_MAIN_PAGE_URI, MANAGE_INDEX_PAGE_URI, USER_MAIN_PAGE_URI, USER_INDEX_PAGE_URI, CP_INDEX_PAGE_URI, CP_MAIN_PAGE_URI, GROUP_INDEX_PAGE_URI, GROUP_MAIN_PAGE_URI, INIT_PAGE_ROW, IMG_LOCATION, CLEAR_SUB_TYPE, SYSTEM_INTRO, EXCEL_PATH, STAT_PICTURE_PATH, SMALL_PICTURE_PATH, SYSTEM_CODE, SYSTEM_STATE) VALUES ("
          + model.getId() + ", '"
          + Function.writeDBEncode(model.getSystemName()) + "', '"
          + Function.writeDBEncode(model.getManageMainPageUri()) + "', '"
          + Function.writeDBEncode(model.getManageIndexPageUri()) + "', '"
          + Function.writeDBEncode(model.getUserMainPageUri()) + "', '"
          + Function.writeDBEncode(model.getUserIndexPageUri()) + "', '"
          + Function.writeDBEncode(model.getCpIndexPageUri()) + "', '"
          + Function.writeDBEncode(model.getCpMainPageUri()) + "', '"
          + Function.writeDBEncode(model.getGroupIndexPageUri()) + "', '"
          + Function.writeDBEncode(model.getGroupMainPageUri()) + "', "
          + model.getInitPageRow() + ", '"
          + Function.writeDBEncode(model.getImgLocation()) + "', "
          + model.getClearSubType() + ", '"
          + Function.writeDBEncode(model.getSystemIntro()) + "', '"
          + Function.writeDBEncode(model.getExcelPath()) + "', '"
          + Function.writeDBEncode(model.getStatPicturePath()) + "', '"
          + Function.writeDBEncode(model.getSmallPicturePath()) + "', '"
          + Function.writeDBEncode(model.getSystemCode()) + "', '"
          + Function.writeDBEncode(model.getSystemState()) + "')";
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "INSERT INTO WAP_SYSTEM_PARAM (ID, SYSTEM_NAME, MANAGE_MAIN_PAGE_URI, MANAGE_INDEX_PAGE_URI, USER_MAIN_PAGE_URI, USER_INDEX_PAGE_URI, CP_INDEX_PAGE_URI, CP_MAIN_PAGE_URI, GROUP_INDEX_PAGE_URI, GROUP_MAIN_PAGE_URI, INIT_PAGE_ROW, IMG_LOCATION, CLEAR_SUB_TYPE, SYSTEM_INTRO, EXCEL_PATH, STAT_PICTURE_PATH, SMALL_PICTURE_PATH, SYSTEM_CODE, SYSTEM_STATE) VALUES ("
          + model.getId() + ", '"
          + Function.writeDBEncode(model.getSystemName()) + "', '"
          + Function.writeDBEncode(model.getManageMainPageUri()) + "', '"
          + Function.writeDBEncode(model.getManageIndexPageUri()) + "', '"
          + Function.writeDBEncode(model.getUserMainPageUri()) + "', '"
          + Function.writeDBEncode(model.getUserIndexPageUri()) + "', '"
          + Function.writeDBEncode(model.getCpIndexPageUri()) + "', '"
          + Function.writeDBEncode(model.getCpMainPageUri()) + "', '"
          + Function.writeDBEncode(model.getGroupIndexPageUri()) + "', '"
          + Function.writeDBEncode(model.getGroupMainPageUri()) + "', "
          + model.getInitPageRow() + ", '"
          + Function.writeDBEncode(model.getImgLocation()) + "', "
          + model.getClearSubType() + ", '"
          + Function.writeDBEncode(model.getSystemIntro()) + "', '"
          + Function.writeDBEncode(model.getExcelPath()) + "', '"
          + Function.writeDBEncode(model.getStatPicturePath()) + "', '"
          + Function.writeDBEncode(model.getSmallPicturePath()) + "', '"
          + Function.writeDBEncode(model.getSystemCode()) + "', '"
          + Function.writeDBEncode(model.getSystemState()) + "')";
    }
    return sql;
  }
  protected static String getUpdateSQL(SystemParamModel model) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "UPDATE WAP_SYSTEM_PARAM SET SYSTEM_NAME = '"
          + Function.writeDBEncode(model.getSystemName()) + "', MANAGE_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getManageMainPageUri()) + "', MANAGE_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getManageIndexPageUri()) + "', USER_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getUserMainPageUri()) + "', USER_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getUserIndexPageUri()) + "', CP_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getCpIndexPageUri()) + "', CP_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getCpMainPageUri()) + "', GROUP_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getGroupIndexPageUri()) + "', GROUP_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getGroupMainPageUri()) + "', INIT_PAGE_ROW = "
          + model.getInitPageRow() + ", IMG_LOCATION = '"
          + Function.writeDBEncode(model.getImgLocation()) + "', CLEAR_SUB_TYPE = "
          + model.getClearSubType() + ", SYSTEM_INTRO = '"
          + Function.writeDBEncode(model.getSystemIntro()) + "', EXCEL_PATH = '"
          + Function.writeDBEncode(model.getExcelPath()) + "', STAT_PICTURE_PATH = '"
          + Function.writeDBEncode(model.getStatPicturePath()) + "', SMALL_PICTURE_PATH = '"
          + Function.writeDBEncode(model.getSmallPicturePath()) + "', SYSTEM_CODE = '"
          + Function.writeDBEncode(model.getSystemCode()) + "', SYSTEM_STATE = '"
          + Function.writeDBEncode(model.getSystemState()) + "' WHERE ID = " + model.getId();
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "UPDATE WAP_SYSTEM_PARAM SET SYSTEM_NAME = '"
          + Function.writeDBEncode(model.getSystemName()) + "', MANAGE_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getManageMainPageUri()) + "', MANAGE_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getManageIndexPageUri()) + "', USER_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getUserMainPageUri()) + "', USER_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getUserIndexPageUri()) + "', CP_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getCpIndexPageUri()) + "', CP_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getCpMainPageUri()) + "', GROUP_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getGroupIndexPageUri()) + "', GROUP_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getGroupMainPageUri()) + "', INIT_PAGE_ROW = "
          + model.getInitPageRow() + ", IMG_LOCATION = '"
          + Function.writeDBEncode(model.getImgLocation()) + "', CLEAR_SUB_TYPE = "
          + model.getClearSubType() + ", SYSTEM_INTRO = '"
          + Function.writeDBEncode(model.getSystemIntro()) + "', EXCEL_PATH = '"
          + Function.writeDBEncode(model.getExcelPath()) + "', STAT_PICTURE_PATH = '"
          + Function.writeDBEncode(model.getStatPicturePath()) + "', SMALL_PICTURE_PATH = '"
          + Function.writeDBEncode(model.getSmallPicturePath()) + "', SYSTEM_CODE = '"
          + Function.writeDBEncode(model.getSystemCode()) + "', SYSTEM_STATE = '"
          + Function.writeDBEncode(model.getSystemState()) + "' WHERE ID = " + model.getId();
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "UPDATE WAP_SYSTEM_PARAM SET SYSTEM_NAME = '"
          + Function.writeDBEncode(model.getSystemName()) + "', MANAGE_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getManageMainPageUri()) + "', MANAGE_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getManageIndexPageUri()) + "', USER_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getUserMainPageUri()) + "', USER_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getUserIndexPageUri()) + "', CP_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getCpIndexPageUri()) + "', CP_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getCpMainPageUri()) + "', GROUP_INDEX_PAGE_URI = '"
          + Function.writeDBEncode(model.getGroupIndexPageUri()) + "', GROUP_MAIN_PAGE_URI = '"
          + Function.writeDBEncode(model.getGroupMainPageUri()) + "', INIT_PAGE_ROW = "
          + model.getInitPageRow() + ", IMG_LOCATION = '"
          + Function.writeDBEncode(model.getImgLocation()) + "', CLEAR_SUB_TYPE = "
          + model.getClearSubType() + ", SYSTEM_INTRO = '"
          + Function.writeDBEncode(model.getSystemIntro()) + "', EXCEL_PATH = '"
          + Function.writeDBEncode(model.getExcelPath()) + "', STAT_PICTURE_PATH = '"
          + Function.writeDBEncode(model.getStatPicturePath()) + "', SMALL_PICTURE_PATH = '"
          + Function.writeDBEncode(model.getSmallPicturePath()) + "', SYSTEM_CODE = '"
          + Function.writeDBEncode(model.getSystemCode()) + "', SYSTEM_STATE = '"
          + Function.writeDBEncode(model.getSystemState()) + "' WHERE ID = " + model.getId();
    }
    return sql;
  }
  protected static String getDeleteSQL(int id) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_SYSTEM_PARAM WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_SYSTEM_PARAM WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_SYSTEM_PARAM WHERE ID = " + id;
    }
    return sql;
  }
  protected static String getDeleteSQL(int[] ids) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_SYSTEM_PARAM WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR ID = " + ids[i];
      }
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_SYSTEM_PARAM WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR ID = " + ids[i];
      }
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_SYSTEM_PARAM WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR ID = " + ids[i];
      }
    }
    return sql;
  }
  protected static String getFindByPKSQL(int id) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "SELECT * FROM WAP_SYSTEM_PARAM WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "SELECT * FROM WAP_SYSTEM_PARAM WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "SELECT * FROM WAP_SYSTEM_PARAM WHERE ID = " + id;
    }
    return sql;
  }
  protected static boolean isValidData(SystemParamModel model) {
    return true;
  }
  private static Connection getDBConnection() throws SysException {
    return Database.getConnection();
  }
  private static void closeConnection(Connection dbConnection) throws SysException {
    try {
      if (dbConnection != null && !dbConnection.isClosed()) {
        dbConnection.close();
        dbConnection = null;
      }
    } catch (SQLException se) {
      //throw new SysException("SQL Exception while closing DB connection : \n" + se);
    }
  }
  private static void closeResultSet(ResultSet result) throws SysException {
    try {
      if (result != null) {
        result.close();
      }
    } catch (SQLException se) {
      //throw new SysException("SQL Exception while closing Result Set : \n" + se);
    }
  }
  private static void closeStatement(Statement stmt) throws SysException {
    try {
      if (stmt != null) {
        stmt.close();
      }
    } catch (SQLException se) {
      //throw new SysException("SQL Exception while closing Statement : \n" + se);
    }
  }
  public static void main(String[] args) throws Exception{
    String action = "";
    if (args.length == 1) {
      action = args[0];
    }
    if (action == null || "".equals(action)) {

    } else if ("insert".equalsIgnoreCase(action)) {
      SystemParamModel model=new SystemParamModel();
      model.setId(SystemParamBean.getSequenceNextValue());
      model.setSystemName("abc");
      model.setManageMainPageUri("abc");
      model.setManageIndexPageUri("abc");
      model.setUserMainPageUri("abc");
      model.setUserIndexPageUri("abc");
      model.setCpIndexPageUri("abc");
      model.setCpMainPageUri("abc");
      model.setGroupIndexPageUri("abc");
      model.setGroupMainPageUri("abc");
      model.setInitPageRow(1);
      model.setImgLocation("abc");
      model.setClearSubType(1);
      model.setSystemIntro("abc");
      model.setExcelPath("abc");
      model.setStatPicturePath("abc");
      model.setSmallPicturePath("abc");
      model.setSystemCode("abc");
      model.setSystemState("abc");
      SystemParamModel systemParamModel = SystemParamBean.insert(model);
    }else if ("update".equalsIgnoreCase(action)){
      SystemParamModel systemParamModel = SystemParamBean.findByPK(1);
      int id = systemParamModel.getId();
      String systemName = systemParamModel.getSystemName();
      String manageMainPageUri = systemParamModel.getManageMainPageUri();
      String manageIndexPageUri = systemParamModel.getManageIndexPageUri();
      String userMainPageUri = systemParamModel.getUserMainPageUri();
      String userIndexPageUri = systemParamModel.getUserIndexPageUri();
      String cpIndexPageUri = systemParamModel.getCpIndexPageUri();
      String cpMainPageUri = systemParamModel.getCpMainPageUri();
      String groupIndexPageUri = systemParamModel.getGroupIndexPageUri();
      String groupMainPageUri = systemParamModel.getGroupMainPageUri();
      int initPageRow = systemParamModel.getInitPageRow();
      String imgLocation = systemParamModel.getImgLocation();
      int clearSubType = systemParamModel.getClearSubType();
      String systemIntro = systemParamModel.getSystemIntro();
      String excelPath = systemParamModel.getExcelPath();
      String statPicturePath = systemParamModel.getStatPicturePath();
      String smallPicturePath = systemParamModel.getSmallPicturePath();
      String systemCode = systemParamModel.getSystemCode();
      String systemState = systemParamModel.getSystemState();
      systemParamModel.setSystemName(systemName);
      systemParamModel.setManageMainPageUri(manageMainPageUri);
      systemParamModel.setManageIndexPageUri(manageIndexPageUri);
      systemParamModel.setUserMainPageUri(userMainPageUri);
      systemParamModel.setUserIndexPageUri(userIndexPageUri);