package test;
import java.sql.*;
import java.util.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
public class DelServlet extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, java.io.IOException {
                response.setContentType("application/html; charset=GB2312");
               	java.io.PrintWriter out = response.getWriter();
                String id=request.getParameter("key");
                 try{
                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	
		Connection con = DriverManager.getConnection("jdbc:odbc:gBook");	
                Statement stmt = con.createStatement();
                String sql="delete from data where id="+id;
                stmt.executeUpdate(sql);
                out.print("ok");
                  }
                catch(Exception e){
                    e.printStackTrace();
                 }
                
	}
}