一段Java代码!

ackage com.demo.javase.day85;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DatabaseConnection {
private static final String DB_URL = "jdbc:mysql://localhost:3306/springboot_db?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8"; // 数据库连接URL
private static final String USER = "root"; // 数据库用户名
private static final String PASSWORD = "123456"; // 数据库密码

public static void main(String[] args) {
    Connection connection = null;
    Statement statement = null;
    ResultSet resultSet = null;

    try {
        // 注册JDBC驱动程序
        Class.forName("com.mysql.cj.jdbc.Driver");

        // 打开连接
        connection = DriverManager.getConnection(DB_URL, USER, PASSWORD);

        // 执行查询
        statement = connection.createStatement();
        String sql = "SELECT * FROM user";
        resultSet = statement.executeQuery(sql);

        // 处理结果集
        while (resultSet.next()) {
            int id = resultSet.getInt("id");
            String name = resultSet.getString("name");
            String sex = resultSet.getString("sex");
            // 打印结果
            System.out.println("id: " + id + ", name: " + name + ", sex: " + sex);
        }
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        // 关闭连接
        try {
            if (resultSet != null) {
                resultSet.close();
            }
            if (statement != null) {
                statement.close();
            }
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

}

posted @ 2025-12-30 20:57  111阳  阅读(2)  评论(0)    收藏  举报