userdao.java

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

          + model.getUserGroup() + ", USER_REGDATE = '"
          + Function.DateToString(model.getUserRegdate()) + "', USER_TEST = "
          + model.getUserTest() + " WHERE USER_MDN = '" + model.getUserMdn() + "'";
    }
    return sql;
  }
  protected static String getDeleteSQL(String userMdn) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_USER WHERE USER_MDN = '" + userMdn + "'";
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_USER WHERE USER_MDN = '" + userMdn + "'";
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_USER WHERE USER_MDN = '" + userMdn + "'";
    }
    return sql;
  }
  protected static String getDeleteSQL(String[] ids) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "DELETE FROM WAP_USER WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR USER_MDN = '" + ids[i] + "'";
      }
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "DELETE FROM WAP_USER WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR USER_MDN = '" + ids[i] + "'";
      }
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "DELETE FROM WAP_USER WHERE 1 = 2";
      for ( int i = 0; i < ids.length; i++ ) {
        sql += " OR USER_MDN = '" + ids[i] + "'";
      }
    }
    return sql;
  }
  protected static String getFindByPKSQL(String userMdn) {
    String sql = "";
    if (Database.dbType == DBType.ORACLE) {
      sql = "SELECT * FROM WAP_USER WHERE USER_MDN = '" + userMdn + "'";
    } else if (Database.dbType == DBType.SQLSERVER) {
      sql = "SELECT * FROM WAP_USER WHERE USER_MDN = '" + userMdn + "'";
    } else if (Database.dbType == DBType.MYSQL) {
      sql = "SELECT * FROM WAP_USER WHERE USER_MDN = '" + userMdn + "'";
    }
    return sql;
  }
  protected static boolean isValidData(UserModel 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)) {
      UserModel model=new UserModel();
      model.setUserMdn("abc");
      model.setUserName("abc");
      model.setUserPwd("abc");
      model.setUserAgent("abc");
      model.setUserArea(1);
      model.setUserStatus(1);
      model.setUserPoint(1);
      model.setUserGroup(1);
      model.setUserRegdate(Function.getCurrTime());
      model.setUserTest(1);
      UserModel userModel = UserBean.insert(model);
    }else if ("update".equalsIgnoreCase(action)){
      UserModel userModel = UserBean.findByPK("1");
      String userMdn = userModel.getUserMdn();
      String userName = userModel.getUserName();
      String userPwd = userModel.getUserPwd();
      String userAgent = userModel.getUserAgent();
      int userArea = userModel.getUserArea();
      int userStatus = userModel.getUserStatus();
      int userPoint = userModel.getUserPoint();
      int userGroup = userModel.getUserGroup();
      Timestamp userRegdate = userModel.getUserRegdate();
      int userTest = userModel.getUserTest();
      userModel.setUserName(userName);
      userModel.setUserPwd(userPwd);
      userModel.setUserAgent(userAgent);
      userModel.setUserArea(userArea);
      userModel.setUserStatus(userStatus);
      userModel.setUserPoint(userPoint);
      userModel.setUserGroup(userGroup);
      userModel.setUserRegdate(userRegdate);
      userModel.setUserTest(userTest);
      update(userModel);
    }else if ("delete".equalsIgnoreCase(action)){
      String[] ids = new String[3];
      ids[0] = "1";
      ids[1] = "2";
      ids[2] = "3";
      UserBean.delete(ids);
    }else if ("findByPK".equalsIgnoreCase(action)){
      UserModel userModel = UserBean.findByPK("1");
      String userMdn = userModel.getUserMdn();
      String userName = userModel.getUserName();
      String userPwd = userModel.getUserPwd();
      String userAgent = userModel.getUserAgent();
      int userArea = userModel.getUserArea();
      int userStatus = userModel.getUserStatus();
      int userPoint = userModel.getUserPoint();
      int userGroup = userModel.getUserGroup();
      Timestamp userRegdate = userModel.getUserRegdate();
      int userTest = userModel.getUserTest();
      System.out.println("userMdn = " + userMdn);
      System.out.println("userName = " + userName);
      System.out.println("userPwd = " + userPwd);
      System.out.println("userAgent = " + userAgent);
      System.out.println("userArea = " + userArea);
      System.out.println("userStatus = " + userStatus);
      System.out.println("userPoint = " + userPoint);
      System.out.println("userGroup = " + userGroup);
      System.out.println("userRegdate = " + Function.getYYYYMMDDHHMISS(userRegdate));
      System.out.println("userTest = " + userTest);
    }else if ("queryBySql".equalsIgnoreCase(action)){
      Collection coll = UserBean.queryBySql("SELECT * FROM WAP_USER");
    }else if ("getRowCountBySql".equalsIgnoreCase(action)){
      int rowCount = UserBean.getRowCountBySql("SELECT COUNT(*) FROM WAP_USER");
      System.out.println("rowCount = " + rowCount);
    }else if ("queryAll".equalsIgnoreCase(action)){
      Collection coll = UserBean.queryAll();
      Iterator it = coll.iterator();
      while ( it.hasNext() ) {
        Hashtable element = (Hashtable)it.next();
        String userMdn = (String)element.get("userMdn");
        String userName = (String)element.get("userName");
        String userPwd = (String)element.get("userPwd");
        String userAgent = (String)element.get("userAgent");
        String userArea = (String)element.get("userArea");
        String userStatus = (String)element.get("userStatus");
        String userPoint = (String)element.get("userPoint");
        String userGroup = (String)element.get("userGroup");
        String userRegdate = Function.getYYYYMMDDHHMISS((Timestamp)element.get("userRegdate"));
        String userTest = (String)element.get("userTest");
        System.out.print("userMdn = " + userMdn + ",\t");
        System.out.print("userName = " + userName + ",\t");
        System.out.print("userPwd = " + userPwd + ",\t");
        System.out.print("userAgent = " + userAgent + ",\t");
        System.out.print("userArea = " + userArea + ",\t");
        System.out.print("userStatus = " + userStatus + ",\t");
        System.out.print("userPoint = " + userPoint + ",\t");
        System.out.print("userGroup = " + userGroup + ",\t");
        System.out.print("userRegdate = " + userRegdate + ",\t");
        System.out.print("userTest = " + userTest + "\n");
      }
    }else if ("getRowCountOfAll".equalsIgnoreCase(action)){
      int rowCount = UserBean.getRowCountOfAll();
      System.out.println("rowCount = " + rowCount);
    }else if ("getSequenceNextValue".equalsIgnoreCase(action)){
      int sequenceValue = UserBean.getSequenceNextValue();
      System.out.println("sequenceValue = " + sequenceValue);
    }
  }
}
/*
String userMdn = (model==null?"":model.getUserMdn());
String userName = (model==null?"":model.getUserName());
String userPwd = (model==null?"":model.getUserPwd());
String userAgent = (model==null?"":model.getUserAgent());
int userArea = (model==null?0:model.getUserArea());
int userStatus = (model==null?0:model.getUserStatus());
int userPoint = (model==null?0:model.getUserPoint());
int userGroup = (model==null?0:model.getUserGroup());
Timestamp userRegdate = (model==null?null:model.getUserRegdate());
int userTest = (model==null?0:model.getUserTest());
String userMdn = PageUtil.parseStringField(request.getParameter("userMdn"), "userMdn", false, 19);
String userName = PageUtil.parseStringField(request.getParameter("userName"), "userName", false, 19);
String userPwd = PageUtil.parseStringField(request.getParameter("userPwd"), "userPwd", false, 19);
String userAgent = PageUtil.parseStringField(request.getParameter("userAgent"), "userAgent", false, 19);
int userArea = PageUtil.parseIntField(request.getParameter("userArea"), "userArea", false, 0, 19);
int userStatus = PageUtil.parseIntField(request.getParameter("userStatus"), "userStatus", false, 0, 19);
int userPoint = PageUtil.parseIntField(request.getParameter("userPoint"), "userPoint", false, 0, 65535);
int userGroup = PageUtil.parseIntField(request.getParameter("userGroup"), "userGroup", false, 0, 65535);
int userTest = PageUtil.parseIntField(request.getParameter("userTest"), "userTest", false, 0, 65535);


String userMdn = PageUtil.parseStringField(request.getParameter("userMdn"), "userMdn", false, 20);
String userName = PageUtil.parseStringField(request.getParameter("userName"), "userName", true, 20);
String userPwd = PageUtil.parseStringField(request.getParameter("userPwd"), "userPwd", true, 20);
String userAgent = PageUtil.parseStringField(request.getParameter("userAgent"), "userAgent", true, 20);
int userArea = PageUtil.parseIntField(request.getParameter("userArea"), "userArea", true, 0, 999999999);
int userStatus = PageUtil.parseIntField(request.getParameter("userStatus"), "userStatus", true, 0, 9);
int userPoint = PageUtil.parseIntField(request.getParameter("userPoint"), "userPoint", true, 0, 99999);
int userGroup = PageUtil.parseIntField(request.getParameter("userGroup"), "userGroup", true, 0, 999999999);
Timestamp userRegdate = PageUtil.parseDateField(request.getParameter("userRegdate"), "userRegdate", true);
int userTest = PageUtil.parseIntField(request.getParameter("userTest"), "userTest", true, 0, 9);
String userMdn = (model==null?"":""+model.getUserMdn());
String userName = (model==null?"":""+model.getUserName());
String userPwd = (model==null?"":""+model.getUserPwd());
String userAgent = (model==null?"":""+model.getUserAgent());
String userArea = (model==null?"0":""+model.getUserArea());
String userStatus = (model==null?"0":""+model.getUserStatus());
String userPoint = (model==null?"0":""+model.getUserPoint());
String userGroup = (model==null?"0":""+model.getUserGroup());
Timestamp userRegdate = (model==null?null:model.getUserRegdate());
String userTest = (model==null?"0":""+model.getUserTest());

Collection coll = UserBean.queryAll((pageNum-1) * pageRow + 1, pageNum * pageRow);
Iterator it = coll.iterator();
while ( it.hasNext() ) {
    Hashtable element = (Hashtable)it.next();
    UserModel userModel = UserBean.toModel(element);
    String userMdn = userModel.getUserMdn();
    String userName = userModel.getUserName();
    String userPwd = userModel.getUserPwd();
    String userAgent = userModel.getUserAgent();
    int userArea = userModel.getUserArea();
    int userStatus = userModel.getUserStatus();
    int userPoint = userModel.getUserPoint();
    int userGroup = userModel.getUserGroup();
    Timestamp userRegdate = userModel.getUserRegdate();
    int userTest = userModel.getUserTest();

        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userMdn+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userName+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userPwd+"");
        excel.setCellData(new ExcelCell(ExcelUtil.STRING_CELL_TYTE, currRow, currCol++), userAgent+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), userArea+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), userStatus+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), userPoint+"");
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), userGroup+"");
        excel.setCellData(new ExcelCell(ExcelUtil.DATE_CELL_TYTE,   currRow, currCol++), userRegdate);
        excel.setCellData(new ExcelCell(ExcelUtil.INT_CELL_TYTE,    currRow, currCol++), userTest+"");
*/