sysmanbean.java

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

/**********************************************************
Copyright (C),2003-10-17, Beijing  USTB.
All rights reserved.
Filename: SysmanBean.java
Author: 
Version 1.0
Date:2003-10-17
Description:主页－－系统管理中的列表查询、单条信息查询、增加记录、修改记录、删除记录
Other:
Variable List:
1.int type = 0;//系统管理类型
2.String id = "-1"//记录唯一编号
3.String dictname = ""//字典名称

Function List:
1.public void setType(String t)//设置系统管理类型
2.public void setID(String i)//设置记录唯一编号
3.public void setDictname(String d)//设置字典名称

4.public Vector getData()//取得数据表内容

5.public void addDict(Hashtable hash)//增加字典数据记录
6.public void addOper(Hashtable hash)//增加操作权限数据记录
..public int addOper_new(Hashtable hash)//增加按钮操作权限记录     
7.public void addFlow(Hashtable hash)//增加流程权限数据记录
8.public void addConf(Hashtable hash)//增加系统配置数据记录

9.public void modDict(Hashtable hash)//修改字典数据记录
10.public void modOper(Hashtable hash)//修改操作权限数据记录
...public void modOper_new(Hashtable hash)//修改按钮操作权限数据记录	
11.public void modFlow(Hashtable hash)//修改流程权限数据记录
12.public void modConf(Hashtable hash)//修改系统配置数据记录

13.public void delData()//删除数据记录

14.public Hashtable getOneData()//取得数据表中的某一条记录

15.public String getPZSZ(String pzmc)//得到配置数值
History:
1.
date:2003-11-19
Author:
action: 增加 按钮操作权限 部分
2.
date:2003-11-24
Author:
action: public String getPZSZ(String pzmc)//根据配置名称得到配置数值
 
***********************************************************/
package oa.bean;

import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;

public class SysmanBean extends ParentBean
{
	int type = 0;
	String id = "-1";
	String dictname = "";

	//设置系统管理类型
	public void setType(int t)
	{
		type = t;
	}

	//设置记录唯一编号
	public void setID(String i)
	{
		id = i;
	}

	//设置字典名称
	public void setDictname(String d)
	{
		dictname = d;
	}

	//修改其他按钮的模块说明
	public int modMKSM(String text_mkbh,String text_mksm)
	{
		String sql = "update CODE_ANCZQXB set MKSM='"+text_mksm+"' where MKBH="+text_mkbh;
		return db.ExecuteSQL(sql);
	}

