update.java ~~~ package zyw.crud; import java.sql.*; public class update { public static void main(String[] args) throws SQLException, ClassNotFoundException { // 1、注冊數據庫的驅動 Class.forName("com.mysql.jdbc.Driver"); // 2.獲取數據庫連接 String url="jdbc:mysql://122.14.200.136:3306/javadb"; Connection connection = DriverManager.getConnection(url, "root", "6a133f0024"); //3.獲取操作數據庫的對象 Statement statement= connection.createStatement(); // String sql = "insert into xuesheng VALUES ('xs005','zhangsna','男',20,'貴州','計算機')"; // String sql="delete from xuesheng where xuehao='xs005'"; String sql="update xuesheng set nianling=21 where xuehao='xs001'"; int result=statement.executeUpdate(sql); //4.遍歷結果集，取出數據 System.out.println("影響條數："+result); //5.關閉對象 statement.close(); connection.close(); } } ~~~