eclipse与Mysql数据库是否连接的检验

先去下载与Mysql数据库版本匹配的架包，然后导入到项目中，在这里我用的是Mysql8.0

Mysql8.0的驱动类名是 com.mysql.cj.jdbc.Driver

首先新建一个Demo类，然后进行数据库的连接即检验，代码如下

package cb.meizu.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Demo {
	
	private static String driver = "com.mysql.cj.jdbc.Driver";  //获取mysql 8.0数据库的驱动类
	private static String url = "jdbc:mysql://localhost:3306/meizu?useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true"; //连接数据库（meizu是数据库名）
	private static String name = "root";//连接mysql的用户名
	private static String pwd = "123456";//连接mysql的密码
		
	static {
		try {
			Class.forName(driver); //加载JDBC驱动程序
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	public static Connection getConnection(){
	    try{
	      Connection conn = DriverManager.getConnection(url,name,pwd);//获取连接对象
	      return conn;
	    }catch(SQLException e){
	      e.printStackTrace();
	      return null;
	    }
	  }

	public static void closeAll(Connection conn,PreparedStatement psmt,ResultSet rs){
	    try{
	      if(rs!=null){
	        rs.close();
	      }
	    }catch(SQLException e){
	      e.printStackTrace();
	    }
	    try{
	      if(psmt!=null){
	        psmt.close();
	      }
	    }catch(SQLException e){
	      e.printStackTrace();
	    }
	    try{
	      if(conn!=null){
	        conn.close();
	      }
	    }catch(SQLException e){
	      e.printStackTrace();
	    }
	  }

	  public static void main(String[] args) throws SQLException {
	    Connection conn = null;
	    PreparedStatement psmt = null;
	    ResultSet rs = null;
	    
	    conn = Demo.getConnection();
	    String sql = "select * from user";  //sql语句，从user表中查询
	    psmt = conn.prepareStatement(sql);
	    rs = psmt.executeQuery();
	    
	    if(!conn.isClosed()) {
	    	 System.out.println("Succeeded connecting to the Database!");
	    }
	    
	    //将查询结果输出
	    while(rs.next()) {
	      System.out.println(rs.getString("username")); //查询username这一列的值
	    }
	    
	  }
	  
	}