package superMarket; 
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javabean.OracleBean;
import javabean.PageBean;
public class ChaXun1 extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
	      throws ServletException,IOException{
	      	try{
	      		HttpSession session = request.getSession();	
	      		response.setContentType("text/html;charset=GBK");
	      	    PrintWriter out = response.getWriter();
	      	    OracleBean conn = new OracleBean();
	      	    PageBean pb = new PageBean();
	      	 
	      	    ResultSet rs = null;
	      	    String gname = null;
	      	    String f_name = null;
	      	    int s_num = 0;
	      	    int page;//起始頁
	      	    int total_pages;//總頁數(shù)
	      	    
	      	    rs = conn.query("SELECT  SUM(s_num) s_num,gname,f_name FROM sales,goods,factory WHERE (sales.g_id=goods.g_id) AND (sales.g_id=goods.g_id) AND (sales.f_id=factory.f_id) group by gname,f_name ORDER BY SUM(s_num)ASC");//分組函數(shù)來實現(xiàn)
	      	    pb.getPage(rs,1);
	      	    if(request.getParameter("Page")==null||request.getParameter("Page").equals("")){
				        page = 1;
	            	}else{
			            page = Integer.parseInt(request.getParameter("Page"));
	         	   }
		
		        if(page<1){
			        page = 1;
	            	}
		
	        	total_pages = pb.getTotalRecords();
		
		        if(page>total_pages){
		    		   page = total_pages;
		          }
		        System.out.println(page);
	      	    Vector vector = pb.getPage(rs,page);
	      	    session.setAttribute("name",vector);
	      	    session.setAttribute("namea",page+"");
	      	    session.setAttribute("nameb",total_pages+"");
	      	    getServletConfig().getServletContext().getRequestDispatcher("/qian500.jsp").forward(request,response);
	        	}catch(Exception e){
	   	 	       e.printStackTrace();
	   	 	
	   	 }
	      	 
	     }
	     public void doPost(HttpServletRequest request,HttpServletResponse response)
	          throws ServletException,IOException{
	          	  doGet(request,response);
	          }
}