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, setNameMapper
public 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()
SQL
getTableNames
in class SQL
Processing library BezierSQLib (formerly SQLibrary) by Florian Jenett. (c) 2005 - 2023