Mysql8.0使用JDBC无法顺利建立连接问题
一开始的建立连接的代码为:
conn=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useSSL=flase","root","xb199795");
控制台什么也没有输出,我也是debug完才发现问题在建立连接这一行
所以我就在这一行加上了tyr-catch语句捕获异常
大概的意思就是要加上时区,然后改正后的代码如下:
conn=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useSSL=FALSE&serverTimezone=UTC","root","xb199795");
整个代码如下:
package jdbc;
public class JDBCTest {
public static void main(String[] args) {
String sql="select * from tbl_user";
Connection conn=null;
Statement st=null;
ResultSet rs=null;
try {
Class.forName("com.mysql.cj.jdbc.Driver").newInstance();
try {
conn=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useSSL=FALSE&serverTimezone=UTC","root","xb199795");
}catch(Exception e) {
e.printStackTrace();
}
st=(Statement)conn.createStatement();
rs=st.executeQuery(sql);
while(rs.next()) {
System.out.print(rs.getInt("id")+" ");
System.out.print(rs.getString("name")+" ");
System.out.print(rs.getString("password")+" ");
System.out.println(rs.getString("email")+" ");
}
} catch (Exception e) {
// TODO: handle exception
}
}
}