bookcarddao.java

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

          + Function.writeDBEncode(model.getUserPost()) + "' WHERE ID = " + model.getId();
    }
    return sql;
  }
  protected static String getDeleteSQL(long id) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_BOOK_CARD WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_BOOK_CARD WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_BOOK_CARD WHERE ID = " + id;
    }
    return sql;
  }
  protected static String getDeleteSQL(long[] ids) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_BOOK_CARD 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_BOOK_CARD 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_BOOK_CARD WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR ID = " + ids[i];
      }
    }
    return sql;
  }
  protected static String getFindByPKSQL(long id) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "SELECT * FROM WAP_BOOK_CARD WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "SELECT * FROM WAP_BOOK_CARD WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "SELECT * FROM WAP_BOOK_CARD WHERE ID = " + id;
    }
    return sql;
  }
  protected static boolean isValidData(BookCardModel 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)) {
      BookCardModel model=new BookCardModel();
      model.setId(999999999999999999L);
      model.setUserMdn("abc");
      model.setUserName("abc");
      model.setUserJob("abc");
      model.setUserCom("abc");
      model.setUserTel("abc");
      model.setUserFax("abc");
      model.setUserEmail("abc");
      model.setUserAdress("abc");
      model.setUserPost("abc");
      BookCardModel bookCardModel = BookCardBean.insert(model);
    }else if ("update".equalsIgnoreCase(action)){
      BookCardModel bookCardModel = BookCardBean.findByPK(1);
      long id = bookCardModel.getId();
      String userMdn = bookCardModel.getUserMdn();
      String userName = bookCardModel.getUserName();
      String userJob = bookCardModel.getUserJob();
      String userCom = bookCardModel.getUserCom();
      String userTel = bookCardModel.getUserTel();
      String userFax = bookCardModel.getUserFax();
      String userEmail = bookCardModel.getUserEmail();
      String userAdress = bookCardModel.getUserAdress();
      String userPost = bookCardModel.getUserPost();
      bookCardModel.setUserMdn(userMdn);
      bookCardModel.setUserName(userName);
      bookCardModel.setUserJob(userJob);
      bookCardModel.setUserCom(userCom);
      bookCardModel.setUserTel(userTel);
      bookCardModel.setUserFax(userFax);
      bookCardModel.setUserEmail(userEmail);
      bookCardModel.setUserAdress(userAdress);
      bookCardModel.setUserPost(userPost);
      update(bookCardModel);
    }else if ("delete".equalsIgnoreCase(action)){
      long[] ids = new long[3];
      ids[0] = 1;
      ids[1] = 2;
      ids[2] = 3;
      BookCardBean.delete(ids);
    }else if ("findByPK".equalsIgnoreCase(action)){
      BookCardModel bookCardModel = BookCardBean.findByPK(1);
      long id = bookCardModel.getId();
      String userMdn = bookCardModel.getUserMdn();
      String userName = bookCardModel.getUserName();
      String userJob = bookCardModel.getUserJob();
      String userCom = bookCardModel.getUserCom();
      String userTel = bookCardModel.getUserTel();
      String userFax = bookCardModel.getUserFax();
      String userEmail = bookCardModel.getUserEmail();
      String userAdress = bookCardModel.getUserAdress();
      String userPost = bookCardModel.getUserPost();
      System.out.println("id = " + id);
      System.out.println("userMdn = " + userMdn);
      System.out.println("userName = " + userName);
      System.out.println("userJob = " + userJob);
      System.out.println("userCom = " + userCom);
      System.out.println("userTel = " + userTel);
      System.out.println("userFax = " + userFax);
      System.out.println("userEmail = " + userEmail);
      System.out.println("userAdress = " + userAdress);
      System.out.println("userPost = " + userPost);
    }else if ("queryBySql".equalsIgnoreCase(action)){
      Collection coll = BookCardBean.queryBySql("SELECT * FROM WAP_BOOK_CARD");
    }else if ("getRowCountBySql".equalsIgnoreCase(action)){
      int rowCount = BookCardBean.getRowCountBySql("SELECT COUNT(*) FROM WAP_BOOK_CARD");
      System.out.println("rowCount = " + rowCount);
    }else if ("queryAll".equalsIgnoreCase(action)){
      Collection coll = BookCardBean.queryAll();
      Iterator it = coll.iterator();
      while ( it.hasNext() ) {
        Hashtable element = (Hashtable)it.next();
        String id = (String)element.get("id");
        String userMdn = (String)element.get("userMdn");
        String userName = (String)element.get("userName");
        String userJob = (String)element.get("userJob");
        String userCom = (String)element.get("userCom");
        String userTel = (String)element.get("userTel");
        String userFax = (String)element.get("userFax");
        String userEmail = (String)element.get("userEmail");
        String userAdress = (String)element.get("userAdress");
        String userPost = (String)element.get("userPost");
        System.out.print("id = " + id + ",\t");
        System.out.print("userMdn = " + userMdn + ",\t");
        System.out.print("userName = " + userName + ",\t");
        System.out.print("userJob = " + userJob + ",\t");
        System.out.print("userCom = " + userCom + ",\t");
        System.out.print("userTel = " + userTel + ",\t");
        System.out.print("userFax = " + userFax + ",\t");
        System.out.print("userEmail = " + userEmail + ",\t");
        System.out.print("userAdress = " + userAdress + ",\t");
        System.out.print("userPost = " + userPost + "\n");
      }
    }else if ("getRowCountOfAll".equalsIgnoreCase(action)){
      int rowCount = BookCardBean.getRowCountOfAll();
      System.out.println("rowCount = " + rowCount);
    }else if ("getSequenceNextValue".equalsIgnoreCase(action)){
      int sequenceValue = BookCardBean.getSequenceNextValue();
      System.out.println("sequenceValue = " + sequenceValue);
    }
  }
}
/*
long id = (model==null?0:model.getId());
String userMdn = (model==null?"":model.getUserMdn());
String userName = (model==null?"":model.getUserName());
String userJob = (model==null?"":model.getUserJob());
String userCom = (model==null?"":model.getUserCom());
String userTel = (model==null?"":model.getUserTel());
String userFax = (model==null?"":model.getUserFax());
String userEmail = (model==null?"":model.getUserEmail());
String userAdress = (model==null?"":model.getUserAdress());
String userPost = (model==null?"":model.getUserPost());
long id = PageUtil.parseLongField(request.getParameter("id"), "id", false, 0, );
String userMdn = PageUtil.parseStringField(request.getParameter("userMdn"), "userMdn", false, 19);
String userName = PageUtil.parseStringField(request.getParameter("userName"), "userName", false, 19);
String userJob = PageUtil.parseStringField(request.getParameter("userJob"), "userJob", false, 199);
String userCom = PageUtil.parseStringField(request.getParameter("userCom"), "userCom", false, 199);
String userTel = PageUtil.parseStringField(request.getParameter("userTel"), "userTel", false, 19);
String userFax = PageUtil.parseStringField(request.getParameter("userFax"), "userFax", false, 19);
String userEmail = PageUtil.parseStringField(request.getParameter("userEmail"), "userEmail", false, 49);
String userAdress = PageUtil.parseStringField(request.getParameter("userAdress"), "userAdress", false, 199);
String userPost = PageUtil.parseStringField(request.getParameter("userPost"), "userPost", false, 199);


long id = PageUtil.parseLongField(request.getParameter("id"), "id", false, 0, 0);
String userMdn = PageUtil.parseStringField(request.getParameter("userMdn"), "userMdn", false, 20);
String userName = PageUtil.parseStringField(request.getParameter("userName"), "userName", false, 20);
String userJob = PageUtil.parseStringField(request.getParameter("userJob"), "userJob", true, 200);
String userCom = PageUtil.parseStringField(request.getParameter("userCom"), "userCom", true, 200);
String userTel = PageUtil.parseStringField(request.getParameter("userTel"), "userTel", true, 20);
String userFax = PageUtil.parseStringField(request.getParameter("userFax"), "userFax", true, 20);
String userEmail = PageUtil.parseStringField(request.getParameter("userEmail"), "userEmail", true, 50);
String userAdress = PageUtil.parseStringField(request.getParameter("userAdress"), "userAdress", true, 200);
String userPost = PageUtil.parseStringField(request.getParameter("userPost"), "userPost", true, 200);
String id = (model==null?"0":""+model.getId());
String userMdn = (model==null?"":""+model.getUserMdn());
String userName = (model==null?"":""+model.getUserName());
String userJob = (model==null?"":""+model.getUserJob());
String userCom = (model==null?"":""+model.getUserCom());
String userTel = (model==null?"":""+model.getUserTel());
String userFax = (model==null?"":""+model.getUserFax());
String userEmail = (model==null?"":""+model.getUserEmail());
String userAdress = (model==null?"":""+model.getUserAdress());
String userPost = (model==null?"":""+model.getUserPost());

Collection coll = BookCardBean.queryAll((pageNum-1) * pageRow + 1, pageNum * pageRow);
Iterator it = coll.iterator();
while ( it.hasNext() ) {
    Hashtable element = (Hashtable)it.next();
    BookCardModel bookCardModel = BookCardBean.toModel(element);
    long id = bookCardModel.getId();
    String userMdn = bookCardModel.getUserMdn();
    String userName = bookCardModel.getUserName();
    String userJob = bookCardModel.getUserJob();
    String userCom = bookCardModel.getUserCom();
    String userTel = bookCardModel.getUserTel();
    String userFax = bookCardModel.getUserFax();
    String userEmail = bookCardModel.getUserEmail();
    String userAdress = bookCardModel.getUserAdress();
    String userPost = bookCardModel.getUserPost();

        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), id+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userMdn+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userName+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userJob+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userCom+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userTel+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userFax+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userEmail+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userAdress+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userPost+"");
*/