java连接mysql

1.下载jar包 
-->点击:"MySQL Connector/J 5.1 — Generally Available (GA) release (recommended)" 
-->点击:(mysql-connector-java-5.1.10.zip)后面的download按钮 
-->点击:"» No thanks, just take me to the downloads!" 
-->随便选一个"HTTP"超链接，开始下载 
2.在项目中导入下载的jar包 mysql-connector-java-5.1.10-bin.jar 
3.打开mysql 
4.编写代码 

Java代码  

1. package Test;  
2.   
3. import java.sql.Connection;  
4. import java.sql.DriverManager;  
5. import java.sql.ResultSet;  
6. import java.sql.Statement;  
7.   
8. public class TestMySql  
9. {  
10.     public static void main(String[] args)  
11.     {  
12.         try  
13.         {  
14.             Statement stmt=null;  
15.             ResultSet rs=null;  
16.             Class.forName("com.mysql.jdbc.Driver");  
17.             Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名称","root","123456");   
18.             stmt = (Statement)conn.createStatement();   
19.             rs = stmt.executeQuery("SELECT * from PetInfo");   
20.   
21.             while (rs.next())   
22.             {   
23.                  System.out.println(rs.getString(2));  
24.             }   
25.         }  
26.         catch(Exception ex)  
27.         {  
28.             ex.printStackTrace();  
29.         }  
30.     }  
31. }