groupchanneldao.java

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

  protected static String getDeleteSQL(int id) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_GROUP_CHANNEL WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_GROUP_CHANNEL WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_GROUP_CHANNEL WHERE ID = " + id;
    }
    return sql;
  }
  protected static String getDeleteSQL(int[] ids) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_GROUP_CHANNEL 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_GROUP_CHANNEL 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_GROUP_CHANNEL 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_GROUP_CHANNEL WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "SELECT * FROM WAP_GROUP_CHANNEL WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "SELECT * FROM WAP_GROUP_CHANNEL WHERE ID = " + id;
    }
    return sql;
  }
  protected static boolean isValidData(GroupChannelModel 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)) {
      GroupChannelModel model=new GroupChannelModel();
      model.setId(GroupChannelBean.getSequenceNextValue());
      model.setChannelTrade(1);
      model.setChannelName("abc");
      model.setChannelDescribe("abc");
      model.setChannelUrl("abc");
      model.setChannelAccess(1);
      model.setChannelStatus(1);
      model.setChannelRegdate(Function.getCurrTime());
      model.setChannelType(1);
      model.setChannelPublic(1);
      model.setChannelCode("abc");
      GroupChannelModel groupChannelModel = GroupChannelBean.insert(model);
    }else if ("update".equalsIgnoreCase(action)){
      GroupChannelModel groupChannelModel = GroupChannelBean.findByPK(1);
      int id = groupChannelModel.getId();
      int channelTrade = groupChannelModel.getChannelTrade();
      String channelName = groupChannelModel.getChannelName();
      String channelDescribe = groupChannelModel.getChannelDescribe();
      String channelUrl = groupChannelModel.getChannelUrl();
      int channelAccess = groupChannelModel.getChannelAccess();
      int channelStatus = groupChannelModel.getChannelStatus();
      Timestamp channelRegdate = groupChannelModel.getChannelRegdate();
      int channelType = groupChannelModel.getChannelType();
      int channelPublic = groupChannelModel.getChannelPublic();
      String channelCode = groupChannelModel.getChannelCode();
      groupChannelModel.setChannelTrade(channelTrade);
      groupChannelModel.setChannelName(channelName);
      groupChannelModel.setChannelDescribe(channelDescribe);
      groupChannelModel.setChannelUrl(channelUrl);
      groupChannelModel.setChannelAccess(channelAccess);
      groupChannelModel.setChannelStatus(channelStatus);
      groupChannelModel.setChannelRegdate(channelRegdate);
      groupChannelModel.setChannelType(channelType);
      groupChannelModel.setChannelPublic(channelPublic);
      groupChannelModel.setChannelCode(channelCode);
      update(groupChannelModel);
    }else if ("delete".equalsIgnoreCase(action)){
      int[] ids = new int[3];
      ids[0] = 1;
      ids[1] = 2;
      ids[2] = 3;
      GroupChannelBean.delete(ids);
    }else if ("findByPK".equalsIgnoreCase(action)){
      GroupChannelModel groupChannelModel = GroupChannelBean.findByPK(1);
      int id = groupChannelModel.getId();
      int channelTrade = groupChannelModel.getChannelTrade();
      String channelName = groupChannelModel.getChannelName();
      String channelDescribe = groupChannelModel.getChannelDescribe();
      String channelUrl = groupChannelModel.getChannelUrl();
      int channelAccess = groupChannelModel.getChannelAccess();
      int channelStatus = groupChannelModel.getChannelStatus();
      Timestamp channelRegdate = groupChannelModel.getChannelRegdate();
      int channelType = groupChannelModel.getChannelType();
      int channelPublic = groupChannelModel.getChannelPublic();
      String channelCode = groupChannelModel.getChannelCode();
      System.out.println("id = " + id);
      System.out.println("channelTrade = " + channelTrade);
      System.out.println("channelName = " + channelName);
      System.out.println("channelDescribe = " + channelDescribe);
      System.out.println("channelUrl = " + channelUrl);
      System.out.println("channelAccess = " + channelAccess);
      System.out.println("channelStatus = " + channelStatus);
      System.out.println("channelRegdate = " + Function.getYYYYMMDDHHMISS(channelRegdate));
      System.out.println("channelType = " + channelType);
      System.out.println("channelPublic = " + channelPublic);
      System.out.println("channelCode = " + channelCode);
    }else if ("queryBySql".equalsIgnoreCase(action)){
      Collection coll = GroupChannelBean.queryBySql("SELECT * FROM WAP_GROUP_CHANNEL");
    }else if ("getRowCountBySql".equalsIgnoreCase(action)){
      int rowCount = GroupChannelBean.getRowCountBySql("SELECT COUNT(*) FROM WAP_GROUP_CHANNEL");
      System.out.println("rowCount = " + rowCount);
    }else if ("queryAll".equalsIgnoreCase(action)){
      Collection coll = GroupChannelBean.queryAll();
      Iterator it = coll.iterator();
      while ( it.hasNext() ) {
        Hashtable element = (Hashtable)it.next();
        String id = (String)element.get("id");
        String channelTrade = (String)element.get("channelTrade");
        String channelName = (String)element.get("channelName");
        String channelDescribe = (String)element.get("channelDescribe");
        String channelUrl = (String)element.get("channelUrl");
        String channelAccess = (String)element.get("channelAccess");
        String channelStatus = (String)element.get("channelStatus");
        String channelRegdate = Function.getYYYYMMDDHHMISS((Timestamp)element.get("channelRegdate"));
        String channelType = (String)element.get("channelType");
        String channelPublic = (String)element.get("channelPublic");
        String channelCode = (String)element.get("channelCode");
        System.out.print("id = " + id + ",\t");
        System.out.print("channelTrade = " + channelTrade + ",\t");
        System.out.print("channelName = " + channelName + ",\t");
        System.out.print("channelDescribe = " + channelDescribe + ",\t");
        System.out.print("channelUrl = " + channelUrl + ",\t");
        System.out.print("channelAccess = " + channelAccess + ",\t");
        System.out.print("channelStatus = " + channelStatus + ",\t");
        System.out.print("channelRegdate = " + channelRegdate + ",\t");
        System.out.print("channelType = " + channelType + ",\t");
        System.out.print("channelPublic = " + channelPublic + ",\t");
        System.out.print("channelCode = " + channelCode + "\n");
      }
    }else if ("getRowCountOfAll".equalsIgnoreCase(action)){
      int rowCount = GroupChannelBean.getRowCountOfAll();
      System.out.println("rowCount = " + rowCount);
    }else if ("getSequenceNextValue".equalsIgnoreCase(action)){
      int sequenceValue = GroupChannelBean.getSequenceNextValue();
      System.out.println("sequenceValue = " + sequenceValue);
    }
  }
}
/*
int id = (model==null?0:model.getId());
int channelTrade = (model==null?0:model.getChannelTrade());
String channelName = (model==null?"":model.getChannelName());
String channelDescribe = (model==null?"":model.getChannelDescribe());
String channelUrl = (model==null?"":model.getChannelUrl());
int channelAccess = (model==null?0:model.getChannelAccess());
int channelStatus = (model==null?0:model.getChannelStatus());
Timestamp channelRegdate = (model==null?null:model.getChannelRegdate());
int channelType = (model==null?0:model.getChannelType());
int channelPublic = (model==null?0:model.getChannelPublic());
String channelCode = (model==null?"":model.getChannelCode());
int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, );
int channelTrade = PageUtil.parseIntField(request.getParameter("channelTrade"), "channelTrade", false, 0, );
String channelName = PageUtil.parseStringField(request.getParameter("channelName"), "channelName", false, 19);
String channelDescribe = PageUtil.parseStringField(request.getParameter("channelDescribe"), "channelDescribe", false, 254);
String channelUrl = PageUtil.parseStringField(request.getParameter("channelUrl"), "channelUrl", false, 199);
int channelAccess = PageUtil.parseIntField(request.getParameter("channelAccess"), "channelAccess", false, 0, 199);
int channelStatus = PageUtil.parseIntField(request.getParameter("channelStatus"), "channelStatus", false, 0, 199);
int channelType = PageUtil.parseIntField(request.getParameter("channelType"), "channelType", false, 0, 199);
int channelPublic = PageUtil.parseIntField(request.getParameter("channelPublic"), "channelPublic", false, 0, 199);
String channelCode = PageUtil.parseStringField(request.getParameter("channelCode"), "channelCode", false, 19);


int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, 2147483647);
int channelTrade = PageUtil.parseIntField(request.getParameter("channelTrade"), "channelTrade", true, 0, 2147483647);
String channelName = PageUtil.parseStringField(request.getParameter("channelName"), "channelName", true, 20);
String channelDescribe = PageUtil.parseStringField(request.getParameter("channelDescribe"), "channelDescribe", true, 255);
String channelUrl = PageUtil.parseStringField(request.getParameter("channelUrl"), "channelUrl", true, 200);
int channelAccess = PageUtil.parseIntField(request.getParameter("channelAccess"), "channelAccess", true, 0, 2147483647);
int channelStatus = PageUtil.parseIntField(request.getParameter("channelStatus"), "channelStatus", true, 0, 2147483647);
Timestamp channelRegdate = PageUtil.parseDateField(request.getParameter("channelRegdate"), "channelRegdate", true);
int channelType = PageUtil.parseIntField(request.getParameter("channelType"), "channelType", true, 0, 2147483647);
int channelPublic = PageUtil.parseIntField(request.getParameter("channelPublic"), "channelPublic", true, 0, 2147483647);
String channelCode = PageUtil.parseStringField(request.getParameter("channelCode"), "channelCode", true, 20);
String id = (model==null?"0":""+model.getId());
String channelTrade = (model==null?"0":""+model.getChannelTrade());
String channelName = (model==null?"":""+model.getChannelName());
String channelDescribe = (model==null?"":""+model.getChannelDescribe());
String channelUrl = (model==null?"":""+model.getChannelUrl());
String channelAccess = (model==null?"0":""+model.getChannelAccess());
String channelStatus = (model==null?"0":""+model.getChannelStatus());
Timestamp channelRegdate = (model==null?null:model.getChannelRegdate());
String channelType = (model==null?"0":""+model.getChannelType());
String channelPublic = (model==null?"0":""+model.getChannelPublic());
String channelCode = (model==null?"":""+model.getChannelCode());

Collection coll = GroupChannelBean.queryAll((pageNum-1) * pageRow + 1, pageNum * pageRow);
Iterator it = coll.iterator();
while ( it.hasNext() ) {
    Hashtable element = (Hashtable)it.next();
    GroupChannelModel groupChannelModel = GroupChannelBean.toModel(element);
    int id = groupChannelModel.getId();
    int channelTrade = groupChannelModel.getChannelTrade();
    String channelName = groupChannelModel.getChannelName();
    String channelDescribe = groupChannelModel.getChannelDescribe();
    String channelUrl = groupChannelModel.getChannelUrl();
    int channelAccess = groupChannelModel.getChannelAccess();
    int channelStatus = groupChannelModel.getChannelStatus();
    Timestamp channelRegdate = groupChannelModel.getChannelRegdate();
    int channelType = groupChannelModel.getChannelType();
    int channelPublic = groupChannelModel.getChannelPublic();
    String channelCode = groupChannelModel.getChannelCode();

        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), id+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), channelTrade+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), channelName+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), channelDescribe+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), channelUrl+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), channelAccess+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), channelStatus+"");
        excel.setCellData(new ExcelCell(ExcelUtil.DATE_CELL_TYTE,   currRow, currCol++), channelRegdate);
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), channelType+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), channelPublic+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), channelCode+"");
*/