java基础入门jdbc答案



package com.me.mengu.java.base.db;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class JDBCExample {

    public static void main(String[] args) {

        // 数据库连接信息

        String url = "jdbc:mysql://localhost:3306/testdb?useSSL=false&serverTimezone=UTC";

        String username = "root";

        String password = "password";

        // 声明 Connection、Statement 和 ResultSet

        Connection conn = null;

        Statement stmt = null;

        ResultSet rs = null;

        try {

            // 1. 加载 MySQL 驱动程序

            Class.forName("com.mysql.cj.jdbc.Driver");

            // 2. 建立连接

            conn = DriverManager.getConnection(url, username, password);

            // 3. 创建 SQL 语句

            stmt = conn.createStatement();

            // 4. 执行查询语句

            String sql = "SELECT id, name, age FROM users";

            java基础入门jdbc答案 rs = stmt.executeQuery(sql);

            // 5. 处理结果集

            while (rs.next()) {

                int id = rs.getInt("id");

                String name = rs.getString("name");

                int age = rs.getInt("age");

                System.out.println("ID: " + id + ", Name: " + name + ", Age: " + age);

            }

        } catch (SQLException e) {

            e.printStackTrace();

        } catch (ClassNotFoundException e) {

            e.printStackTrace();

        } finally {

            // 6. 关闭资源

            try {

                if (rs != null) rs.close();

                if (stmt != null) stmt.close();

                if (conn != null) conn.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

    }

版权声明：

本文来源网络，所有图片文章版权属于原作者，如有侵权，联系删除。

本文网址：https://www.bianchenghao6.com/h6javajc/19797.html