?? rightbean.java
字號(hào):
/**********************************************************
Version 1.0
Date:2003-11-07
Description:權(quán)限控制
Other:
Variable List:
1.String uid = "-1";//人員編號(hào)
String Orgid = "-1";//部門編號(hào)
Function List:
1.public void setUID(String uid)//設(shè)置人員編號(hào)
2.public void setOrgid(String Orgid)//設(shè)置部門編號(hào)
//三種權(quán)限
3.public boolean isAdmin();//判斷是否是系統(tǒng)管理員
4.public Vector getRightConf()//配置權(quán)限
5.public Vector getRightMode()//模塊權(quán)限
6.public Vector getRightFlow()//流程權(quán)限
7.public String getConfValue(String type)//取得配置數(shù)字
8.public boolean isRightMode(String mode,String button)//是否有操作button對(duì)模塊mode的權(quán)限
9.public boolean isRightFlow(String flow)//是否有操作流程flow的權(quán)限
//公文權(quán)限
10.public Vector getRightConfidential()機(jī)要權(quán)限
11.public boolean isRightConfidential()判斷當(dāng)前是否有該權(quán)限
12.public boolean isRightSecretary()文書權(quán)限
13.public Vector getRightDuty()職務(wù)權(quán)限
14.public Vector getRightArchives()檔案權(quán)限
15.public Vector getRightPeriodical()期刊權(quán)限
//版面管理權(quán)限
16.public Vector getBMBHS()//當(dāng)前職工所在的部門編號(hào)（包括被分配職務(wù)后得到的職務(wù)部門編號(hào)） 柳美\
17.public boolean isRightOrg(String lbid)//部門新聞操作權(quán)限(根據(jù)orgmenu.id判斷)(uid,orgid)
18.public boolean isRightPage(String dxbh,String whichtable,String sf,String cz)//版面權(quán)限
19. //*取得模塊權(quán)限------------lbh-----------11-29
//public String getRightModelbh()
20. //是否有模塊操作權(quán)限------------lbh-----------11-29
//public boolean isRightModelbh(String strmkmc,String strbtnmc)
History:
***********************************************************/
package oa.bean;
import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;
public class RightBean extends ParentBean
{
String uid = "-1";//人員編號(hào)
String Orgid = "-1";//部門編號(hào)
public void setUID(String uid)//設(shè)置人員編號(hào)
{
this.uid = uid.trim();
}
public void setOrgid(String Orgid)//設(shè)置部門編號(hào)
{
this.Orgid = Orgid.trim();
}
/**判斷是否是系統(tǒng)管理員*/
public boolean isAdmin()
{
String name = toName("ZZ_ZGB","ZGBH","ZGBH",uid).toLowerCase();
if(name.equals("1"))return true;
else return false;
}
/**配置權(quán)限*/
public Vector getRightConf()
{
Vector vect = new Vector();
String right = "";
ResultSet rs = selectRecord("select PZCS from news.ZZ_ZGB where ZGBH='"+uid+"'");
Statement stmt = null;
try{
if(rs.next())
{
right = ds.toString(rs.getString("PZCS"));
}
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("RightBean.getRightConf()關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("RightBean.getRightConf()關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
//if(right.equals(""))//當(dāng)當(dāng)前人員表為空時(shí)，查詢職務(wù)表權(quán)限集合
{
rs = selectRecord("select PZCS from news.ZZ_ZWB where (BMBH,ZWBH) in (select BMBH,ZWBH from ZZ_ZGZWB where ZGBH='"+uid+"')");
if(rs.next())
{
if(!right.equals(""))right+=",";
right = ds.toString(rs.getString("PZCS"));
}
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("RightBean.getRightConf()關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("RightBean.getRightConf()關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
if(right.equals(""))//當(dāng)職務(wù)表集合為空時(shí)
{
stmt = rs.getStatement(); rs.close(); stmt.close();
rs = selectRecord("select PZSZ from news.CODE_XTPZ order by PZBH");
while(rs.next())
{
vect.add(ds.toString(rs.getString(1)));
}
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("RightBean.getRightConf()關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("RightBean.getRightConf()關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
else
{
String str[] = ds.splitStr(right,',');
for(int i=0;i<str.length;i++)
{
vect.add(str[i]);
}
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
return vect;
}
public String getConfValue(String type)//取得配置數(shù)字
{
String confvalue = "";
Vector vect = getRightConf();
int pzbh = toID("CODE_XTPZ","PZMC","PZBH",type.trim());
if(vect.size()>=pzbh&&pzbh>0)
confvalue = (String)vect.get(pzbh-1);
return confvalue;
}
/**模塊權(quán)限*/
public Vector getRightMode()
{
Vector vect = new Vector();
String sql = "select BMBH,ZWBH,CZQX from news.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)+"%')";
}
String right = "";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
while(rs.next())//取得職務(wù)表權(quán)限
{
String czqx = ds.toString(rs.getString("CZQX"));
String bmbh = ds.toString(rs.getString("BMBH"));
String zwbh = ds.toString(rs.getString("ZWBH"));
if(czqx.equals(""))//當(dāng)職務(wù)表中權(quán)限為空時(shí)，去部門職務(wù)表權(quán)限
{
sql = "select CZQX from news.ZZ_ZWB where BMBH='"+bmbh+"' and ZWBH="+zwbh+" and ZWZT=0";
ResultSet rs_t = selectRecord(sql);
try{
rs_t.next();
czqx = ds.toString(rs_t.getString("CZQX"));
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs_t!=null)try{ stmt = rs_t.getStatement(); rs_t.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
}
if(!right.equals("")&&!czqx.equals(""))
right += ",";
if(!czqx.equals(""))
right += czqx;
}
//if(right.equals(""))//當(dāng)職務(wù)權(quán)限集合為空時(shí)查詢字典
//{
stmt = rs.getStatement(); rs.close();stmt.close();
rs = selectRecord("select ID from news.CODE_ANCZQXB where MRCZ=1 and SYZT=0");
while(rs.next())
{
vect.add(rs.getString(1));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
//}
//else
//{
String str[] = ds.splitStr(right,',');
for(int i=0;i<str.length;i++)
{
vect.add(str[i]);
}
//}
return vect;
}
/**流程權(quán)限*/
public Vector getRightFlow()
{
Vector vect = new Vector();
String sql = "select BMBH,ZWBH,LCQX from news.ZZ_ZGZWB where ZGBH='"+uid+"'";
if(!Orgid.equals("-1"))sql += " and BMBH='"+Orgid+"'";
String right = "";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
while(rs.next())//取得職務(wù)表權(quán)限
{
String czqx = ds.toString(rs.getString("LCQX"));
String bmbh = ds.toString(rs.getString("BMBH"));
String zwbh = ds.toString(rs.getString("ZWBH"));
if(czqx.equals(""))//當(dāng)職務(wù)表中權(quán)限為空時(shí)，去部門職務(wù)表權(quán)限
{
sql = "select LCQX from news.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("LCQX"));
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs_t!=null)try{ stmt = rs_t.getStatement(); rs_t.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
}
if(!right.equals("")&&!czqx.equals(""))
right += ",";
if(!czqx.equals(""))
right += czqx;
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
if(right.equals(""))//當(dāng)職務(wù)權(quán)限集合為空時(shí)查詢字典
{
rs = selectRecord("select MKBH from news.CODE_LCQXB where MRCZ=1 and SYZT=0");
try{
while(rs.next())
{
vect.add(rs.getString(1));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
}
else
{
String str[] = ds.splitStr(right,',');
for(int i=0;i<str.length;i++)
{
vect.add(str[i]);
}
}
return vect;
}
/**是否有操作button對(duì)模塊mode的權(quán)限*/
public boolean isRightMode(String mode,String button)
{
boolean bool = false;
ResultSet rs = selectRecord("select ID from news.CODE_ANCZQXB where MKMC='"+ds.toString(mode)+"' and ANMC='"+ds.toString(button)+"'");
String mkbh = "";
Statement stmt = null;
try{
if(rs.next())
{
mkbh = ds.toString(rs.getString("ID"));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
Vector vect = getRightMode();
int index = vect.indexOf(mkbh);
if(index!=-1)bool = true;
return bool;
}
public boolean isRightFlow(String flow)//是否有操作流程flow的權(quán)限
{
boolean bool = false;
ResultSet rs = selectRecord("select MKBH from news.CODE_LCQXB where MKMC='"+ds.toString(flow)+"'");
String mkbh = "";
Statement stmt = null;
try{
if(rs.next())
{
mkbh = ds.toString(rs.getString("MKBH"));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
Vector vect = getRightFlow();
int index = vect.indexOf(mkbh);
if(index!=-1)bool = true;
return bool;
}
/**機(jī)要權(quán)限*/
public Vector getRightConfidential()
{
Vector vect = new Vector();
ResultSet rs = selectRecord("select CKQX from news.ZZ_BMB where BMBH ='"+Orgid+"'");
String right = "";
Statement stmt = null;
try{
if(rs.next())
right = rs.getString("CKQX");
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
String str[] = ds.splitStr(right,',');
for(int i=0;i<str.length;i++)
{
vect.add(toName("ZZ_ZGB","ZGBH","XM",str[i]));
}
return vect;
}
/*判斷當(dāng)前是否有該權(quán)限*/
public boolean isRightConfidential()
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -