如何在in子句中设置SQL查询中绑定变量的值

SELECT * FROM users WHERE age IN (:ageValues)

import psycopg2

# 创建数据库连接
conn = psycopg2.connect(database="your_database", user="your_user", password="your_password", host="your_host", port="your_port")

# 创建游标
cur = conn.cursor()

# 设置绑定变量的值
age_values = [25, 30, 35]
cur.execute("SELECT * FROM users WHERE age IN %s", (tuple(age_values),))

# 获取查询结果
rows = cur.fetchall()

# 关闭游标和连接
cur.close()
conn.close()

import java.sql.*;

public class Main {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;

        try {
            // 创建数据库连接
            conn = DriverManager.getConnection("jdbc:mysql://your_host:your_port/your_database", "your_user", "your_password");

            // 创建PreparedStatement对象
            String sql = "SELECT * FROM users WHERE age IN (?)";
            stmt = conn.prepareStatement(sql);

            // 设置绑定变量的值
            Array ageValues = conn.createArrayOf("INTEGER", new Integer[]{25, 30, 35});
            stmt.setArray(1, ageValues);

            // 执行查询
            rs = stmt.executeQuery();

            // 处理查询结果
            while (rs.next()) {
                // 处理每一行数据
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭ResultSet、PreparedStatement和Connection
            try {
                if (rs != null) {
                    rs.close();
                }
                if (stmt != null) {
                    stmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}