Connection Class
Used to connect to a database via JDBC
Constructors
public Connection( )
public Connection( java.sql.Connection conn )
Methods
close( ) returns void
Used to close a connection to the database, freeing up connections
commit( ) returns void
Used to explicitely commit changes made to the database.
execute( String sql ) returns void
Used to execute a prepared sql statement (e.g. "delete from my_table").
getConnection( ) returns java.sql.Connection
Used to retrieve the java.sql.Connection for this Connection
getConnectionSpeed( ) returns long
Used to retrieve the time it took to open the database connection
(in milliseconds)
getDatabase( ) returns javaxt.sql.Database
Used to return database information associated with this connection.
getRecordset( String sql ) returns javaxt.utils.Generator
Used to execute a SQL statement and returns a Recordset as an iterator.
The Recordset is read-only. Use the other getRecordset() method for
creating and updating records.
getRecordset( String sql, boolean readOnly ) returns javaxt.utils.Generator
Used to execute a SQL statement and returns a Recordset as an iterator.
This simplifies using the Recordset object insofar as it eliminate the
need to call the hasNext(), moveNext(), and close() methods. Instead,
you can execute a query and iterate through records like this:
Connection conn = db.getConnection();
for (Recordset rs : conn.getRecordset("select distinct(name) from contacts")){
System.out.println(rs.getValue(0));
}
conn.close();
isClosed( ) returns boolean
Used to determine whether the connection is closed.
isOpen( ) returns boolean
Used to determine whether the connection is open.
open( String ConnectionString ) returns boolean
Used to open a connection to the database.
ConnectionString | A jdbc connection string/url. All connection URLs have the following form: |
jdbc:[dbVendor]://[dbName][propertyList] Example: |
jdbc:derby://temp/my.db;user=admin;password=mypassword |
open( javaxt.sql.Database database ) returns boolean
Used to open a connection to the database.
open( java.sql.Connection conn ) returns boolean
Used to open a connection to the database using a JDBC Connection. This
is particularly useful when using JDBC connection pools.