import java.sql.*;

public class MysqlJdbc {
  public static void main(String args[]) {
    try {
      Class.forName("org.gjt.mm.mysql.Driver");     //加載MYSQL JDBC驅動程序  
      System.out.println("Success loading Mysql Driver!");
    }
    catch (Exception e) {
      System.out.print("Error loading Mysql Driver!");
      e.printStackTrace();
    }

    try {
      Connection connect = DriverManager.getConnection(
          "jdbc:mysql://localhost/catmiw", "root", "");
//連接URL為   jdbc:mysql//服務器地址/數據庫名
//后面的2個參數分別是登陸用戶名和密碼
      System.out.println("Success connect Mysql server!");

      Statement stmt = connect.createStatement();
      ResultSet rs = stmt.executeQuery("select * from pet");
      while (rs.next()) {
        System.out.println(rs.getString("name"));

      }
    }
    catch (Exception e) {
      System.out.print("get data error!");
      e.printStackTrace();
    }
  }
}

程序運行結果如下：
Success loading Mysql Driver!
Success connect Mysql server!
a dog