package com.tsinghua.servlet;

import java.io.IOException;
import java.io.PrintWriter;
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.tsinghua.bean.pageBean;
import com.tsinghua.DAO.*;

public class look_Servlet extends HttpServlet {

	/**
	 * 此Servlet是用來實現 察看學生信息的
	 * 
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException 
	{
		request.setCharacterEncoding("gbk");
		response.setContentType("text/html;charset=gbk");
		
		DAO dao = new DAO();
		pageBean page = new pageBean();
		String sql = "select count(*) from stu_info";
              //	  設置  總的條數
		int totalRows=(int) dao.getTotalRows(sql) ;
		page.setTotalRows(totalRows);
		
		int perPage = page.getPerPageRows();
		
		 //   設置 總頁數
		int allPages ;
		
		if(totalRows%5==0)
		{
			allPages =(int) (totalRows/perPage); 
		}
		else
			allPages=(int) (totalRows/perPage+1);
		page.setAllPages(allPages);
		
		//設置當前頁數
		String per= request.getParameter("nowPage");
		if(per==null)
		{
			int i = 1;
			page.setNowPage(i);
		}
		else
		page.setNowPage( Integer.parseInt(per));
		
		List results;
		
		results = dao.getInfo(page);
		page.setResult(results);
		request.setAttribute("pageBean",page);
		
		request.getRequestDispatcher("/look.jsp").forward(request, response);
	}
}