cpdao.java

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

  protected static String getDeleteSQL(int id) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_CP WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_CP WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_CP WHERE ID = " + id;
    }
    return sql;
  }
  protected static String getDeleteSQL(int[] ids) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_CP 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_CP 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_CP 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_CP WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "SELECT * FROM WAP_CP WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "SELECT * FROM WAP_CP WHERE ID = " + id;
    }
    return sql;
  }
  protected static boolean isValidData(CpModel 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)) {
      CpModel model=new CpModel();
      model.setId(CpBean.getSequenceNextValue());
      model.setCpName("abc");
      model.setCpPwd("abc");
      model.setCpAddr("abc");
      model.setCpEmail("abc");
      model.setCpDescribe("abc");
      model.setCpStatus(1);
      model.setRegDate(Function.getCurrTime());
      model.setCpTel("abc");
      model.setCpContact("abc");
      model.setClientTel("abc");
      CpModel cpModel = CpBean.insert(model);
    }else if ("update".equalsIgnoreCase(action)){
      CpModel cpModel = CpBean.findByPK(1);
      int id = cpModel.getId();
      String cpName = cpModel.getCpName();
      String cpPwd = cpModel.getCpPwd();
      String cpAddr = cpModel.getCpAddr();
      String cpEmail = cpModel.getCpEmail();
      String cpDescribe = cpModel.getCpDescribe();
      int cpStatus = cpModel.getCpStatus();
      Timestamp regDate = cpModel.getRegDate();
      String cpTel = cpModel.getCpTel();
      String cpContact = cpModel.getCpContact();
      String clientTel = cpModel.getClientTel();
      cpModel.setCpName(cpName);
      cpModel.setCpPwd(cpPwd);
      cpModel.setCpAddr(cpAddr);
      cpModel.setCpEmail(cpEmail);
      cpModel.setCpDescribe(cpDescribe);
      cpModel.setCpStatus(cpStatus);
      cpModel.setRegDate(regDate);
      cpModel.setCpTel(cpTel);
      cpModel.setCpContact(cpContact);
      cpModel.setClientTel(clientTel);
      update(cpModel);
    }else if ("delete".equalsIgnoreCase(action)){
      int[] ids = new int[3];
      ids[0] = 1;
      ids[1] = 2;
      ids[2] = 3;
      CpBean.delete(ids);
    }else if ("findByPK".equalsIgnoreCase(action)){
      CpModel cpModel = CpBean.findByPK(1);
      int id = cpModel.getId();
      String cpName = cpModel.getCpName();
      String cpPwd = cpModel.getCpPwd();
      String cpAddr = cpModel.getCpAddr();
      String cpEmail = cpModel.getCpEmail();
      String cpDescribe = cpModel.getCpDescribe();
      int cpStatus = cpModel.getCpStatus();
      Timestamp regDate = cpModel.getRegDate();
      String cpTel = cpModel.getCpTel();
      String cpContact = cpModel.getCpContact();
      String clientTel = cpModel.getClientTel();
      System.out.println("id = " + id);
      System.out.println("cpName = " + cpName);
      System.out.println("cpPwd = " + cpPwd);
      System.out.println("cpAddr = " + cpAddr);
      System.out.println("cpEmail = " + cpEmail);
      System.out.println("cpDescribe = " + cpDescribe);
      System.out.println("cpStatus = " + cpStatus);
      System.out.println("regDate = " + Function.getYYYYMMDDHHMISS(regDate));
      System.out.println("cpTel = " + cpTel);
      System.out.println("cpContact = " + cpContact);
      System.out.println("clientTel = " + clientTel);
    }else if ("queryBySql".equalsIgnoreCase(action)){
      Collection coll = CpBean.queryBySql("SELECT * FROM WAP_CP");
    }else if ("getRowCountBySql".equalsIgnoreCase(action)){
      int rowCount = CpBean.getRowCountBySql("SELECT COUNT(*) FROM WAP_CP");
      System.out.println("rowCount = " + rowCount);
    }else if ("queryAll".equalsIgnoreCase(action)){
      Collection coll = CpBean.queryAll();
      Iterator it = coll.iterator();
      while ( it.hasNext() ) {
        Hashtable element = (Hashtable)it.next();
        String id = (String)element.get("id");
        String cpName = (String)element.get("cpName");
        String cpPwd = (String)element.get("cpPwd");
        String cpAddr = (String)element.get("cpAddr");
        String cpEmail = (String)element.get("cpEmail");
        String cpDescribe = (String)element.get("cpDescribe");
        String cpStatus = (String)element.get("cpStatus");
        String regDate = Function.getYYYYMMDDHHMISS((Timestamp)element.get("regDate"));
        String cpTel = (String)element.get("cpTel");
        String cpContact = (String)element.get("cpContact");
        String clientTel = (String)element.get("clientTel");
        System.out.print("id = " + id + ",\t");
        System.out.print("cpName = " + cpName + ",\t");
        System.out.print("cpPwd = " + cpPwd + ",\t");
        System.out.print("cpAddr = " + cpAddr + ",\t");
        System.out.print("cpEmail = " + cpEmail + ",\t");
        System.out.print("cpDescribe = " + cpDescribe + ",\t");
        System.out.print("cpStatus = " + cpStatus + ",\t");
        System.out.print("regDate = " + regDate + ",\t");
        System.out.print("cpTel = " + cpTel + ",\t");
        System.out.print("cpContact = " + cpContact + ",\t");
        System.out.print("clientTel = " + clientTel + "\n");
      }
    }else if ("getRowCountOfAll".equalsIgnoreCase(action)){
      int rowCount = CpBean.getRowCountOfAll();
      System.out.println("rowCount = " + rowCount);
    }else if ("getSequenceNextValue".equalsIgnoreCase(action)){
      int sequenceValue = CpBean.getSequenceNextValue();
      System.out.println("sequenceValue = " + sequenceValue);
    }
  }
}
/*
int id = (model==null?0:model.getId());
String cpName = (model==null?"":model.getCpName());
String cpPwd = (model==null?"":model.getCpPwd());
String cpAddr = (model==null?"":model.getCpAddr());
String cpEmail = (model==null?"":model.getCpEmail());
String cpDescribe = (model==null?"":model.getCpDescribe());
int cpStatus = (model==null?0:model.getCpStatus());
Timestamp regDate = (model==null?null:model.getRegDate());
String cpTel = (model==null?"":model.getCpTel());
String cpContact = (model==null?"":model.getCpContact());
String clientTel = (model==null?"":model.getClientTel());
int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, );
String cpName = PageUtil.parseStringField(request.getParameter("cpName"), "cpName", false, 99);
String cpPwd = PageUtil.parseStringField(request.getParameter("cpPwd"), "cpPwd", false, 7);
String cpAddr = PageUtil.parseStringField(request.getParameter("cpAddr"), "cpAddr", false, 199);
String cpEmail = PageUtil.parseStringField(request.getParameter("cpEmail"), "cpEmail", false, 199);
String cpDescribe = PageUtil.parseStringField(request.getParameter("cpDescribe"), "cpDescribe", false, 199);
int cpStatus = PageUtil.parseIntField(request.getParameter("cpStatus"), "cpStatus", false, 0, 199);
String cpTel = PageUtil.parseStringField(request.getParameter("cpTel"), "cpTel", false, 14);
String cpContact = PageUtil.parseStringField(request.getParameter("cpContact"), "cpContact", false, 9);
String clientTel = PageUtil.parseStringField(request.getParameter("clientTel"), "clientTel", false, 14);


int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, 999999999);
String cpName = PageUtil.parseStringField(request.getParameter("cpName"), "cpName", true, 100);
String cpPwd = PageUtil.parseStringField(request.getParameter("cpPwd"), "cpPwd", true, 8);
String cpAddr = PageUtil.parseStringField(request.getParameter("cpAddr"), "cpAddr", true, 200);
String cpEmail = PageUtil.parseStringField(request.getParameter("cpEmail"), "cpEmail", true, 200);
String cpDescribe = PageUtil.parseStringField(request.getParameter("cpDescribe"), "cpDescribe", true, 200);
int cpStatus = PageUtil.parseIntField(request.getParameter("cpStatus"), "cpStatus", true, 0, 9);
Timestamp regDate = PageUtil.parseDateField(request.getParameter("regDate"), "regDate", true);
String cpTel = PageUtil.parseStringField(request.getParameter("cpTel"), "cpTel", true, 15);
String cpContact = PageUtil.parseStringField(request.getParameter("cpContact"), "cpContact", true, 10);
String clientTel = PageUtil.parseStringField(request.getParameter("clientTel"), "clientTel", true, 15);
String id = (model==null?"0":""+model.getId());
String cpName = (model==null?"":""+model.getCpName());
String cpPwd = (model==null?"":""+model.getCpPwd());
String cpAddr = (model==null?"":""+model.getCpAddr());
String cpEmail = (model==null?"":""+model.getCpEmail());
String cpDescribe = (model==null?"":""+model.getCpDescribe());
String cpStatus = (model==null?"0":""+model.getCpStatus());
Timestamp regDate = (model==null?null:model.getRegDate());
String cpTel = (model==null?"":""+model.getCpTel());
String cpContact = (model==null?"":""+model.getCpContact());
String clientTel = (model==null?"":""+model.getClientTel());

Collection coll = CpBean.queryAll((pageNum-1) * pageRow + 1, pageNum * pageRow);
Iterator it = coll.iterator();
while ( it.hasNext() ) {
    Hashtable element = (Hashtable)it.next();
    CpModel cpModel = CpBean.toModel(element);
    int id = cpModel.getId();
    String cpName = cpModel.getCpName();
    String cpPwd = cpModel.getCpPwd();
    String cpAddr = cpModel.getCpAddr();
    String cpEmail = cpModel.getCpEmail();
    String cpDescribe = cpModel.getCpDescribe();
    int cpStatus = cpModel.getCpStatus();
    Timestamp regDate = cpModel.getRegDate();
    String cpTel = cpModel.getCpTel();
    String cpContact = cpModel.getCpContact();
    String clientTel = cpModel.getClientTel();

        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), id+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), cpName+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), cpPwd+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), cpAddr+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), cpEmail+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), cpDescribe+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), cpStatus+"");
        excel.setCellData(new ExcelCell(ExcelUtil.DATE_CELL_TYTE,   currRow, currCol++), regDate);
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), cpTel+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), cpContact+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), clientTel+"");
*/