postgresqlHow do I use PostgreSQL with Maven?

Maven is a build automation tool for Java projects. PostgreSQL is an open source relational database. It is possible to use PostgreSQL with Maven.

The first step is to add the PostgreSQL JDBC driver dependency to the project's pom.xml file. This can be done by adding the following lines to the <dependencies> section:

<dependency>
  <groupId>org.postgresql</groupId>
  <artifactId>postgresql</artifactId>
  <version>9.4-1206-jdbc42</version>
</dependency>

The next step is to configure the database connection. This can be done by adding the following lines to the <properties> section of the pom.xml file:

<properties>
  <db.driver>org.postgresql.Driver</db.driver>
  <db.url>jdbc:postgresql://localhost:5432/mydb</db.url>
  <db.username>postgres</db.username>
  <db.password>password</db.password>
</properties>

The last step is to add the code to access the database. This can be done by adding the following lines to the code:

String url = System.getProperty("db.url");
String username = System.getProperty("db.username");
String password = System.getProperty("db.password");

Class.forName(System.getProperty("db.driver"));
Connection connection = DriverManager.getConnection(url, username, password);

This code will create a connection to the database using the parameters configured in the pom.xml file.

Helpful links

• Maven
• PostgreSQL
• PostgreSQL JDBC Driver

Edit this code on GitHub