Package br.ufsc.labsec.signature.database

Class SqlDatabase

java.lang.Object

br.ufsc.labsec.signature.database.SqlDatabase

All Implemented Interfaces:

Database

Direct Known Subclasses:

DatabaseImpl

public abstract class SqlDatabase
extends Object
implements Database

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	SqlDatabase(DatabaseConnectionCreator connectionCreator)

Method Summary

Modifier and Type	Method	Description
boolean	close()
void	createDatabase()
protected abstract void	createTables()
IntermediaryQueryResult	executeStatement(String sql, Object... params)	Executa uma query no banco de dados
protected String	inStatement(String statement, int size)	Constrói uma query SQL com o argumento in com um número variável de parâmetros

Methods inherited from class java.lang.Object

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

Constructor Details

SqlDatabase

protected SqlDatabase(DatabaseConnectionCreator connectionCreator)

Method Details

createDatabase

public void createDatabase()

Specified by:

createDatabase in interface Database

createTables

protected abstract void createTables()

executeStatement

public IntermediaryQueryResult executeStatement(@Language("SQL")
String sql,
Object... params)

Executa uma query no banco de dados

Specified by:

executeStatement in interface Database

Parameters:

sql - Query SQL

params - Parâmetros da query

Returns:

Resultado da query

inStatement

protected String inStatement(@Language("SQL")
String statement,
int size)

Constrói uma query SQL com o argumento in com um número variável de parâmetros

Parameters:

statement - Query SQL

size - Número de parâmetros

Returns:

Query SQL com o argumento in

close

public boolean close()

Specified by:

close in interface Database