語(yǔ)句對(duì)象Statement包含兩個(gè)主要方法：executeUpdate()方法執(zhí)行數(shù)據(jù)的更新操作(添加記錄，刪除記錄，更新記錄)，executeQuery()方法用來(lái)執(zhí)行數(shù)據(jù)的查詢(xún)操作(查詢(xún)記錄)
添加記錄
<%@page language="java" contentType="text/html;charset=gb2312"%><%@page import="java.sql.*" %><!DOCTYPE html><html> <head> <title>添加用戶(hù)記錄</title> </head> <body> <% String url = "jdbc:mysql://localhost:3306/javaweb";//連接數(shù)據(jù)庫(kù)的url地址 String user = "root";//登錄數(shù)據(jù)庫(kù)的用戶(hù)名 String password = "zhangda890126;;";//登錄數(shù)據(jù)庫(kù)的用戶(hù)名的密碼 Connection conn = null; try{ Class.forName("com.mysql.jdbc.Driver");//加載JDBC驅(qū)動(dòng)程序 conn = DriverManager.getConnection(url,user,password);//鏈接數(shù)據(jù)庫(kù) }catch(ClassNotFoundException e){ out.println("找不到驅(qū)動(dòng)類(lèi)");//拋出異常時(shí)，提示信息 }catch(SQLException e){ out.println("鏈接MySQL數(shù)據(jù)庫(kù)失敗");//處理SQLException異常 } try{ //創(chuàng)建語(yǔ)句對(duì)象Statement Statement stmt = conn.createStatement(); String adduser = "INSERT INTO user(userid,username,password) VALUES (null,'James','1234')";//添加用戶(hù) stmt.executeUpdate(adduser);//執(zhí)行語(yǔ)句 }catch(SQLException e){ out.println("添加用戶(hù)信息失敗"); } %> </body></html><html> <head> <title>添加多個(gè)用戶(hù)記錄</title> </head> <body> <% String url = "jdbc:mysql://localhost:3306/javaweb";//連接數(shù)據(jù)庫(kù)的url地址 String user = "root";//登錄數(shù)據(jù)庫(kù)的用戶(hù)名 String password = "zhangda890126;;";//登錄數(shù)據(jù)庫(kù)的用戶(hù)名的密碼 Connection conn = null; try{ Class.forName("com.mysql.jdbc.Driver");//加載JDBC驅(qū)動(dòng)程序 conn = DriverManager.getConnection(url,user,password);//鏈接數(shù)據(jù)庫(kù) }catch(ClassNotFoundException e){ out.println("找不到驅(qū)動(dòng)類(lèi)");//拋出異常時(shí)，提示信息 }catch(SQLException e){ out.println("鏈接MySQL數(shù)據(jù)庫(kù)失敗");//處理SQLException異常 } try{ //創(chuàng)建語(yǔ)句對(duì)象Statement Statement stmt = conn.createStatement(); //刪除userid為1的用戶(hù)信息 for(int i=2;i<6;i++){ String username = "zhangda_"+i; String adduser = "INSERT INTO user (userid,username,password) VALUES (null,'"+username+"','1234')";//添加用戶(hù) stmt.executeUpdate(adduser);//執(zhí)行語(yǔ)句 } }catch(SQLException e){ out.println("添加用戶(hù)信息失敗"); } %> </body></html> 更新記錄
<%@page language="java" contentType="text/html;charset=gb2312"%><%@page import="java.sql.*" %><!DOCTYPE html><html> <head> <title>添加用戶(hù)記錄</title> </head> <body> <% String url = "jdbc:mysql://localhost:3306/javaweb";//連接數(shù)據(jù)庫(kù)的url地址 String user = "root";//登錄數(shù)據(jù)庫(kù)的用戶(hù)名 String password = "zhangda890126;;";//登錄數(shù)據(jù)庫(kù)的用戶(hù)名的密碼 Connection conn = null; try{ Class.forName("com.mysql.jdbc.Driver");//加載JDBC驅(qū)動(dòng)程序 conn = DriverManager.getConnection(url,user,password);//鏈接數(shù)據(jù)庫(kù) }catch(ClassNotFoundException e){ out.println("找不到驅(qū)動(dòng)類(lèi)");//拋出異常時(shí)，提示信息 }catch(SQLException e){ out.println("鏈接MySQL數(shù)據(jù)庫(kù)失敗");//處理SQLException異常 } try{ //創(chuàng)建語(yǔ)句對(duì)象Statement Statement stmt = conn.createStatement(); //更新userid為1的用戶(hù)信息，更新其密碼為12345 String updateuser = "UPDATE user SET password='12345' WHERE userid=1;";//添加用戶(hù) stmt.executeUpdate(updateuser);//執(zhí)行語(yǔ)句 }catch(SQLException e){ out.println("更新用戶(hù)信息失敗"); } %> </body></html> 刪除記錄
<%@page language="java" contentType="text/html;charset=gb2312"%><%@page import="java.sql.*" %><!DOCTYPE html><html> <head> <title>添加用戶(hù)記錄</title> </head> <body> <% String url = "jdbc:mysql://localhost:3306/javaweb";//連接數(shù)據(jù)庫(kù)的url地址 String user = "root";//登錄數(shù)據(jù)庫(kù)的用戶(hù)名 String password = "zhangda890126;;";//登錄數(shù)據(jù)庫(kù)的用戶(hù)名的密碼 Connection conn = null; try{ Class.forName("com.mysql.jdbc.Driver");//加載JDBC驅(qū)動(dòng)程序 conn = DriverManager.getConnection(url,user,password);//鏈接數(shù)據(jù)庫(kù) }catch(ClassNotFoundException e){ out.println("找不到驅(qū)動(dòng)類(lèi)");//拋出異常時(shí)，提示信息 }catch(SQLException e){ out.println("鏈接MySQL數(shù)據(jù)庫(kù)失敗");//處理SQLException異常 } try{ //創(chuàng)建語(yǔ)句對(duì)象Statement Statement stmt = conn.createStatement(); //刪除userid為1的用戶(hù)信息 String deleteuser = "DELETE FROM user WHERE userid=1;";//添加用戶(hù) stmt.executeUpdate(deleteuser);//執(zhí)行語(yǔ)句 }catch(SQLException e){ out.println("刪除用戶(hù)信息失敗"); } %> </body></html> 