	//取得数据表内容
	public Vector getData()
	{
		Vector vect = new Vector();
		String sql = "";

		switch (type)
		{//SYZT,
			case 1: sql = " select * from CODE_ZDB order by ZDMC,JBXH ";break;
			case 2: sql = " select * from CODE_CZQXB order by MKBH ";break;
			case 3: sql = " select * from CODE_LCQXB order by JBXH ";break;
			case 4: sql = " select * from CODE_XTPZ order by PZBH ";break;
			case 5: sql = " select * from CODE_ANCZQXB order by MKBH,ANXH ";break;
			default:break;
		}

		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			//取得列数和列名
			ResultSetMetaData rsmd = rs.getMetaData();
			int cols = rsmd.getColumnCount();
			while(rs.next())
			{	
				Hashtable hash = new Hashtable();
				for(int i=1;i<=cols;i++)
				{
					String field = ds.toString(rsmd.getColumnName(i));
					String value = ds.toString(rs.getString(i));
					hash.put(field,value);
				}
				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 Hashtable getOneData()
	{
		Hashtable hash = new Hashtable();
		String sql = "";

		switch (type)
		{
			case 1: sql = " select * from CODE_ZDB where ZDMC = '"+dictname+"' and XMBH = "+id;break;
			case 2: sql = " select * from CODE_CZQXB where MKBH = "+id;break;
			case 3: sql = " select * from CODE_LCQXB where MKBH = "+id;break;
			case 4: sql = " select * from CODE_XTPZ where PZBH = "+id;break;
			case 5: sql = " select * from CODE_ANCZQXB where ID = "+id;break;
			default:break;
		}

		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		ResultSetMetaData rsmd = rs.getMetaData();
		int cols = rsmd.getColumnCount();
		if (rs.next())
		{
			for(int i=1;i<=cols;i++)
			{
				String field = ds.toString(rsmd.getColumnName(i));
				String value = ds.toString(rs.getString(i));
				hash.put(field,value);
			}
		}
		}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 hash;
	}

	//增加字典数据记录
	public int addDict(Hashtable hash)
	{		
		String strZDMC = ds.toString((String)hash.get("ZDMC"));
		int intXMBH = db.makeID("CODE_ZDB","ZDMC","XMBH",strZDMC,false);
		String strXMMC = ds.toString((String)hash.get("XMMC"));
		String strSYZT = ds.toString((String)hash.get("SYZT"));
		String strJBXH = ds.toString((String)hash.get("JBXH"));
	
		//检验是否已经存在
		ResultSet rs = selectRecord("select * from CODE_ZDB where ZDMC='"+strZDMC+"' and XMMC='"+strXMMC+"'");
		Statement stmt = null;
		try{
			if(rs.next())
				return 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);}		
		}
/////////////////
		int maxjbNo=makeID("CODE_ZDB","ZDMC","JBXH",strZDMC,false);
		int jbxh=0;
		if(!strJBXH.equals(""))
			jbxh=Integer.parseInt(strJBXH);
		if(jbxh==0||jbxh>maxjbNo)
			{ jbxh=maxjbNo;strJBXH=""+jbxh;}
////////////////////// and SYZT=0
		String sql="update CODE_ZDB set jbxh=jbxh+1 where ZDMC='"+ strZDMC	+ "' and JBXH >=" + jbxh ;
		deleteRecord(sql);
//////////////////////
		Vector vect =new Vector();
		vect.add("CODE_ZDB");
		vect.add(addVector("ZDMC",strZDMC,"CHAR"));
		vect.add(addVector("XMBH",String.valueOf(intXMBH),"NUM"));
		vect.add(addVector("XMMC",strXMMC,"CHAR"));
		vect.add(addVector("SYZT",strSYZT,"NUM"));
		vect.add(addVector("JBXH",strJBXH,"NUM"));
		return insertRecord(vect);
	}

	//增加操作权限数据记录
	public int addOper(Hashtable hash)
	{		
		int intMKBH = db.makeID("CODE_CZQXB","MKBH","","",true);
		String strMKMC = ds.toString((String)hash.get("MKMC"));
		String strMKSM = ds.toString((String)hash.get("MKSM"));
		String strCZLX = ds.toString((String)hash.get("CZLX"));
		String strMRCZ = ds.toString((String)hash.get("MRCZ"));
		String strSYZT = ds.toString((String)hash.get("SYZT"));

		Vector vect = new Vector();
		vect.add("CODE_CZQXB");
		vect.add(addVector("MKBH",String.valueOf(intMKBH),"NUM"));
		vect.add(addVector("MKMC",strMKMC,"CHAR"));
		vect.add(addVector("MKSM",strMKSM,"CHAR"));
		vect.add(addVector("CZLX",strCZLX,"NUM"));
		vect.add(addVector("MRCZ",strMRCZ,"NUM"));
		vect.add(addVector("SYZT",strSYZT,"NUM"));

		//检验是否已经存在
		ResultSet rs = selectRecord("select * from CODE_CZQXB where MKMC='"+strMKMC+"'");
		Statement stmt = null;
		try{
		if(!rs.next())
			return insertRecord(vect);
		}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 1;
	}

	//增加按钮操作权限记录
	public int addOper_new(Hashtable hash,int ee)
	{	
//		int intanID = db.makeID("CODE_ANCZQXB","ID","","",true);
		ResultSet rs1 = selectRecord("select max(ID) from CODE_ANCZQXB");		
		int intanID = 1;
		Statement stmt = null;
		try{
		if(rs1.next())
			intanID = rs1.getInt(1)+1;//Integer.parseInt()
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		int intMKBH = -1;
		String strMKMC = ds.toString((String)hash.get("MKMC"));
		String strMKSM = ds.toString((String)hash.get("MKSM"));
		if(ee==1)
			intMKBH = Integer.parseInt(ds.toString((String)hash.get("MKBH")));
		if(ee==4){
			ResultSet rs=selectRecord("select MKBH from CODE_ANCZQXB where MKMC='" + strMKMC + "'");
			try{
				if(rs.next())
					intMKBH = rs.getInt(1);
				else
					intMKBH = db.makeID("CODE_ANCZQXB","MKBH","","",true);	
			}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);}		
			}
		}
		int intANXH = db.makeID("CODE_ANCZQXB","MKBH","ANXH",String.valueOf(intMKBH),true);
		String strANMC = ds.toString((String)hash.get("ANMC"));
		String strANSM = ds.toString((String)hash.get("ANSM"));
		String strMRCZ = ds.toString((String)hash.get("MRCZ"));
		String strSYZT = ds.toString((String)hash.get("SYZT"));

		Vector vect = new Vector();
		vect.add("CODE_ANCZQXB");
		vect.add(addVector("ID", String.valueOf(intanID),"NUM"));
		vect.add(addVector("MKBH",String.valueOf(intMKBH),"NUM"));
		vect.add(addVector("MKMC", strMKMC,"CHAR"));
		vect.add(addVector("MKSM", strMKSM,"CHAR"));
		vect.add(addVector("ANXH", String.valueOf(intANXH),"NUM"));
		vect.add(addVector("ANMC",strANMC ,"CHAR"));
		vect.add(addVector("ANSM", strANSM,"CHAR"));
		vect.add(addVector("MRCZ",strMRCZ ,"NUM"));
		vect.add(addVector("SYZT", strSYZT,"NUM"));
		ResultSet rs = selectRecord("select * from CODE_ANCZQXB where ANMC='"+strANMC+"' and MKBH="+String.valueOf(intMKBH));
		try{
			if(!rs.next()){
				insertRecord(vect);
				PublicData.rebuildButtonTable();
				PublicData.rebuildRightVector();
				return 0;
			}
		}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 1;
	}

	//增加流程权限数据记录
	public int addFlow(Hashtable hash)
	{	
		ResultSet rs = selectRecord("select max(MKBH) from CODE_LCQXB");		
		int intMKBH = 1;
		Statement stmt = null;
		try{
			if(rs.next())
				intMKBH = rs.getInt(1)+1;//Integer.parseInt()
		}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 strMKMC = ds.toString((String)hash.get("MKMC"));
		String strDYLX = ds.toString((String)hash.get("DYLX"));
		String strMKSM = ds.toString((String)hash.get("MKSM"));
		String strMRCZ = ds.toString((String)hash.get("MRCZ"));
		String strSYZT = ds.toString((String)hash.get("SYZT"));
		String strJBXH = ds.toString((String)hash.get("JBXH"));

		//检验是否已经存在
		rs = selectRecord("select * from CODE_LCQXB where MKMC='"+strMKMC+"'");
		try{
			if(rs.next())
				return 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);}		
		}
/////////////////
		int maxjbNo=makeID("CODE_LCQXB","JBXH","","",true);
		int jbxh=0;
		if(!strJBXH.equals(""))
			jbxh=Integer.parseInt(strJBXH);
		if(jbxh==0||jbxh>maxjbNo)
			{ jbxh=maxjbNo;strJBXH=""+jbxh;}
////////////////////// and SYZT=0
		String sql="update CODE_LCQXB set jbxh=jbxh+1 where JBXH >=" + jbxh;
		deleteRecord(sql);
//////////////////////
		Vector vect = new Vector();
		vect.add("CODE_LCQXB");
		vect.add(addVector("MKBH",String.valueOf(intMKBH),"NUM"));
		vect.add(addVector("MKMC",strMKMC,"CHAR"));
		vect.add(addVector("DYLX",strDYLX,"NUM"));
		vect.add(addVector("MKSM",strMKSM,"CHAR"));
		vect.add(addVector("MRCZ",strMRCZ,"NUM"));
		vect.add(addVector("SYZT",strSYZT,"NUM"));
		vect.add(addVector("JBXH",strJBXH,"NUM"));
		insertRecord(vect);

		PublicData.rebuildFlowVector();

		return 0;
	}