📄 persondutybean.java

📁 “JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。注意： 1. 本书中的案例提供的数据库环境不同
💻 JAVA
📖 第 1 页 / 共 3 页
字号:
12 3 下一页
/**********************************************************
Copyright (C),2003-10-18, Beijing  USTB.
All rights reserved.
Filename: PersonDutyBean.java
Author: 
Version 1.0
Date:2003-10-18
Description:职工职务表ZZ_ZGZWB的Bean
Other:
Variable List:
2.String PersonNo="";//职工编号
3.String DutyOrgNo="";//职务部门编号
4.String DutyNo="";//职务编号

Function List:
1.public PersonDutyBean()//构造函数
	
..public void setDutyOrgNo(String DutyOrgNo)//设置部门编号
..public void setPersonNo(String PersonNo)//设置职工编号

2.public String getOrgName(String strOrgNo)//通过部门编号得到部门名称
3.public String getPersonName(String strPersonNo)//通过职工编号得到职工姓名	
..public String getBMMC_ZWMC(String strPersonNo)//通过职工编号得到ZZ_ZGZWB的BMMC_ZWMC记录	
..public String getBMMC(String strPersonNo)//通过职工编号得到ZZ_ZGZWB的所有BMMC记录	
..public Vector getData(String strPersonNo)//通过职工编号得到ZZ_ZGZWB的所有记录	

4.public String getDutyNo(String strDutyName)//通过职务名称得到职务编号
..public String getDutyName(String strDutyNo)//通过职务编号得到职务名称
	

5.public boolean hasRect(String personno,String dutyOrgno,String dutyno)//判断ZZ_ZGZWB中是否已经由此条记录

6.public void addRec(String personno,String dutyOrgno,String dutyno,String czqx,String lcqx)//增加一条职工职务纪录
7.public void delRec(String personno,String dutyOrgno,Strng dutyno)//删除一条职工职务纪录

8.public void modZZ_ZWB(String dutyOrgno,String dutyno,String personno,int i)
							//修改职务表ZZ_ZWB的职务状态i:0:增加记录时设为正常；1：删除记录时可能为挂起可能为正常
9.public void modZZ_ZGB(String personno,String dutyno,int i)
							//修改职工表ZZ_ZGB的在职状态i:0:增加记录时设为正常；1：删除记录时可能为离职可能为正常

10.public Vector getPowerLimit(String dutyOrgno,String dutyno)
							//通过部门编号、职务编号得到ZZ_ZWB的职务操作权限,职务流程权限,职务配置参数	
11.public void setPowerLimit(String personno,Vector vect,int i)
							//通过职工编号修改ZZ_ZGB的操作权限,流程权限,配置参数i:0:增加职务时；1：删除职务时

12.public int hasPerson(String orgName,String personno,String personname)//判断ZZ_ZGB中是否有输入的部门名称、职工编号、职工姓名的对应纪录
13.public int hasOrgDuty(String orgName,String dutyName)//判断ZZ_ZWB是否有输入的部门名称、职务名称的对应纪录
14.public vect srchPersons(String bmbh,String zwbh)//取得当前职务的使用人:bmmc\xm
15.public String srchPersons1(String bmbh,String zwbh)//取得当前职务的使用人串:bmmc\xm

History:
1.  Date:2003-10-18
    Author:
    Modification:文件头、架子
2.  Date:2003-10-19
    Author:
    Modification:函数体
3.  Date:2003-10-29
    Author:
    Modification:函数getBMMC_ZWMC
4.  Date:2003-11-15
    Author:
    Modification:函数setDutyOrgNo(String DutyOrgNo)，setPersonNo(String PersonNo),getDutyNo(String strDutyName),public Vector getData(String strPersonNo),getDutyName(String strDutyno)


	public Vector getDutyRight(String PersonNo,String DutyOrgNo,String DutyNo)
			//取得当前人,部门,职务下的操作权限(String)vect.get(0)和流程权限(String)vect.get(1).
	public void modRec(String personno,String dutyOrgno,String dutyno,String czqx,String lcqx)//修改一条职工职务纪录
5.  Date:2003-10-19
    Author:
    Modification:public vect srchPersons(String bmbh,String zwbh)//取得当前职务的使用人:bmmc\xm
		
***********************************************************/
package oa.bean;

import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;
//import javax.swing.tree.DefaultMutableTreeNode;

public class PersonDutyBean extends ParentBean
{
	String PersonNo="";//职工编号
    String DutyOrgNo="";//职务部门编号
    String DutyNo="";//职务编号

