JDBC 連結 MySQL

mysql-connector-java-5.1.8.tar.gz
http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.8.tar.gz/from/pick#mirrors
須把 mysql-connector-java-5.1.8-bin.jar
放到 Tomcat 5.5\shared\lib
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class MySQLbata { public static void main(String[] args){ try{ //載入驅動程式 Class.forName("com.mysql.jdbc.Driver"); //建立 DBMS 的連結 Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1/mydb", "root", "123"); //建立 JDBC 指令 Statement stmt = con.createStatement(); //執行 SQL 指令 String sql = "select * from user"; ResultSet rs = stmt.executeQuery(sql); //抓資料 while(rs.next()){ System.out.println(rs.getString("id") + "\t" + rs.getString("pwd")); } }catch(ClassNotFoundException e){ System.out.println("ClassNotFoundException : " + e.getMessage()); }catch(SQLException e){ System.out.println("SQLException : " + e.getMessage()); } } }