Eclipse中连接MySQL的问题!
用Eclipse连接MySQL的问题。我安装了Eclipse3.2和MySQL 5.0和mysql-connector-java-5.0.4.zip。写了一个程序但是不好用:
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 = "123123";
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 = {"Rachel","Rose","Phoebe","Monica","Chandler","Joey"};
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 = prestatement.executeQuery(query);
System.out.println("The Results is:");
while (result.next())
{
System.out.println(result.getString("name"));
}
con.close();
}catch(SQLException e)
{
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
在下面显示以下问题,请教大家是什么问题?
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:17)