Postgres binding large array example (to replace an "IN" list)

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

public class PostgresArrayExample {
    private static final int NUM_IDS=100000;

    public static void main(String[] args) throws SQLException {
        Connection conn = setup(args[0], args[1], args[2]);
        try {
            // Define the array of IDs
            //Integer[] ids = {2, 6, 12}; // Example array

            //let's make an array of 100,000 IDs to search by
            Integer[] ids = new Integer[NUM_IDS];
            for (int i=0; i<NUM_IDS; i++) {
                ids[i] = i;
            }

            // prepare the SQL query with array parameter
            String sql = "SELECT * FROM t WHERE id = ANY(?)";
            try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
                // set the array parameter
                pstmt.setArray(1, conn.createArrayOf("INTEGER", ids));

                // Execute the query
                try (ResultSet rs = pstmt.executeQuery()) {
                    while (rs.next()) {
                        System.out.println("ID: " + rs.getInt("id"));
                    }
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    private static Connection setup(String jdbcUrl, String user, String pw) throws SQLException {
        DriverManager.registerDriver(new org.postgresql.Driver());

        Connection conn = DriverManager.getConnection(jdbcUrl, user, pw);
        conn.setAutoCommit(false);

        return conn;
    }

}