deleteservlet.java

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

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.naming.InitialContext;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class DeleteServlet 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 {
      
    Connection con = null;
    
    try {
        
      InitialContext ctx = new InitialContext();
      DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/inventoryDB");
      
      con = ds.getConnection();
      PreparedStatement stmt = 
      con.prepareStatement("delete from item where id = ?");
      
      stmt.setInt(1, Integer.parseInt(req.getParameter("id")));
      stmt.executeUpdate();            
      stmt.close();           
      
      getServletContext().getRequestDispatcher("/List").
      forward(req, res);
        
    } catch(Exception ex) {
        throw new ServletException(ex);
    } finally {
      try {
        if(con != null) con.close();
      } catch(Exception ex) {
        throw new ServletException(ex);
      }
    }
  }
}