eclipse看项目中mysql版本_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这一列的值

}

}

}