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

public class OceanBaseResultSetExample {

    public static void main(String[] args) {
        try {
            // 加载 JDBC 驱动
            Class.forName("oracle.jdbc.driver.OracleDriver");

            // OceanBase 数据库连接 URL
            String url = "jdbc:oracle:thin:@localhost:1521:your_oceanbase_sid";

            // 用户名和密码
            String user = "your_username";
            String password = "your_password";

            // 获取连接
            try (Connection connection = DriverManager.getConnection(url, user, password)) {
                // 执行查询的 SQL 语句
                String sql = "SELECT * FROM your_table_name";
                
                // 预编译 SQL 语句
                try (PreparedStatement statement = connection.prepareStatement(sql)) {
                    // 执行查询并获取结果集
                    try (ResultSet resultSet = statement.executeQuery()) {
                        // 处理结果集
                        while (resultSet.next()) {
                            // 获取每行数据的列值
                            int column1Value = resultSet.getInt("column1");
                            String column2Value = resultSet.getString("column2");
                            // ... 根据需要获取其他列的值

                            // 在这里可以对每一行的数据进行处理
                            System.out.println("Column1: " + column1Value + ", Column2: " + column2Value);
                        }
                    }
                }
            }
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
    }
}