All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • net.sf.jstuff.integration.persistence.JdbcResourcesCloser Maven / Gradle / Ivy

    /*
 * Copyright 2010-2022 by Sebastian Thomschke and contributors.
 * SPDX-License-Identifier: EPL-2.0
 */
package net.sf.jstuff.integration.persistence;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.LinkedList;

import org.eclipse.jdt.annotation.Nullable;

import net.sf.jstuff.core.logging.Logger;
import net.sf.jstuff.core.validation.Args;

/**
 * @author Sebastian Thomschke
 */
public class JdbcResourcesCloser {
   private static boolean close(final @Nullable Object resource) {
      if (resource == null)
         return false;

      try {
         if (resource instanceof Connection) {
            ((Connection) resource).close();
         } else if (resource instanceof Statement) {
            ((Statement) resource).close();
         } else if (resource instanceof ResultSet) {
            ((ResultSet) resource).close();
         } else
            return false;
      } catch (final SQLException ex) {
         LOG.warn(ex, "Closing JDBC Resource %s failed.", resource);
         return false;
      }
      return true;
   }

   private static final Logger LOG = Logger.create();

   private final LinkedList resources = new LinkedList<>();

   /**
    * closes all resources in LIFO order.
    */
   public void closeAll() {
      for (final Object resource : resources) {
         close(resource);
      }
      resources.clear();
   }

   /**
    * Closes the resources registered at last.
    */
   public Object closeLast() {
      final Object resource = resources.removeFirst();
      close(resource);
      return resource;
   }

   /**
    * Registers a resource for later closing.
    *
    * @param stmt the resource
    *
    * @return the resource
    */
   @SuppressWarnings("resource")
   public CallableStatement register(final CallableStatement stmt) {
      Args.notNull("stmt", stmt);

      resources.addFirst(stmt);
      return stmt;
   }

   /**
    * Registers a resource for later closing.
    *
    * @param con the resource
    *
    * @return the resource
    */
   @SuppressWarnings("resource")
   public Connection register(final Connection con) {
      Args.notNull("con", con);

      resources.addFirst(con);
      return con;
   }

   /**
    * Registers a resource for later closing.
    *
    * @param stmt the resource
    *
    * @return the resource
    */
   @SuppressWarnings("resource")
   public PreparedStatement register(final PreparedStatement stmt) {
      Args.notNull("stmt", stmt);

      resources.addFirst(stmt);
      return stmt;
   }

   /**
    * Registers a resource for later closing.
    *
    * @param rs the resource
    *
    * @return the resource
    */
   @SuppressWarnings("resource")
   public ResultSet register(final ResultSet rs) {
      Args.notNull("rs", rs);

      resources.addFirst(rs);
      return rs;
   }

   /**
    * Registers a resource for later closing.
    *
    * @param stmt the resource
    *
    * @return the resource
    */
   @SuppressWarnings("resource")
   public Statement register(final Statement stmt) {
      Args.notNull("stmt", stmt);

      resources.addFirst(stmt);
      return stmt;
   }
}
    
    
    
    

    




    
    
    © 2015 - 2025 Weber Informatics LLC | Privacy Policy