JAVA-数据库之删除记录
相关资料：
《21天学通Java Web开发》
删除记录
Statementdelete.jsp
1 <%@ page language="java" contentType="text/html; charset=gb2312" %>
2 <%@ page import="java.sql.*"%>
3 <html>
4 <head>
5 <title>删除用户记录</title>
6 </head>
7 <body>
8 <%
9 String url = "jdbc:mysql://localhost:3306/java";
10 String user = "root";
11 String password = "zhujq";
12 Connection conn = null;
13 try{
14 Class.forName("com.mysql.jdbc.Driver");//加载JDBC驱动程序
15 conn= DriverManager.getConnection(url, user, password);
16 }catch(ClassNotFoundException e){
17 out.println("找不到驱动类");
18 }catch(SQLException e){
19 out.println("连接SQL数据库失败");
20 }
21 try{
22 Statement stmt = conn.createStatement();
23 String deleteuser="delete from usertable where id=1";
24 stmt.executeUpdate(deleteuser);
25 out.println("删除用户信息成功！");
26 }catch(SQLException e){
27 out.println("删除用户信息失败");
28 }
29 %>
30 </body>
31 </html>
请发表评论