写在前面
java连接Mysql8.0.11与之前版本有些不同。
最近也是踩了很多的坑,总结一下。
其中driver为com.mysql.cj.jdbc.Driver
url为jdbc:mysql://localhost/net_tableinfo?useSSL=FALSE&serverTimezone=UTC(net_tableinfo为数据库的名字)
测试代码如下
package com.dgd.test;
import java.sql.*;
/**
* @author Dgd
* @create 2017-10-16-21:25
* 测试数据库
*/
public class Test {
//mysql驱动包名
private static final String DRIVER_NAME = "com.mysql.cj.jdbc.Driver";
//数据库连接地址
private static final String URL = "jdbc:mysql://localhost/New_info?useSSL=FALSE&serverTimezone=UTC";
//用户名
private static final String USER_NAME = "root";
//密码
private static final String PASSWORD = "password";
public static void main(String[] args){
Connection connection = null;
try {
//加载mysql的驱动类
Class.forName(DRIVER_NAME);
//获取数据库连接
connection = DriverManager.getConnection(URL, USER_NAME, PASSWORD);
//mysql查询语句
String sql = "SELECT name FROM net_tableinfo";
PreparedStatement prst = connection.prepareStatement(sql);
//结果集
ResultSet rs = prst.executeQuery();
while (rs.next()) {
System.out.println("用户名:" + rs.getString("name"));
}
rs.close();
prst.close();
} catch (Exception e) {
e.printStackTrace();
}finally {
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}