eclipse JDBC 连接MySql

1.首先导入mysql driver 如上图，导入后箭头位置出现 驱动，即为成功。

2.测试JDBC  connection

源码如下：

package TestJdbc;
import java.sql.*;
public class Test {
Connection con;
public Connection getConnection(){
try {
Class.forName("com.mysql.jdbc.Driver");
//Class.forName("org.gjt.mm.mysql.Driver"); 
System.out.println("数据库驱动加载成功");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


try {
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sakila","root","18252035965");  //这里个参数分别为 数据库url ， 数据库账号，密码
System.out.println("数据库链接成功");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
public static void  main(String[] args){
Test c=  new Test();
c.getConnection();
}

3 遍历输出 数据库 ：sakila 表：test_table

package TestJdbc;


import java.sql.*;
public class TestSql {
static Connection con;
static Statement sql;
static ResultSet res;
public Connection getConnection(){
try {
Class.forName("com.mysql.jdbc.Driver");
//Class.forName("org.gjt.mm.mysql.Driver"); 
System.out.println("数据库驱动加载成功");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


try {
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sakila","root","18252035965");
System.out.println("数据库链接成功");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}


public  static  void  main (String [] args){
TestSql c = new TestSql();
con=c.getConnection();
try {
sql =con.createStatement();//实例化
res = sql.executeQuery("select*from test_table");//根据自己数据库选择表
while(res.next()){
String id= res.getString("id");
String name = res.getString("name");
String age = res.getString("age");
System.out.println("id  is  "+id);
System.out.println("name  is  "+name);
System.out.println("age  is  "+age);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}



}