Connect with Database Postgres using MAVEN

Step 1: Set up MAVEN in enviroment variable

Test command

Step 2 : Creating a mavent project using quick start template of maven

#mvn archetype:generate -DgroupId=com.mycompany.app / -DartifactId=my-app  -DarchetypeArtifactId=maven-archetype-quickstart -DinteractiveMode=false

-DartifactId : name of project
 -DgroupId  : name of package

After run command we have result:

Step 3 : Main code in App.java

 package com.mycompany.app;  
 import java.sql.DriverManager;  
 import java.sql.Connection;  
 import java.sql.SQLException;  
 public class App {   
      public static void main(String[] argv) {   
           System.out.println("-------- PostgreSQL "  
                     + "JDBC Connection Testing ------------");   
           try {   
                Class.forName("org.postgresql.Driver");   
           } catch (ClassNotFoundException e) {   
                System.out.println("Where is your PostgreSQL JDBC Driver? "  
                          + "Include in your library path!");  
                e.printStackTrace();  
                return;   
           }   
           System.out.println("PostgreSQL JDBC Driver Registered!");   
           Connection connection = null;   
           try {   
                connection = DriverManager.getConnection(  
                          "jdbc:postgresql://10.190.201.79:5432/postgres", "postgres",  
                          "admin");   
           } catch (SQLException e) {   
                System.out.println("Connection Failed! Check output console");  
                e.printStackTrace();  
                return;   
           }  
            if (connection != null) {  
                System.out.println("You made it, take control your database now!");  
           } else {  
                System.out.println("Failed to make connection!");  
           }  
      }   
 }  

Step 4 : Contain in pom.xml

 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   
 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">   
      <modelVersion>4.0.0</modelVersion>   
      <groupId>PostgreSQL</groupId>   
      <artifactId>postgres</artifactId>   
      <packaging>jar</packaging>   
      <version>1.0-SNAPSHOT</version>   
      <name>postgres</name>   
      <url>http://maven.apache.org</url>   
      <dependencies>   
           <!-- Add Junit lib -->  
           <dependency>   
                <groupId>junit</groupId>   
                <artifactId>junit</artifactId>   
                <version>3.8.1</version>   
                <scope>test</scope>   
           </dependency>   
           <!-- Add postgresql JDBC lib-->   
           <dependency>   
                <groupId>postgresql</groupId>   
                <artifactId>postgresql</artifactId>   
                <version>9.1-901.jdbc4</version>   
           </dependency>      
      </dependencies>   
       <build>   
             <plugins>   
                <plugin>   
                 <groupId>org.apache.maven.plugins</groupId>   
                 <artifactId>maven-jar-plugin</artifactId>   
                 <configuration>   
                 <archive>   
                  <manifest>   
                     <addClasspath>true</addClasspath>   
                     <mainClass>com.mycompany.app.App</mainClass>   
                  </manifest>   
                 </archive>   
                 </configuration>   
                </plugin>  
                <!--  
                to package this program with external jar files  
                -->  
                <plugin>   
                     <artifactId>maven-assembly-plugin</artifactId>   
                     <configuration>   
                          <descriptorRefs>   
                               <descriptorRef>jar-with-dependencies</descriptorRef>   
                          </descriptorRefs>   
                          <archive>   
                               <manifest>   
                               <mainClass>com.mycompany.app.App</mainClass>   
                               </manifest>   
                          </archive>   
                     </configuration>   
                     <executions>   
                          <execution>   
                               <id>with-lib</id>   
                               <phase>package</phase>   
                               <goals>   
                                    <goal>single</goal>   
                               </goals>   
                          </execution>   
                     </executions>   
                </plugin>   
                <!--  
                To run program with command   
                #mvn exec:java  
                -->  
                <plugin>  
                     <groupId>org.codehaus.mojo</groupId>  
                     <artifactId>exec-maven-plugin</artifactId>  
                     <version>1.1</version>  
                     <configuration>  
                          <mainClass>com.mycompany.app.App</mainClass>  
                     </configuration>  
                </plugin>  
           </plugins>   
      </build>   
 </project>   

Step 5 

$cd my-app
$mvn package
$mvn exec:java

Result :