querybookprocess.java

简单的图书馆管理系统

package com.common.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 com.common.DBParent.DBBase;

public class QueryBookProcess {

	public QueryBookProcess() {
		super();
		// TODO 自动生成构造函数存根
	}
	public Vector getBookByName(String arg,String bookName)
	{
		DBBase db=new DBBase();
		Vector v=new Vector();
		Hashtable hs=null;
		Connection con=db.getConnection();
		String sql="select BookClassID,Title,Author,ISBN,CBFXX,ZTXX,DTZRZ,ZRZ,ZGTSFLFLH,LTZT,FZX,CBSJ,DJ,PCJE from KJB2_KJXX_BOOK where "+arg+" like ?";
		PreparedStatement ps;
		try {
			ps = con.prepareStatement(sql);
			ps.setString(1,"%"+bookName+"%");
			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);
//				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.closeDB(con);
		return v;	
	}
	
	//以图书id查找
	public Hashtable getBookByID(int bookClassID)
	{
		DBBase db=new DBBase();
		Hashtable hs=new Hashtable();
		Connection con=db.getConnection();
		String sql="select BookClassID,Title,Author,ISBN,CBFXX,ZTXX,DTZRZ,ZRZ,ZGTSFLFLH,KTTSFLFLH,LTZT,FZX,CBSJ,DJ,PCJE from KJB2_KJXX_BOOK where BookClassID=?";
		PreparedStatement ps;
		try {
			ps = con.prepareStatement(sql);
			ps.setInt(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));
				}
//				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.closeDB(con);
		return hs;	
	}
	
	//根据图书ID查找图书的藏馆信息
	public Hashtable getBookInfo(int bookID)
	{
		Hashtable hs=new Hashtable();
		DBBase db=new DBBase();
		Connection con=db.getConnection();
		String sql="select KJB2_KJXX_Store.SQH,KJB2_KJXX_Store.TMH,KJB2_KJXX_StorePlace.MC,KJB2_KJXX_Store.ZT from KJB2_KJXX_Store,KJB2_KJXX_StorePlace where KJB2_KJXX_Store.BookID=? and KJB2_KJXX_StorePlace.StoreID=KJB2_KJXX_Store.StoreID";
		try {
			PreparedStatement ps=con.prepareStatement(sql);
			ps.setInt(1,bookID);
			ResultSet rs=ps.executeQuery();
			while(rs.next())
			{
				hs.put("SQH",rs.getObject(1));
				hs.put("TMH",rs.getObject(2));
				hs.put("MC",rs.getObject(3));
				hs.put("ZT",rs.getObject(4));
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(con);
		return hs;
		
	}
	public static void main(String[] args) {
		//QueryBookProcess qbp=new QueryBookProcess();
	
		//Vector vv=qbp.getBookByName("Title","java");
//		Vector v=qbp.getBookByID(1);
//		for(int i=0;i<v.size();i++)
//		{
//			System.out.println(((Hashtable)v.get(i)).get("Author"));
//		}
	}

}