From 33613a85afc4b1481367fbe92a17ee59c240250b Mon Sep 17 00:00:00 2001
From: Sven Eisenhauer <sven@sven-eisenhauer.net>
Date: Fri, 10 Nov 2023 15:11:48 +0100
Subject: add new repo

---
 .../hjp5/examples/CachedConnection.java            | 33 ++++++++++++++++++++++
 1 file changed, 33 insertions(+)
 create mode 100644 Master/Reference Architectures and Patterns/hjp5/examples/CachedConnection.java

(limited to 'Master/Reference Architectures and Patterns/hjp5/examples/CachedConnection.java')

diff --git a/Master/Reference Architectures and Patterns/hjp5/examples/CachedConnection.java b/Master/Reference Architectures and Patterns/hjp5/examples/CachedConnection.java
new file mode 100644
index 0000000..4493adb
--- /dev/null
+++ b/Master/Reference Architectures and Patterns/hjp5/examples/CachedConnection.java	
@@ -0,0 +1,33 @@
+/* CachedConnection.java */
+
+import java.sql.*;
+import java.util.*;
+
+public class CachedConnection
+{
+  private Connection             con;
+  private LinkedList<Statement>  cache;
+  private int                    stmtcnt;
+
+  public CachedConnection(Connection con)
+  {
+    this.con     = con;
+    this.cache   = new LinkedList<Statement>();
+    this.stmtcnt = 0;
+  }
+
+  public Statement getStatement()
+  throws SQLException
+  {
+    if (cache.size() <= 0) {
+      return con.createStatement();
+    } else {
+      return cache.poll();
+    }
+  }
+
+  public void releaseStatement(Statement statement)
+  {
+    cache.add(statement);
+  }
+}
\ No newline at end of file
-- 
cgit v1.2.3