結(jié)果顯示不出來(lái) 這是怎么回事?是版本匹配問(wèn)題么?
我試過(guò)了不同的jdbk版本 ,3x 5x,都不行 ,環(huán)境變量也設(shè)置了,求大神指導(dǎo)!
不知道和這些有沒(méi)有關(guān)系,還是放出來(lái),這是相關(guān)程序的版本:
MYSQL -5.5.47
tomcat -7.0.63
myeclipse -10.0
jdk -1.8.0-60
問(wèn)題 :
Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.imooc.db.DBUtil.main(DBUtil.java:21)
原代碼:
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="root";
public static void main(String[] args) throws Exception {
/*
* 鏈接數(shù)據(jù)庫(kù)需要分為三個(gè)步驟
* 1.加載驅(qū)動(dòng)程序
*/
Class.forName("com.mysql.jdbc.Driver");
//2.獲取數(shù)據(jù)庫(kù)的鏈接
Connection conn=DriverManager.getConnection(URL, USER, PASSWORD);
//3.通過(guò)數(shù)據(jù)庫(kù)的鏈接操作數(shù)據(jù)庫(kù),實(shí)現(xiàn)增刪改查
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select user_name,age from imooc_goddess");
//目前數(shù)據(jù)保存在rs這個(gè)對(duì)象中,從rs這個(gè)對(duì)象中獲取數(shù)據(jù)
while(rs.next()){
System.out.println(rs.getString("user_name")+","+rs.getInt("age"));
}
}
}
2015-12-24
com.mysql.jdbc.Driver沒(méi)有導(dǎo)入成功