advertisedao.java

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

          + Function.writeDBEncode(model.getAdvertiseContent()) + "', '"
          + Function.DateToString(model.getAdvertiseDate()) + "', "
          + model.getAdvertiseImg() + ")";
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "INSERT INTO WAP_ADVERTISE (ID, ADVERTISE_TITLE, ADVERTISE_CONTENT, ADVERTISE_DATE, ADVERTISE_IMG) VALUES ("
          + model.getId() + ", '"
          + Function.writeDBEncode(model.getAdvertiseTitle()) + "', '"
          + Function.writeDBEncode(model.getAdvertiseContent()) + "', '"
          + Function.DateToString(model.getAdvertiseDate()) + "', "
          + model.getAdvertiseImg() + ")";
    }
    return sql;
  }
  protected static String getUpdateSQL(AdvertiseModel model) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "UPDATE WAP_ADVERTISE SET ADVERTISE_TITLE = '"
          + Function.writeDBEncode(model.getAdvertiseTitle()) + "', ADVERTISE_CONTENT = '"
          + Function.writeDBEncode(model.getAdvertiseContent()) + "', ADVERTISE_DATE = TO_DATE('"
          + Function.DateToString(model.getAdvertiseDate()) + "', 'YYYY-MM-DD HH24:MI:SS'), ADVERTISE_IMG = "
          + model.getAdvertiseImg() + " WHERE ID = " + model.getId();
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "UPDATE WAP_ADVERTISE SET ADVERTISE_TITLE = '"
          + Function.writeDBEncode(model.getAdvertiseTitle()) + "', ADVERTISE_CONTENT = '"
          + Function.writeDBEncode(model.getAdvertiseContent()) + "', ADVERTISE_DATE = '"
          + Function.DateToString(model.getAdvertiseDate()) + "', ADVERTISE_IMG = "
          + model.getAdvertiseImg() + " WHERE ID = " + model.getId();
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "UPDATE WAP_ADVERTISE SET ADVERTISE_TITLE = '"
          + Function.writeDBEncode(model.getAdvertiseTitle()) + "', ADVERTISE_CONTENT = '"
          + Function.writeDBEncode(model.getAdvertiseContent()) + "', ADVERTISE_DATE = '"
          + Function.DateToString(model.getAdvertiseDate()) + "', ADVERTISE_IMG = "
          + model.getAdvertiseImg() + " WHERE ID = " + model.getId();
    }
    return sql;
  }
  protected static String getDeleteSQL(int id) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_ADVERTISE WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_ADVERTISE WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_ADVERTISE WHERE ID = " + id;
    }
    return sql;
  }
  protected static String getDeleteSQL(int[] ids) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_ADVERTISE 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_ADVERTISE 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_ADVERTISE 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_ADVERTISE WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "SELECT * FROM WAP_ADVERTISE WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "SELECT * FROM WAP_ADVERTISE WHERE ID = " + id;
    }
    return sql;
  }
  protected static boolean isValidData(AdvertiseModel 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)) {
      AdvertiseModel model=new AdvertiseModel();
      model.setId(AdvertiseBean.getSequenceNextValue());
      model.setAdvertiseTitle("abc");
      model.setAdvertiseContent("abc");
      model.setAdvertiseDate(Function.getCurrTime());
      model.setAdvertiseImg(1);
      AdvertiseModel advertiseModel = AdvertiseBean.insert(model);
    }else if ("update".equalsIgnoreCase(action)){
      AdvertiseModel advertiseModel = AdvertiseBean.findByPK(1);
      int id = advertiseModel.getId();
      String advertiseTitle = advertiseModel.getAdvertiseTitle();
      String advertiseContent = advertiseModel.getAdvertiseContent();
      Timestamp advertiseDate = advertiseModel.getAdvertiseDate();
      int advertiseImg = advertiseModel.getAdvertiseImg();
      advertiseModel.setAdvertiseTitle(advertiseTitle);
      advertiseModel.setAdvertiseContent(advertiseContent);
      advertiseModel.setAdvertiseDate(advertiseDate);
      advertiseModel.setAdvertiseImg(advertiseImg);
      update(advertiseModel);
    }else if ("delete".equalsIgnoreCase(action)){
      int[] ids = new int[3];
      ids[0] = 1;
      ids[1] = 2;
      ids[2] = 3;
      AdvertiseBean.delete(ids);
    }else if ("findByPK".equalsIgnoreCase(action)){
      AdvertiseModel advertiseModel = AdvertiseBean.findByPK(1);
      int id = advertiseModel.getId();
      String advertiseTitle = advertiseModel.getAdvertiseTitle();
      String advertiseContent = advertiseModel.getAdvertiseContent();
      Timestamp advertiseDate = advertiseModel.getAdvertiseDate();
      int advertiseImg = advertiseModel.getAdvertiseImg();
      System.out.println("id = " + id);
      System.out.println("advertiseTitle = " + advertiseTitle);
      System.out.println("advertiseContent = " + advertiseContent);
      System.out.println("advertiseDate = " + Function.getYYYYMMDDHHMISS(advertiseDate));
      System.out.println("advertiseImg = " + advertiseImg);
    }else if ("queryBySql".equalsIgnoreCase(action)){
      Collection coll = AdvertiseBean.queryBySql("SELECT * FROM WAP_ADVERTISE");
    }else if ("getRowCountBySql".equalsIgnoreCase(action)){
      int rowCount = AdvertiseBean.getRowCountBySql("SELECT COUNT(*) FROM WAP_ADVERTISE");
      System.out.println("rowCount = " + rowCount);
    }else if ("queryAll".equalsIgnoreCase(action)){
      Collection coll = AdvertiseBean.queryAll();
      Iterator it = coll.iterator();
      while ( it.hasNext() ) {
        Hashtable element = (Hashtable)it.next();
        String id = (String)element.get("id");
        String advertiseTitle = (String)element.get("advertiseTitle");
        String advertiseContent = (String)element.get("advertiseContent");
        String advertiseDate = Function.getYYYYMMDDHHMISS((Timestamp)element.get("advertiseDate"));
        String advertiseImg = (String)element.get("advertiseImg");
        System.out.print("id = " + id + ",\t");
        System.out.print("advertiseTitle = " + advertiseTitle + ",\t");
        System.out.print("advertiseContent = " + advertiseContent + ",\t");
        System.out.print("advertiseDate = " + advertiseDate + ",\t");
        System.out.print("advertiseImg = " + advertiseImg + "\n");
      }
    }else if ("getRowCountOfAll".equalsIgnoreCase(action)){
      int rowCount = AdvertiseBean.getRowCountOfAll();
      System.out.println("rowCount = " + rowCount);
    }else if ("getSequenceNextValue".equalsIgnoreCase(action)){
      int sequenceValue = AdvertiseBean.getSequenceNextValue();
      System.out.println("sequenceValue = " + sequenceValue);
    }
  }
}
/*
int id = (model==null?0:model.getId());
String advertiseTitle = (model==null?"":model.getAdvertiseTitle());
String advertiseContent = (model==null?"":model.getAdvertiseContent());
Timestamp advertiseDate = (model==null?null:model.getAdvertiseDate());
int advertiseImg = (model==null?0:model.getAdvertiseImg());
int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, );
String advertiseTitle = PageUtil.parseStringField(request.getParameter("advertiseTitle"), "advertiseTitle", false, 199);
String advertiseContent = PageUtil.parseStringField(request.getParameter("advertiseContent"), "advertiseContent", false, 199);
int advertiseImg = PageUtil.parseIntField(request.getParameter("advertiseImg"), "advertiseImg", false, 0, 199);


int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, 999999999);
String advertiseTitle = PageUtil.parseStringField(request.getParameter("advertiseTitle"), "advertiseTitle", true, 200);
String advertiseContent = PageUtil.parseStringField(request.getParameter("advertiseContent"), "advertiseContent", true, 200);
Timestamp advertiseDate = PageUtil.parseDateField(request.getParameter("advertiseDate"), "advertiseDate", true);
int advertiseImg = PageUtil.parseIntField(request.getParameter("advertiseImg"), "advertiseImg", true, 0, 999999999);
String id = (model==null?"0":""+model.getId());
String advertiseTitle = (model==null?"":""+model.getAdvertiseTitle());
String advertiseContent = (model==null?"":""+model.getAdvertiseContent());
Timestamp advertiseDate = (model==null?null:model.getAdvertiseDate());
String advertiseImg = (model==null?"0":""+model.getAdvertiseImg());

Collection coll = AdvertiseBean.queryAll((pageNum-1) * pageRow + 1, pageNum * pageRow);
Iterator it = coll.iterator();
while ( it.hasNext() ) {
    Hashtable element = (Hashtable)it.next();
    AdvertiseModel advertiseModel = AdvertiseBean.toModel(element);
    int id = advertiseModel.getId();
    String advertiseTitle = advertiseModel.getAdvertiseTitle();
    String advertiseContent = advertiseModel.getAdvertiseContent();
    Timestamp advertiseDate = advertiseModel.getAdvertiseDate();
    int advertiseImg = advertiseModel.getAdvertiseImg();

        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), id+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), advertiseTitle+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), advertiseContent+"");
        excel.setCellData(new ExcelCell(ExcelUtil.DATE_CELL_TYTE,   currRow, currCol++), advertiseDate);
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), advertiseImg+"");
*/