moviedao.java

jsp中数据查询并带翻页的实现,只是一个例子,做参考.

package com.mali.dao;
import java.util.*;
import java.sql.*;

import com.mali.beans.*;

public class MovieDAO {
	public MovieDAO(){}
	DBHelper dh = new DBHelper();
	public ArrayList getOnePageMovie(int page){
		ArrayList list = new ArrayList();
		String sql = "select * from movieTbl where id between "+((page*4)-3)+" and "+page*4;
		ResultSet rs = dh.executeQuery(sql);
		try {
			while(rs.next()){
				Movie movie = new Movie(rs.getString(1),rs.getString(2));
				list.add(movie);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			dh.closeCon();
		}
		return list;
	}
	public int getMovieCount(){
		int res = 0;
		String sql = "select count(*) from movieTbl";
		ResultSet rs = dh.executeQuery(sql);
		try {
			rs.next();
			res = rs.getInt(1);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			dh.closeCon();
		}
		return res;
	}
}