channeldao.java

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

      int channelType = channelModel.getChannelType();
      int channelAppear = channelModel.getChannelAppear();
      int channelTrade = channelModel.getChannelTrade();
      int channelFree = channelModel.getChannelFree();
      int channelTest = channelModel.getChannelTest();
      String channelCode = channelModel.getChannelCode();
      int sendMobile = channelModel.getSendMobile();
      String channelRemark = channelModel.getChannelRemark();
      channelModel.setCpId(cpId);
      channelModel.setChannelName(channelName);
      channelModel.setChannelDescribe(channelDescribe);
      channelModel.setChannelUrl(channelUrl);
      channelModel.setChannelAccess(channelAccess);
      channelModel.setChannelSubscribe(channelSubscribe);
      channelModel.setChannelStatus(channelStatus);
      channelModel.setChannelRegdate(channelRegdate);
      channelModel.setChannelType(channelType);
      channelModel.setChannelAppear(channelAppear);
      channelModel.setChannelTrade(channelTrade);
      channelModel.setChannelFree(channelFree);
      channelModel.setChannelTest(channelTest);
      channelModel.setChannelCode(channelCode);
      channelModel.setSendMobile(sendMobile);
      channelModel.setChannelRemark(channelRemark);
      update(channelModel);
    }else if ("delete".equalsIgnoreCase(action)){
      int[] ids = new int[3];
      ids[0] = 1;
      ids[1] = 2;
      ids[2] = 3;
      ChannelBean.delete(ids);
    }else if ("findByPK".equalsIgnoreCase(action)){
      ChannelModel channelModel = ChannelBean.findByPK(1);
      int id = channelModel.getId();
      int cpId = channelModel.getCpId();
      String channelName = channelModel.getChannelName();
      String channelDescribe = channelModel.getChannelDescribe();
      String channelUrl = channelModel.getChannelUrl();
      int channelAccess = channelModel.getChannelAccess();
      int channelSubscribe = channelModel.getChannelSubscribe();
      int channelStatus = channelModel.getChannelStatus();
      Timestamp channelRegdate = channelModel.getChannelRegdate();
      int channelType = channelModel.getChannelType();
      int channelAppear = channelModel.getChannelAppear();
      int channelTrade = channelModel.getChannelTrade();
      int channelFree = channelModel.getChannelFree();
      int channelTest = channelModel.getChannelTest();
      String channelCode = channelModel.getChannelCode();
      int sendMobile = channelModel.getSendMobile();
      String channelRemark = channelModel.getChannelRemark();
      System.out.println("id = " + id);
      System.out.println("cpId = " + cpId);
      System.out.println("channelName = " + channelName);
      System.out.println("channelDescribe = " + channelDescribe);
      System.out.println("channelUrl = " + channelUrl);
      System.out.println("channelAccess = " + channelAccess);
      System.out.println("channelSubscribe = " + channelSubscribe);
      System.out.println("channelStatus = " + channelStatus);
      System.out.println("channelRegdate = " + Function.getYYYYMMDDHHMISS(channelRegdate));
      System.out.println("channelType = " + channelType);
      System.out.println("channelAppear = " + channelAppear);
      System.out.println("channelTrade = " + channelTrade);
      System.out.println("channelFree = " + channelFree);
      System.out.println("channelTest = " + channelTest);
      System.out.println("channelCode = " + channelCode);
      System.out.println("sendMobile = " + sendMobile);
      System.out.println("channelRemark = " + channelRemark);
    }else if ("queryBySql".equalsIgnoreCase(action)){
      Collection coll = ChannelBean.queryBySql("SELECT * FROM WAP_CHANNEL");
    }else if ("getRowCountBySql".equalsIgnoreCase(action)){
      int rowCount = ChannelBean.getRowCountBySql("SELECT COUNT(*) FROM WAP_CHANNEL");
      System.out.println("rowCount = " + rowCount);
    }else if ("queryAll".equalsIgnoreCase(action)){
      Collection coll = ChannelBean.queryAll();
      Iterator it = coll.iterator();
      while ( it.hasNext() ) {
        Hashtable element = (Hashtable)it.next();
        String id = (String)element.get("id");
        String cpId = (String)element.get("cpId");
        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 channelSubscribe = (String)element.get("channelSubscribe");
        String channelStatus = (String)element.get("channelStatus");
        String channelRegdate = Function.getYYYYMMDDHHMISS((Timestamp)element.get("channelRegdate"));
        String channelType = (String)element.get("channelType");
        String channelAppear = (String)element.get("channelAppear");
        String channelTrade = (String)element.get("channelTrade");
        String channelFree = (String)element.get("channelFree");
        String channelTest = (String)element.get("channelTest");
        String channelCode = (String)element.get("channelCode");
        String sendMobile = (String)element.get("sendMobile");
        String channelRemark = (String)element.get("channelRemark");
        System.out.print("id = " + id + ",\t");
        System.out.print("cpId = " + cpId + ",\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("channelSubscribe = " + channelSubscribe + ",\t");
        System.out.print("channelStatus = " + channelStatus + ",\t");
        System.out.print("channelRegdate = " + channelRegdate + ",\t");
        System.out.print("channelType = " + channelType + ",\t");
        System.out.print("channelAppear = " + channelAppear + ",\t");
        System.out.print("channelTrade = " + channelTrade + ",\t");
        System.out.print("channelFree = " + channelFree + ",\t");
        System.out.print("channelTest = " + channelTest + ",\t");
        System.out.print("channelCode = " + channelCode + ",\t");
        System.out.print("sendMobile = " + sendMobile + ",\t");
        System.out.print("channelRemark = " + channelRemark + "\n");
      }
    }else if ("getRowCountOfAll".equalsIgnoreCase(action)){
      int rowCount = ChannelBean.getRowCountOfAll();
      System.out.println("rowCount = " + rowCount);
    }else if ("getSequenceNextValue".equalsIgnoreCase(action)){
      int sequenceValue = ChannelBean.getSequenceNextValue();
      System.out.println("sequenceValue = " + sequenceValue);
    }
  }
}
/*
int id = (model==null?0:model.getId());
int cpId = (model==null?0:model.getCpId());
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 channelSubscribe = (model==null?0:model.getChannelSubscribe());
int channelStatus = (model==null?0:model.getChannelStatus());
Timestamp channelRegdate = (model==null?null:model.getChannelRegdate());
int channelType = (model==null?0:model.getChannelType());
int channelAppear = (model==null?0:model.getChannelAppear());
int channelTrade = (model==null?0:model.getChannelTrade());
int channelFree = (model==null?0:model.getChannelFree());
int channelTest = (model==null?0:model.getChannelTest());
String channelCode = (model==null?"":model.getChannelCode());
int sendMobile = (model==null?0:model.getSendMobile());
String channelRemark = (model==null?"":model.getChannelRemark());
int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, );
int cpId = PageUtil.parseIntField(request.getParameter("cpId"), "cpId", false, 0, );
String channelName = PageUtil.parseStringField(request.getParameter("channelName"), "channelName", false, 19);
String channelDescribe = PageUtil.parseStringField(request.getParameter("channelDescribe"), "channelDescribe", false, 199);
String channelUrl = PageUtil.parseStringField(request.getParameter("channelUrl"), "channelUrl", false, 199);
int channelAccess = PageUtil.parseIntField(request.getParameter("channelAccess"), "channelAccess", false, 0, 199);
int channelSubscribe = PageUtil.parseIntField(request.getParameter("channelSubscribe"), "channelSubscribe", 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 channelAppear = PageUtil.parseIntField(request.getParameter("channelAppear"), "channelAppear", false, 0, 199);
int channelTrade = PageUtil.parseIntField(request.getParameter("channelTrade"), "channelTrade", false, 0, 199);
int channelFree = PageUtil.parseIntField(request.getParameter("channelFree"), "channelFree", false, 0, 199);
int channelTest = PageUtil.parseIntField(request.getParameter("channelTest"), "channelTest", false, 0, 199);
String channelCode = PageUtil.parseStringField(request.getParameter("channelCode"), "channelCode", false, 19);
int sendMobile = PageUtil.parseIntField(request.getParameter("sendMobile"), "sendMobile", false, 0, 19);
String channelRemark = PageUtil.parseStringField(request.getParameter("channelRemark"), "channelRemark", false, 199);


int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, 2147483647);
int cpId = PageUtil.parseIntField(request.getParameter("cpId"), "cpId", true, 0, 2147483647);
String channelName = PageUtil.parseStringField(request.getParameter("channelName"), "channelName", true, 20);
String channelDescribe = PageUtil.parseStringField(request.getParameter("channelDescribe"), "channelDescribe", true, 200);
String channelUrl = PageUtil.parseStringField(request.getParameter("channelUrl"), "channelUrl", true, 200);
int channelAccess = PageUtil.parseIntField(request.getParameter("channelAccess"), "channelAccess", true, 0, 2147483647);
int channelSubscribe = PageUtil.parseIntField(request.getParameter("channelSubscribe"), "channelSubscribe", 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 channelAppear = PageUtil.parseIntField(request.getParameter("channelAppear"), "channelAppear", true, 0, 2147483647);
int channelTrade = PageUtil.parseIntField(request.getParameter("channelTrade"), "channelTrade", true, 0, 2147483647);
int channelFree = PageUtil.parseIntField(request.getParameter("channelFree"), "channelFree", true, 0, 2147483647);
int channelTest = PageUtil.parseIntField(request.getParameter("channelTest"), "channelTest", true, 0, 2147483647);
String channelCode = PageUtil.parseStringField(request.getParameter("channelCode"), "channelCode", true, 20);
int sendMobile = PageUtil.parseIntField(request.getParameter("sendMobile"), "sendMobile", true, 0, 2147483647);
String channelRemark = PageUtil.parseStringField(request.getParameter("channelRemark"), "channelRemark", true, 200);
String id = (model==null?"0":""+model.getId());
String cpId = (model==null?"0":""+model.getCpId());
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 channelSubscribe = (model==null?"0":""+model.getChannelSubscribe());
String channelStatus = (model==null?"0":""+model.getChannelStatus());
Timestamp channelRegdate = (model==null?null:model.getChannelRegdate());
String channelType = (model==null?"0":""+model.getChannelType());
String channelAppear = (model==null?"0":""+model.getChannelAppear());
String channelTrade = (model==null?"0":""+model.getChannelTrade());
String channelFree = (model==null?"0":""+model.getChannelFree());
String channelTest = (model==null?"0":""+model.getChannelTest());
String channelCode = (model==null?"":""+model.getChannelCode());
String sendMobile = (model==null?"0":""+model.getSendMobile());
String channelRemark = (model==null?"":""+model.getChannelRemark());

Collection coll = ChannelBean.queryAll((pageNum-1) * pageRow + 1, pageNum * pageRow);
Iterator it = coll.iterator();
while ( it.hasNext() ) {
    Hashtable element = (Hashtable)it.next();
    ChannelModel channelModel = ChannelBean.toModel(element);
    int id = channelModel.getId();
    int cpId = channelModel.getCpId();
    String channelName = channelModel.getChannelName();
    String channelDescribe = channelModel.getChannelDescribe();
    String channelUrl = channelModel.getChannelUrl();
    int channelAccess = channelModel.getChannelAccess();
    int channelSubscribe = channelModel.getChannelSubscribe();
    int channelStatus = channelModel.getChannelStatus();
    Timestamp channelRegdate = channelModel.getChannelRegdate();
    int channelType = channelModel.getChannelType();
    int channelAppear = channelModel.getChannelAppear();
    int channelTrade = channelModel.getChannelTrade();
    int channelFree = channelModel.getChannelFree();
    int channelTest = channelModel.getChannelTest();
    String channelCode = channelModel.getChannelCode();
    int sendMobile = channelModel.getSendMobile();
    String channelRemark = channelModel.getChannelRemark();

        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), id+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), cpId+"");
        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++), channelSubscribe+"");
        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++), channelAppear+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), channelTrade+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), channelFree+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), channelTest+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), channelCode+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), sendMobile+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), channelRemark+"");
*/