eclipse连接mysql数据库

前期准备

1.eclipse

2.Mysql workbench

3.jdbc 下载 提取码: tj5u

导入jdbc

• 新建项目
  
  

• 为项目命名
  

• 加入jdbc库

• 

选中jdbc

apply and close

• 新建class

• 创建数据库
  在mysql中创建数据库，例如

create database test;
use  test;
drop table user;
CREATE  TABLE  user (name VARCHAR(20),password VARCHAR(20));
INSERT  INTO  user  VALUES('huzhiheng','123456'); 
SELECT *	 from user

• 复制这段代码

package test;	//命名为包名字
import java.sql.*;
public class select_test {
	   // JDBC driver name and database URL
	   static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";  
	   static final String DB_URL = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT";

	   //  Database credentials
	   static final String USER = "root";
	   static final String PASS = "admin";

	   public static void main(String[] args) {
	   Connection conn = null;
	   Statement stmt = null;
	   try{
	      //STEP 2: Register JDBC driver
	      Class.forName("com.mysql.cj.jdbc.Driver");

	      //STEP 3: Open a connection
	      System.out.println("Connecting to a selected database...");
	      conn = DriverManager.getConnection(DB_URL, USER, PASS);
	      System.out.println("Connected database successfully...");

	      //STEP 4: Execute a query
	      System.out.println("Creating statement...");
	      stmt = conn.createStatement();

	      String sql = "SELECT* FROM user";
	      ResultSet rs = stmt.executeQuery(sql);
	      //STEP 5: Extract data from result set
	      while(rs.next()){
	         //Retrieve by column name
	    	 String name  = rs.getString("name");
	    	 String pass = rs. getString("password");


	         //Display values
	         System.out.print("name: " + name);
	         System.out.print(", pass: " + pass);
	      }
	      rs.close();
	   }catch(SQLException se){
	      //Handle errors for JDBC
	      se.printStackTrace();
	   }catch(Exception e){
	      //Handle errors for Class.forName
	      e.printStackTrace();
	   }finally{
	      //finally block used to close resources
	      try{
	         if(stmt!=null)
	            conn.close();
	      }catch(SQLException se){
	      }// do nothing
	      try{
	         if(conn!=null)
	            conn.close();
	      }catch(SQLException se){
	         se.printStackTrace();
			} // end finally try
	   }//end try
	   System.out.println("Goodbye!");
	}//end main
	}//end JDBCExample

完成连接