menudao.java

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

    }
    return sql;
  }
  protected static String getDeleteSQL(int[] ids) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_MENU WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR MENU_ID = " + ids[i];
      }
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_MENU WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR MENU_ID = " + ids[i];
      }
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_MENU WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR MENU_ID = " + ids[i];
      }
    }
    return sql;
  }
  protected static String getFindByPKSQL(int menuId) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "SELECT * FROM WAP_MENU WHERE MENU_ID = " + menuId;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "SELECT * FROM WAP_MENU WHERE MENU_ID = " + menuId;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "SELECT * FROM WAP_MENU WHERE MENU_ID = " + menuId;
    }
    return sql;
  }
  protected static boolean isValidData(MenuModel 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)) {
      MenuModel model=new MenuModel();
      model.setMenuId(MenuBean.getSequenceNextValue());
      model.setImgId(1);
      model.setMenuParent(1);
      model.setMenuChannel(1);
      model.setMenuName("abc");
      model.setMenuAreacode(1);
      model.setMenuVisible(1);
      model.setAdName("abc");
      model.setAdContent("abc");
      model.setAdUrl("abc");
      model.setAdState(1);
      model.setOrderId(1);
      MenuModel menuModel = MenuBean.insert(model);
    }else if ("update".equalsIgnoreCase(action)){
      MenuModel menuModel = MenuBean.findByPK(1);
      int menuId = menuModel.getMenuId();
      int imgId = menuModel.getImgId();
      int menuParent = menuModel.getMenuParent();
      int menuChannel = menuModel.getMenuChannel();
      String menuName = menuModel.getMenuName();
      int menuAreacode = menuModel.getMenuAreacode();
      int menuVisible = menuModel.getMenuVisible();
      String adName = menuModel.getAdName();
      String adContent = menuModel.getAdContent();
      String adUrl = menuModel.getAdUrl();
      int adState = menuModel.getAdState();
      int orderId = menuModel.getOrderId();
      menuModel.setImgId(imgId);
      menuModel.setMenuParent(menuParent);
      menuModel.setMenuChannel(menuChannel);
      menuModel.setMenuName(menuName);
      menuModel.setMenuAreacode(menuAreacode);
      menuModel.setMenuVisible(menuVisible);
      menuModel.setAdName(adName);
      menuModel.setAdContent(adContent);
      menuModel.setAdUrl(adUrl);
      menuModel.setAdState(adState);
      menuModel.setOrderId(orderId);
      update(menuModel);
    }else if ("delete".equalsIgnoreCase(action)){
      int[] ids = new int[3];
      ids[0] = 1;
      ids[1] = 2;
      ids[2] = 3;
      MenuBean.delete(ids);
    }else if ("findByPK".equalsIgnoreCase(action)){
      MenuModel menuModel = MenuBean.findByPK(1);
      int menuId = menuModel.getMenuId();
      int imgId = menuModel.getImgId();
      int menuParent = menuModel.getMenuParent();
      int menuChannel = menuModel.getMenuChannel();
      String menuName = menuModel.getMenuName();
      int menuAreacode = menuModel.getMenuAreacode();
      int menuVisible = menuModel.getMenuVisible();
      String adName = menuModel.getAdName();
      String adContent = menuModel.getAdContent();
      String adUrl = menuModel.getAdUrl();
      int adState = menuModel.getAdState();
      int orderId = menuModel.getOrderId();
      System.out.println("menuId = " + menuId);
      System.out.println("imgId = " + imgId);
      System.out.println("menuParent = " + menuParent);
      System.out.println("menuChannel = " + menuChannel);
      System.out.println("menuName = " + menuName);
      System.out.println("menuAreacode = " + menuAreacode);
      System.out.println("menuVisible = " + menuVisible);
      System.out.println("adName = " + adName);
      System.out.println("adContent = " + adContent);
      System.out.println("adUrl = " + adUrl);
      System.out.println("adState = " + adState);
      System.out.println("orderId = " + orderId);
    }else if ("queryBySql".equalsIgnoreCase(action)){
      Collection coll = MenuBean.queryBySql("SELECT * FROM WAP_MENU");
    }else if ("getRowCountBySql".equalsIgnoreCase(action)){
      int rowCount = MenuBean.getRowCountBySql("SELECT COUNT(*) FROM WAP_MENU");
      System.out.println("rowCount = " + rowCount);
    }else if ("queryAll".equalsIgnoreCase(action)){
      Collection coll = MenuBean.queryAll();
      Iterator it = coll.iterator();
      while ( it.hasNext() ) {
        Hashtable element = (Hashtable)it.next();
        String menuId = (String)element.get("menuId");
        String imgId = (String)element.get("imgId");
        String menuParent = (String)element.get("menuParent");
        String menuChannel = (String)element.get("menuChannel");
        String menuName = (String)element.get("menuName");
        String menuAreacode = (String)element.get("menuAreacode");
        String menuVisible = (String)element.get("menuVisible");
        String adName = (String)element.get("adName");
        String adContent = (String)element.get("adContent");
        String adUrl = (String)element.get("adUrl");
        String adState = (String)element.get("adState");
        String orderId = (String)element.get("orderId");
        System.out.print("menuId = " + menuId + ",\t");
        System.out.print("imgId = " + imgId + ",\t");
        System.out.print("menuParent = " + menuParent + ",\t");
        System.out.print("menuChannel = " + menuChannel + ",\t");
        System.out.print("menuName = " + menuName + ",\t");
        System.out.print("menuAreacode = " + menuAreacode + ",\t");
        System.out.print("menuVisible = " + menuVisible + ",\t");
        System.out.print("adName = " + adName + ",\t");
        System.out.print("adContent = " + adContent + ",\t");
        System.out.print("adUrl = " + adUrl + ",\t");
        System.out.print("adState = " + adState + ",\t");
        System.out.print("orderId = " + orderId + "\n");
      }
    }else if ("getRowCountOfAll".equalsIgnoreCase(action)){
      int rowCount = MenuBean.getRowCountOfAll();
      System.out.println("rowCount = " + rowCount);
    }else if ("getSequenceNextValue".equalsIgnoreCase(action)){
      int sequenceValue = MenuBean.getSequenceNextValue();
      System.out.println("sequenceValue = " + sequenceValue);
    }
  }
}
/*
int menuId = (model==null?0:model.getMenuId());
int imgId = (model==null?0:model.getImgId());
int menuParent = (model==null?0:model.getMenuParent());
int menuChannel = (model==null?0:model.getMenuChannel());
String menuName = (model==null?"":model.getMenuName());
int menuAreacode = (model==null?0:model.getMenuAreacode());
int menuVisible = (model==null?0:model.getMenuVisible());
String adName = (model==null?"":model.getAdName());
String adContent = (model==null?"":model.getAdContent());
String adUrl = (model==null?"":model.getAdUrl());
int adState = (model==null?0:model.getAdState());
int orderId = (model==null?0:model.getOrderId());
int menuId = PageUtil.parseIntField(request.getParameter("menuId"), "menuId", false, 0, );
int imgId = PageUtil.parseIntField(request.getParameter("imgId"), "imgId", false, 0, );
int menuParent = PageUtil.parseIntField(request.getParameter("menuParent"), "menuParent", false, 0, );
int menuChannel = PageUtil.parseIntField(request.getParameter("menuChannel"), "menuChannel", false, 0, );
String menuName = PageUtil.parseStringField(request.getParameter("menuName"), "menuName", false, 19);
int menuAreacode = PageUtil.parseIntField(request.getParameter("menuAreacode"), "menuAreacode", false, 0, 19);
int menuVisible = PageUtil.parseIntField(request.getParameter("menuVisible"), "menuVisible", false, 0, 19);
String adName = PageUtil.parseStringField(request.getParameter("adName"), "adName", false, 49);
String adContent = PageUtil.parseStringField(request.getParameter("adContent"), "adContent", false, 199);
String adUrl = PageUtil.parseStringField(request.getParameter("adUrl"), "adUrl", false, 199);
int adState = PageUtil.parseIntField(request.getParameter("adState"), "adState", false, 0, 199);
int orderId = PageUtil.parseIntField(request.getParameter("orderId"), "orderId", false, 0, 199);


int menuId = PageUtil.parseIntField(request.getParameter("menuId"), "menuId", false, 0, 999999999);
int imgId = PageUtil.parseIntField(request.getParameter("imgId"), "imgId", true, 0, 999999999);
int menuParent = PageUtil.parseIntField(request.getParameter("menuParent"), "menuParent", true, 0, 999999999);
int menuChannel = PageUtil.parseIntField(request.getParameter("menuChannel"), "menuChannel", true, 0, 999999999);
String menuName = PageUtil.parseStringField(request.getParameter("menuName"), "menuName", true, 20);
int menuAreacode = PageUtil.parseIntField(request.getParameter("menuAreacode"), "menuAreacode", true, 0, 999999999);
int menuVisible = PageUtil.parseIntField(request.getParameter("menuVisible"), "menuVisible", true, 0, 999999999);
String adName = PageUtil.parseStringField(request.getParameter("adName"), "adName", true, 50);
String adContent = PageUtil.parseStringField(request.getParameter("adContent"), "adContent", true, 200);
String adUrl = PageUtil.parseStringField(request.getParameter("adUrl"), "adUrl", true, 200);
int adState = PageUtil.parseIntField(request.getParameter("adState"), "adState", true, 0, 9);
int orderId = PageUtil.parseIntField(request.getParameter("orderId"), "orderId", true, 0, 999999999);
String menuId = (model==null?"0":""+model.getMenuId());
String imgId = (model==null?"0":""+model.getImgId());
String menuParent = (model==null?"0":""+model.getMenuParent());
String menuChannel = (model==null?"0":""+model.getMenuChannel());
String menuName = (model==null?"":""+model.getMenuName());
String menuAreacode = (model==null?"0":""+model.getMenuAreacode());
String menuVisible = (model==null?"0":""+model.getMenuVisible());
String adName = (model==null?"":""+model.getAdName());
String adContent = (model==null?"":""+model.getAdContent());
String adUrl = (model==null?"":""+model.getAdUrl());
String adState = (model==null?"0":""+model.getAdState());
String orderId = (model==null?"0":""+model.getOrderId());

Collection coll = MenuBean.queryAll((pageNum-1) * pageRow + 1, pageNum * pageRow);
Iterator it = coll.iterator();
while ( it.hasNext() ) {
    Hashtable element = (Hashtable)it.next();
    MenuModel menuModel = MenuBean.toModel(element);
    int menuId = menuModel.getMenuId();
    int imgId = menuModel.getImgId();
    int menuParent = menuModel.getMenuParent();
    int menuChannel = menuModel.getMenuChannel();
    String menuName = menuModel.getMenuName();
    int menuAreacode = menuModel.getMenuAreacode();
    int menuVisible = menuModel.getMenuVisible();
    String adName = menuModel.getAdName();
    String adContent = menuModel.getAdContent();
    String adUrl = menuModel.getAdUrl();
    int adState = menuModel.getAdState();
    int orderId = menuModel.getOrderId();

        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), menuId+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), imgId+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), menuParent+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), menuChannel+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), menuName+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), menuAreacode+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), menuVisible+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), adName+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), adContent+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), adUrl+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), adState+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), orderId+"");
*/