From 3b1023c45a919f25ef38c080f2ac2c0dc5d5e7ca Mon Sep 17 00:00:00 2001
From: "David A. Madore" <david+git@madore.org>
Date: Sun, 28 Aug 2011 19:52:02 +0200
Subject: (Preliminary) handling of weblog entry selection and summary.

---
 .../damlengine/WeblogDatabaseConnection.java       | 30 ++++++++++++++++++++++
 1 file changed, 30 insertions(+)
 create mode 100644 org/madore/damlengine/WeblogDatabaseConnection.java

(limited to 'org/madore/damlengine/WeblogDatabaseConnection.java')

diff --git a/org/madore/damlengine/WeblogDatabaseConnection.java b/org/madore/damlengine/WeblogDatabaseConnection.java
new file mode 100644
index 0000000..a1dfc1f
--- /dev/null
+++ b/org/madore/damlengine/WeblogDatabaseConnection.java
@@ -0,0 +1,30 @@
+package org.madore.damlengine;
+
+import java.util.Properties;
+import java.sql.Connection;
+import java.sql.SQLException;
+import org.postgresql.Driver;
+
+public final class WeblogDatabaseConnection {
+
+    private WeblogDatabaseConnection() { // Forbid instantiation
+	throw new AssertionError("WeblogDatabaseConnection cannot be instantiated");
+    }
+
+    public static Connection conn;
+
+    public static Connection getConnection()
+        throws SQLException {
+	if ( conn == null ) {
+	    final String dbUrl = "jdbc:postgresql://localhost/weblog";
+	    final Properties dbProps = new Properties();
+	    dbProps.setProperty("user", "david");
+	    dbProps.setProperty("password", "IHATETHISWHYCANTIUSEUNIXDOMAINSOCKETS");
+	    dbProps.setProperty("ssl", "true");
+	    dbProps.setProperty("sslfactory", "org.postgresql.ssl.NonValidatingFactory");
+	    conn = (new Driver()).connect(dbUrl, dbProps);
+	}
+	return conn;
+    }
+
+}
-- 
cgit v1.2.3