admindao.java

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

          + Function.DateToString(model.getAdminRegdate()) + "')";
    }
    return sql;
  }
  protected static String getUpdateSQL(AdminModel model) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "UPDATE WAP_ADMIN SET ADMIN_PWD = '"
          + Function.writeDBEncode(model.getAdminPwd()) + "', ADMIN_AREA = "
          + model.getAdminArea() + ", ADMIN_FLAG = "
          + model.getAdminFlag() + ", ADMIN_STATUS = "
          + model.getAdminStatus() + ", ADMIN_REGDATE = TO_DATE('"
          + Function.DateToString(model.getAdminRegdate()) + "', 'YYYY-MM-DD HH24:MI:SS') WHERE ADMIN_NAME = '" + model.getAdminName() + "'";
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "UPDATE WAP_ADMIN SET ADMIN_PWD = '"
          + Function.writeDBEncode(model.getAdminPwd()) + "', ADMIN_AREA = "
          + model.getAdminArea() + ", ADMIN_FLAG = "
          + model.getAdminFlag() + ", ADMIN_STATUS = "
          + model.getAdminStatus() + ", ADMIN_REGDATE = '"
          + Function.DateToString(model.getAdminRegdate()) + "' WHERE ADMIN_NAME = '" + model.getAdminName() + "'";
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "UPDATE WAP_ADMIN SET ADMIN_PWD = '"
          + Function.writeDBEncode(model.getAdminPwd()) + "', ADMIN_AREA = "
          + model.getAdminArea() + ", ADMIN_FLAG = "
          + model.getAdminFlag() + ", ADMIN_STATUS = "
          + model.getAdminStatus() + ", ADMIN_REGDATE = '"
          + Function.DateToString(model.getAdminRegdate()) + "' WHERE ADMIN_NAME = '" + model.getAdminName() + "'";
    }
    return sql;
  }
  protected static String getDeleteSQL(String adminName) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_ADMIN WHERE ADMIN_NAME = '" + adminName + "'";
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_ADMIN WHERE ADMIN_NAME = '" + adminName + "'";
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_ADMIN WHERE ADMIN_NAME = '" + adminName + "'";
    }
    return sql;
  }
  protected static String getDeleteSQL(String[] ids) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_ADMIN WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR ADMIN_NAME = '" + ids[i] + "'";
      }
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_ADMIN WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR ADMIN_NAME = '" + ids[i] + "'";
      }
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_ADMIN WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR ADMIN_NAME = '" + ids[i] + "'";
      }
    }
    return sql;
  }
  protected static String getFindByPKSQL(String adminName) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "SELECT * FROM WAP_ADMIN WHERE ADMIN_NAME = '" + adminName + "'";
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "SELECT * FROM WAP_ADMIN WHERE ADMIN_NAME = '" + adminName + "'";
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "SELECT * FROM WAP_ADMIN WHERE ADMIN_NAME = '" + adminName + "'";
    }
    return sql;
  }
  protected static boolean isValidData(AdminModel 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)) {
      AdminModel model=new AdminModel();
      model.setAdminName("abc");
      model.setAdminPwd("abc");
      model.setAdminArea(1);
      model.setAdminFlag(1);
      model.setAdminStatus(1);
      model.setAdminRegdate(Function.getCurrTime());
      AdminModel adminModel = AdminBean.insert(model);
    }else if ("update".equalsIgnoreCase(action)){
      AdminModel adminModel = AdminBean.findByPK("1");
      String adminName = adminModel.getAdminName();
      String adminPwd = adminModel.getAdminPwd();
      int adminArea = adminModel.getAdminArea();
      int adminFlag = adminModel.getAdminFlag();
      int adminStatus = adminModel.getAdminStatus();
      Timestamp adminRegdate = adminModel.getAdminRegdate();
      adminModel.setAdminPwd(adminPwd);
      adminModel.setAdminArea(adminArea);
      adminModel.setAdminFlag(adminFlag);
      adminModel.setAdminStatus(adminStatus);
      adminModel.setAdminRegdate(adminRegdate);
      update(adminModel);
    }else if ("delete".equalsIgnoreCase(action)){
      String[] ids = new String[3];
      ids[0] = "1";
      ids[1] = "2";
      ids[2] = "3";
      AdminBean.delete(ids);
    }else if ("findByPK".equalsIgnoreCase(action)){
      AdminModel adminModel = AdminBean.findByPK("1");
      String adminName = adminModel.getAdminName();
      String adminPwd = adminModel.getAdminPwd();
      int adminArea = adminModel.getAdminArea();
      int adminFlag = adminModel.getAdminFlag();
      int adminStatus = adminModel.getAdminStatus();
      Timestamp adminRegdate = adminModel.getAdminRegdate();
      System.out.println("adminName = " + adminName);
      System.out.println("adminPwd = " + adminPwd);
      System.out.println("adminArea = " + adminArea);
      System.out.println("adminFlag = " + adminFlag);
      System.out.println("adminStatus = " + adminStatus);
      System.out.println("adminRegdate = " + Function.getYYYYMMDDHHMISS(adminRegdate));
    }else if ("queryBySql".equalsIgnoreCase(action)){
      Collection coll = AdminBean.queryBySql("SELECT * FROM WAP_ADMIN");
    }else if ("getRowCountBySql".equalsIgnoreCase(action)){
      int rowCount = AdminBean.getRowCountBySql("SELECT COUNT(*) FROM WAP_ADMIN");
      System.out.println("rowCount = " + rowCount);
    }else if ("queryAll".equalsIgnoreCase(action)){
      Collection coll = AdminBean.queryAll();
      Iterator it = coll.iterator();
      while ( it.hasNext() ) {
        Hashtable element = (Hashtable)it.next();
        String adminName = (String)element.get("adminName");
        String adminPwd = (String)element.get("adminPwd");
        String adminArea = (String)element.get("adminArea");
        String adminFlag = (String)element.get("adminFlag");
        String adminStatus = (String)element.get("adminStatus");
        String adminRegdate = Function.getYYYYMMDDHHMISS((Timestamp)element.get("adminRegdate"));
        System.out.print("adminName = " + adminName + ",\t");
        System.out.print("adminPwd = " + adminPwd + ",\t");
        System.out.print("adminArea = " + adminArea + ",\t");
        System.out.print("adminFlag = " + adminFlag + ",\t");
        System.out.print("adminStatus = " + adminStatus + ",\t");
        System.out.print("adminRegdate = " + adminRegdate + ",\t");
      }
    }else if ("getRowCountOfAll".equalsIgnoreCase(action)){
      int rowCount = AdminBean.getRowCountOfAll();
      System.out.println("rowCount = " + rowCount);
    }else if ("getSequenceNextValue".equalsIgnoreCase(action)){
      int sequenceValue = AdminBean.getSequenceNextValue();
      System.out.println("sequenceValue = " + sequenceValue);
    }
  }
}
/*
String adminName = (model==null?"":model.getAdminName());
String adminPwd = (model==null?"":model.getAdminPwd());
int adminArea = (model==null?0:model.getAdminArea());
int adminFlag = (model==null?0:model.getAdminFlag());
int adminStatus = (model==null?0:model.getAdminStatus());
Timestamp adminRegdate = (model==null?null:model.getAdminRegdate());
String adminName = PageUtil.parseStringField(request.getParameter("adminName"), "adminName", false, 19);
String adminPwd = PageUtil.parseStringField(request.getParameter("adminPwd"), "adminPwd", false, 19);
int adminArea = PageUtil.parseIntField(request.getParameter("adminArea"), "adminArea", false, 0, 19);
int adminFlag = PageUtil.parseIntField(request.getParameter("adminFlag"), "adminFlag", false, 0, 19);
int adminStatus = PageUtil.parseIntField(request.getParameter("adminStatus"), "adminStatus", false, 0, 19);


String adminName = PageUtil.parseStringField(request.getParameter("adminName"), "adminName", false, 20);
String adminPwd = PageUtil.parseStringField(request.getParameter("adminPwd"), "adminPwd", true, 20);
int adminArea = PageUtil.parseIntField(request.getParameter("adminArea"), "adminArea", true, 0, 999999999);
int adminFlag = PageUtil.parseIntField(request.getParameter("adminFlag"), "adminFlag", true, 0, 9);
int adminStatus = PageUtil.parseIntField(request.getParameter("adminStatus"), "adminStatus", true, 0, 9);
Timestamp adminRegdate = PageUtil.parseDateField(request.getParameter("adminRegdate"), "adminRegdate", true);
String adminName = (model==null?"":""+model.getAdminName());
String adminPwd = (model==null?"":""+model.getAdminPwd());
String adminArea = (model==null?"0":""+model.getAdminArea());
String adminFlag = (model==null?"0":""+model.getAdminFlag());
String adminStatus = (model==null?"0":""+model.getAdminStatus());
Timestamp adminRegdate = (model==null?null:model.getAdminRegdate());

Collection coll = AdminBean.queryAll((pageNum-1) * pageRow + 1, pageNum * pageRow);
Iterator it = coll.iterator();
while ( it.hasNext() ) {
    Hashtable element = (Hashtable)it.next();
    AdminModel adminModel = AdminBean.toModel(element);
    String adminName = adminModel.getAdminName();
    String adminPwd = adminModel.getAdminPwd();
    int adminArea = adminModel.getAdminArea();
    int adminFlag = adminModel.getAdminFlag();
    int adminStatus = adminModel.getAdminStatus();
    Timestamp adminRegdate = adminModel.getAdminRegdate();

        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), adminName+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), adminPwd+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), adminArea+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), adminFlag+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), adminStatus+"");
        excel.setCellData(new ExcelCell(ExcelUtil.DATE_CELL_TYTE,   currRow, currCol++), adminRegdate);
*/