bookbean.java

图书馆管理系统很有用的 相当不错 十分好用

/**********************************************************
Copyright (C),2004-8-12, Beijing  USTB.
All rights reserved.
Filename: StorePlaceBean.java
Author: 邹晨
Version 1.0
Date:2004-8-12
Description:书库管理
Other:
Variable List:

Function List:
History:

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

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

public class BookBean extends ParentBean
{
	private String id = "-1";

	//设置馆ID
	public void setID(String i)
	{
		id = i;
	}

	//取得所有信息内容
	public Vector getData(int page)
	{
		String sql = "";
		sql = " select * from KJB2_KJXX_Book";
		return getOnePage(sql,page,20);
	}
	

	public Vector getData(String sqlwhere,int page)
	{
		String sql = "";
		sql = " select * from KJB2_KJXX_Book ";
		if (!sqlwhere.equals("")) sql+=sqlwhere;
		return getOnePage(sql,page,20);
	}


	//根据某库取得此库的详细信息
	public Hashtable getOneData(String id)
	{
		String sql="";
		sql = "select * from KJB2_KJXX_Book where BookClassID="+id+"";
		return searchOneData(sql);
	}


	//新增库
	public int insert(Hashtable hash)
	{
		int intID = makeID("KJB2_KJXX_Book","BookClassID","","",true);


		Vector vect = new Vector();
		vect.add("KJB2_KJXX_Book");

		vect.add(addVector("BookClassID",String.valueOf(intID),"NUM"));
		vect.add(addVector("Title",ds.toString((String)hash.get("TITLE")),"CHAR"));
		vect.add(addVector("Author",ds.toString((String)hash.get("AUTHOR")),"CHAR"));
		vect.add(addVector("ISBN",ds.toString((String)hash.get("ISBN")),"CHAR"));
		vect.add(addVector("CBFXX",ds.toString((String)hash.get("CBFXX")),"CHAR"));
		vect.add(addVector("ZTXX",ds.toString((String)hash.get("ZTXX")),"CHAR"));
		vect.add(addVector("DTZRZ",ds.toString((String)hash.get("DTZRZ")),"CHAR"));

		vect.add(addVector("ZRZ",ds.toString((String)hash.get("ZRZ")),"CHAR"));


		vect.add(addVector("ZGTSFLFLH",ds.toString((String)hash.get("ZGTSFLFLH")),"CHAR"));
		vect.add(addVector("KTTSFLFLH",ds.toString((String)hash.get("KTTSFLFLH")),"CHAR"));
		vect.add(addVector("LTZT",ds.toString((String)hash.get("LTZT")),"CHAR"));
		vect.add(addVector("FZX",ds.toString((String)hash.get("FZX")),"CHAR"));
		vect.add(addVector("CBSJ",ds.toString((String)hash.get("CBSJ")),"CHAR"));
		vect.add(addVector("DJ",ds.toString((String)hash.get("DJ")),"CHAR"));
		vect.add(addVector("PCJE",ds.toString((String)hash.get("PCJE")),"CHAR"));

		return insertRecord(vect);
	}


	//修改库信息
	public int update(Hashtable hash)
	{

		Vector vect = new Vector();
		vect.add("KJB2_KJXX_Book");
		
		vect.add(addVector("Title",ds.toString((String)hash.get("TITLE")),"CHAR"));
		vect.add(addVector("Author",ds.toString((String)hash.get("AUTHOR")),"CHAR"));
		vect.add(addVector("ISBN",ds.toString((String)hash.get("ISBN")),"CHAR"));
		vect.add(addVector("CBFXX",ds.toString((String)hash.get("CBFXX")),"CHAR"));
		vect.add(addVector("ZTXX",ds.toString((String)hash.get("ZTXX")),"CHAR"));
		vect.add(addVector("DTZRZ",ds.toString((String)hash.get("DTZRZ")),"CHAR"));

		vect.add(addVector("ZRZ",ds.toString((String)hash.get("ZRZ")),"CHAR"));


		vect.add(addVector("ZGTSFLFLH",ds.toString((String)hash.get("ZGTSFLFLH")),"CHAR"));
		vect.add(addVector("KTTSFLFLH",ds.toString((String)hash.get("KTTSFLFLH")),"CHAR"));
		vect.add(addVector("LTZT",ds.toString((String)hash.get("LTZT")),"CHAR"));
		vect.add(addVector("FZX",ds.toString((String)hash.get("FZX")),"CHAR"));
		vect.add(addVector("CBSJ",ds.toString((String)hash.get("CBSJ")),"CHAR"));
		vect.add(addVector("DJ",ds.toString((String)hash.get("DJ")),"CHAR"));
		vect.add(addVector("PCJE",ds.toString((String)hash.get("PCJE")),"CHAR"));
		vect.add("BookClassID = "+ds.toString((String)hash.get("BOOKCLASSID")));

		return updateRecord(vect);
	}


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


	//判断某库中是否有书
	public boolean isHaveBook(String id)
	{
		String sql="";
		sql="select * from KJB2_KJXX_Book where BookClassID="+id;
		Vector vect = getDataBySql(sql);
		if(vect.isEmpty())
			return false;
		else
			return true;
	}



	//查找一条记录统一函数
	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;
	}	
}