Version:
Mysql-connector-java-6.0.2-bin.jar
mysql:5.7.11
Importcom.mysql.cj.api.jdbc.Statement; Public classTest { Public Static voidMain (string[] args) {Try{class.forname ("Com.mysql.cj.jdbc.Driver"). newinstance (); Connection Conn=NULL; String urlstring= "jdbc:mysql://localhost:3306/javademo?user=root&password=123" + "&characterencoding=utf8" + "&USESSL=TRUE&SERVERTIMEZONE=UTC"; Conn=drivermanager.getconnection (urlstring); Statement Sat=(Statement) conn.createstatement (); String SQL= "SELECT * FROM Student"; ResultSet result=sat.executequery (SQL); intNumcol =result.getmetadata (). getColumnCount (); while(Result.next ()) { for(inti = 1; I <= Numcol; i++) {System.out.println (result.getstring (i)); } } } Catch(Exception ex) {ex.printstacktrace (); } }}
Update:
1.class.forname ("com.mysqlCJ. Jdbc. Driver"). newinstance ();
2. "&USESSL=TRUE&SERVERTIMEZONE=UTC" must be dropped
2016-7-8 JDBC for Mysql