Driver — Jdbc Postgresql
try (Connection conn = DriverManager.getConnection(url, user, password)) System.out.println("Connected to PostgreSQL!"); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT version()"); if (rs.next()) System.out.println(rs.getString(1)); catch (SQLException e) e.printStackTrace();
// READ try (PreparedStatement ps = conn.prepareStatement( "SELECT * FROM users WHERE id = ?")) ps.setInt(1, 1); ResultSet rs = ps.executeQuery(); if (rs.next()) String name = rs.getString("name"); driver jdbc postgresql
// DELETE try (PreparedStatement ps = conn.prepareStatement( "DELETE FROM users WHERE id = ?")) ps.setInt(1, 1); ps.executeUpdate(); try (Connection conn = DriverManager