mysql数据库连接
- 下载
下载网址:https://dev.mysql.com/downloads/
java下载红框标的。
我是下载 ZIP文件的
- 在Java中导入jar包
在Project Structure中导入,选择 Libraries 点击 +号并选择需要导入的Module
打开快捷键 :Ctrl + Shift + Alt + S
- 出现情况
首先检查 url ,user,password有没有写错
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.jdbc.Driver 改成 com.mysql.cj.jdbc.Driver
若还是错误,尝试:
url = “jdbc:mysql://127.0.0.1:3306/student”
改成
url = “jdbc:mysql://127.0.0.1:3306/student?useUnicode=true&characterEncoding=UTF-8&userSSL=false&serverTimezone=GMT%2B8”