peccancyprocess.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 PeccancyProcess{

	public PeccancyProcess() {
		super();
		// TODO 自动生成构造函数存根
	}
	public Vector getPeccancyIfon(String zjh)
	{
		DBBase db=new DBBase();
		Vector v=new Vector();
		Hashtable hs=null;
		Connection con=db.getConnection();
		String sql="select CFID,ReaderID,BookID,CFYY,CFJG,FKJE,ZT from KJB2_KJXX_CFB where ReaderID=(select ReaderID from KJB2_KJXX_Reader where ZJH=?)";
		PreparedStatement ps;
		try {
			ps = con.prepareStatement(sql);
			ps.setString(1,zjh);
			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.closeDB(con);
		return v;	
	}
	
	public static void main(String[] args) 
	{
		PeccancyProcess qbp=new PeccancyProcess();
	
		Vector vv=qbp.getPeccancyIfon("d");
		Vector v=qbp.getPeccancyIfon("d");
		
		System.out.println(((Hashtable)v.get(0)).get("ReaderID"));
	}

}