创建项目
打开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();
}
}
}
}
}