readerbean.java

利用JavaBean和JSP实现学校图书馆管理系统。分5个模块：图书查询、借阅管理、图书管理、借阅证管理和读者规则管理。

/**********************************************************
Copyright (C),2003-12-9, Beijing  USTB.
All rights reserved.
Filename: ReaderBean.java
Author: 
Version 1.0
Date:2004-8
Description:读者（借阅证管理）--列表查询、单条信息查询、增加记录、修改记录、删除记录
Other:
Variable List:
1.String strReaderID = "-1";//读者ｉｄ
2.String strZJH = "-1";//证件号

***********************************************************/
package kjb2.library.bean;

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

public class ReaderBean extends ParentBean
{

	String strReaderID = "-1";//读者ｉｄ
	String strZJH = "-1";//证件号

	//设置馆ID
	public void setReaderID(String i)
	{
		strReaderID = i;
	}

	public void SetZJH(String i)
	{
		strZJH = i;
	}

	//取得所有信息内容
	public Vector getData() 
	{
		String sql = "";
		sql = " select * from KJB2_KJXX_Reader order by BZRQ,ZJH";
		return searchData(sql);
	}
	
	//根据读者id得到其信息
	public Hashtable getOneData(String id)
	{
		String sql="";
		sql = " select * from KJB2_KJXX_Reader where READERID = "+id+" order by BZRQ";
		return searchOneData(sql);
	}


    public Vector getAllRule()   
	{
		Vector vect = new Vector();
		String sql="";
		sql = "select * from KJB2_KJXX_Rule ";
		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;
	}

//由规则id得到规则名称
	public String getRuleName(String ruleid)
	{
		String name="";
		String sql="";
		sql = "select GZMC from KJB2_KJXX_Rule where RULEID  ="+ruleid+"";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		//取得列数和列名
			if (rs.next())
			{	
				name= ds.toString(rs.getString("GZMC"));	
				return name;
			}
			
		}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 name;
	}


    public String getReaderName(String id)
	{
		String name="";
		String sql="";
		sql = "select XM from ZZ_ZGB where ZGBH in ( select GH from KJB2_KJXX_Reader where ReaderID = "+id+")";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		//取得列数和列名
		ResultSetMetaData rsmd = rs.getMetaData();
		int cols = rsmd.getColumnCount();
			if (rs.next())
			{	
				name= ds.toString(rs.getString("XM"));	
				return name;
			}
			
		}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 name;
	}

    //分页取得所有信息内容
	public Vector getPageData(int page) 
	{
		String sql = "";
		int records = 20;
		sql ="select * from KJB2_KJXX_Reader order by ZJH";
		return getOnePage(sql,page,records);
	}

	// 得到库中所有参数为str的字符串组合";"		
	public String getAllstr(String str)
	{
		String sql="";
		String STR="";
		sql="select  "+str+" from  KJB2_KJXX_Reader";
		Vector vect =(Vector)searchData(sql);
		int n=vect.size();
		for(int i=0;i<n;i++)
		{
			Hashtable hash=(Hashtable)vect.get(i);
			String oneStr = ds.toString((String)hash.get(str));
			if(STR.equals(""))
				STR=oneStr;
			else
				STR+=";"+oneStr;
		}
			
		return STR;
	}

	//新增库 在数据库中添加一条记录，在注册之后借阅证可以使用
	public int addReader(Hashtable hash)
	{
		int intReaderID = makeID("KJB2_KJXX_READER","READERID","","",true);///产生唯一的编号
		System.out.println("intReaderID is "+intReaderID);
		String strZJH = ds.toString((String)hash.get("ZJH"));
		String strGH = ds.toString((String)hash.get("GH"));
		String strBZRQ= ds.toString((String)hash.get("BZRQ"));
		String strSXRQ= ds.toString((String)hash.get("SXRQ"));
		String strGQRQ= ds.toString((String)hash.get("GQRQ"));
		String strYJ= ds.toString((String)hash.get("YJ"));
		String strSXF= ds.toString((String)hash.get("SXF"));
		String strLJJS= ds.toString((String)hash.get("LJJS"));
		String strRuleID= ds.toString((String)hash.get("RULEID"));
		String strZT= ds.toString((String)hash.get("ZT"));


		Vector vect = new Vector();
		vect.add("KJB2_KJXX_READER");
		vect.add(addVector("READERID",String.valueOf(intReaderID),"NUM"));
		vect.add(addVector("ZJH",strZJH,"CHAR"));
		vect.add(addVector("GH",strGH,"CHAR"));
		vect.add(addVector("BZRQ",strBZRQ,"CHAR"));
		vect.add(addVector("SXRQ",strSXRQ,"CHAR"));
		vect.add(addVector("GQRQ",strGQRQ,"CHAR"));
		vect.add(addVector("YJ",strYJ,"CHAR"));
		vect.add(addVector("SXF",strSXF,"CHAR"));
		vect.add(addVector("LJJS",strLJJS,"NUM"));
		vect.add(addVector("RULEID",strRuleID,"NUM"));
		vect.add(addVector("ZT",strZT,"CHAR"));
		int m=insertRecord(vect);
		System.out.println(vect);
		return m;
	}


	//修改库信息
	public int modReader(Hashtable hash)
	{
		String strReaderID = ds.toString((String)hash.get("READERID"));
		String strZJH = ds.toString((String)hash.get("ZJH"));
		String strGH = ds.toString((String)hash.get("GH"));
		String strBZRQ= ds.toString((String)hash.get("BZRQ"));
		String strSXRQ= ds.toString((String)hash.get("SXRQ"));
		String strGQRQ= ds.toString((String)hash.get("GQRQ"));
		String strYJ= ds.toString((String)hash.get("YJ"));
		String strSXF= ds.toString((String)hash.get("SXF"));
		String strLJJS= ds.toString((String)hash.get("LJJS"));
		String strRuleID= ds.toString((String)hash.get("RULEID"));
		String strZT= ds.toString((String)hash.get("ZT"));

		Vector vect = new Vector();

		vect.add("KJB2_KJXX_Reader");
		vect.add(addVector("ZJH",strZJH,"CHAR"));
		vect.add(addVector("GH",strGH,"CHAR"));
		vect.add(addVector("BZRQ",strBZRQ,"CHAR"));
		vect.add(addVector("SXRQ",strSXRQ,"CHAR"));
		vect.add(addVector("GQRQ",strGQRQ,"CHAR"));
		vect.add(addVector("YJ",strYJ,"CHAR"));
		vect.add(addVector("SXF",strSXF,"CHAR"));
		vect.add(addVector("LJJS",strLJJS,"NUM"));
		vect.add(addVector("RULEID",strRuleID,"NUM"));
		vect.add(addVector("ZT",strZT,"CHAR"));
		vect.add("READERID = "+strReaderID);

		System.out.println(vect);
		return updateRecord(vect);
	}


	//删除库信息
	public int delReader(String id)
	{
		String sql="";
		sql="delete from KJB2_KJXX_Reader where READERID="+id;
		return deleteRecord(sql);
	}



	//查找所有的统一函数
	private Vector searchData(String sql) 
	{
		Vector vect = new Vector();
		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;	
	}

	//查找一条记录统一函数
	private Hashtable searchOneData(String sql) 
	{
		Hashtable hash = new Hashtable();
		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;
	}	

}