MYSQL 的JDBC串連測試程式

package com.catmiw.testmysql;

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