bookdao.java

jsp/servlet/javaBean应用：网上购书系统

package dao;

import java.sql.*;
import java.util.*;
import bean.BookBean;

/**
 * 书目数据层
 * @author dell
 *
 */
public class BookDao {
	
	BaseDao dao=new BaseDao();
	
	//分页查询书目
	public  List getPage(int page){

		List titles=new ArrayList();
		Connection conn=null;
		PreparedStatement psmt=null;
		ResultSet rest=null;
		String sql=null;
		int beginRow=0;
		if(page>1){
			beginRow=9*(page-1);
		}
		try{
			conn=dao.getConn();
			sql="select top 9 * from titles where isbn not in(select top "+
			beginRow+" isbn from titles order by isbn) order by isbn";
			psmt=conn.prepareStatement(sql);
			rest=psmt.executeQuery();
			while(rest.next()){
				BookBean book=new BookBean();
				book.setIsbn(rest.getString("isbn"));
				book.setTitle(rest.getString("title"));
				book.setEditionNumber(rest.getInt("editionNumber"));
				book.setCopyright(rest.getString("copyright"));
				book.setPublisherID(rest.getInt("publisherID"));
				book.setImageFile(rest.getString("imageFile"));
				book.setPrice(rest.getDouble("price"));
				titles.add(book);
				System.out.println("11111111111111");
			}
		}catch(Exception sexS){
			sexS.printStackTrace();
			System.out.println(sexS.getMessage());
		}finally{
			dao.closeConn(conn,psmt,rest);
		}
		return titles;
	}
}