Question

eclipse java 数据库mysql 连接问题

import java.sql.*;

public class ggg {
public static void main(String[] args) {
String username = "root";
String password = "860702";
String url = "jdbc:mysql://localhost:3306/test";

try {
String driver = "com.mysql.jdbc.driver";
Class.forName(driver);
Connection cn = DriverManager.getConnection(url, username,
password);
} catch (ClassNotFoundException cnfex) {
System.out.println("装载JDBC/ODBC 驱动程序失败");
cnfex.printStackTrace();
} catch (SQLException sqlex) {
System.out.println("无法联接数据库");
sqlex.printStackTrace();
} catch (Exception ex) {
System.out.println("NoClassDefException");
ex.printStackTrace();
}
}
}

装载JDBC/ODBC 驱动程序失败
java.lang.ClassNotFoundException: com.mysql.jdbc.driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
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.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at ggg.main(ggg.java:11)
JDBC安装了..具体配置不知到是不是正确的,,,,,...
那个高人会的话配置截图发给我把!谢谢高分!!!
e-mail:jcj1986@163.com
QQ:93062670

Answer 1

com.mysql.jdbc.driver
这个出错了，不知道你的jar包放进去没有？
如果没有的话点项目名：->properties->Java build path->Libraries->add External jars->选择你的jdbc驱动程序
然后将 String driver = "com.mysql.jdbc.driver"; 改为String driver = "com.mysql.jdbc.Driver";

Answer 2

很明显，你的String driver是错误的，好好搞清楚

Answer 3

jar包呢？？

Answer 4

这个应该是String driver = "com.mysql.jdbc.driver"; 错了

改成com.mysql.jdbc.Driver

Answer 5

com.mysql.jdbc.Driver

Answer 6

哎哟,拜托,你程序里写的又不是odbc形式的连接,配odbc又有什么用呢?你需要把mysql的驱动库文件加到你开发环境的classpath中,晓得了吗?