deletedservlet.java

java+oracle实现学生管理系统 学生信息的增删改查

package list.servlet;

import java.sql.*;

import java.io.*;

import javax.servlet.*;
import javax.servlet.http.*;

import data.DBUtil;
import bean.listbean;

public class DeletedServlet extends HttpServlet
{
    public void doGet(HttpServletRequest request,
                    HttpServletResponse response)
                    throws ServletException,IOException
    {  
       request.setCharacterEncoding("GBK");
       response.setContentType("text/html;charset=GBK");
       String address = "unknownlist.jsp";
     
       try
       {
    	    
    	    new oracle.jdbc.driver.OracleDriver();
    		String url="jdbc:oracle:thin:@localhost:1521:ora9i";
    		Connection conn = DriverManager.getConnection(url,"scott","tiger");
    		String SQL = " delete addrestlist where name=?";
    		PreparedStatement stmt = conn.prepareStatement(SQL);
        
            //指定参数
            stmt.setString(1,request.getParameter("name"));
           
            //执行查询
            stmt.executeUpdate();
            address = "havedeleted.jsp";
        
        }
        catch(SQLException e)
        {
        }
   
      
       //跳转到JSP页面
       RequestDispatcher dis = request.getRequestDispatcher(address);
       dis.forward(request,response);
    } 
    public void doPost(HttpServletRequest request,
    	     HttpServletResponse response)
    	     throws ServletException,IOException
    	     {
    		         doGet(request,response);
    	     }
}