java代码083

code083.java

1package pack02;
2
3import java.io.IOException;
4import java.sql.Connection;
5import java.sql.DriverManager;
6import java.sql.PreparedStatement;
7
8import javax.servlet.ServletException;
9import javax.servlet.annotation.WebServlet;
10import javax.servlet.http.HttpServlet;
11import javax.servlet.http.HttpServletRequest;
12import javax.servlet.http.HttpServletResponse;
13
14//DeleteServlet�࣬��code080.jsp������ã�ɾ�����ݿ�����
15@WebServlet(name="code083",urlPatterns = "/page04/pack02.code083")
16public class code083 extends HttpServlet
17{
18	@Override
19	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
20	{
21		int id = Integer.valueOf(request.getParameter("id"));
22		try
23		{
24			Class.forName("com.mysql.jdbc.Driver");
25			String url = "jdbc:mysql://localhost:3306/test";
26			String user = "root";
27			String pwd = "mysql123";
28			Connection conn = DriverManager.getConnection(url,user,pwd);
29			
30			String sql = "delete from tb_books where id=?";
31			PreparedStatement stmt = conn.prepareStatement(sql);
32			stmt.setInt(1, id);
33			stmt.executeUpdate();
34			stmt.close();
35			conn.close();
36		} catch (Exception e)
37		{
38			e.printStackTrace();
39		}
40		
41		response.sendRedirect("pack02.code079"); //ɾ����Ϻ󣬵���Findservlet�࣬��ʾ���ݿ�����
42	}
43}
44