JDBC连接MySQL

最简单的分4步

1. 注册驱动
2. 打开连接
3. 进行SQL操作
4. 关闭流

Connection conn = null;
Statement stmt = null;
try {
	// 注册JDBC驱动
	Class.forName("com.mysql.cj.jdbc.Driver");
	// 打开连接，此处连接为MySQL8.0的写法
	conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/库名?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC","账号","密码");
		
	stmt = conn.createStatement();
			
	String sql = "select * from user";
			
	ResultSet rs = stmt.executeQuery(sql);
	// 展开结果集数据库
    while(rs.next()){
		// 通过字段检索
        int id  = rs.getInt("id");
    
		// 输出数据
		System.out.println("ID: " + id);
    }
	// 完成后关闭
    rs.close();
    stmt.close();
    conn.close();
} catch (Exception e) {
	// TODO: handle exception
	e.printStackTrace();
}

面试的时候让你手写的话可以更抽象点：

try{
	// 1.加载驱动
	Class.forName("com.jdbc.mysql.Driver");
	// 2.获取连接
	Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/库名","账号","密码");
	// 3.进行SQL操作
	Statement stmt = conn.createStatement();
	ResultSet rs = stmt.excuteQuery("select * from user");
	while(rs.next()){
		int id = rs.getInt("id");
		System.out.println(id);
	}
	// 4.关闭流
	rs.close();
	stmt.close();
	conn.close();
} catch(Exception e){
	
}