安装MySQL数据库
1、安装visual c++ 2019 Redistributable Package。
2、安装mysql。
下载地址：https://dev.mysql.com/downloads/mysql/
3、安装Navicat Premium。
4、验证。
使用navicat连接mysql，看看是否能连接成功。
使用JDBC访问MySQL
添加依赖
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.29</version>
</dependency>
参考代码
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Application {
public static void main(String[] args) {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (Exception e) {
e.printStackTrace();
}
try {
Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "root");
PreparedStatement statement = conn.prepareStatement("select * from user where name like ?");
statement.setString(1, "%To%");
ResultSet result = statement.executeQuery();
while (result.next()) {
int id = result.getInt("id");
String name = result.getString("name");
int age = result.getInt("age");
String email = result.getString("email");
System.out.printf("id = %d, name = %s, age = %d, email = %s\n", id, name, age, email);
}
result.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}