com.hfg.sql.jdbc.postgresql.PostgreSQLConnection Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of com_hfg Show documentation
com.hfg xml, html, svg, and bioinformatics utility library
There is a newer version: 20240423
package com.hfg.sql.jdbc.postgresql;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.hfg.sql.SQLQuery;
import com.hfg.sql.SQLUtil;
import com.hfg.sql.jdbc.JDBCConnection;
import com.hfg.sql.jdbc.JDBCConnectionSettings;
import com.hfg.sql.jdbc.JDBCServer;
import com.hfg.security.LoginCredentials;

//------------------------------------------------------------------------------
/**
 Represents a PostgreSQL database connection.
 
 @author J. Alex Taylor, hairyfatguy.com
 
 */
//------------------------------------------------------------------------------
// com.hfg XML/HTML Coding Library
//
// This library is free software; you can redistribute it and/or
// modify it under the terms of the GNU Lesser General Public
// License as published by the Free Software Foundation; either
// version 2.1 of the License, or (at your option) any later version.
//
// This library is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
// Lesser General Public License for more details.
//
// You should have received a copy of the GNU Lesser General Public
// License along with this library; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
//
// J. Alex Taylor, President, Founder, CEO, COO, CFO, OOPS hairyfatguy.com
// [email protected]
//------------------------------------------------------------------------------

public class PostgreSQLConnection extends JDBCConnection
{

   //###########################################################################
   // CONSTRUCTORS
   //###########################################################################

   //---------------------------------------------------------------------------
   public PostgreSQLConnection(Connection inConnection)
   {
      super(inConnection);
   }

   //---------------------------------------------------------------------------
   public PostgreSQLConnection(JDBCServer inServer, String inDatabaseName, LoginCredentials inCredentials)
   {
      super(inServer, inDatabaseName, inCredentials);
   }

   //---------------------------------------------------------------------------
   public PostgreSQLConnection(JDBCServer inServer, String inDatabaseName, LoginCredentials inCredentials, JDBCConnectionSettings inSettings)
   {
      super(inServer, inDatabaseName, inCredentials, inSettings);
   }


   //###########################################################################
   // PUBLIC METHODS
   //###########################################################################

   //---------------------------------------------------------------------------
   @Override
   public String getCurrentUser()
      throws SQLException
   {
      String currentUser = null;

      SQLQuery query = new SQLQuery().addSelect("current_user");

      ResultSet rs = null;
      try
      {
         rs = query.execute(this);
         if (rs.next())
         {
            currentUser = rs.getString(1);
         }
      }
      finally
      {
         SQLUtil.close(rs);
      }

      return currentUser;
   }
}