	//构造函数
	public PersonDutyBean() 
	{
	}
	//设置部门编号
	public void setDutyOrgNo(String DutyOrgNo)
	{
		this.DutyOrgNo = DutyOrgNo;
	}
	//设置职工编号
	public void setPersonNo(String PersonNo)
	{
		this.PersonNo = PersonNo;
	}

	//通过部门编号得到部门名称
	public String getOrgName(String strOrgNo)
	{
		return toName("ZZ_BMB","BMBH","BMMC",strOrgNo);
	}

	public Vector getBMMC(String strPersonNo)//通过职工编号得到ZZ_ZGZWB的所有BMMC记录	
	{
		Vector vt = new Vector();
		String sql = "";
		String bmbh = "";
		String bmName = "";

		sql = "select BMBH from ZZ_ZGZWB where ZGBH='"+strPersonNo+"' order by BMBH";
		ResultSet rs = selectRecord(sql);
		ResultSet rst = null;
		Statement stmt = null;
		try{
		while(rs.next())
		{	
			String bmbh1 = ds.toString(rs.getString("BMBH"));
			if(bmbh1.equals(bmbh))
			{
				continue;
			}
			else
			{
				bmbh = bmbh1;
				sql = "select BMMC from ZZ_BMB where BMBH='"+bmbh+"'";
				rst = selectRecord(sql);
				try{
					if(rst.next()){
						bmName = ds.toString(rst.getString("BMMC"));
						Hashtable ht = new Hashtable();
						ht.put("BMBH",bmbh);
						ht.put("BMMC",bmName);
						vt.add(ht);	
					}
				}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);}		
				}
			}
		}
		}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 vt;
	}

	//通过职工编号得到职工姓名
	public String getPersonName(String strPersonNo)
	{
		return toName("ZZ_ZGB","ZGBH","XM",strPersonNo);
	}

	//通过职工编号得到ZZ_ZGZWB的BMMC_ZWMC记录
	public String getBMMC_ZWMC(String strPersonNo)
	{
		String sql = " select a.BMBH,b.zwmc,b.zwzt from ZZ_ZGZWB a,zz_zwb b where a.ZGBH='"+strPersonNo+"' and a.bmbh=b.bmbh and a.zwbh=b.zwbh ";
		ResultSet rs = selectRecord(sql);
		String bmName="",zwName="",mixName="",dutyzt="";
		Statement stmt = null;
		DutyBean dutybn = null;
		PersonBean psbn = null;
		try{
		while(rs.next())
		{	
			String bmbh = ds.toString(rs.getString("BMBH"));						
			bmName = getName(bmbh);
			zwName = ds.toString(rs.getString("ZWMC"));		
			dutyzt = ds.toString(rs.getString("ZWZT"));	
			if (dutyzt.equals("1"))
			{
				dutyzt = "(挂起)";
			}
			else
				dutyzt = "";

			if(!mixName.equals(""))
				mixName += "\n"+bmName+":"+zwName+dutyzt;
			if(mixName.equals(""))
				mixName = bmName+":"+zwName+dutyzt;
		}
		if(mixName.equals("")){
			dutybn = new DutyBean();
			psbn = new PersonBean();
			psbn.setPersonNO(strPersonNo);	 
			String BMBH = psbn.getBMBH();	
			String zwNo = dutybn.getOrdinaryZWBH(BMBH,"一般员工");
			if(zwNo.equals("")){
				Hashtable dutyhash = new Hashtable();
				dutyhash.put("BMBH",BMBH);
				dutyhash.put("ZWMC","一般员工");
				dutyhash.put("CZQX","");
				dutyhash.put("LCQX","");
				dutyhash.put("PZCS","");
				dutyhash.put("JBXH","");
				dutyhash.put("ZWZT","0");
				dutybn.addDuty(dutyhash);
				zwNo = dutybn.getOrdinaryZWBH(BMBH,"一般员工");
			}
			addRec(strPersonNo,BMBH,zwNo,"","");
			mixName = getBMMC_ZWMC(strPersonNo);
		}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(psbn!=null) psbn.closeConn();
			if(dutybn!=null)dutybn.closeConn();
			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 mixName;
		/*String sql ="select BMBH,ZWBH from ZZ_ZGZWB where ZGBH='"+strPersonNo+"'";					
		ResultSet rs = selectRecord(sql);
		ResultSet rst = null;
		String bmName="",zwName="",mixName="";
		Statement stmt = null;
		DutyBean dutybn = null;
		PersonBean psbn = null;
		try{
		while(rs.next())
		{	
			String bmbh = ds.toString(rs.getString("BMBH"));
			String zwbh = ds.toString(rs.getString("ZWBH"));
			if(!bmbh.equals(""))
			{
				//sql = "select BMMC from ZZ_BMB where BMBH='"+bmbh+"'";
				//rst = selectRecord(sql);
				//rst.next();
				bmName = getName(bmbh);//ds.toString(rst.getString("BMMC"));
				if(!zwbh.equals(""))
				{
					sql = "select ZWMC from ZZ_ZWB where BMBH='"+bmbh+"' and ZWBH='"+zwbh+"'";
					rst = selectRecord(sql);
					try{
						if(rst.next())
						zwName = ds.toString(rst.getString("ZWMC"));
					}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);}		
					}
				}
			}
			if(!mixName.equals(""))
				mixName += "\n"+bmName+":"+zwName;
			if(mixName.equals(""))
				mixName = bmName+":"+zwName;
		}
		if(mixName.equals("")){
			dutybn = new DutyBean();
			psbn = new PersonBean();
			psbn.setPersonNO(strPersonNo);	 
			String BMBH = psbn.getBMBH();	
			String zwNo = dutybn.getOrdinaryZWBH(BMBH,"一般员工");
			if(zwNo.equals("")){
				Hashtable dutyhash = new Hashtable();
				dutyhash.put("BMBH",BMBH);
				dutyhash.put("ZWMC","一般员工");
				dutyhash.put("CZQX","");
				dutyhash.put("LCQX","");
				dutyhash.put("PZCS","");
				dutyhash.put("JBXH","");
				dutyhash.put("ZWZT","0");
				dutybn.addDuty(dutyhash);
				zwNo = dutybn.getOrdinaryZWBH(BMBH,"一般员工");
			}
			addRec(strPersonNo,BMBH,zwNo,"","");
			mixName = getBMMC_ZWMC(strPersonNo);
		}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(psbn!=null) psbn.closeConn();
			if(dutybn!=null)dutybn.closeConn();
			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 mixName;*/
	}
	public Vector getData(String strPersonNo)//通过职工编号得到ZZ_ZGZWB的所有记录
	{
		Vector vt = new Vector();
		String sql ="select BMBH,ZWBH from ZZ_ZGZWB where ZGBH='"+strPersonNo+"'";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		DutyBean dutybn = null;
		PersonBean psbn = null;
		try{
		while(rs.next())
		{	
			String bmbh = ds.toString(rs.getString("BMBH"));
			String zwbh = ds.toString(rs.getString("ZWBH"));
			Hashtable ht = new Hashtable();
			ht.put("BMBH",bmbh);
			ht.put("ZWBH",zwbh);
			vt.add(ht);
		}
		if(vt.size()==0){
			dutybn = new DutyBean();
			psbn = new PersonBean();
			psbn.setPersonNO(strPersonNo);
			String BMBH = psbn.getBMBH();
			String zwNo = dutybn.getOrdinaryZWBH(BMBH,"一般员工");
			if(zwNo.equals("")){
				Hashtable dutyhash = new Hashtable();
				dutyhash.put("BMBH",BMBH);
				dutyhash.put("ZWMC","一般员工");
				dutyhash.put("CZQX","");
				dutyhash.put("LCQX","");
				dutyhash.put("PZCS","");
				dutyhash.put("JBXH","");
				dutyhash.put("ZWZT","0");
				dutybn.addDuty(dutyhash);
				zwNo = dutybn.getOrdinaryZWBH(BMBH,"一般员工");
			}
			addRec(strPersonNo,BMBH,zwNo,"","");
			vt = getData(strPersonNo);
		}
		}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(psbn!=null) psbn.closeConn();
			if(dutybn!=null)dutybn.closeConn();
		}
		return vt;
	}

	//通过职务名称得到职务编号
	public String getDutyNo(String strDutyName)
	{
		String dutyno = "";
		String sql = "select ZWBH from ZZ_ZWB where trim(ZWMC)='"+strDutyName+"' and BMBH='"+DutyOrgNo+"'";

		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		while(rs.next())
			dutyno = ds.toString(rs.getString("ZWBH"));
		}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 dutyno;
	}

	//通过职务编号得到职务名称
	public String getDutyName(String strDutyNo)
	{
		String dutyname = "";
		String sql = "select ZWMC from ZZ_ZWB where ZWBH='"+strDutyNo+"' and BMBH='"+DutyOrgNo+"'";
		ResultSet rs = selectRecord(sql);
12 3 下一页
💿 文件大小 28909 K
👤 上传用户 moxcki
📂 所属分类 Java编程
🏷️ 相关标签

#JSP #数据库 #案例 #导航
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -