java基础入门jdbc答案

科技前沿 • 2024-12-31 17:51 • 阅读 63

大家好，我是讯享网，很高兴认识大家。

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();

}

java基础入门jdbc答案

相关推荐