import java.sql.*;
    
    public class JDBCExample {
       static final String DB_URL = "jdbc:postgresql://localhost:5432/postgres";
       static final String USER = "postgres";
       static final String PASS = "Vinr";
       static final String QUERY = "SELECT id, first, last, age FROM Employees";
    
       public static void main(String[] args) {
          // Open a connection
          try(Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
             Statement stmt = conn.createStatement();
             ResultSet rs = stmt.executeQuery(QUERY);) {
             // Extract data from result set
             while (rs.next()) {
                // Retrieve by column name
                System.out.print("ID: "   rs.getInt("id"));
                System.out.print(", Age: "   rs.getInt("age"));
                System.out.print(", First: "   rs.getString("first"));
                System.out.println(", Last: "   rs.getString("last"));
             }
          } catch (SQLException e) {
             e.printStackTrace();
          } 
       }
    }

getting error as

java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/postgres
        at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:708)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:230)
        at JDBCExample.main(JDBCExample.java:11)

CodePudding user response：

You miss the postgresql driver in your classpath at runtime.

Download it and add it to your classpath.

If you use maven for building, add

<!-- https://mvnrepository.com/artifact/org.postgresql/postgresql -->
<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>42.5.0</version>
</dependency>

to your pom