systemparamdao.java

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

      systemParamModel.setCpIndexPageUri(cpIndexPageUri);
      systemParamModel.setCpMainPageUri(cpMainPageUri);
      systemParamModel.setGroupIndexPageUri(groupIndexPageUri);
      systemParamModel.setGroupMainPageUri(groupMainPageUri);
      systemParamModel.setInitPageRow(initPageRow);
      systemParamModel.setImgLocation(imgLocation);
      systemParamModel.setClearSubType(clearSubType);
      systemParamModel.setSystemIntro(systemIntro);
      systemParamModel.setExcelPath(excelPath);
      systemParamModel.setStatPicturePath(statPicturePath);
      systemParamModel.setSmallPicturePath(smallPicturePath);
      systemParamModel.setSystemCode(systemCode);
      systemParamModel.setSystemState(systemState);
      update(systemParamModel);
    }else if ("delete".equalsIgnoreCase(action)){
      int[] ids = new int[3];
      ids[0] = 1;
      ids[1] = 2;
      ids[2] = 3;
      SystemParamBean.delete(ids);
    }else if ("findByPK".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();
      System.out.println("id = " + id);
      System.out.println("systemName = " + systemName);
      System.out.println("manageMainPageUri = " + manageMainPageUri);
      System.out.println("manageIndexPageUri = " + manageIndexPageUri);
      System.out.println("userMainPageUri = " + userMainPageUri);
      System.out.println("userIndexPageUri = " + userIndexPageUri);
      System.out.println("cpIndexPageUri = " + cpIndexPageUri);
      System.out.println("cpMainPageUri = " + cpMainPageUri);
      System.out.println("groupIndexPageUri = " + groupIndexPageUri);
      System.out.println("groupMainPageUri = " + groupMainPageUri);
      System.out.println("initPageRow = " + initPageRow);
      System.out.println("imgLocation = " + imgLocation);
      System.out.println("clearSubType = " + clearSubType);
      System.out.println("systemIntro = " + systemIntro);
      System.out.println("excelPath = " + excelPath);
      System.out.println("statPicturePath = " + statPicturePath);
      System.out.println("smallPicturePath = " + smallPicturePath);
      System.out.println("systemCode = " + systemCode);
      System.out.println("systemState = " + systemState);
    }else if ("queryBySql".equalsIgnoreCase(action)){
      Collection coll = SystemParamBean.queryBySql("SELECT * FROM WAP_SYSTEM_PARAM");
    }else if ("getRowCountBySql".equalsIgnoreCase(action)){
      int rowCount = SystemParamBean.getRowCountBySql("SELECT COUNT(*) FROM WAP_SYSTEM_PARAM");
      System.out.println("rowCount = " + rowCount);
    }else if ("queryAll".equalsIgnoreCase(action)){
      Collection coll = SystemParamBean.queryAll();
      Iterator it = coll.iterator();
      while ( it.hasNext() ) {
        Hashtable element = (Hashtable)it.next();
        String id = (String)element.get("id");
        String systemName = (String)element.get("systemName");
        String manageMainPageUri = (String)element.get("manageMainPageUri");
        String manageIndexPageUri = (String)element.get("manageIndexPageUri");
        String userMainPageUri = (String)element.get("userMainPageUri");
        String userIndexPageUri = (String)element.get("userIndexPageUri");
        String cpIndexPageUri = (String)element.get("cpIndexPageUri");
        String cpMainPageUri = (String)element.get("cpMainPageUri");
        String groupIndexPageUri = (String)element.get("groupIndexPageUri");
        String groupMainPageUri = (String)element.get("groupMainPageUri");
        String initPageRow = (String)element.get("initPageRow");
        String imgLocation = (String)element.get("imgLocation");
        String clearSubType = (String)element.get("clearSubType");
        String systemIntro = (String)element.get("systemIntro");
        String excelPath = (String)element.get("excelPath");
        String statPicturePath = (String)element.get("statPicturePath");
        String smallPicturePath = (String)element.get("smallPicturePath");
        String systemCode = (String)element.get("systemCode");
        String systemState = (String)element.get("systemState");
        System.out.print("id = " + id + ",\t");
        System.out.print("systemName = " + systemName + ",\t");
        System.out.print("manageMainPageUri = " + manageMainPageUri + ",\t");
        System.out.print("manageIndexPageUri = " + manageIndexPageUri + ",\t");
        System.out.print("userMainPageUri = " + userMainPageUri + ",\t");
        System.out.print("userIndexPageUri = " + userIndexPageUri + ",\t");
        System.out.print("cpIndexPageUri = " + cpIndexPageUri + ",\t");
        System.out.print("cpMainPageUri = " + cpMainPageUri + ",\t");
        System.out.print("groupIndexPageUri = " + groupIndexPageUri + ",\t");
        System.out.print("groupMainPageUri = " + groupMainPageUri + ",\t");
        System.out.print("initPageRow = " + initPageRow + ",\t");
        System.out.print("imgLocation = " + imgLocation + ",\t");
        System.out.print("clearSubType = " + clearSubType + ",\t");
        System.out.print("systemIntro = " + systemIntro + ",\t");
        System.out.print("excelPath = " + excelPath + ",\t");
        System.out.print("statPicturePath = " + statPicturePath + ",\t");
        System.out.print("smallPicturePath = " + smallPicturePath + ",\t");
        System.out.print("systemCode = " + systemCode + ",\t");
        System.out.print("systemState = " + systemState + "\n");
      }
    }else if ("getRowCountOfAll".equalsIgnoreCase(action)){
      int rowCount = SystemParamBean.getRowCountOfAll();
      System.out.println("rowCount = " + rowCount);
    }else if ("getSequenceNextValue".equalsIgnoreCase(action)){
      int sequenceValue = SystemParamBean.getSequenceNextValue();
      System.out.println("sequenceValue = " + sequenceValue);
    }
  }
}
/*
int id = (model==null?0:model.getId());
String systemName = (model==null?"":model.getSystemName());
String manageMainPageUri = (model==null?"":model.getManageMainPageUri());
String manageIndexPageUri = (model==null?"":model.getManageIndexPageUri());
String userMainPageUri = (model==null?"":model.getUserMainPageUri());
String userIndexPageUri = (model==null?"":model.getUserIndexPageUri());
String cpIndexPageUri = (model==null?"":model.getCpIndexPageUri());
String cpMainPageUri = (model==null?"":model.getCpMainPageUri());
String groupIndexPageUri = (model==null?"":model.getGroupIndexPageUri());
String groupMainPageUri = (model==null?"":model.getGroupMainPageUri());
int initPageRow = (model==null?0:model.getInitPageRow());
String imgLocation = (model==null?"":model.getImgLocation());
int clearSubType = (model==null?0:model.getClearSubType());
String systemIntro = (model==null?"":model.getSystemIntro());
String excelPath = (model==null?"":model.getExcelPath());
String statPicturePath = (model==null?"":model.getStatPicturePath());
String smallPicturePath = (model==null?"":model.getSmallPicturePath());
String systemCode = (model==null?"":model.getSystemCode());
String systemState = (model==null?"":model.getSystemState());
int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, );
String systemName = PageUtil.parseStringField(request.getParameter("systemName"), "systemName", false, 149);
String manageMainPageUri = PageUtil.parseStringField(request.getParameter("manageMainPageUri"), "manageMainPageUri", false, 254);
String manageIndexPageUri = PageUtil.parseStringField(request.getParameter("manageIndexPageUri"), "manageIndexPageUri", false, 254);
String userMainPageUri = PageUtil.parseStringField(request.getParameter("userMainPageUri"), "userMainPageUri", false, 254);
String userIndexPageUri = PageUtil.parseStringField(request.getParameter("userIndexPageUri"), "userIndexPageUri", false, 254);
String cpIndexPageUri = PageUtil.parseStringField(request.getParameter("cpIndexPageUri"), "cpIndexPageUri", false, 254);
String cpMainPageUri = PageUtil.parseStringField(request.getParameter("cpMainPageUri"), "cpMainPageUri", false, 254);
String groupIndexPageUri = PageUtil.parseStringField(request.getParameter("groupIndexPageUri"), "groupIndexPageUri", false, 254);
String groupMainPageUri = PageUtil.parseStringField(request.getParameter("groupMainPageUri"), "groupMainPageUri", false, 254);
int initPageRow = PageUtil.parseIntField(request.getParameter("initPageRow"), "initPageRow", false, 0, 254);
String imgLocation = PageUtil.parseStringField(request.getParameter("imgLocation"), "imgLocation", false, 254);
int clearSubType = PageUtil.parseIntField(request.getParameter("clearSubType"), "clearSubType", false, 0, 254);
String systemIntro = PageUtil.parseStringField(request.getParameter("systemIntro"), "systemIntro", false, 254);
String excelPath = PageUtil.parseStringField(request.getParameter("excelPath"), "excelPath", false, 254);
String statPicturePath = PageUtil.parseStringField(request.getParameter("statPicturePath"), "statPicturePath", false, 254);
String smallPicturePath = PageUtil.parseStringField(request.getParameter("smallPicturePath"), "smallPicturePath", false, 254);
String systemCode = PageUtil.parseStringField(request.getParameter("systemCode"), "systemCode", false, 9);
String systemState = PageUtil.parseStringField(request.getParameter("systemState"), "systemState", false, 19);


int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, 999999999);
String systemName = PageUtil.parseStringField(request.getParameter("systemName"), "systemName", true, 150);
String manageMainPageUri = PageUtil.parseStringField(request.getParameter("manageMainPageUri"), "manageMainPageUri", true, 255);
String manageIndexPageUri = PageUtil.parseStringField(request.getParameter("manageIndexPageUri"), "manageIndexPageUri", true, 255);
String userMainPageUri = PageUtil.parseStringField(request.getParameter("userMainPageUri"), "userMainPageUri", true, 255);
String userIndexPageUri = PageUtil.parseStringField(request.getParameter("userIndexPageUri"), "userIndexPageUri", true, 255);
String cpIndexPageUri = PageUtil.parseStringField(request.getParameter("cpIndexPageUri"), "cpIndexPageUri", true, 255);
String cpMainPageUri = PageUtil.parseStringField(request.getParameter("cpMainPageUri"), "cpMainPageUri", true, 255);
String groupIndexPageUri = PageUtil.parseStringField(request.getParameter("groupIndexPageUri"), "groupIndexPageUri", true, 255);
String groupMainPageUri = PageUtil.parseStringField(request.getParameter("groupMainPageUri"), "groupMainPageUri", true, 255);
int initPageRow = PageUtil.parseIntField(request.getParameter("initPageRow"), "initPageRow", true, 0, 999999999);
String imgLocation = PageUtil.parseStringField(request.getParameter("imgLocation"), "imgLocation", true, 255);
int clearSubType = PageUtil.parseIntField(request.getParameter("clearSubType"), "clearSubType", true, 0, 9);
String systemIntro = PageUtil.parseStringField(request.getParameter("systemIntro"), "systemIntro", true, 255);
String excelPath = PageUtil.parseStringField(request.getParameter("excelPath"), "excelPath", true, 255);
String statPicturePath = PageUtil.parseStringField(request.getParameter("statPicturePath"), "statPicturePath", true, 255);
String smallPicturePath = PageUtil.parseStringField(request.getParameter("smallPicturePath"), "smallPicturePath", true, 255);
String systemCode = PageUtil.parseStringField(request.getParameter("systemCode"), "systemCode", true, 10);
String systemState = PageUtil.parseStringField(request.getParameter("systemState"), "systemState", true, 20);
String id = (model==null?"0":""+model.getId());
String systemName = (model==null?"":""+model.getSystemName());
String manageMainPageUri = (model==null?"":""+model.getManageMainPageUri());
String manageIndexPageUri = (model==null?"":""+model.getManageIndexPageUri());
String userMainPageUri = (model==null?"":""+model.getUserMainPageUri());
String userIndexPageUri = (model==null?"":""+model.getUserIndexPageUri());
String cpIndexPageUri = (model==null?"":""+model.getCpIndexPageUri());
String cpMainPageUri = (model==null?"":""+model.getCpMainPageUri());
String groupIndexPageUri = (model==null?"":""+model.getGroupIndexPageUri());
String groupMainPageUri = (model==null?"":""+model.getGroupMainPageUri());
String initPageRow = (model==null?"0":""+model.getInitPageRow());
String imgLocation = (model==null?"":""+model.getImgLocation());
String clearSubType = (model==null?"0":""+model.getClearSubType());
String systemIntro = (model==null?"":""+model.getSystemIntro());
String excelPath = (model==null?"":""+model.getExcelPath());
String statPicturePath = (model==null?"":""+model.getStatPicturePath());
String smallPicturePath = (model==null?"":""+model.getSmallPicturePath());
String systemCode = (model==null?"":""+model.getSystemCode());
String systemState = (model==null?"":""+model.getSystemState());

Collection coll = SystemParamBean.queryAll((pageNum-1) * pageRow + 1, pageNum * pageRow);
Iterator it = coll.iterator();
while ( it.hasNext() ) {
    Hashtable element = (Hashtable)it.next();
    SystemParamModel systemParamModel = SystemParamBean.toModel(element);
    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();

        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), id+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), systemName+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), manageMainPageUri+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), manageIndexPageUri+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userMainPageUri+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userIndexPageUri+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), cpIndexPageUri+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), cpMainPageUri+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), groupIndexPageUri+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), groupMainPageUri+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), initPageRow+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), imgLocation+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), clearSubType+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), systemIntro+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), excelPath+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), statPicturePath+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), smallPicturePath+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), systemCode+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), systemState+"");
*/