package JDBCsql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

import java.sql.Statement;

public class DBUTil {
?private static final String URL="jdbc:mysql://localhost:3306/imooc?characterEncoding=utf8&useSSL=false";
?private static final String USER="root";
?private static final String PASSWORD="201305";
?public static void main(String[] args) throws Exception {
??// TODO Auto-generated method stub
??? //1.加載驅(qū)動程序
??Class.forName("com.mysql.jdbc.Driver");
??//獲取數(shù)據(jù)庫的連接
??Connection conn=DriverManager.getConnection(URL,USER,PASSWORD);
??//3.通過數(shù)據(jù)庫的連接操作數(shù)據(jù)庫
??Statement stmt=conn.createStatement();
?? ResultSet rs=stmt.executeQuery("select * from imooc_goddess");
?while(rs.next())
?{
??System.out.println(rs.getString("user_name")+","+rs.getInt("age"));
??
?}
?}

錯誤解析

ed Aug 17 20:00:29 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.
Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'imooc.imooc' doesn't exist
?at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
?at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
?at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
?at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
?at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
?at com.mysql.jdbc.Util.getInstance(Util.java:387)
?at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942)
?at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
?at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
?at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
?at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
?at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
?at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
?at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)
?at JDBCsql.DBUTil.main(DBUTil.java:21)