打开IDEA开发工具，“New Project” 复制mysql-connector-java驱动(链接MySql驱动)到“libs”目录下 添加驱动 若是项目还没有jdk，需添加jdk
package com.dgd.test; import java.sql.*; /** * @author lam * @create 2020-10-21-15:25 * 测试数据库 */ public class DBTest { //mysql驱动包名 private static final String DRIVER_NAME = "com.mysql.jdbc.Driver"; //数据库连接地址 // ?useSSL=false不校验ssl证书 private static final String URL = "jdbc:mysql://localhost:3306/test?useSSL=false"; //用户名,root更换成你自己的mysql用户名 private static final String USER_NAME = "root"; //密码，123456更换成你自己设定的密码， private static final String PASSWORD = "123456"; public static void main(String[] args){ Connection connection = null; try { //加载mysql的驱动类 Class.forName(DRIVER_NAME); //获取数据库连接 connection = DriverManager.getConnection(URL, USER_NAME, PASSWORD); //mysql查询语句 String sql = "SELECT name FROM test.info"; PreparedStatement prst = connection.prepareStatement(sql); //结果集 ResultSet rs = prst.executeQuery(); while (rs.next()) { System.out.println("用户名:" + rs.getString("name")); } rs.close(); prst.close(); } catch (Exception e) { e.printStackTrace(); }finally { if (connection != null) { try { connection.close(); } catch (SQLException e) { e.printStackTrace(); } } } } }