listservlet.java

来自「JAVA Servlet2.3外文书籍源码」· Java 代码 · 共 43 行

package jsp;

import javax.servlet.ServletException;
import javax.servlet.ServletConfig;

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

import javax.sql.DataSource;
import javax.sql.RowSet;

import sun.jdbc.rowset.CachedRowSet;

public class ListServlet extends HttpServlet {

  public void init(ServletConfig config) throws ServletException {
    super.init(config);
  }
  
  public void doPost(HttpServletRequest req, HttpServletResponse res)
      throws ServletException {
    doGet(req, res);
  }

  public void doGet(HttpServletRequest req, HttpServletResponse res)
      throws ServletException {
    try {
        
        RowSet rs = new CachedRowSet();
        rs.setDataSourceName("java:comp/env/jdbc/inventoryDB");
        rs.setCommand("select * from item");
        rs.execute();            
        req.setAttribute("rs", rs);           
        
        getServletContext().getRequestDispatcher("/List.jsp").
        forward(req, res);      
    } catch(Exception ex) {
        throw new ServletException(ex);
    }  
  }
}