import java.sql.*;

 public class ConnectionTest
 {

     public static void main(String[] args)
     {
         Connection conn = null;

         try
         {
             String userName = "openmrs";
             String password = "openmrs";
             String url = "jdbc:mysql://127.0.0.1:3306/openmrs";
             Class.forName ("com.mysql.jdbc.Driver").newInstance ();
             conn = DriverManager.getConnection (url, userName, password);
             System.out.println ("Database connection established");
         }
         catch (Exception e)
         {
             System.err.println ("Cannot connect to database server");
             e.printStackTrace();
         }
         finally
         {
             if (conn != null)
             {
                 try
                 {
                     conn.close ();
                     System.out.println ("Database connection terminated");
                 }
                 catch (Exception e) { /* ignore close errors */ }
             }
         }
     }
 }