package com.baidu.servlet;


import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.baidu.entity.User;
import com.baidu.service.ListService;
import com.sun.org.apache.regexp.internal.recompile;

public class ListServlet extends HttpServlet {

	private ListService service = new ListService();
	
	@Override
	protected void service(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String page = request.getParameter("page");
		
		if(page==null){
			page="1";
		}
		
		//用户访问的页面
		int currentPage = Integer.parseInt(page);
		
		//每页显示的条数
		int pageSize = 3;
		
		//上一页
		int prevPage = 0;
		if(currentPage==1){
			prevPage=1;
		}else{
			prevPage=currentPage-1;
		}
		
		//末页
		int count = service.getCount();
		int pageCount = count/pageSize;
		if(count % pageSize != 0){
			pageCount++;
		}
		
		
		//下一页
		int nextPage = 0;
		if(currentPage==pageCount){
			nextPage = pageCount;
		}else{
			nextPage = currentPage+1;
		}
		
		
		List list = service.getList(currentPage,pageSize);
		request.setAttribute("list", list);
		request.setAttribute("prevPage", prevPage);
		request.setAttribute("nextPage", nextPage);
		request.setAttribute("pageCount", pageCount);
		request.getRequestDispatcher("jsp/list.jsp").forward(request, response);
		
	}
	
}