de.bezier.data.sql
Class MySQL

java.lang.Object
  extended by de.bezier.data.sql.SQL
      extended by de.bezier.data.sql.MySQL

public class MySQL
extends SQL

MySQL wrapper for SQL library for Processing 2+

A wrapper around some of sun's java.sql.* classes and the "com.mysql.jdbc.Driver" driver by mysql.com (GPL).

see: - http://www.mysql.com/products/connector/j/ - http://java.sun.com/products/jdbc/

Author:
Florian Jenett - mail@florianjenett.de created: 07.05.2005 - 12:46 Uhr modified: 2012-02

Field Summary
 
Fields inherited from class de.bezier.data.sql.SQL
connection, database, driver, previousQuery, result, server, statement, type, url, user
 
Constructor Summary
MySQL(processing.core.PApplet _papplet, java.lang.String _database)
           
MySQL(processing.core.PApplet _papplet, java.lang.String _server, java.lang.String _database, java.lang.String _user, java.lang.String _pass)
          Creates a new MySQL connection.
 
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

MySQL

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

MySQL

public MySQL(processing.core.PApplet _papplet,
             java.lang.String _server,
             java.lang.String _database,
             java.lang.String _user,
             java.lang.String _pass)
Creates a new MySQL 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
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


Processing library BezierSQLib (formerly SQLibrary) by Florian Jenett. (c) 2005 - 2012