checkbean.java

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

package com.sxit.wap.usercheck;
import java.sql.*;
import java.util.*;
import com.sxit.wap.common.*;
import com.sxit.wap.exception.*;

public class CheckBean extends CheckDao{
  public static boolean isCanUsed(String userMdn)throws SysException,FinderException{
   CheckModel model = findByPK(userMdn);
   if("91004".equals(model.getSubstatus())){
     return false;
   }else{
     return true;
   }
  }
  public static Hashtable getAllUserTypeName(){
    Hashtable ht = new Hashtable();
    ht.put("91003","销户用户");
    ht.put("91005","取消预约销户");
    ht.put("91004","预约销户");
    ht.put("91010","营业停机");
    ht.put("91011","欠费停机");
    ht.put("91002","改号用户");
    ht.put("91001","新建用户");
    ht.put("91009","开机用户");
    ht.put("9","所有用户");
    return ht;
  }
  public static int getRowCountOfUser(String mdn,String status)throws SysException{
    String sql = "SELECT COUNT(*) FROM WAP_USER U,USER_CHECK C WHERE U.USER_MDN = C.MDN AND U.USER_MDN LIKE '" + mdn + "%' AND C.SUBSTATUS LIKE '" + status + "%'";
    System.out.println(sql);
    return getRowCountBySql(sql);
  }
  public static Collection queryUser(String mdn,String status,int beginRow, int endRow)throws SysException{
    String sql = "SELECT * FROM WAP_USER U,USER_CHECK C WHERE U.USER_MDN = C.MDN AND U.USER_MDN LIKE '" + mdn + "%' AND C.SUBSTATUS LIKE '" + status + "%'";
    System.out.println(sql);
    return queryBySql(sql, beginRow, endRow);
  }
  public static void main(String[] args){

  }
}