listdept.java

还是超市系统

package listdept;

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import db.ConnOracle;

public class Listdept extends HttpServlet{
	
	public void doGet(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			req.setCharacterEncoding("GBK");
			db.ConnOracle conn = new db.ConnOracle();
			ResultSet rs = null;
		try{
			String sql = "select dept_id,dept_name from table_dept";
			rs = conn.query(sql);
			
			req.setAttribute("r",rs);
			
			
				getServletConfig().getServletContext().getRequestDispatcher("/pages/listdept.jsp").forward(req,res);
			
			}catch(Exception e){
				e.printStackTrace();
			}
	}
	public void doPost(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			doGet(req,res);
		}
}