循环遍历Oracle查询结果中的值列表

SELECT column_name
FROM table_name
WHERE condition;

import java.sql.*;

public class OracleQuery {
    public static void main(String[] args) {
        String url = "jdbc:oracle:thin:@localhost:1521:xe";
        String username = "your_username";
        String password = "your_password";
        
        try {
            // 连接到Oracle数据库
            Connection conn = DriverManager.getConnection(url, username, password);
            
            // 创建SQL语句
            String sql = "SELECT column_name FROM table_name WHERE condition";
            
            // 执行查询
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            
            // 循环遍历查询结果
            while (rs.next()) {
                String value = rs.getString("column_name");
                // 对每个值进行处理
                System.out.println(value);
            }
            
            // 关闭连接
            rs.close();
            stmt.close();
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}