emp_message.java

好的超市管理系统 下来看看啊 请大家多提意见啊！~

package SuperMarket;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.Vector;

import javabean.OracleBean;
import javabean.SplitPager;

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

public class Emp_Message extends HttpServlet {
	public void doGet(HttpServletRequest req, HttpServletResponse res)
	throws ServletException, IOException {
		OracleBean ob = new OracleBean();
	     
	      int pageSize = 4;
		  int page;
		 
		  String sql= "SELECT emptable.emp_id,ename,MAX(S_NUM*S_PRICE),MIN(S_NUM*S_PRICE),AVG(SUM(S_NUM*S_PRICE)),SUM(S_NUM*S_PRICE),DEPTNO FROM EMPTABLE,SALES WHERE EMPTABLE.EMP_ID=SALES.EMP_ID group by MIN(S_NUM*S_PRICE)";
		  
		  System.out.print(sql);
		  
		  String ipage = req.getParameter("ipage");
       
		  
		  SplitPager sp = new SplitPager();
		  
		  
		 
          ResultSet rs = ob.query(sql);
		  
		  sp.initialize(rs, pageSize);
		    
		  
		  if(req.getParameter("ipage")==null||req.getParameter("ipage").equals("")){
		  page = 1;
		  }
		  else{
		  page =Integer.parseInt(req.getParameter("ipage"));
		  
		  System.out.println(page+"1111");
		  }
		  
		  
		  if(page<1)page = 1;
		  
		  if(page>sp.getTotalPages())page = sp.getTotalPages();
		  
		  Vector vector = sp.getPage(rs, page);
		  
		  System.out.println("111111111111111111111111");
		  System.out.println(vector);
		  HttpSession	session = req.getSession();
		  
		  session.setAttribute("page", page+"");
		  
		  session.setAttribute("vector", vector);
		  
		  session.setAttribute("totalpage", sp.getTotalPages()+"");
		  System.out.println("22222222222222222222");
		  
		  getServletConfig().getServletContext().getRequestDispatcher(
				"/emp_Message.jsp").forward(req, res);
		  
		  
	}
  
	public void doPost(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		doGet(req,res);
			  
     }

		
	}