borrowbookprocess.java

简单的图书馆管理系统

package com.common.DBaccess;

import java.sql.Connection;
import java.sql.Date;
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 BorrowBookProcess
{
	public BorrowBookProcess()
	{
		
	}
	//按照 借阅时间的起始日期和终止日期 查询
	public Vector getQueryDate(String date1,String date2,String ZJH)
	{
		DBBase db=new DBBase();
		Vector v=new Vector();
		Hashtable hs=null;
		//调用 -  连接数据库
		Connection conn=db.getConnection();
		String sql="select JYID,ReaderID,BookID,JYSJ,DQSJ,GHRQ,ZT,XJCS from KJB2_KJXX_JYB where JYSJ between ? and ? and ReaderID=(select ReaderID from KJB2_KJXX_Reader where ZJH=?)";
		PreparedStatement ps;
		try
		{
			ps=conn.prepareStatement(sql);
			ps.setDate(1,Date.valueOf(date1));
			ps.setDate(2,Date.valueOf(date2));
			ps.setString(3,ZJH);
			ResultSet rs=ps.executeQuery();
			while(rs.next())
			{
				hs=new Hashtable();
				ResultSetMetaData rsmd=ps.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 Auto-generated catch block
			e.printStackTrace();
		}
		db.closeDB(conn);
		return v;
	}
	
	public static void main(String[] args)
	{
		// TODO Auto-generated method stub
		BorrowBookProcess b=new BorrowBookProcess();
		Vector v=b.getQueryDate("1982-01-01","2007-01-01","002");
		System.out.println(v);
		Hashtable hs=(Hashtable)v.get(0);
		System.out.println(hs);
	}

}