searchbookdb.java

本系统完成简单的图书管理系统

/***********************************************************************
*                          湖南大学图书管理系统
* @author Administrator                                                         
* @since 2008.06                                                  
* @version 1.0                                                           															  
* @category 查询图书数据库操作
*************************************************************************/

package library.DBaccess;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Hashtable;
import java.util.Vector;

import library.DBBase.JDBC;

public class SearchBookDB {

	public SearchBookDB(){
		super();
	}
	
	public Vector getBookByName(String arg,String bookName)
	{
		JDBC db=new JDBC();
		Vector v=new Vector();
		
		Connection con=db.getConnection();
		String sql="select BOOKCLASSID,TITLE,AUTHOR,CATEGORY,PRESS,PRICE,PAGINATION,ISBN,CHECTDATE,COUNT,REMARK from BOOK where "+arg+" like ?";
		PreparedStatement ps;
		try {
			ps = con.prepareStatement(sql);
			ps.setString(1,"%"+bookName+"%");
			ResultSet rs=ps.executeQuery();
			while(rs.next())
			{
				Hashtable hs=new Hashtable();
				ResultSetMetaData rsmd=rs.getMetaData();
				int numCols = rsmd.getColumnCount();
				for(int i=0;i<numCols;i++)
				{
					hs.put(rsmd.getColumnName(i+1),rs.getObject(i + 1) == null ? "" : rs.getObject(i + 1));
				}
				v.addElement(hs);
				hs=null;
//				hs.put("BookClassID",rs.getObject(1));
//				hs.put("Title",rs.getObject(2));
//				hs.put("Author",rs.getObject(3));
//				hs.put("ISBN",rs.getObject(4));
//				hs.put("CBFXX",rs.getObject(5));
//				hs.put("ZTXX",rs.getObject(6));
//				hs.put("DTZRZ",rs.getObject(7));
//				hs.put("ZRZ",rs.getObject(8));
//				hs.put("ZGTSFLFLH",rs.getObject(9));
//				hs.put("LTZT",rs.getObject(10));
//				hs.put("FZX",rs.getObject(11));
//				hs.put("CBSJ",rs.getObject(12));
//				hs.put("DJ",rs.getObject(13));
//				hs.put("PCJE",rs.getObject(14));
			
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeConnection(con);
		return v;	
	}
	
	//以图书id查找
	public Hashtable getBookByID(String bookClassID)
	{
		JDBC db=new JDBC();
		Hashtable hs=new Hashtable();
		Connection con=db.getConnection();
		String sql="select BOOKCLASSID,TITLE,AUTHOR,CATEGORY,PRESS,PRICE,PAGINATION,ISBN,CHECTDATE,COUNT,REMARK from BOOK where BOOKCLASSID=?";
		PreparedStatement ps;
		try {
			ps = con.prepareStatement(sql);
			ps.setString(1,bookClassID);
			ResultSet rs=ps.executeQuery();
			while(rs.next())
			{
				ResultSetMetaData rsmd=rs.getMetaData();
				for(int i=0;i<rsmd.getColumnCount();i++)
				{
					hs.put(rsmd.getColumnName(i+1),rs.getObject(i + 1) == null ? "" : rs.getObject(i + 1));
				}
			
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeConnection(con);
		return hs;	
	}
	
	
	//根据ISBN查找图书的藏馆信息
	public Vector getBookByISBN(String isbn)
	{
		Hashtable hs=new Hashtable();
		Vector v=new Vector();
		JDBC db=new JDBC();
		Connection con=db.getConnection();
		String sql="select BOOKCLASSID,TITLE,AUTHOR,CATEGORY,PRESS,PRICE,PAGINATION,ISBN,CHECTDATE,COUNT,REMARK from BOOK where ISBN = '"+isbn+"'";
		try {
			PreparedStatement ps=con.prepareStatement(sql);
			ResultSet rs=ps.executeQuery();
			while(rs.next())
			{
				hs=new Hashtable();
				ResultSetMetaData rsmd=rs.getMetaData();
				for(int i=0;i<rsmd.getColumnCount();i++)
				{
					hs.put(rsmd.getColumnName(i+1),rs.getObject(i+1));
				}
				v.add(hs);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeConnection(con);
		return v;
		
	}
/*	public static void main(String[] args) {
		SearchBookDB sb=new SearchBookDB();
	
		Vector vv=sb.getBookByName("TITLE","java");
		Hashtable v=sb.getBookByID(10000);
		for(int i=0;i<v.size();i++)
		{
//			System.out.println(((Hashtable)vv.get(i)).get("AUTHOR"));
			System.out.println(v.get(i));
		}
	}*/
}