fr.cnes.genius.sqlite

Class SqliteBase

java.lang.Object

fr.cnes.genius.sqlite.SqliteBase

Direct Known Subclasses:

ResultReader, ResultWriter

public class SqliteBase
extends Object

Class base for SQLite operations.

Author:

escc

Field Summary

Fields

Modifier and Type	Field and Description
protected static String	COMMA Comma field constant.
protected static String	DEFINITION_SUFIX Definition constant.
protected static String	DESCRIPTION Description field constant.
protected static String	GAP_THRESHOLD Gap threshold field constant.
protected static String	NAME Name field constant.
protected static String	TYPE Type field constant.
protected static String	UNIT Unit field constant.
protected static String	USER_VISIBLE Show the column to the user.

Constructor Summary

Constructors

Constructor and Description
SqliteBase(File newFile) Default constructor.

Method Summary

Modifier and Type	Method and Description
void	close() Close the SQL connection.
protected void	executeStatement(String sql) Execute the SQL statement.
protected PreparedStatement	getPreparedStatement(String sql) Get the prepared statement from the SQL value.
protected Statement	getStatement() Get the statement from the SQL value.
void	open() Open the SQL connection.

Methods inherited from class java.lang.Object

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

Field Detail

DEFINITION_SUFIX

protected static final String DEFINITION_SUFIX

Definition constant.

See Also:

Constant Field Values

TYPE

protected static final String TYPE

Type field constant.

See Also:

Constant Field Values

DESCRIPTION

protected static final String DESCRIPTION

Description field constant.

See Also:

Constant Field Values

GAP_THRESHOLD

protected static final String GAP_THRESHOLD

Gap threshold field constant.

See Also:

Constant Field Values

USER_VISIBLE

protected static final String USER_VISIBLE

Show the column to the user.

See Also:

Constant Field Values

UNIT

protected static final String UNIT

Unit field constant.

See Also:

Constant Field Values

NAME

protected static final String NAME

Name field constant.

See Also:

Constant Field Values

COMMA

protected static final String COMMA

Comma field constant.

See Also:

Constant Field Values

Constructor Detail

SqliteBase

public SqliteBase(File newFile)

Default constructor.

Parameters:

newFile - to use

Method Detail

open

public void open()
          throws SqliteException

Open the SQL connection.

Throws:

SqliteException - in case of error

close

public void close()

Close the SQL connection.

executeStatement

protected void executeStatement(String sql)
                         throws SqliteException

Execute the SQL statement.

Parameters:

sql - to execute

Throws:

SqliteException - in case of error

getPreparedStatement

protected PreparedStatement getPreparedStatement(String sql)
                                          throws SqliteException

Get the prepared statement from the SQL value.

Parameters:

sql - value

Returns:

the prepared statement

Throws:

SqliteException - in case of error

getStatement

protected Statement getStatement()
                          throws SqliteException

Get the statement from the SQL value.

Returns:

the SQL statement

Throws:

SqliteException - in case of error