searchbean.java

JSP+SQL 图书馆管理系统

package beans;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;

public class SearchBean {
	Connection con=null;
	public SearchBean(){
		con = DBConnection.getConnection();
	}
	public Collection query(String key,String type) throws Exception{
		String s = "select * from Book where "+type+"='"+key+"'";
		
			Statement st = con.createStatement();
			ResultSet rs = st.executeQuery(s);
			Collection ret = new ArrayList();
			while(rs.next()){
				Borrow b = new Borrow();
				b.setBookID(rs.getString(1));
//				b.setReaID(rs.getString(2));
				b.setBookName(rs.getString(2));
				
				b.setOutDate(rs.getDate(6));
//				b.setYHDate(rs.getDate(6));
//				b.setInDate(rs.getDate(7));
				b.setFine(rs.getString(4));
				b.setState(rs.getString(11));
				b.setRoomMID(rs.getString(12));
				ret.add(b);
			}
		return ret;
	}
}