- 论坛徽章:
- 3
|
本帖最后由 grshrd49 于 2013-09-23 11:08 编辑
刚刚接触java 我按照<<java编程手记>>第534页的说法,下载并配置了jdbc但是运行535页的程序后就报错,报错信息因该是jdbc加载就失败了
代码- package leanrjavamysql;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- public class DatabaseDemo01 {
- public static void main(String[] args) {
- // TODO Auto-generated method stub
- Connection conn = null;
- try{
- //加载jdbc
- Class.forName("com.mysql.jdbc.Driver");
- System.out.println("jdbc load success!");
- }catch(Exception e){
- System.out.println("jdbc load false!");
-
- e.printStackTrace();
- }
- try{
- //链接数据库
- conn = DriverManager.getConnection("jdbc:mysql://10.201.2.13:3306/survey","mq-user","redhat");
- System.out.println("sqldb connect success!!");
- }catch(SQLException e){
- System.out.println("sqldb connect false!!");
- e.printStackTrace();
- }finally{
- try{
- //关闭数据库
- conn.close();
- System.out.println("sqldb close success!!");
- }catch(SQLException e){
- System.out.println("sqldb close false!!");
- e.printStackTrace();
- }
- }
- }
- }
复制代码 报错信息- jdbc load false!
- java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
- at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
- at java.security.AccessController.doPrivileged(Native Method)
- at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
- at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- at java.lang.Class.forName0(Native Method)
- at java.lang.Class.forName(Class.java:190)
- at leanrjavamysql.DatabaseDemo01.main(DatabaseDemo01.java:12)
- java.sql.SQLException: No suitable driver found for jdbc:mysql://10.201.2.13:3306/survey
- at java.sql.DriverManager.getConnection(DriverManager.java:596)
- at java.sql.DriverManager.getConnection(DriverManager.java:215)
- at leanrjavamysql.DatabaseDemo01.main(DatabaseDemo01.java:22)
- Exception in thread "main" java.lang.NullPointerException
- at leanrjavamysql.DatabaseDemo01.main(DatabaseDemo01.java:30)
- sqldb connect false!!
复制代码 环境变量classpath配置如下,最后一个就是jdbc的jar包的路径
CLASSPAHT
C:\Program Files\Java\jdk1.7.0_40\lib\dt.jar; C:\Program Files\Java\jdk1.7.0_40\lib\tools.jar; C:\Program Files\Java\jdk1.7.0_40\bin; C:\Program Files\Java\mysql\mysql-connector-java-5.1.26-bin.jar
有大神能帮我看看什么问题不?? |
|