MySql连接java以及异常解决

MySQL版本：8.0.16

JDK：1.8.0_181

---

1、Mysql安装并连接java

Mysql安装参考：https://www.cnblogs.com/reyinever/p/8551977.html

 

package TestDemo;
import java.sql.*;

public class MysqlTest {

	public static void main(String[] args) throws SQLException {
	    try {
                //1.驱动加载
                Class.forName("com.mysql.cj.jdbc.Driver");
                //2.连接到数据库上去
                Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/demotest?serverTimezone=UTC", "root", "123");
                //3.构建SQL命令
                Statement state=conn.createStatement();
                String s="insert into user values('1','gao','1234')";
                state.executeUpdate(s);
		}catch(Exception e){
                    e.printStackTrace();
            }
	}
}

---

2、出现的连接问题描述：

2.1、运行时出现“Could not create connection to database server”或者“Communications link failure”问题

方案

• 检查用户名密码等
• 修改timeout
• 检查mysql与jar包版本一致不一致

jar包官方下载地址：jdbc驱动下载地址

• 检查表名是否正确

2.2、出现“The server time zone value 'XXXX' is unrecognized or represents more than one time zone.”问题

• url改为“jdbc:mysql://localhost:3306/demotest?serverTimezone=UTC”

2.3、出现警告

出现“WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 

• 已经提示解决办法（加粗部分）：将url改为“jdbc:mysql://localhost:3306/demotest?useSSL=true”或者“jdbc:mysql://localhost:3306/demotest?useSSL=false”

 

注意：

• 加载驱动名称变化：com.mysql.cj.jdbc.Driver
• url端口号后面的是自己的数据库名，如：“jdbc:mysql://localhost:3306/YourDatabaseName?serverTimezone=UTC”