编程论坛 » MySQL » [求助]ecplipse中连mysql问题

tigershi10 发表于 2007-5-28 13:14

[求助]ecplipse中连mysql问题

<P>package mypackage;</P>
<P>import java.sql.*;</P>
<P>public class DataConnection<BR>{<BR> public static void main(String[] args) <BR> {<BR>  String driver = "com.mysql.jdbc.driver";<BR>  String url = "jdbc:mysql://localhost/mydatabase";<BR>  String user="root";<BR>  String password="tiger";<BR>    try<BR>   {<BR>    Class.forName(driver);<BR>    Connection con= DriverManager.getConnection(url, user, password);<BR>    String insert ="insert friends(id,name) values (?,?)";<BR>    PreparedStatement prestatement=con.prepareStatement(insert);<BR>    String[] names={"liu","qian","shi","xu","zhou","lu"};<BR>    for(int i=0;i&lt;6;i++)<BR>    {<BR>     prestatement.setInt(1, i);<BR>     prestatement.setString(2, names[i]);<BR>     prestatement.execute();<BR>    }<BR>    String query="select * from friends";<BR>    ResultSet result=(ResultSet) prestatement.executeQuery(query);<BR>    while(result.next())<BR>    {<BR>     System.out.println(result.getString("name"));<BR>    }<BR>   }<BR>   catch (ClassNotFoundException e)<BR>   {   <BR>    e.printStackTrace();<BR>   }<BR>   catch (SQLException e)<BR>   {<BR>        e.printStackTrace();<BR>   }</P>
<P> }</P>
<P>}<BR>这是我的程序<BR>已经加载了mysql-connector-java-5.0.6-bin.jar和mysql-connector-java-5.0.6-bin-g.jar包<BR>但总是出现<BR>java.lang.ClassNotFoundException: com.mysql.jdbc.driver<BR> at java.net.URLClassLoader$1.run(Unknown Source)<BR> at java.security.AccessController.doPrivileged(Native Method)<BR> at java.net.URLClassLoader.findClass(Unknown Source)<BR> at java.lang.ClassLoader.loadClass(Unknown Source)<BR> at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)<BR> at java.lang.ClassLoader.loadClass(Unknown Source)<BR> at java.lang.ClassLoader.loadClassInternal(Unknown Source)<BR> at java.lang.Class.forName0(Native Method)<BR> at java.lang.Class.forName(Unknown Source)<BR> at mypackage.DataConnection.main(DataConnection.java:16)<BR>这个错误<BR>明明驱动我已经加载了<BR>mysql我用的是5.0<BR>我在网上搜了几天,都没有解决这个问题<BR>大家帮帮我吧</P>

tigershi10 发表于 2007-5-28 17:22

<P>有人会吗?<BR>教教我哦</P>

hedawn 发表于 2007-7-5 10:03

在项目里面加入对应的MySql的连接驱动包了吗？我也不懂，你试一下。

fengxfu 发表于 2007-7-28 22:36

<P>晕！～～<BR>   看你的驱动名写对了没？？？<BR>com.mysql.jdbc.Driver<BR><BR></P>

evollock 发表于 2007-8-29 11:50

com.mysql.jdbc.driver<BR>这个应该是Driver吧...

静思 发表于 2007-8-29 18:01

com.mysql.jdbc.driver应该写成com.mysql.jdbc.Driver<BR>JAVA是区分大小写的<BR>还有你的驱动包是不是包含进来啦，把Mysql的驱动包以外部jar的形似添加进来<BR><BR><BR>

ConZhang 发表于 2007-9-3 14:17

[em03][em03][em03]

查看完整版本: [求助]ecplipse中连mysql问题