exceedarrearageprocess.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 ExceedArrearageProcess {

	public ExceedArrearageProcess() {
		super();
		// TODO 自动生成构造函数存根
	}
    public Vector getCQQK(String ZJH)
    {
    	Vector v=new Vector();
 	    Hashtable ht=null;
        DBBase db=new DBBase();
        Connection con=db.getConnection();
        String str="select CFID,ReaderID,BookID,CFYY,CFJG,FKJE,ZT from KJB2_KJXX_CFB where ReaderID=(select ReaderID from KJB2_KJXX_Reader where ZJH=?) and ZT=?";
        PreparedStatement ps;
        try {
 		ps=con.prepareStatement(str);
 		ps.setString(1,ZJH);
 		ps.setString(2,"n");
 		ResultSet rs=ps.executeQuery();
 		ResultSetMetaData rsmd=rs.getMetaData();
 		while(rs.next())
 		{
 			ht=new Hashtable();
 		    for(int i=0;i<rsmd.getColumnCount();i++)
 		    {
 		    	ht.put(rsmd.getColumnName(i+1),rs.getObject(i+1));
 		    	
 		    }
 		    v.add(ht);
 		}
 	} catch (SQLException e) {
 		// TODO 自动生成 catch 块
 		e.printStackTrace();
 	}
 	return v;
 	}
    

}