Eclipse中连接Mysql数据库

。先将下载下来的mysql-connector-driver.jar驱动jar包导入到Eclipse中来：

选择File->Properties->Java Bulid Path ->Libraries->Add External Jars选择mysql的驱动jar文件。

2。测试有没有连接到数据库

import java.sql.*;
public class DbTest2 {
      public static void main(String[] args) {
      String username = "root";          //root为数据库用户名
      String password = "123456";        //定义密码字符串
      //定义数据库连接字

     String url = "jdbc:mysql://localhost:3306/mysql";      try {
     String driver = "com.mysql.jdbc.Driver";
     Class.forName(driver);      //调用mysql驱动
     Connection cn = DriverManager       
     getConnection(url, username, password);             
    Statement stmt = cn.createStatement();
    String sql = "select * from user";
    ResultSet rs = stmt.executeQuery(sql);
    if (rs.next()) {
           String name = rs.getString(1);
           System.out.print(name);
     }
     DatabaseMetaData ddm = cn.getMetaData();
   System.out.println(ddm.getUserName());
   System.out.println(ddm.getMaxConnections());
  } catch (ClassNotFoundException cnfex) {
   System.out.println("加载JdbcOdbcDeriver失败");
   cnfex.printStackTrace();
  } catch (SQLException sqlex) {
   System.out.println("Can not Connect to the DataBase!");
   sqlex.printStackTrace();
  } catch (Exception ex) {
   System.out.println("NoClassDefException");
   ex.printStackTrace();
  }
  
  
 }
}