rolesbean.java

JSP移动商品管理平台源代码.........

package bean.roles;

import java.io.UnsupportedEncodingException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Hashtable;

import database.DBPoolManager;

public class RolesBean {

	private ArrayList<Hashtable<String, String>> roles;
	private ArrayList<Hashtable<String, String>> validate;
	
	public RolesBean() {
		roles = new ArrayList();
		validate = new ArrayList();
	}


	public String ISOtoGB(String in){
		String out = "";
		if (in == null){
			return "";
		}
		else{
    			try {
	
    				out = new String(in.getBytes("iso-8859-1"),"gb2312");
				return out;    					
    			} 
    			catch (UnsupportedEncodingException e) {
    				e.printStackTrace();
    			}
    		}
    		return out; 		
        } 
	public String GBtoISO(String in){
		String out = "";
		if (in == null){
			return "";
		}
		else{
    			try {
	
    				out = new String(in.getBytes("gb2312"),"iso-8859-1");
				return out;    					
    			} 
    			catch (UnsupportedEncodingException e) {
    				e.printStackTrace();
    			}
    		}
    		return out;		
        } 
	public ArrayList getRoles() {
		roles.clear();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;
			String    sql  = "select RoleID,RoleName from ManRole order by RoleID";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("RoleID") == null){
					ht.put("RoleID", "");
				}
				else{
					s  =   rest.getString("RoleID");
					s  =   s.trim();
					ht.put("RoleID", s);
				}
				if (rest.getString("RoleName") == null){
					ht.put("RoleName", "");
				}
				else{
					s  =   rest.getString("RoleName");
					s  =   s.trim();				
					ht.put("RoleName", s);
				}
				roles.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get RolesBean SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.roles;
	}

	public ArrayList getRoles(int RoleID) {
		roles.clear();		
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;			
			String    sql  = "select RoleID,RoleName,Purview from ManRole where RoleID="+RoleID+" order by RoleID";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("RoleID") == null){
					ht.put("RoleID", "");
				}
				else{
					s  =   rest.getString("RoleID");
					s  =   s.trim();
					ht.put("RoleID", s);
				}
				if (rest.getString("RoleName") == null){
					ht.put("RoleName", "");
				}
				else{
					s  =   rest.getString("RoleName");
					s  =   s.trim();				
					ht.put("RoleName", s);
				}
				if (rest.getString("Purview") == null){
					ht.put("Purview", "");
				}
				else{
					s  =   rest.getString("Purview");
					s  =   s.trim();				
					ht.put("Purview", s);
				}				
				roles.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get RolesBean SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.roles;
	}
	public ArrayList getRoles(String UserCode) {
		roles.clear();		
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;			
			String    sql  = "select distinct a.RoleID,a.RoleName,a.Purview from ManRole a, Staff_Role b, Staff c where a.ROLEID=b.ROLEID and b.USERID=c.USERID and c.USERFLAG='1' and  c.USERCODE='"+UserCode+"' order by a.RoleID";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("RoleID") == null){
					ht.put("RoleID", "");
				}
				else{
					s  =   rest.getString("RoleID");
					s  =   s.trim();
					ht.put("RoleID", s);
				}
				if (rest.getString("RoleName") == null){
					ht.put("RoleName", "");
				}
				else{
					s  =   rest.getString("RoleName");
					s  =   s.trim();				
					ht.put("RoleName", s);
				}
				if (rest.getString("Purview") == null){
					ht.put("Purview", "");
				}
				else{
					s  =   rest.getString("Purview");
					s  =   s.trim();				
					ht.put("Purview", s);
				}				
				roles.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get RolesBean SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.roles;
	}	
	public ArrayList getRoles(int Page,int Lines) {
		roles.clear();		
		String  s       =	null;
        	int 	i	=	0;
        	int 	tp	=	0;
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    sql  = "select RoleID, RoleName, Purview, ModifyDate, Remark from ManRole order by RoleID";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				tp=	tp	+	1;
				if ((tp>Page*Lines)&&(i<Lines)){
					i	=	i	+	1;
					if (rest.getString("RoleID") == null){
						ht.put("RoleID", "");
					}
					else{
						s  =   rest.getString("RoleID");
						s  =   s.trim();					
						ht.put("RoleID", s);
					}
					if (rest.getString("RoleName") == null){
						ht.put("RoleName", "");
					}
					else{
						s  =   rest.getString("RoleName");
						s  =   s.trim();					
						ht.put("RoleName", s);
					}
					if (rest.getString("Purview") == null){
						ht.put("Purview", "");
					}
					else{
						s  =   rest.getString("Purview");
						s  =   s.trim();					
						ht.put("Purview", s);
					}					
					if (rest.getString("ModifyDate") == null){
						ht.put("ModifyDate", "");
					}
					else{
						s  =   rest.getString("ModifyDate");
						s  =   s.trim();					
						ht.put("ModifyDate", s);
					}
					if (rest.getString("Remark") == null){
						ht.put("Remark", "");
					}
					else{
						s  =   rest.getString("Remark");
						s  =   s.trim();					
						ht.put("Remark", s);
					}					
					
					roles.add(ht);
				}
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get RolesBean SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.roles;
	}		
