Advertisement
Guest User

Postgres binding array via JDBC

a guest
Sep 25th, 2024
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.26 KB | Source Code | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.PreparedStatement;
  4. import java.sql.ResultSet;
  5. import java.sql.SQLException;
  6.  
  7. public class PostgresArrayExample {
  8.     public static void main(String[] args) throws SQLException {
  9.         Connection conn = setup(args[0], args[1], args[2]);
  10.         try {
  11.             Integer[] idArray = {1,2,3,4,5,100,200,-999};
  12.  
  13.             String sql = "SELECT * FROM t WHERE id = ANY(?)";
  14.             try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
  15.                 pstmt.setArray(1, conn.createArrayOf("INTEGER", idArray));
  16.  
  17.                 // Execute the query
  18.                 try (ResultSet rs = pstmt.executeQuery()) {
  19.                     while (rs.next()) {
  20.                         System.out.println("ID: " + rs.getInt("id"));
  21.                     }
  22.                 }
  23.             }
  24.         } catch (SQLException e) {
  25.             e.printStackTrace();
  26.         }
  27.     }
  28.  
  29.     private static Connection setup(String jdbcUrl, String user, String pw) throws SQLException {
  30.         DriverManager.registerDriver(new org.postgresql.Driver());
  31.  
  32.         Connection conn = DriverManager.getConnection(jdbcUrl, user, pw);
  33.         conn.setAutoCommit(false);
  34.  
  35.         return conn;
  36.     }
  37.  
  38. }
  39.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement