JAVA-数据库之更新记录

相关资料：
《21天学通Java Web开发》

更新记录

StatementUpdate.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 updateuser="update usertable set password = 'ztjcs' where name = 'ztj'";
24       stmt.executeUpdate(updateuser);
25       out.println("更新用户信息成功！");
26       }catch(SQLException e){
27         out.println("更新用户信息失败");
28       }
29   %>
30 </body>
31 </html>

View Code