rightbean.java

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

	/**文书权限*/
	public boolean isRightSecretary()
	{
		boolean bool = false;
		String right = "";
		ResultSet rs = selectRecord("select WSZWBH from ZZ_BMB where BMBH =(select BMBH from ZZ_ZGB where ZGBH='"+uid+"')");
		Statement stmt = null;
		try{
		if(rs.next())
			right = ds.toString(rs.getString(1));
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		if(right!=null && right.equals(uid))bool = true;
		return bool;
	}

	/**比较该Vector变量中莫一个变量权限名称*/
	public String getExist(Vector v,String s)
	{
		String str = "";
		for(int i=0;i<v.size();i++)
		{
			String t = (String)v.get(i);
			if(t.indexOf(s)!=-1)
			{	
				int t1 = t.indexOf("<");
				str = t.substring(t1+1,t.length()-1);
				break;
			}
		}
		return str;
	}
	
	/**档案权限*/
	//public Vector getRightArchives()档案权限
	//public Vector getRightPeriodical()期刊权限

	//当前职工所在的部门编号（包括被分配职务后得到的职务部门编号）
	public Vector getBMBHS()
	{	
		Vector vect = new Vector();
		String sql = " select BMBH from ZZ_ZGZWB where ZGBH='"+uid+"'";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		while(rs.next())
		{
			String bmbh = ds.toString(rs.getString(1));
			String bmmc = db.toName("ZZ_BMB","BMBH","BMMC",bmbh);
			Hashtable hash = new Hashtable();
			hash.put("BMBH",bmbh);
			hash.put("BMMC",bmmc);
			vect.add(hash);
		}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return vect;
	}
	public boolean isRightOrg(String lbid){//ZZ_FBXWB//部门新闻操作权限(根据orgmenu.id判断)(uid,Orgid)
		boolean isright=false;
		ResultSet rst=selectRecord("select LB from ZZ_FBXWB where ZGBH='"+uid
			+"' and BMBH='"+Orgid+"' and LB = 2");
		Statement stmt = null;
		try{
			if(rst.next()){ isright=true;}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rst!=null)try{ stmt = rst.getStatement(); rst.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return isright;
	}

	public boolean isRightPage(String dxbh,String whichtable,String sf,String cz){//版面权限
		boolean isright=false;
		ResultSet rst=selectRecord("select LB from ZZ_FBXWB where ZGBH='"+uid
			+"' and LB = 1 and DXBH='"+ dxbh +"' and WHICHTABLE = '"+whichtable+"' and SF='"
			+sf+"' and cz='"+cz+"'");
		Statement stmt = null;
		try{
			if(rst.next()){ isright=true;}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rst!=null)try{ stmt = rst.getStatement(); rst.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return isright;
	}
	
	/**取得模块权限-----------------------11-29*/
	public String getRightModelbh()
	{
		String czqx = "",czqx1="";
		String bmbh = "",bmbhchg="";
		String zwbh = "";
		String right = "";
		String sql = "select BMBH,ZWBH,CZQX from ZZ_ZGZWB where ZGBH='"+uid+"'";
		/*if(!uid.equals("1") && !Orgid.equals("-1"))
		{
			char bmsub;
			int n=19;
			for(n=19;n>=0;n--)
			{
				bmsub = Orgid.charAt(n);
				if(bmsub!='0')
					break;
			}
			if(n==-1) n=1;
			sql += " and (BMBH='"+Orgid+"' or BMBH like '%"+Orgid.substring(0,n+1)+"%')";
		}*/
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			while(rs.next())//取得职务表权限
			{
				czqx = ds.toString(rs.getString("CZQX"));
				bmbh = ds.toString(rs.getString("BMBH"));
				zwbh = ds.toString(rs.getString("ZWBH"));
				if(!bmbh.equals("") && !zwbh.equals("")){
					if(czqx.equals(""))//当职务表中权限为空时，去部门职务表权限
					{
						sql = "select CZQX from ZZ_ZWB where BMBH='"+bmbh+"' and ZWBH="+zwbh+" and ZWZT=0";
						ResultSet rs_t = selectRecord(sql);
						try{
							if(rs_t.next())
								czqx = ds.toString(rs_t.getString("CZQX"));

							if(rs_t!=null)try{ stmt = rs_t.getStatement(); rs_t.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
							if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
							
							if(czqx.equals(""))//当职务权限集合为空时查询字典
							{
								rs_t = selectRecord("select ID from CODE_ANCZQXB where MRCZ=1 and SYZT=0");
								while(rs_t.next())
								{
									czqx1 = rs_t.getString(1);
									if(czqx.equals(""))
										czqx = czqx1;
									else
										czqx = czqx+","+czqx1;
								}
							}
						}catch(Exception e){System.out.println("运行时出错："+e);}
						finally{
							if(rs_t!=null)try{ stmt = rs_t.getStatement(); rs_t.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
							if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
						}
					}
					if(!bmbhchg.equals("") && !bmbh.equals(bmbhchg))
					{
						right = right+"@"+bmbh+":"+czqx;
						bmbhchg = bmbh;
						continue;
					}
					if(right.equals("") && !czqx.equals(""))
						right = bmbh+":"+czqx;
					else if(!right.equals("") && !czqx.equals(""))
						right = right+","+czqx;
					bmbhchg = bmbh;
				}
			}

			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
			//////////////////////////////////////////////////////////////////////////////
			if(right.equals(""))//当职务权限集合为空时查询字典
			{
				bmbh = Orgid;
				stmt = rs.getStatement();rs.close();stmt.close();
				rs = selectRecord("select ID from CODE_ANCZQXB where MRCZ=1 and SYZT=0");
				while(rs.next())
				{
					czqx = rs.getString(1);
					if(!right.equals("") && !czqx.equals(""))
						right = right+","+czqx;
					if(right.equals("") && !czqx.equals(""))
						right = bmbh+":"+czqx;
				}
			}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return right;
	}
	/**是否有模块操作权限-----------------------11-29*/
	public boolean isRightModelbh(String strmkmc,String strbtnmc)
	{
		boolean bool = false;
/*原先每次取数据库的代码
		ResultSet rs = selectRecord("select ID from CODE_ANCZQXB where MKMC='"+ds.toString(strmkmc)+"' and ANMC='"+ds.toString(strbtnmc)+"'");
		String mkbh = "";
		Statement stmt = null;
		try{
			if(rs.next())
				 mkbh = ds.toString(rs.getString("ID"));
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		String rights = getRightModelbh();
		String []ids = rights.split("@");
		for(int i=0;i<ids.length;i++)
		{
			String []bmrt = ids[i].split(":");
			char bmsub ;
			int n=19;
			for(n=19;n>=0;n--)
			{
				bmsub = bmrt[0].charAt(n);
				if(bmsub!='0')
					break;
			}
//要setOrgid为当前部门
			if(bmrt[0].equals(Orgid) || (bmrt[0].substring(0,n+1)).equals(Orgid.substring(0,n+1)))
			{
				String []rts = bmrt[1].split(",");
				for(int j=0;j<rts.length;j++)
				{
					if(rts[j].equals(mkbh))
					{
						bool = true;
						break;
					}
				}
			}
		}
*/
//////////////
//从静态向量中取得权限记录
	if(PublicData.v_Buttons == null)
		PublicData.rebuildButtonTable();
	String strID = null;
	String strRight = null;
	Hashtable hash = null;
	//得到该按钮的ID
	int k = PublicData.v_Buttons.size();
	for(int i=0;i<k;i++){
		hash = (Hashtable)PublicData.v_Buttons.get(i);
		if(strmkmc.equals((String)hash.get("MKMC")) && strbtnmc.equals((String)hash.get("ANMC")))
		{
			strID = ","+(String)hash.get("ID")+",";
			break;
		}
	}
	//得到此人的所有权限
	if(Orgid.equals("-1")){//不限制所在部门
		if(PublicData.v_right==null)
			PublicData.rebuildRightVector();
		k = PublicData.v_right.size();
		for(int i=0;i<k;i++){
			if(uid.equals((String)PublicData.v_right.get(i))){
				strRight = ","+(String)PublicData.v_right.get(++i)+",";
				break;
			}
		}
	}
	else{//限制部门
		if(PublicData.v_RightTable == null)
			PublicData.rebuildRightTable();
		k = PublicData.v_RightTable.size();
		boolean b = false;
		for(int i=0;i<k;i++){
			hash = (Hashtable)PublicData.v_RightTable.get(i);
			if(uid.equals((String)hash.get("ZGBH"))){
				if(!b)	b = true;
				int n=19;
				String bmrt = (String)hash.get("BMBH");
				for(n=19;n>=0;n--)
				{
					if(bmrt.charAt(n)!='0')
						break;
				}
				if(bmrt.equals(Orgid) || (bmrt.substring(0,n+1)).equals(Orgid.substring(0,n+1)))
				{
					String str = (String)hash.get("CZQX");
					if(strRight==null)
						strRight = str;
					else
					strRight += ","+str;
				}
			}
			else if(b)
				break;
		}
		if(strRight == null){
			if(PublicData.s_RightDefault==null)
				PublicData.rebuildRightDefault();
			strRight = ","+PublicData.s_RightDefault+",";	
		}
		else
			strRight = ","+ds.strDistinct(strRight)+",";
	}
	//判断权限
	bool = (strRight.indexOf(strID)!=-1);
//////////////
	return bool;
	}


	public boolean isRightMeetingSummaryReceive(){
       try{
		String sql="select A.ID from HG2_MEET_SUMMARY_MEN A,HG2_MEET_SUMMARY B where A.SUMMARYID=B.ID and A.RECEIVER='"+uid+"' and B.ISFILED='1' ";
		//System.out.println(sql);
		ResultSet rs = selectRecord(sql);
		if(rs.next()) { rs.getStatement().close();rs.close();rs=null;return true;};
		if(rs!=null)
		 {
			rs.getStatement().close();
			rs.close();
			rs=null;
		 }
	   }catch(Exception e){System.out.println("\n[SYSTEM]DBOPEN ERROR:"+e.getMessage());}
		return false;
	}

	public boolean isRightMeetingPerform(){
	  try{
		String sql="select ID from HG2_MEET_SUMMARY where PERFORMER='"+uid+"' and ISCHECK='1' and ISFILED='1' ";
		//System.out.println(sql);
		ResultSet rs = selectRecord(sql);
		if(rs.next()) { rs.getStatement().close();rs.close();rs=null;return true;};
		if(rs!=null)
		 {
			rs.getStatement().close();
			rs.close();
			rs=null;
		 }
	  }catch(Exception e){System.out.println("\n[SYSTEM]DBOPEN ERROR:"+e.getMessage());}
		return false;
	}

	public boolean isRightMeetingCheck(){
	 try{
		String sql="select ID from HG2_MEET_SUMMARY where CHECKER='"+uid+"'";
		//System.out.println(sql);
		ResultSet rs = selectRecord(sql);
		if(rs.next()) { rs.getStatement().close();rs.close();rs=null;return true;};
		if(rs!=null)
		 {
			rs.getStatement().close();
			rs.close();
			rs=null;
		 }
	  }catch(Exception e){System.out.println("\n[SYSTEM]DBOPEN ERROR:"+e.getMessage());}
		return false;
	}




	public static void main(String args[])
	{
		RightBean mb = new RightBean();

		mb.setUID("1");

		//判断是否是管理员
		boolean bool = mb.isAdmin();

		//模块权限用法:true/false
		bool = mb.isRightMode("个人信息","修改个人信息");
		//流程权限用法:true/false
		bool = mb.isRightFlow("发邮件");
		//系统配置参数
		System.out.println(mb.isRightMode("部门列表","增加子部门"));
		//System.out.println(mb.getConfValue("短消息保存时间"));

		System.out.println("\r\n\r\nend");
	}
}