連接不上數(shù)據(jù)庫(kù)啊。。大神幫忙看看
package?jdbc_imooc; import?java.sql.Connection; import?java.sql.DriverManager; import?java.sql.ResultSet; import?java.sql.Statement; public?class?DBUtil?{ ???? ????private?static?final?String?URL="jdbd:mysql://localhost:3306/imooc"; ????private?static?final?String?NAME="root"; ????private?static?final?String?PASSWORD="789456"; ???? ????public?static?void?main(String[]?args)?throws?Exception{ ????????//1.加載驅(qū)動(dòng)程序 ????????Class.forName("com.mysql.jdbc.Dirver"); ????????//2.獲得數(shù)據(jù)庫(kù)的連接 ????????Connection?conn=DriverManager.getConnection(URL,NAME,PASSWORD); ????????//3.操縱數(shù)據(jù)庫(kù) ????????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")); ????????} ????} }
代碼就完全是按照老師的敲的,環(huán)境變量也加載了啊 可總是拋異常
Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Dirver
?? ?at java.net.URLClassLoader.findClass(Unknown Source)
?? ?at java.lang.ClassLoader.loadClass(Unknown Source)
?? ?at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
?? ?at java.lang.ClassLoader.loadClass(Unknown Source)
?? ?at java.lang.Class.forName0(Native Method)
?? ?at java.lang.Class.forName(Unknown Source)
?? ?at jdbc_imooc.DBUtil.main(DBUtil.java:17)
2016-07-29
?這句Class.forName("com.mysql.jdbc.Dirver");Driver拼錯(cuò)了
2016-08-02
請(qǐng)問(wèn)問(wèn)題出在哪
2016-07-29
在java項(xiàng)目中,只需要引入mysql-connector-java-xxx-bin.jar就可以運(yùn)行java項(xiàng)目。
在web項(xiàng)目中,當(dāng)Class.forName("om.mysql.jdbc.Driver");時(shí)myeclipse是不會(huì)去查找字符串,不會(huì)去查找驅(qū)動(dòng)的。所以只需要把mysql-connector-java-xxx-bin.jar拷貝到tomcat下lib目錄就可以了。
2016-07-28
項(xiàng)目運(yùn)行時(shí)沒(méi)有找到mysql-connector-java-bin.jar包