deleteservlet.java

来自「student managment systemstudent managmen」· Java 代码 · 共 49 行

/*
 * 创建日期 2008-6-1
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import common.DataBaseConnection;
import common.NumFormat;
public class DeleteServlet extends HttpServlet
{  
	public void init(ServletConfig config) throws ServletException
    {super.init(config);
    }
   public  void  doPost(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
    {   
   		try{
   			String sno=request.getParameter("sno");
   			Connection con=DataBaseConnection.getConnection();
   			PreparedStatement prst=con.prepareStatement("delete from score where sno=?");
   			prst.setString(1,NumFormat.transInsert(sno));
	        prst.executeUpdate();	
		    con.close();
   		}catch(SQLException e){
   			e.printStackTrace();
   		}
        RequestDispatcher dispatcher= request.getRequestDispatcher("/success.jsp");
        dispatcher.forward(request, response);         
    } 
   public  void  doGet(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
    {   
   		doPost(request,response);
    }
}