網上的資料真爛,千篇一律的拷貝的,根本不能用,鄙視! 正題: 到MYSQL網站下載mysql-connector-java-5.0.4.zip文件,解壓; 解壓后有一個文件:mysql-connector-java-5.0.4-bin.jar 把這個文件放到應用的lib包里或者寫一個classpath確定絕對地址。 package org.sytuyuan; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import java.sql.ResultSet; public class MySqlTest { ??? public static void main(String[] args) { ??? ??? try { ??? ??? ??? Class.forName("com.mysql.jdbc.Driver"); ??? ??? ??? Connection con = DriverManager.getConnection( ??? ??? ??? ??? ??? "jdbc:mysql://localhost/test", "root", "123456"); ??? ??? ??? Statement stmt = con.createStatement(); ??? ??? ??? // stmt.execute("insert into user values('123',null,null,null) "); ??? ??? ??? ResultSet rs = stmt.executeQuery("select * from user"); ??? ??? ??? while (rs.next()) { ??? ??? ??? ??? System.out.println(rs.getString("userid")); ??? ??? ??? } ??? ??? ??? rs.close(); ??? ??? ??? con.close(); ??? ??? } catch (ClassNotFoundException e) { ??? ??? ??? System.out.println(e.getMessage()); ??? ??? } catch (SQLException ex) { ??? ??? ??? System.out.println("SQLException: " + ex.getMessage()); ??? ??? ??? System.out.println("SQLState: " + ex.getSQLState()); ??? ??? ??? System.out.println("VendorError: " + ex.getErrorCode()); ??? ??? } ??? } }