bookdao.java

此压缩文件解压后为eclipse的一个工程需要导入使用

package com.monitor.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import com.monitor.bean.BookBean;

public class BookDao {
	public ArrayList<BookBean> getAllBooks(String strsql) throws ClassNotFoundException, SQLException{
		MyConn conn=new MyConn();
		ResultSet rs=conn.executeAllQuery(strsql);
		ArrayList<BookBean> books=new ArrayList<BookBean>();
		while(rs.next()){
			BookBean book=new BookBean();
			book.setBookid(rs.getInt(1));
			book.setBookname(rs.getString(2));
			book.setBookprice(rs.getFloat(3));
			books.add(book);
		}
		return books;
	}
	public BookBean getSingleBook(String strsql0) throws ClassNotFoundException, SQLException{
		BookBean book=this.getAllBooks(strsql0).get(0);
		return book;
	}
}