【转载】JDBC 连接MYSQL

import java.sql.*;

public class SampleIntro
{
   public static void main(String[] args)
   {
     try
     {
       Connection conn;
       Statement stmt;
       ResultSet res;
       //加载Connector/J驱动
       //这一句也可写为：Class.forName("com.mysql.jdbc.Driver");
       Class.forName("com.mysql.jdbc.Driver").newInstance();
       //建立到MySQL的连接
       conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test",
                                         "root", "guapo");
       //执行SQL语句
       stmt = conn.createStatement();
       res = stmt.executeQuery("select * from pet");
       //处理结果集
       while (res.next())
       {
         String name = res.getString("name");
         System.out.println(name);
       }
       res.close();

     }
     catch (Exception ex)
     {
       System.out.println("Error : " + ex.toString());
     }
   }
}