Some progress toward implementing connection to DB and auto-schema-creation.

[cfb.git] / prod / net / jaekl / cfb / db / driver / PostgresqlDriver.java

diff --git a/prod/net/jaekl/cfb/db/driver/PostgresqlDriver.java b/prod/net/jaekl/cfb/db/driver/PostgresqlDriver.java
index 0f6a12d7796d53b8e886eb2975a56f7ebb5b55a2..ec90ab8e9622c8498bb0fc4a745bf3dd739b57fc 100644 (file)
--- a/prod/net/jaekl/cfb/db/driver/PostgresqlDriver.java
+++ b/prod/net/jaekl/cfb/db/driver/PostgresqlDriver.java
@@ -1,7 +1,10 @@
 package net.jaekl.cfb.db.driver;
 
 import java.sql.Connection;
+import java.sql.DriverManager;
 import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Properties;
 
 import net.jaekl.cfb.db.Column;
 import net.jaekl.cfb.db.Table;
@@ -17,9 +20,13 @@ public class PostgresqlDriver extends DbDriver {
        }
 
        @Override
-       public Connection connect(String host, int port, String user, String pass) {
-               // TODO Auto-generated method stub
-               return null;
+       public Connection connect(String host, int port, String dbName, String user, String pass) throws SQLException {
+               String url = "jdbc:postgresql://" + host + ":" + port + "/" + dbName;
+               Properties props = new Properties();
+               props.setProperty("user", user);
+               props.setProperty("password", pass);
+               //props.setProperty("ssl", "true");
+               return DriverManager.getConnection(url, props);
        }
 
        @Override