chaxun.java

还是那个超市系统都是组员的成品

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 ChaXun 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;
	      	    int s_num = 0;
	      	    int pages;//起始页
	      	    int total_pages;//总页数
	      	    
	      	    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)DESC");//分组函数来实现
	      	    pb.getPage(rs,1);
	      	    if(request.getParameter("Page")==null||request.getParameter("Page").equals("")){
				        pages = 1;
	            	}else{
			            pages = Integer.parseInt(request.getParameter("Page"));
	         	   }
		
		        if(pages<1){
			        pages = 1;
	            	}
		
	        	total_pages = pb.getTotalRecords();
		
		        if(pages>total_pages){
		    		   pages = total_pages;
		          }
	      	    Vector vector = pb.getPage(rs,pages);
	      	    session.setAttribute("name",vector);
	      	    session.setAttribute("namea",pages+"");
	      	    session.setAttribute("nameb",total_pages+"");
	      	    getServletConfig().getServletContext().getRequestDispatcher("/hou500.jsp").forward(request,response);
	        	}catch(Exception e){
	   	 	       e.printStackTrace();
	   	 	
	   	 }
	      	 
	     }
	     public void doPost(HttpServletRequest request,HttpServletResponse response)
	          throws ServletException,IOException{
	          	  doGet(request,response);
	          }
}