readerruleprocess.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 ReaderRuleProcess {

	public ReaderRuleProcess() {
		// TODO 自动生成构造函数存根
	}
	public Vector ReaderRulePro(String ZJH)
	{
		Vector v=new Vector();
		PreparedStatement ps=null;
		ResultSet rs=null;
		Hashtable ht=null;
		DBBase db=new DBBase();
		Connection conn=db.getConnection();
		
		String sql="select RuleID,GZMC,KJYSJ,KJYGCDID,KXJSJ,KXJCS,KYYSJ from KJB2_KJXX_Rule where RuleID=(select RuleID from KJB2_KJXX_Reader where ZJH=?)";
		try {
			ps=conn.prepareStatement(sql);
			ps.setString(1,ZJH);
			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();
		}
		db.closeDB(conn);
		System.out.println(v.size());
		return v;
	}

}