The SQLDatabase class represents a SQL database connection.
The SQLDatabase class defines the following attributes.
|
|
|
|
connectionURL
|
String
|
The database connection URL
|
|
id
|
String
|
The database ID
|
|
name
|
String
|
The database name
|
|
password
|
String
|
The database password
|
|
sessionMode
|
String
|
The user session mode
|
|
type
|
String
|
The database type
|
|
username
|
String
|
The user name
|
The SQLDatabase class defines the following methods.
|
|
|
|
executeCustomQuery(String):int
|
Integer
|
Runs a non-read custom query on the database.
|
|
getAllTableNames():String[]
|
Array of Strings
|
Returns a list of all of the tables in the database.
|
|
getMappedTableNames():String[]
|
Array of Strings
|
Returns a list of all of the tables added to the database.
|
|
getTables():SQLTable[]
|
Array of SQL Tables
|
Returns a list of tables in the database.
|
|
getUnmappedTableNames():String[]
|
Array of Strings
|
Returns a list of tables that are not added to the database.
|
|
readCustomQuery(String):ResultSet
|
ResultSet
|
Runs a read custom query on the database and returns the results in a ResultSet.
|