Java Database Connectivity——JDBC连接MySQL数据库执行DML语句

/*
 * 	注册驱动的第一种方式
 */
import java.sql.*;

public class JDBCTest003 {
	public static void main(String[] args) {
		
		Connection conn = null;
		Statement stmt = null;
		
		try {
			//1、注册驱动
			DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
			//2、创建连接
			String url = "jdbc:mysql://localhost:3306/db_ymy?serverTimezone=UTC";
			String user = "test";
			String password = "333";
			conn = DriverManager.getConnection(url, user, password);
			//3、创建sql操作对象
			stmt = conn.createStatement();
			//4、执行sql语句
			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{
			//1、注册驱动
			Class.forName("com.mysql.cj.jdbc.Driver");
			//2、获取连接
			String url = "jdbc:mysql://localhost:3306/db_ymy?serverTimezone=UTC";
			String user = "test";
			String password = "333";
			conn = DriverManager.getConnection(url, user, password);
			//3、创建sql操作对象
			stmt = conn.createStatement();
			//4、执行sql
			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();
			}
		}
	}
}