indexmenudao.java

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

          + model.getDispOrder() + ", MENU_TYPE = "
          + model.getMenuType() + ", DISP_FLAG = "
          + model.getDispFlag() + ", CHANNEL_ID = "
          + model.getChannelId() + " WHERE ID = " + model.getId();
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "UPDATE WAP_INDEX_MENU SET MENU_NAME = '"
          + Function.writeDBEncode(model.getMenuName()) + "', MENU_URL = '"
          + Function.writeDBEncode(model.getMenuUrl()) + "', MENU_IMG = "
          + model.getMenuImg() + ", DISP_ORDER = "
          + model.getDispOrder() + ", MENU_TYPE = "
          + model.getMenuType() + ", DISP_FLAG = "
          + model.getDispFlag() + ", CHANNEL_ID = "
          + model.getChannelId() + " WHERE ID = " + model.getId();
    }
    return sql;
  }
  protected static String getDeleteSQL(int id) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_INDEX_MENU WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_INDEX_MENU WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_INDEX_MENU WHERE ID = " + id;
    }
    return sql;
  }
  protected static String getDeleteSQL(int[] ids) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_INDEX_MENU 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_INDEX_MENU 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_INDEX_MENU 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_INDEX_MENU WHERE ID = " + id;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "SELECT * FROM WAP_INDEX_MENU WHERE ID = " + id;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "SELECT * FROM WAP_INDEX_MENU WHERE ID = " + id;
    }
    return sql;
  }
  protected static boolean isValidData(IndexMenuModel 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)) {
      IndexMenuModel model=new IndexMenuModel();
      model.setId(IndexMenuBean.getSequenceNextValue());
      model.setMenuName("abc");
      model.setMenuUrl("abc");
      model.setMenuImg(1);
      model.setDispOrder(1);
      model.setMenuType(1);
      model.setDispFlag(1);
      model.setChannelId(1);
      IndexMenuModel indexMenuModel = IndexMenuBean.insert(model);
    }else if ("update".equalsIgnoreCase(action)){
      IndexMenuModel indexMenuModel = IndexMenuBean.findByPK(1);
      int id = indexMenuModel.getId();
      String menuName = indexMenuModel.getMenuName();
      String menuUrl = indexMenuModel.getMenuUrl();
      int menuImg = indexMenuModel.getMenuImg();
      int dispOrder = indexMenuModel.getDispOrder();
      int menuType = indexMenuModel.getMenuType();
      int dispFlag = indexMenuModel.getDispFlag();
      int channelId = indexMenuModel.getChannelId();
      indexMenuModel.setMenuName(menuName);
      indexMenuModel.setMenuUrl(menuUrl);
      indexMenuModel.setMenuImg(menuImg);
      indexMenuModel.setDispOrder(dispOrder);
      indexMenuModel.setMenuType(menuType);
      indexMenuModel.setDispFlag(dispFlag);
      indexMenuModel.setChannelId(channelId);
      update(indexMenuModel);
    }else if ("delete".equalsIgnoreCase(action)){
      int[] ids = new int[3];
      ids[0] = 1;
      ids[1] = 2;
      ids[2] = 3;
      IndexMenuBean.delete(ids);
    }else if ("findByPK".equalsIgnoreCase(action)){
      IndexMenuModel indexMenuModel = IndexMenuBean.findByPK(1);
      int id = indexMenuModel.getId();
      String menuName = indexMenuModel.getMenuName();
      String menuUrl = indexMenuModel.getMenuUrl();
      int menuImg = indexMenuModel.getMenuImg();
      int dispOrder = indexMenuModel.getDispOrder();
      int menuType = indexMenuModel.getMenuType();
      int dispFlag = indexMenuModel.getDispFlag();
      int channelId = indexMenuModel.getChannelId();
      System.out.println("id = " + id);
      System.out.println("menuName = " + menuName);
      System.out.println("menuUrl = " + menuUrl);
      System.out.println("menuImg = " + menuImg);
      System.out.println("dispOrder = " + dispOrder);
      System.out.println("menuType = " + menuType);
      System.out.println("dispFlag = " + dispFlag);
      System.out.println("channelId = " + channelId);
    }else if ("queryBySql".equalsIgnoreCase(action)){
      Collection coll = IndexMenuBean.queryBySql("SELECT * FROM WAP_INDEX_MENU");
    }else if ("getRowCountBySql".equalsIgnoreCase(action)){
      int rowCount = IndexMenuBean.getRowCountBySql("SELECT COUNT(*) FROM WAP_INDEX_MENU");
      System.out.println("rowCount = " + rowCount);
    }else if ("queryAll".equalsIgnoreCase(action)){
      Collection coll = IndexMenuBean.queryAll();
      Iterator it = coll.iterator();
      while ( it.hasNext() ) {
        Hashtable element = (Hashtable)it.next();
        String id = (String)element.get("id");
        String menuName = (String)element.get("menuName");
        String menuUrl = (String)element.get("menuUrl");
        String menuImg = (String)element.get("menuImg");
        String dispOrder = (String)element.get("dispOrder");
        String menuType = (String)element.get("menuType");
        String dispFlag = (String)element.get("dispFlag");
        String channelId = (String)element.get("channelId");
        System.out.print("id = " + id + ",\t");
        System.out.print("menuName = " + menuName + ",\t");
        System.out.print("menuUrl = " + menuUrl + ",\t");
        System.out.print("menuImg = " + menuImg + ",\t");
        System.out.print("dispOrder = " + dispOrder + ",\t");
        System.out.print("menuType = " + menuType + ",\t");
        System.out.print("dispFlag = " + dispFlag + ",\t");
        System.out.print("channelId = " + channelId + "\n");
      }
    }else if ("getRowCountOfAll".equalsIgnoreCase(action)){
      int rowCount = IndexMenuBean.getRowCountOfAll();
      System.out.println("rowCount = " + rowCount);
    }else if ("getSequenceNextValue".equalsIgnoreCase(action)){
      int sequenceValue = IndexMenuBean.getSequenceNextValue();
      System.out.println("sequenceValue = " + sequenceValue);
    }
  }
}
/*
int id = (model==null?0:model.getId());
String menuName = (model==null?"":model.getMenuName());
String menuUrl = (model==null?"":model.getMenuUrl());
int menuImg = (model==null?0:model.getMenuImg());
int dispOrder = (model==null?0:model.getDispOrder());
int menuType = (model==null?0:model.getMenuType());
int dispFlag = (model==null?0:model.getDispFlag());
int channelId = (model==null?0:model.getChannelId());
int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, );
String menuName = PageUtil.parseStringField(request.getParameter("menuName"), "menuName", false, 19);
String menuUrl = PageUtil.parseStringField(request.getParameter("menuUrl"), "menuUrl", false, 199);
int menuImg = PageUtil.parseIntField(request.getParameter("menuImg"), "menuImg", false, 0, 199);
int dispOrder = PageUtil.parseIntField(request.getParameter("dispOrder"), "dispOrder", false, 0, 199);
int menuType = PageUtil.parseIntField(request.getParameter("menuType"), "menuType", false, 0, 199);
int dispFlag = PageUtil.parseIntField(request.getParameter("dispFlag"), "dispFlag", false, 0, 199);
int channelId = PageUtil.parseIntField(request.getParameter("channelId"), "channelId", false, 0, 199);


int id = PageUtil.parseIntField(request.getParameter("id"), "id", false, 0, 999999999);
String menuName = PageUtil.parseStringField(request.getParameter("menuName"), "menuName", true, 20);
String menuUrl = PageUtil.parseStringField(request.getParameter("menuUrl"), "menuUrl", true, 200);
int menuImg = PageUtil.parseIntField(request.getParameter("menuImg"), "menuImg", true, 0, 999999999);
int dispOrder = PageUtil.parseIntField(request.getParameter("dispOrder"), "dispOrder", true, 0, 999999999);
int menuType = PageUtil.parseIntField(request.getParameter("menuType"), "menuType", true, 0, 9);
int dispFlag = PageUtil.parseIntField(request.getParameter("dispFlag"), "dispFlag", true, 0, 9);
int channelId = PageUtil.parseIntField(request.getParameter("channelId"), "channelId", true, 0, 999999999);
String id = (model==null?"0":""+model.getId());
String menuName = (model==null?"":""+model.getMenuName());
String menuUrl = (model==null?"":""+model.getMenuUrl());
String menuImg = (model==null?"0":""+model.getMenuImg());
String dispOrder = (model==null?"0":""+model.getDispOrder());
String menuType = (model==null?"0":""+model.getMenuType());
String dispFlag = (model==null?"0":""+model.getDispFlag());
String channelId = (model==null?"0":""+model.getChannelId());

Collection coll = IndexMenuBean.queryAll((pageNum-1) * pageRow + 1, pageNum * pageRow);
Iterator it = coll.iterator();
while ( it.hasNext() ) {
    Hashtable element = (Hashtable)it.next();
    IndexMenuModel indexMenuModel = IndexMenuBean.toModel(element);
    int id = indexMenuModel.getId();
    String menuName = indexMenuModel.getMenuName();
    String menuUrl = indexMenuModel.getMenuUrl();
    int menuImg = indexMenuModel.getMenuImg();
    int dispOrder = indexMenuModel.getDispOrder();
    int menuType = indexMenuModel.getMenuType();
    int dispFlag = indexMenuModel.getDispFlag();
    int channelId = indexMenuModel.getChannelId();

        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), id+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), menuName+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), menuUrl+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), menuImg+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), dispOrder+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), menuType+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), dispFlag+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), channelId+"");
*/