1 package net.jaekl.cfb.db.driver;
3 // Copyright (C) 2015 Christian Jaekl
5 import java.sql.Connection;
6 import java.sql.DriverManager;
7 import java.sql.ResultSet;
8 import java.sql.SQLException;
9 import java.util.Properties;
11 import net.jaekl.cfb.db.Column;
12 import net.jaekl.cfb.db.Table;
14 public class PostgresqlDriver extends DbDriver {
17 public void load() throws ClassNotFoundException {
18 // This should no longer be necessary, so long as we're using
19 // JDBC 4 (which came out with JDK 6) and an updated driver.
20 // But, it shouldn't hurt, either.
21 Class.forName("org.postgresql.Driver");
25 public Connection connect(String host, int port, String dbName, String user, String pass) throws SQLException {
26 String url = "jdbc:postgresql://" + host + ":" + port + "/" + dbName;
27 Properties props = new Properties();
28 props.setProperty("user", user);
29 props.setProperty("password", pass);
30 //props.setProperty("ssl", "true");
31 return DriverManager.getConnection(url, props);
35 public ResultSet selectColumnsFromWhere(Column[] columns, Table[] tables, String where) {
36 // TODO Auto-generated method stub