deleteservlet.java

它统一管理各个应用系统用户的身份验证

package servlet;

import java.sql.*;

import java.io.*;

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

import bean.DBConnBean;
import bean.StudentBean;

public class DeleteServlet 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
       {    	    
    	   String driverName="com.mysql.jdbc.Driver";
    		String userName="root";  			//数据库用户名
    		String userPasswd="123";			//密码	
    		String dbName="student";			//数据库名
    		String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
    		
    		try  {  
    			Class.forName(driverName);  
    		}  
    		catch(java.lang.ClassNotFoundException   e)   {  
    			System.err.println(e.getMessage()+"112"); 
    		}  
    		Connection conn = DriverManager.getConnection(url);    		
    		String SQL = "delete from studentinfo where name=?";
    		PreparedStatement stmt = conn.prepareStatement(SQL);
        
            //指定参数
            stmt.setString(1,request.getParameter("name"));        
            int bool = stmt.executeUpdate();           
            //执行查询
            if( bool > 0)
            	address = "deleteResult.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);
    	     }
}