mainpage.java

还是超市系统

package main;

import oracle.OracleBean;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class MainPage extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
	  throws ServletException,IOException{
	  	
	  	OracleBean ob = new OracleBean();
	  	ResultSet rs = null;
	  	String dept_id = request.getParameter("id");
	  	
	  	HttpSession session = request.getSession();
	  	
	  	try{
	  			String sql = "select * from table_dept where dept_id ="+dept_id;
	  			rs = ob.query(sql);
	  		
	  			session.setAttribute("rs",rs);
	  		}catch(Exception e){
	  			e.printStackTrace();
	  			}
	  		getServletConfig().getServletContext().getRequestDispatcher("/supermaket/checkpage.jsp").forward(request,response);
	  	}
	  	
	  public void doPost(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			doGet(req,res);
		}
	  	
	
}