1. MySQL数据库及表的建立
2. 新建maven项目,进行数据库的操作
2.1 在pom.xml中添加MySQL的jdbc驱动
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.33</version>
</dependency>
</dependencies>
下载驱动的官网
2.2 新建database_test.java文件进行数据库操作
database_test.java
文件代码
package com.mycode;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class database_test {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/demo";
String user = "root";
String password = "15072286700hh@";
try {
Connection connection = DriverManager.getConnection(url, user, password);
Statement statement = connection.createStatement();
// 准备sql语句
String sql = "SELECT * FROM studentp";
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
// 处理查询结果
System.out.println(resultSet.getString(2));
}
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}