報錯：java.sql.SQLException
為什么照著老師抄代碼都會報錯……
package com.imooc.db;
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://127.0.0.1:3306/imooc";
private static final String USER="root";
private static final String PASSWORD="123";
public static void main(String[] args) throws Exception{
// TODO Auto-generated method stub
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection(URL, USER, PASSWORD);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select user_name,age from imooc_goddess");
while(rs.next()){
System.out.println(rs.getString("user_name")+","+rs.getInt("age"));
}
}
}
2018-11-01
將常量值改成這個就行了
private static final String URL = "jdbc:mysql://127.0.0.1:3306/imooc?serverTimezone=UTC";
2018-11-01
查看一下你的jar版本?mysql-connector-java-8.0.13.jar
如果是這個版本：
private static String URL = "jdbc:mysql://localhost:3306/sakila?serverTimezone=UTC";
private static String USER = "root";
private static String PASSWORD = "root";
public static void main(String[] args) throws Exception {
// 1.加載驅(qū)動程序
Class.forName("com.mysql.cj.jdbc.Driver");
// 2.獲得數(shù)據(jù)庫的連接
Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
// 3.通過數(shù)據(jù)庫的連接操作數(shù)據(jù)庫,實現(xiàn)增刪改查
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from sakila.actor;");
while (rs.next()) {
System.out.println(rs.getInt("actor_id") + ": " + rs.getString("first_name") + " " + rs.getString("last_name"));
}
}
如果不是這個版本把你eclipse中報錯的信息百度一下就行
2018-10-31
一直提示我Class.forName("com.mysql.jdbc.Driver");這句話有錯誤