springboot項目中使用原生jdbc連接MySQL資料庫

第一步：pom.xml中添加依賴；

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>

第二步：編寫連接類

package com.example.demo.controller;
import java.lang.*;
import java.sql.*;
public class JDBCDemo {
public static void main(String[] args) throws SQLException, ClassNotFoundException {
// Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://127.0.0.1:3306/mysql?serverTimezone=GMT%2B8";
// String url = "jdbc:mysql://127.0.0.1:3306/mysql";
Connection con = DriverManager.getConnection(url, "root", "123");
Statement statement = con.createStatement();
ResultSet resultSet = statement.executeQuery("select * from db");
while(resultSet.next()){
System.out.println(resultSet.getString(1));
}
}
}

執行結果：

註：問題記錄

1.資料庫密碼錯誤會報錯「Exception in thread "main" java.sql.SQLException: Access denied for user "root"@"localhost" (using password: YES)」

2.url中未加參數『serverTimezone=GMT%2B8』，會報下面的錯誤；

3.mysql驅動，使用

"com.mysql.jdbc.Driver"

會報如下警告：

Loading class `com.mysql.jdbc.Driver". This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver". The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

換成

"com.mysql.cj.jdbc.Driver"

即可

喜歡這篇文章嗎？立刻分享出去讓更多人知道吧！