为了账号安全,请及时绑定邮箱和手机立即绑定

每次跑JDBC获取链接的时候都提示需要SSL设置,为什么,怎么处理?

每次跑JDBC获取链接的时候都提示需要SSL设置,为什么,怎么处理?

慕UI4723116 2016-04-06 21:31:31
import java.io.IOException;import java.io.InputStream;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;import org.apache.commons.dbcp2.BasicDataSource;import org.apache.commons.dbcp2.BasicDataSourceFactory;//import org.apache.tomcat.jdbc.pool.DataSource;import java.sql.Connection;//import com.mysql.jdbc.Connection;public class userDateLink implements userDao {    @Override    public Connection getConnection() {        // TODO Auto-generated method stub        Connection connection = null;        Properties userMailProperties = new Properties();        String jdbcUrl = null;        String name = null;        String pw = null;        String driver = null;                // this.getClass().getClassLoader().getResourceAsStream("mailuser.properties");//原来的参数返回in值为null,不知道为啥,实例调用的缘故?        InputStream in = this.getClass().getResourceAsStream("mailuser.properties");        try {            userMailProperties.load(in);            driver = userMailProperties.getProperty("driver");            jdbcUrl = userMailProperties.getProperty("jdbcUrl");            name = userMailProperties.getProperty("user");            pw = userMailProperties.getProperty("password");            Class.forName(driver);            connection = (Connection) DriverManager.getConnection(jdbcUrl, name, pw);        } catch (IOException | ClassNotFoundException | SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        return connection;    }报警:Wed Apr 06 21:23:11 CST 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.
查看完整描述

2 回答

?
zhouwh

TA贡献1条经验 获得超2个赞

URL="jdbc:mysql://127.0.0.1:3306/imooc?useSSL=false"

查看完整回答
2 反对 回复 2016-05-15
  • 2 回答
  • 0 关注
  • 11627 浏览

添加回答

举报

0/150
提交
取消
意见反馈 帮助中心 APP下载
官方微信