相关资料:
《21天学通Java Web开发》
删除记录
Statementdelete.jsp
1 <%@ page language="java" contentType="text/html; charset=gb2312" %> 2 <%@ page import="java.sql.*"%> 3 4 5删除用户记录 6 7 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 31