package frist;

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

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class comi {
?? ?private static final String URL="jdbc:mysql://127.0.0.1:3306/imooc";
?? ?private static final String USER="root";
?? ?private static final String PASSWORD="root";
?? ?public static void main(String[] arges) throws Exception{
?? ??? ?//加載驅(qū)動(dòng)
?? ??? ?Class.forName("com.mysql.jdbc.Driver");
?? ??? ?//連接數(shù)據(jù)庫(kù)
?? ??? ?java.sql.Connection conn=DriverManager.getConnection(URL,USER,PASSWORD);
?? ??? ?//操作數(shù)據(jù)庫(kù)
?? ??? ?java.sql.Statement stmt=conn.createStatement();
?? ??? ?ResultSet rs=stmt.executeQuery("select username,age from imooc_goddeess");
?? ??? ?
?? ??? ?while(rs.next()){
?? ??? ??? ?System.out.println(rs.getString("username")+","+rs.getInt("age"));
?? ??? ?}
?? ?}
}
Exception in thread "main" com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'imooc.imooc_goddeess' doesn't exist
?? ?at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
?? ?at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
?? ?at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
?? ?at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
?? ?at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
?? ?at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
?? ?at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232)
?? ?at frist.comi.main(comi.java:20)