staffuserbean.java

来自「WAP PUSH后台源码,WAP PUSH后台源码」· Java 代码 · 共 27 行

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

public class StaffUserBean extends StaffUserDao{
  public static int getRowCountByGroupId(int groupId, String userName) throws SysException {
    String sql = "SELECT COUNT(*) FROM WAP_STAFF_USER WHERE  GROUP_ID = " + groupId + " AND USER_NAME LIKE '" + userName + "%'";
    System.out.println(sql);
    return getRowCountBySql(sql);
}
  public static Collection queryByGroupId(int groupId, String userName, int beginRow, int endRow) throws SysException {
  String sql = "SELECT * FROM WAP_STAFF_USER WHERE  GROUP_ID = " + groupId + " AND USER_NAME LIKE '" + userName + "%'";
  return queryBySql(sql, beginRow, endRow);
}
public static boolean isExist(String userName,int groupId)throws SysException{
  String sql = "SELECT COUNT(*) FROM WAP_STAFF_USER WHERE USER_NAME = '" + userName + "' AND GROUP_ID = " + groupId;
  return getRowCountBySql(sql)>0;
}
public static boolean isMember(String userName,String userPwd,int groupId)throws SysException{
  String sql = "SELECT COUNT(*) FROM WAP_STAFF_USER WHERE USER_NAME = '" + userName + "' AND USER_PWD = '" + userPwd + "' AND GROUP_ID = " + groupId;
  return getRowCountBySql(sql)>0;
}

}