de.bezier.data.sql
Class SQLite

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

public class SQLite
extends SQL

SQLite wrapper for SQL library for Processing 2+

A wrapper around some of sun's java.sql.* classes and the pure java "org.sqlite.JDBC" driver of the Xerial project (Apache 2 license).

see:

• http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC
• http://www.xerial.org/maven/repository/site/xerial-project/sqlite-jdbc/apidocs/index.html?index-all.html
• http://java.sun.com/products/jdbc/

Author:

Florian Jenett - mail@florianjenett.de created: 2008-11-29 12:15:15 - fjenett modified: fjenett 20121217

Field Summary

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

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

Constructor Summary

SQLite(processing.core.PApplet _papplet, java.lang.String _database)
Creates a new SQLite connection.

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

Method Summary

java.lang.String[]

getTableNames() Get names of available tables in active database, needs to be implemented per db adapter.

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

close, connect, dispose, escape, execute, execute, getBigDecimal, getBigDecimal, getBoolean, getBoolean, getColumnNames, getConnection, getDate, getDate, getDebug, getDouble, getDouble, getDriverVersion, getFloat, getFloat, getInt, getInt, getLong, getLong, getNameMapper, getObject, getObject, getString, getString, getTime, getTime, getTimestamp, getTimestamp, insertUpdateInDatabase, nameToGetter, nameToSetter, next, query, query, registerTableNameForClass, saveToDatabase, saveToDatabase, setDebug, setFromRow, setNameMapper

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLite

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

Creates a new SQLite connection.

Parameters:

_papplet - Your sketch, pass "this" in here

_database - Path to the database file, if this is just a name the data and sketch folders are searched for the file

SQLite

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

Creates a new SQLite connection, same as SQLite( PApplet, String )

Parameters:

_papplet - Your sketch, pass "this" in here

_server - Ignored

_database - Path to the database file, if this is just a name the data and sketch folders are searched for the file

_user - Ignored

_pass - Ignored

Method Detail

getTableNames

public java.lang.String[] getTableNames()

Description copied from class: SQL

Get names of available tables in active database, needs to be implemented per db adapter.

Specified by:

getTableNames in class SQL

Returns:

String[] The table names