eclipse连接mysql数据库找不到适合的驱动

以下是找不到驱动的解决办法：一是：连接URL格式出现了问题(Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/XX","root","XXXX")二是：驱动字符串出错(com.mysql.jdbc.Driver)三是：Classpath中没有加入合适的mysql_jdbc驱动四是：将mysql-connector-java-3.1.14-bin.jar的jar包加入C:\Program Files\Java\jre1.6.0_02\lib\ext文件夹下试试

给你个例子。。我以前写的代码。

import java.sql.*

/*

* MYSQL的桥连接与直连接

*/

public class test {

public static void main(String[] args) {

try {

//MYSQL直连字符串

String driver = "org.gjt.mm.mysql.Driver"

String url = "jdbc:mysql://localhost/mysql?useUnicode=true&characterEncoding=gb2312"

//MYSQL桥连字符串

// String driver = "sun.jdbc.odbc.JdbcOdbcDriver"

// String url = "jdbc:odbc:test"

String user = "root"

String pwd = "msconfig"

Class.forName(driver)

Connection con = DriverManager.getConnection(url,user,pwd)

PreparedStatement pstmt = con.prepareStatement("select * from user")

ResultSet rs = pstmt.executeQuery()

while(rs.next()){

for (int i = 1i <= rs.getMetaData().getColumnCount()i++){

System.out.print(rs.getString(i) + "\t")

}

System.out.println()

}

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace()

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace()

}

}

}

---