eclipse连接mysql有关问题
eclipse连接mysql问题
package mypackage;
import java.sql.*;
public class DataConnection {
/**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成方法存根
String driver = "com.mysql.jdbc.Driver ";
String url = "jdbc:MySQL://localhost/mydatabase ";
String user = "root ";
String password = "123 ";
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 = (ResultSet) prestatement.executeQuery( query );
while(result.next())
{
System.out.println(result.getString( "name "));
}
}catch(SQLException e)
{
e.getMessage();
}catch(ClassNotFoundException e)
{
e.getMessage();
}
}
}
院程序代码如上,从网上当了个MYSQL驱动mysql-connector-java-5.0.5-bin,工程的java build path的libraries中,但是程序执行到Class.forName( driver );抛出异常,Source not found(driver (non registeringdriver)).请求高手救助!
------解决方案--------------------
你下载的mysql connector是jar包吗?
------解决方案--------------------
找不到驱动程序
你顺着com.com.mysql.jdbc.Driver目录看看对不对
再试试 org.gjt.mm.mysql.Driver
------解决方案--------------------
驱动是mysql.jar老大 你下错包了
------解决方案--------------------
学习
------解决方案--------------------
楼主只要把mysql-connector-java-5.0.5-bin.jar放在eclipse目录下的plugins里面就可以了.eclipse开启的时候会去这里面加载的!我就是这样用的.没有什么错误发生!
------解决方案--------------------
下的是正确的 我以前下的也是这个 你要把那个JAR import到eclipse里面去
------解决方案--------------------
eclispe 是需要把包import 进去的.
package mypackage;
import java.sql.*;
public class DataConnection {
/**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成方法存根
String driver = "com.mysql.jdbc.Driver ";
String url = "jdbc:MySQL://localhost/mydatabase ";
String user = "root ";
String password = "123 ";
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 = (ResultSet) prestatement.executeQuery( query );
while(result.next())
{
System.out.println(result.getString( "name "));
}
}catch(SQLException e)
{
e.getMessage();
}catch(ClassNotFoundException e)
{
e.getMessage();
}
}
}
院程序代码如上,从网上当了个MYSQL驱动mysql-connector-java-5.0.5-bin,工程的java build path的libraries中,但是程序执行到Class.forName( driver );抛出异常,Source not found(driver (non registeringdriver)).请求高手救助!
------解决方案--------------------
你下载的mysql connector是jar包吗?
------解决方案--------------------
找不到驱动程序
你顺着com.com.mysql.jdbc.Driver目录看看对不对
再试试 org.gjt.mm.mysql.Driver
------解决方案--------------------
驱动是mysql.jar老大 你下错包了
------解决方案--------------------
学习
------解决方案--------------------
楼主只要把mysql-connector-java-5.0.5-bin.jar放在eclipse目录下的plugins里面就可以了.eclipse开启的时候会去这里面加载的!我就是这样用的.没有什么错误发生!
------解决方案--------------------
下的是正确的 我以前下的也是这个 你要把那个JAR import到eclipse里面去
------解决方案--------------------
eclispe 是需要把包import 进去的.