Java - MySQL只显示一个条目？

// 示例代码
String sql = "SELECT * FROM your_table WHERE some_condition";
try (Connection conn = DriverManager.getConnection(url, username, password);
     Statement stmt = conn.createStatement();
     ResultSet rs = stmt.executeQuery(sql)) {
    while (rs.next()) {
        // 处理结果
    }
} catch (SQLException e) {
    e.printStackTrace();
}

// 检查数据表中的条目数量
String countSql = "SELECT COUNT(*) FROM your_table";
try (Connection conn = DriverManager.getConnection(url, username, password);
     Statement stmt = conn.createStatement();
     ResultSet rs = stmt.executeQuery(countSql)) {
    if (rs.next()) {
        int count = rs.getInt(1);
        System.out.println("Total entries: " + count);
    }
} catch (SQLException e) {
    e.printStackTrace();
}

// 确保遍历所有的结果
String sql = "SELECT * FROM your_table WHERE some_condition";
try (Connection conn = DriverManager.getConnection(url, username, password);
     Statement stmt = conn.createStatement();
     ResultSet rs = stmt.executeQuery(sql)) {
    while (rs.next()) {
        // 处理每个结果
    }
} catch (SQLException e) {
    e.printStackTrace();
}