+ 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+"");*/