用JDBC连接MySQL数据库,简单的连接代码如下
public Connection getConnection() throws Exception{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
throw new Exception("No database");
}
return DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "test", "test");
}
执行连接时提示警告,警告如下
Sun Jan 10 11:36:32 GMT+08:00 2016 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.