public class SQLite extends SQL
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:| Constructor and Description |
|---|
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 )
|
| Modifier and Type | Method and Description |
|---|---|
java.lang.String[] |
getTableNames()
Get names of available tables in active database,
needs to be implemented per db adapter.
|
close, connect, dispose, escape, execute, execute, getBigDecimal, getBigDecimal, getBlob, getBlob, 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, setNameMapperpublic SQLite(processing.core.PApplet _papplet,
java.lang.String _database)
_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 filepublic SQLite(processing.core.PApplet _papplet,
java.lang.String _server,
java.lang.String _database,
java.lang.String _user,
java.lang.String _pass)
_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 - Ignoredpublic java.lang.String[] getTableNames()
SQLgetTableNames in class SQLProcessing library BezierSQLib (formerly SQLibrary) by Florian Jenett. (c) 2005 - 2023