import java.sql.*;
public class JDBCTest003 {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try {
DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
String url = "jdbc:mysql://localhost:3306/db_ymy?serverTimezone=UTC";
String user = "test";
String password = "333";
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
String sql = "update t_user set username = 'aa' where id = 11";
stmt.executeUpdate(sql);
}catch(SQLException e) {
e.printStackTrace();
}finally {
try{
stmt.close();
}catch(SQLException e) {
e.printStackTrace();
}
try{
conn.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}
}
import java.sql.*;
public class JDBCTest004 {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try{
Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/db_ymy?serverTimezone=UTC";
String user = "test";
String password = "333";
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
String sql = "update t_user set username = 'bb' where id = 11";
stmt.executeUpdate(sql);
}catch(ClassNotFoundException e) {
e.printStackTrace();
}catch(SQLException e) {
e.printStackTrace();
}finally {
try{
stmt.close();
}catch(SQLException e) {
e.printStackTrace();
}
try{
conn.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}
}