atavism.agis.database

Class Queries

java.lang.Object

atavism.agis.database.Queries

Direct Known Subclasses:

AdminQueries, ArenaQueries, AuthQueries

public class Queries
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
protected java.sql.Connection	con
protected java.lang.String	DATABASEDRIVER
protected java.lang.String	DATABASENAME
protected java.lang.String	DBTIMEZONE
protected java.lang.String	IPADDRESS
protected java.lang.String	PASSWORD
protected int	PORT
protected java.lang.String	USERNAME

Constructor Summary

Constructors

Constructor and Description
Queries(boolean keepAlive)

Method Summary

Modifier and Type	Method and Description
protected void	checkConnection()
void	close()
int	executeInsert(java.sql.PreparedStatement ps)
int	executeInsert(java.lang.String query)
java.sql.ResultSet	executeSelect(java.sql.PreparedStatement ps)
int	executeUpdate(java.sql.PreparedStatement ps)
int	executeUpdate(java.lang.String query)
protected void	finalize()
java.lang.String	getConnectionString()
java.sql.Connection	initConnection()
protected boolean	loadStrings()
protected void	ping() Runs a select statement to make sure we can still talk to the database.
java.sql.PreparedStatement	prepare(java.lang.String sql)

Methods inherited from class java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

con

protected java.sql.Connection con

PORT

protected int PORT

DBTIMEZONE

protected java.lang.String DBTIMEZONE

USERNAME

protected java.lang.String USERNAME

PASSWORD

protected java.lang.String PASSWORD

IPADDRESS

protected java.lang.String IPADDRESS

DATABASENAME

protected java.lang.String DATABASENAME

DATABASEDRIVER

protected java.lang.String DATABASEDRIVER

Constructor Detail

Queries

public Queries(boolean keepAlive)

Method Detail

loadStrings

protected boolean loadStrings()

getConnectionString

public java.lang.String getConnectionString()

initConnection

public java.sql.Connection initConnection()

finalize

protected void finalize()
                 throws java.lang.Throwable

Overrides:

finalize in class java.lang.Object

Throws:

java.lang.Throwable

close

public void close()

prepare

public java.sql.PreparedStatement prepare(java.lang.String sql)

executeSelect

public java.sql.ResultSet executeSelect(java.sql.PreparedStatement ps)

executeInsert

public int executeInsert(java.lang.String query)

executeInsert

public int executeInsert(java.sql.PreparedStatement ps)

executeUpdate

public int executeUpdate(java.lang.String query)

executeUpdate

public int executeUpdate(java.sql.PreparedStatement ps)

checkConnection

protected void checkConnection()

ping

protected void ping()

Runs a select statement to make sure we can still talk to the database.