de.bezier.data.sql
Class PostgreSQL

java.lang.Object
  de.bezier.data.sql.SQL
      de.bezier.data.sql.PostgreSQL

public class PostgreSQL
extends SQL

PostgreSQL wrapper for SQL library for Processing 1.0

This is a wrapper around some of sun's java.sql.* classes and the "org.postgresql.Driver" driver by postgresql.org (BSD).

see:

• http://jdbc.postgresql.org/download.html
• http://java.sun.com/products/jdbc/

PostgreSQL on OS-X (i used a mix of these on 10.5.x):

• http://developer.apple.com/internet/opensource/postgres.html
• http://shifteleven.com/articles/2008/03/21/installing-postgresql-on-leopard-using-macports
• http://systems.takizo.com/2008/03/10/installing-postgresql-82-on-leopard-with-macports/

PostgreSQL documentation is at:

• http://www.postgresql.org/docs/8.3/interactive/index.html

Since:

0.0.1

Author:

Florian Jenett - mail@florianjenett.de created: 2008-11-29 17:49:23 - fjenett modified: fjenett 20081129

Field Summary

Fields inherited from class de.bezier.data.sql.SQL

connection, database, driver, previousQuery, result, server, statement, type, url, user

Constructor Summary

PostgreSQL(processing.core.PApplet _papplet, java.lang.String _database)

PostgreSQL(processing.core.PApplet _papplet, java.lang.String _server, java.lang.String _database, java.lang.String _user, java.lang.String _pass)
Creates a new PostgreSQL connection.

Method Summary

Methods inherited from class de.bezier.data.sql.SQL

close, connect, dispose, execute, getBigDecimal, getBigDecimal, getBoolean, getBoolean, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getInt, getInt, getLong, getLong, getObject, getObject, getString, getString, getTime, getTime, getTimestamp, getTimestamp, next, query

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PostgreSQL

public PostgreSQL(processing.core.PApplet _papplet,
                  java.lang.String _database)

PostgreSQL

public PostgreSQL(processing.core.PApplet _papplet,
                  java.lang.String _server,
                  java.lang.String _database,
                  java.lang.String _user,
                  java.lang.String _pass)

Creates a new PostgreSQL connection.

Parameters:

_papplet - Normally you'd pass "this" in for your sketch

_server - The server running the database, try "localhost"

_database - Name of the database

_user - Username for that database

_pass - Password for user