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代碼  

package test;

import java.sql.connection;

import java.sql.drivermanager;

import java.sql.resultset;

import java.sql.statement;

public class testmysql

{   

    public static void main(string[] args)

    {   

        try  

        {

            statement stmt=null;   

            resultset rs=null;   

            class.forname("com.mysql.jdbc.driver");   

            connection conn = drivermanager.getconnection("jdbc:mysql://localhost:3306/資料庫名稱","root","123456");    

            stmt = (statement)conn.createstatement(); 

            rs = stmt.executequery("select * from petinfo"); 

            while (rs.next()) 

            { 

                 system.out.println(rs.getstring(2));   

            } 

        }

        catch(exception ex)

            ex.printstacktrace();

    }   

}