eclipse中使用mysql连接失败_eclipse 连接mysql，显示连接失败！为什么呀？高手指教！...

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassconnsql{/***@paramargs*/pu...

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class connsql {

/**

* @param args

*/

public static void main(String[] args) {

// TODO Auto-generated method stub

Connection conn=null;

Statement sm=null;

ResultSet result=null;

String drive="com.mysql.jdbc.Driver";

String url="jdbc:mysql://localhost:3306/test";

//String user="root";

//String password="";

try

{

Class.forName(drive);

conn=DriverManager.getConnection(url,"root","");

sm=conn.createStatement();

System.out.println("连接成功");

String str="select id,name,price from table1";

result=sm.executeQuery(str);

while(result.next()){

System.out.println(result.getString("id")+"_"+result.getString("name")+"_"+result.getString("price"));

}

}

catch(Exception e)

{

System.out.println("连接失败");

e.printStackTrace();

}

finally

{

if(result!=null){

try{

result.close();

}catch(SQLException e){}

result=null;}

if(sm!=null){

try{

sm.close();

}catch(SQLException e){}

sm=null;}

if(conn!=null){

try{

conn.close();

}catch(SQLException e){}

conn=null;}

}

}

}

连接失败

java.lang.ClassNotFoundException: com.mysql.jdbc.Driverat 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 connsql.main(connsql.java:25)

错误信息？！

展开