1 files changed, 33 insertions, 0 deletions
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