javaweb--分页

分页功能

实例化dao类，可以调用拿到带有模糊查询的方法，和查询总数的方法。

定义第一页和每页显示的条数。

拿到查询总数，可以得到总页数。

        调用带有模糊查询的方法  参数（第几页，每页数，模糊查询关键词）——拿到查询的内容进行一个排列。
 

DAO类

public class INewDao{
 
 
	public List<news> queryNewsAll() {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		List<news> list = new ArrayList<news>();
		try {
			conn = DBHelper.getConn();
			String sql = "select * from tb_news";
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while(rs.next()) {
				//获取分类编号rs.getInt("ntid");
				Theme theme = new ThemeDao().getThemeByTid(rs.getInt("ntid"));
				list.add(new news(rs.getInt("nid"), theme, rs.getString("ntitle"), rs.getString("nauthor"),
						rs.getString("nsummary"), rs.getString("ncontent"),
						rs.getString("nimage"), rs.getString("ndate"), rs.getInt("ncount")));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.close(conn, ps, rs);
		}
		return list;
	}
	
	
	public List<news> queryNewsAll2() {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		List<news> list = new ArrayList<news>();
		try {
			conn = DBHelper.getConn();
			String sql = "select b.* from ( select a.*,rownum as rid from tb_news a ) b where b.rid between 1 and 5";
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while(rs.next()) {
				//获取分类编号rs.getInt("ntid");
				Theme theme = new ThemeDao().getThemeByTid(rs.getInt("ntid"));
				list.add(new news(rs.getInt("nid"), theme, rs.getString("ntitle"), rs.getString("nauthor"),
						rs.getString("nsummary"), rs.getString("ncontent"),
						rs.getString("nimage"), rs.getString("ndate"), rs.get