Driver - Postgres Jdbc

JSON/JSONB:

// PreparedStatement (preferred) String sql = "SELECT * FROM users WHERE age > ? AND city = ?"; try (PreparedStatement pstmt = conn.prepareStatement(sql)) pstmt.setInt(1, 18); pstmt.setString(2, "Paris"); ResultSet rs = pstmt.executeQuery(); postgres jdbc driver

public User findById(long id) String sql = "SELECT id, name, email FROM users WHERE id = ?"; try (Connection conn = dataSource.getConnection(); PreparedStatement pstmt = conn.prepareStatement(sql)) pstmt.setLong(1, id); try (ResultSet rs = pstmt.executeQuery()) if (rs.next()) return new User(rs.getLong("id"), rs.getString("name"), rs.getString("email")); catch (SQLException e) throw new RuntimeException("Database error", e); return null; ? AND city = ?"

// Store array Integer[] intArray = 1, 2, 3; Array array = conn.createArrayOf("integer", intArray); pstmt.setArray(1, array); // Read array Array resultArray = rs.getArray("int_array"); Integer[] values = (Integer[]) resultArray.getArray(); ResultSet rs = pstmt.executeQuery()