1.引入依赖:
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.28</version>
</dependency>
</dependencies>
2.代码编写:
public static void main(String[] args) throws SQLException {
Connection concon = null;
PreparedStatement pstm = null;
ResultSet resultSet = null;
String url = "jdbc:mysql://localhost:3306/db06";
String user = "root";
String password = "root";
try {
//1.注册驱动。
DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
//2.获取连接。
concon = DriverManager.getConnection(url, user, password);
if (!concon.isClosed()) {
System.out.println("数据库连接成功!");
}
//3.获取操作数据库的预处理对象
pstm = concon.prepareStatement("select * from t_product");
//4.执行sql,得到结果集
resultSet = pstm.executeQuery();
//5.遍历结果集。
int i = 0;
while (resultSet.next()) {
int id = resultSet.getInt("id");
String productCode = resultSet.getString("product_c1ode");
System.out.println("id" + id);
System.out.println("product_code" + productCode);
}
} catch (SQLException throwables) {
System.out.println("数据库字段错误!");
} finally {
//6.释放资源
if (resultSet != null) {
resultSet.close();
}
if (pstm != null) {
pstm.close();
}
if (concon != null) {
concon.close();
}
}
}
点击运行,大功告成!