连接数据库主要分为六个步骤:
- 加载驱动
- 建立连接
- 准备SQL语句
- 执行SQL语句
- 处理结果
- 断开连接
我举一个查询的例子:
public static Connection lianJie() throws ClassNotFoundException, SQLException {
//1.加载驱动
Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/mysql?serverTimezone=GMT%2B8";
String user = "root";
String password = "123456";
//2.建立连接
Connection connections = Dri