打开Eclipse,创建一个项目(my),

操作:右键点击my--->build Path--->add external Archiver...选择jdbc驱动,点击确定。

pom 导入mysql驱动 myeclipse怎么导入mysql驱动_bc

我的项目列表:

pom 导入mysql驱动 myeclipse怎么导入mysql驱动_bc_02

3.驱动已经导入,下面我们来写一个程序验证一下

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;//上边三行自动
public class MysqlJdbc {/**
 * @param args
 */
 public static void main(String[] args) {
 // TODO Auto-generated method stub
 try { 
 Class.forName("com.mysql.jdbc.Driver"); //加载MYSQL JDBC驱动程序 
 //Class.forName("org.gjt.mm.mysql.Driver"); 
 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:3306/first","root","5106"); 
 //连接URL为 jdbc:mysql//服务器地址/数据库名 ,后面的2个参数分别是登陆用户名和密码 

 System.out.println("Success connect Mysql server!"); 
 Statement stmt = connect.createStatement(); 
 ResultSet rs = stmt.executeQuery("select * from about"); 
 //user 为你表的名称 
 while (rs.next()) { 
 System.out.println(rs.getString("name")); 
 } 
 } 
 catch (Exception e) { 
 System.out.print("get data error!"); 
 e.printStackTrace(); 
 } 
 }
}

插入代码:

try { 
 Class.forName("com.mysql.jdbc.Driver"); //加载MYSQL JDBC驱动程序 
 //Class.forName("org.gjt.mm.mysql.Driver"); 
 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:3306/first","root","5106"); 

 int num=100; 
 PreparedStatement Statement=connect.prepareStatement("INSERT INTO about VALUES(?,?)"); 
 for(int i=0;i<2;i++) //定义个100次的循环,往表里插入一百条信息。 
 { 
 Statement.setInt(1, i); 
 Statement.setString(2,"bo"+i); 
 Statement.executeUpdate(); 
 } 

 // } catch (ClassNotFoundException e) { 
 // TODO Auto-generated catch block 
 // System.out.println("An error has occurred:"+e.toString()); 
 // e.printStackTrace(); 
 }catch(SQLException e) 
 { 
 }