注册 登录
编程论坛 MySQL论坛

[求助]ecplipse中连mysql问题

tigershi10 发布于 2007-05-28 13:14, 2062 次点击

package mypackage;

import java.sql.*;

public class DataConnection
{
public static void main(String[] args)
{
String driver = "com.mysql.jdbc.driver";
String url = "jdbc:mysql://localhost/mydatabase";
String user="root";
String password="tiger";
try
{
Class.forName(driver);
Connection con= DriverManager.getConnection(url, user, password);
String insert ="insert friends(id,name) values (?,?)";
PreparedStatement prestatement=con.prepareStatement(insert);
String[] names={"liu","qian","shi","xu","zhou","lu"};
for(int i=0;i<6;i++)
{
prestatement.setInt(1, i);
prestatement.setString(2, names[i]);
prestatement.execute();
}
String query="select * from friends";
ResultSet result=(ResultSet) prestatement.executeQuery(query);
while(result.next())
{
System.out.println(result.getString("name"));
}
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException e)
{
e.printStackTrace();
}

}

}
这是我的程序
已经加载了mysql-connector-java-5.0.6-bin.jar和mysql-connector-java-5.0.6-bin-g.jar包
但总是出现
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 mypackage.DataConnection.main(DataConnection.java:16)
这个错误
明明驱动我已经加载了
mysql我用的是5.0
我在网上搜了几天,都没有解决这个问题
大家帮帮我吧

6 回复
#2
tigershi102007-05-28 17:22

有人会吗?
教教我哦

#3
hedawn2007-07-05 10:03
在项目里面加入对应的MySql的连接驱动包了吗?我也不懂,你试一下。
#4
fengxfu2007-07-28 22:36

晕!~~
看你的驱动名写对了没???
com.mysql.jdbc.Driver

#5
evollock2007-08-29 11:50
com.mysql.jdbc.driver
这个应该是Driver吧...
#6
静思2007-08-29 18:01
com.mysql.jdbc.driver应该写成com.mysql.jdbc.Driver
JAVA是区分大小写的
还有你的驱动包是不是包含进来啦,把Mysql的驱动包以外部jar的形似添加进来


#7
ConZhang2007-09-03 14:17
1