/*	
	public void Method(HttpServletRequest req) {
		loginuser = req.getParameter("loginuser");
		password  = req.getParameter("password");
		roleID    = req.getParameter("sRoleID");
		return	;		
	}

*/	
public boolean isAdmin(String loginuser) {
		boolean res = false;
		DBPoolManager db = new DBPoolManager();
		db.getConnection();
		try {
			String sql = "select userid from staff where USERFLAG='1' and usercode ='"
					+ loginuser + "'";
			String userId = "";
			Statement st = db.conn.createStatement();
			ResultSet rs = st.executeQuery(sql);
			if (rs.next()) {
				userId = rs.getString("userid");
			}
			rs.close();
			st.close();

			if (userId.length() > 0) {
				sql = "select roleid from staff_role where userid = " + userId;
				st = db.conn.createStatement();
				rs = st.executeQuery(sql);
				while (rs.next()) {
					int roleId = rs.getInt("roleid");
					if (roleId == 100) {
						res = true;
						break;
					}
				}
				rs.close();
				st.close();
			}
		} catch (SQLException ex) {
			res = false;
			System.err.println("Check Is Administrator SQLException: "
					+ ex.toString());
		} finally {
			db.freeConnection();
		}
		return res;
	}
	public ArrayList getValidate(String loginuser,String password) {
		validate.clear();		
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;			
			String sql="select a.UserID,a.UserName,a.UserPwd, a.UserCode, b.OrganID, b.OrganName,b.ModifyDate as logindate from staff a, organ b where a.USERFLAG='1' and a.UserCode='"
      					+loginuser+"' and a.UserPwd='"
      					+password+"'  and a.OrganID=b.OrganID ";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);

			while (rest.next()) {
				Hashtable ht = new Hashtable();

				if (rest.getString("UserID") == null){
					ht.put("UserID", "");
				}
				else{
					s  =   rest.getString("UserID");
					s  =   s.trim();				
					ht.put("UserID", s);
				}
				
				if (rest.getString("UserCode") == null){
					ht.put("UserCode", "");
				}
				else{
					s  =   rest.getString("UserCode");
					s  =   s.trim();				
					ht.put("UserCode", s);
				}				
				
				if (rest.getString("UserName") == null){
					ht.put("UserName", "");
				}
				else{
					s  =   rest.getString("UserName");
					s  =   s.trim();				
					ht.put("UserName", s);
				}
				if (rest.getString("UserPwd") == null){
					ht.put("UserPwd", "");
				}
				else{
					s  =   rest.getString("UserPwd");
					s  =   s.trim();				
					ht.put("UserPwd", s);
				}
				if (rest.getString("OrganID") == null){
					ht.put("OrganID", "");
				}
				else{
					s  =   rest.getString("OrganID");
					s  =   s.trim();				
					ht.put("OrganID", s);
				}				
				if (rest.getString("OrganName") == null){
					ht.put("OrganName", "");
				}
				else{
					s  =   rest.getString("OrganName");
					s  =   s.trim();				
					ht.put("OrganName", s);
				}
				if (rest.getString("logindate") == null){
					ht.put("logindate", "");
				}
				else{
					s  =   rest.getString("logindate");
					s  =   s.trim();				
					ht.put("logindate", s);
				}				

				validate.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get RolesBean SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.validate;
	}
	public ArrayList getValidate(String loginuser,String password,String roleID) {
		validate.clear();		
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;			
			String sql="select a.UserID,a.UserName,a.UserPwd, a.UserCode, b.RoleName, b.Purview, d.OrganName,b.ModifyDate as logindate from staff a, ManRole b, staff_role c, organ d where a.USERFLAG='1' and a.UserCode='"
      					+loginuser+"' and a.UserPwd='"
      					+password+"' and b.RoleID='"+roleID
      					+"' and a.UserId=c.UserId "
      					+"  and b.RoleID=c.RoleID "
      					+"  and a.OrganID=d.OrganID ";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);

			while (rest.next()) {
				Hashtable ht = new Hashtable();

				if (rest.getString("UserID") == null){
					ht.put("UserID", "");
				}
				else{
					s  =   rest.getString("UserID");
					s  =   s.trim();				
					ht.put("UserID", s);
				}
				
				if (rest.getString("UserCode") == null){
					ht.put("UserCode", "");
				}
				else{
					s  =   rest.getString("UserCode");
					s  =   s.trim();				
					ht.put("UserCode", s);
				}				
				
				if (rest.getString("UserName") == null){
					ht.put("UserName", "");
				}
				else{
					s  =   rest.getString("UserName");
					s  =   s.trim();				
					ht.put("UserName", s);
				}
				if (rest.getString("UserPwd") == null){
					ht.put("UserPwd", "");
				}
				else{
					s  =   rest.getString("UserPwd");
					s  =   s.trim();				
					ht.put("UserPwd", s);
				}
				if (rest.getString("RoleName") == null){
					ht.put("RoleName", "");
				}
				else{
					s  =   rest.getString("RoleName");
					s  =   s.trim();				
					ht.put("RoleName", s);
				}				
				if (rest.getString("Purview") == null){
					ht.put("Purview", "");
				}
				else{
					s  =   rest.getString("Purview");
					s  =   s.trim();				
					ht.put("Purview", s);
				}								
				if (rest.getString("OrganName") == null){
					ht.put("OrganName", "");
				}
				else{
					s  =   rest.getString("OrganName");
					s  =   s.trim();				
					ht.put("OrganName", s);
				}
				if (rest.getString("logindate") == null){
					ht.put("logindate", "");
				}
				else{
					s  =   rest.getString("logindate");
					s  =   s.trim();				
					ht.put("logindate", s);
				}				

				validate.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get RolesBean SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.validate;
	}		
}