Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep

Class DBServer  view DBServer download

  extended byopenfuture.util.database.DBServer
Direct Known Subclasses:
HyperSQLServer, MySqlServer

public abstract class DBServer
extends java.lang.Object

Abstract JDBC database server.

Created: Tue Feb 08 05:52:56 2000

$Revision: 1.3 $

Field Summary
static java.lang.String AUTO_INCREMENT
          Datatype AUTO_INCREMENT.
static java.lang.String BLOB
          Datatype BLOB.
private  java.sql.Connection connection
private  java.sql.Driver driver
static java.lang.String LAST_INSERT_ID
          Datatype LAST_INSERT_ID.
private  java.lang.String password
private  java.lang.String url
private  java.lang.String user
protected static java.lang.String[] usertables
Constructor Summary
Method Summary
protected abstract  void checkDriver()
          Check, if a driver is already registered.
 java.sql.Connection createConnection(java.lang.String user, java.lang.String password)
          Create a new connection to the database.
 java.lang.Integer executeIndexedQuery(java.sql.Statement statement, java.lang.String sqlcommand)
          Execute an SQL query, that inserts a row into a table with an auto increment column.
protected  void finalize()
          Called on an object by the Virtual Machine at most once, at some point after the Object is determined unreachable but before it is destroyed.
 java.sql.Connection getConnection(java.lang.String user, java.lang.String password)
          Get the of connection to the database.
 java.sql.Driver getDriver()
          Get the value of driver.
 java.lang.String getPassword()
          Get the value of password.
 java.lang.String getUser()
          Get the value of user.
 void init(java.lang.String url)
          Initialize the database pointed at by url
 void setConnection(java.sql.Connection v)
          Set the value of connection.
 void setDriver(java.sql.Driver v)
          Set the value of driver.
 void setPassword(java.lang.String v)
          Set the value of password.
 void setUser(java.lang.String v)
          Set the value of user.
 java.lang.String sqlTranslate(java.lang.String s)
          Translate SQL constructs into database specific syntax.
static boolean tableExists(java.sql.Connection connection, java.lang.String name)
          Check, if the table name exists.
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail


public static final java.lang.String BLOB
Datatype BLOB.

See Also:
Constant Field Values


public static final java.lang.String LAST_INSERT_ID

See Also:
Constant Field Values


public static final java.lang.String AUTO_INCREMENT

See Also:
Constant Field Values


private java.lang.String url


private java.lang.String user


private java.lang.String password


private java.sql.Connection connection


private java.sql.Driver driver


protected static final java.lang.String[] usertables
Constructor Detail


public DBServer()
Method Detail


public void init(java.lang.String url)
Initialize the database pointed at by url


public java.sql.Connection getConnection(java.lang.String user,
                                         java.lang.String password)
                                  throws java.sql.SQLException
Get the of connection to the database. If the user/password have changed since the last connection, a new connection is established.


public void setConnection(java.sql.Connection v)
Set the value of connection.


public java.sql.Connection createConnection(java.lang.String user,
                                            java.lang.String password)
                                     throws java.sql.SQLException
Create a new connection to the database.


public java.lang.String getUser()
Get the value of user.


public void setUser(java.lang.String v)
Set the value of user.


public java.lang.String getPassword()
Get the value of password.


public void setPassword(java.lang.String v)
Set the value of password.


public java.sql.Driver getDriver()
Get the value of driver.


public void setDriver(java.sql.Driver v)
Set the value of driver.


public java.lang.String sqlTranslate(java.lang.String s)
Translate SQL constructs into database specific syntax. This method implements the identity. Override this method in super classes for database specifics.


public static boolean tableExists(java.sql.Connection connection,
                                  java.lang.String name)
Check, if the table name exists. In order to check this, the connection is used.


public java.lang.Integer executeIndexedQuery(java.sql.Statement statement,
                                             java.lang.String sqlcommand)
                                      throws java.sql.SQLException
Execute an SQL query, that inserts a row into a table with an auto increment column.


protected void finalize()
                 throws java.lang.Throwable
Description copied from class: java.lang.Object
Called on an object by the Virtual Machine at most once, at some point after the Object is determined unreachable but before it is destroyed. You would think that this means it eventually is called on every Object, but this is not necessarily the case. If execution terminates abnormally, garbage collection does not always happen. Thus you cannot rely on this method to always work. For finer control over garbage collection, use references from the java.lang.ref package.

Virtual Machines are free to not call this method if they can determine that it does nothing important; for example, if your class extends Object and overrides finalize to do simply super.finalize().

finalize() will be called by a java.lang.Thread that has no locks on any Objects, and may be called concurrently. There are no guarantees on the order in which multiple objects are finalized. This means that finalize() is usually unsuited for performing actions that must be thread-safe, and that your implementation must be use defensive programming if it is to always work.

If an Exception is thrown from finalize() during garbage collection, it will be patently ignored and the Object will still be destroyed.

It is allowed, although not typical, for user code to call finalize() directly. User invocation does not affect whether automatic invocation will occur. It is also permitted, although not recommended, for a finalize() method to "revive" an object by making it reachable from normal code again.

Unlike constructors, finalize() does not get called for an object's superclass unless the implementation specifically calls super.finalize().

The default implementation does nothing.


protected abstract void checkDriver()
                             throws java.sql.SQLException
Check, if a driver is already registered. If not, register the specific driver.