groupmenudao.java

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

          + Function.writeDBEncode(model.getMenuName()) + "', MENU_TRADE = "
          + model.getMenuTrade() + ", ORDER_ID = "
          + model.getOrderId() + " WHERE MENU_ID = " + model.getMenuId();
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "UPDATE WAP_GROUP_MENU SET IMG_ID = "
          + model.getImgId() + ", MENU_PARENT = "
          + model.getMenuParent() + ", MENU_CHANNEL = "
          + model.getMenuChannel() + ", MENU_NAME = '"
          + Function.writeDBEncode(model.getMenuName()) + "', MENU_TRADE = "
          + model.getMenuTrade() + ", ORDER_ID = "
          + model.getOrderId() + " WHERE MENU_ID = " + model.getMenuId();
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "UPDATE WAP_GROUP_MENU SET IMG_ID = "
          + model.getImgId() + ", MENU_PARENT = "
          + model.getMenuParent() + ", MENU_CHANNEL = "
          + model.getMenuChannel() + ", MENU_NAME = '"
          + Function.writeDBEncode(model.getMenuName()) + "', MENU_TRADE = "
          + model.getMenuTrade() + ", ORDER_ID = "
          + model.getOrderId() + " WHERE MENU_ID = " + model.getMenuId();
    }
    return sql;
  }
  protected static String getDeleteSQL(int menuId) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_GROUP_MENU WHERE MENU_ID = " + menuId;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_GROUP_MENU WHERE MENU_ID = " + menuId;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_GROUP_MENU WHERE MENU_ID = " + menuId;
    }
    return sql;
  }
  protected static String getDeleteSQL(int[] ids) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_GROUP_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_GROUP_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_GROUP_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_GROUP_MENU WHERE MENU_ID = " + menuId;
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "SELECT * FROM WAP_GROUP_MENU WHERE MENU_ID = " + menuId;
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "SELECT * FROM WAP_GROUP_MENU WHERE MENU_ID = " + menuId;
    }
    return sql;
  }
  protected static boolean isValidData(GroupMenuModel 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)) {
      GroupMenuModel model=new GroupMenuModel();
      model.setMenuId(GroupMenuBean.getSequenceNextValue());
      model.setImgId(1);
      model.setMenuParent(1);
      model.setMenuChannel(1);
      model.setMenuName("abc");
      model.setMenuTrade(1);
      model.setOrderId(1);
      GroupMenuModel groupMenuModel = GroupMenuBean.insert(model);
    }else if ("update".equalsIgnoreCase(action)){
      GroupMenuModel groupMenuModel = GroupMenuBean.findByPK(1);
      int menuId = groupMenuModel.getMenuId();
      int imgId = groupMenuModel.getImgId();
      int menuParent = groupMenuModel.getMenuParent();
      int menuChannel = groupMenuModel.getMenuChannel();
      String menuName = groupMenuModel.getMenuName();
      int menuTrade = groupMenuModel.getMenuTrade();
      int orderId = groupMenuModel.getOrderId();
      groupMenuModel.setImgId(imgId);
      groupMenuModel.setMenuParent(menuParent);
      groupMenuModel.setMenuChannel(menuChannel);
      groupMenuModel.setMenuName(menuName);
      groupMenuModel.setMenuTrade(menuTrade);
      groupMenuModel.setOrderId(orderId);
      update(groupMenuModel);
    }else if ("delete".equalsIgnoreCase(action)){
      int[] ids = new int[3];
      ids[0] = 1;
      ids[1] = 2;
      ids[2] = 3;
      GroupMenuBean.delete(ids);
    }else if ("findByPK".equalsIgnoreCase(action)){
      GroupMenuModel groupMenuModel = GroupMenuBean.findByPK(1);
      int menuId = groupMenuModel.getMenuId();
      int imgId = groupMenuModel.getImgId();
      int menuParent = groupMenuModel.getMenuParent();
      int menuChannel = groupMenuModel.getMenuChannel();
      String menuName = groupMenuModel.getMenuName();
      int menuTrade = groupMenuModel.getMenuTrade();
      int orderId = groupMenuModel.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("menuTrade = " + menuTrade);
      System.out.println("orderId = " + orderId);
    }else if ("queryBySql".equalsIgnoreCase(action)){
      Collection coll = GroupMenuBean.queryBySql("SELECT * FROM WAP_GROUP_MENU");
    }else if ("getRowCountBySql".equalsIgnoreCase(action)){
      int rowCount = GroupMenuBean.getRowCountBySql("SELECT COUNT(*) FROM WAP_GROUP_MENU");
      System.out.println("rowCount = " + rowCount);
    }else if ("queryAll".equalsIgnoreCase(action)){
      Collection coll = GroupMenuBean.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 menuTrade = (String)element.get("menuTrade");
        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("menuTrade = " + menuTrade + ",\t");
        System.out.print("orderId = " + orderId + "\n");
      }
    }else if ("getRowCountOfAll".equalsIgnoreCase(action)){
      int rowCount = GroupMenuBean.getRowCountOfAll();
      System.out.println("rowCount = " + rowCount);
    }else if ("getSequenceNextValue".equalsIgnoreCase(action)){
      int sequenceValue = GroupMenuBean.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 menuTrade = (model==null?0:model.getMenuTrade());
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 menuTrade = PageUtil.parseIntField(request.getParameter("menuTrade"), "menuTrade", false, 0, 19);
int orderId = PageUtil.parseIntField(request.getParameter("orderId"), "orderId", false, 0, 19);


int menuId = PageUtil.parseIntField(request.getParameter("menuId"), "menuId", false, 0, 2147483647);
int imgId = PageUtil.parseIntField(request.getParameter("imgId"), "imgId", true, 0, 2147483647);
int menuParent = PageUtil.parseIntField(request.getParameter("menuParent"), "menuParent", true, 0, 2147483647);
int menuChannel = PageUtil.parseIntField(request.getParameter("menuChannel"), "menuChannel", true, 0, 2147483647);
String menuName = PageUtil.parseStringField(request.getParameter("menuName"), "menuName", true, 20);
int menuTrade = PageUtil.parseIntField(request.getParameter("menuTrade"), "menuTrade", true, 0, 2147483647);
int orderId = PageUtil.parseIntField(request.getParameter("orderId"), "orderId", true, 0, 2147483647);
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 menuTrade = (model==null?"0":""+model.getMenuTrade());
String orderId = (model==null?"0":""+model.getOrderId());

Collection coll = GroupMenuBean.queryAll((pageNum-1) * pageRow + 1, pageNum * pageRow);
Iterator it = coll.iterator();
while ( it.hasNext() ) {
    Hashtable element = (Hashtable)it.next();
    GroupMenuModel groupMenuModel = GroupMenuBean.toModel(element);
    int menuId = groupMenuModel.getMenuId();
    int imgId = groupMenuModel.getImgId();
    int menuParent = groupMenuModel.getMenuParent();
    int menuChannel = groupMenuModel.getMenuChannel();
    String menuName = groupMenuModel.getMenuName();
    int menuTrade = groupMenuModel.getMenuTrade();
    int orderId = groupMenuModel.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++), menuTrade+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), orderId+"");
*/