学习做了一下入门程序,一个很简单的程序,写的时候是没有出现什么问题,但是编译的时候就老是出错,以下是我出现的问题和解决方法。
一开始的程序如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
public class ConnMySql {
public static void main(String[] args) throws Exception{
Class.forName("com.mysql.jdbc.Driver");
try {
String url="jdbc:mysql://localhost:3306/SAMPLEDB";
String username="";//此处是我的mysql用户
String passwd="";//此处是mysql用户的登陆密码
Connection conn=DriverManager.getConnection(url,username,passwd);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from monkeys");
while(rs.next()) {
int id=rs.getInt("id");
String name=rs.getString("name");
int age=rs.getInt("age");
System.out.println("id:"+id+"\nname:"+name+",age:"+age);
}
}finally {System.out.println("lalalala");}
}
}
以下是出现的错误:
一
Wed May 23 21:52:21 CST 2018 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.
lalalalaException in thread "main" java.sql.SQLException: The server time zone value '???ú