Package totalcross.sql

Interface Connection

All Superinterfaces:

java.lang.AutoCloseable

All Known Implementing Classes:

SQLite4JConnection, SQLiteConnection

public interface Connection
extends java.lang.AutoCloseable

Field Summary

Fields

Modifier and Type	Field	Description
static int	TRANSACTION_NONE
static int	TRANSACTION_READ_COMMITTED
static int	TRANSACTION_READ_UNCOMMITTED
static int	TRANSACTION_REPEATABLE_READ
static int	TRANSACTION_SERIALIZABLE

Method Summary

Modifier and Type	Method	Description
void	clearWarnings()
void	close()
void	commit()
Statement	createStatement()
Statement	createStatement(int resultSetType, int resultSetConcurrency)
boolean	getAutoCommit()
java.lang.String	getCatalog()
DatabaseMetaData	getMetaData()
int	getTransactionIsolation()
java.sql.SQLWarning	getWarnings()
boolean	isClosed()
boolean	isReadOnly()
java.lang.String	nativeSQL(java.lang.String sql)
PreparedStatement	prepareStatement(java.lang.String sql)
PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency)
void	rollback()
void	setAutoCommit(boolean autoCommit)
void	setCatalog(java.lang.String catalog)
void	setReadOnly(boolean readOnly)
void	setTransactionIsolation(int level)

Field Detail

TRANSACTION_NONE

static final int TRANSACTION_NONE

See Also:

Constant Field Values

TRANSACTION_READ_UNCOMMITTED

static final int TRANSACTION_READ_UNCOMMITTED

See Also:

Constant Field Values

TRANSACTION_READ_COMMITTED

static final int TRANSACTION_READ_COMMITTED

See Also:

Constant Field Values

TRANSACTION_REPEATABLE_READ

static final int TRANSACTION_REPEATABLE_READ

See Also:

Constant Field Values

TRANSACTION_SERIALIZABLE

static final int TRANSACTION_SERIALIZABLE

See Also:

Constant Field Values

Method Detail

createStatement

Statement createStatement()
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

PreparedStatement prepareStatement(java.lang.String sql)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

nativeSQL

java.lang.String nativeSQL(java.lang.String sql)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

setAutoCommit

void setAutoCommit(boolean autoCommit)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

getAutoCommit

boolean getAutoCommit()
               throws java.sql.SQLException

Throws:

java.sql.SQLException

commit

void commit()
     throws java.sql.SQLException

Throws:

java.sql.SQLException

rollback

void rollback()
       throws java.sql.SQLException

Throws:

java.sql.SQLException

close

void close()
    throws java.sql.SQLException

Specified by:

close in interface java.lang.AutoCloseable

Throws:

java.sql.SQLException

isClosed

boolean isClosed()
          throws java.sql.SQLException

Throws:

java.sql.SQLException

setReadOnly

void setReadOnly(boolean readOnly)
          throws java.sql.SQLException

Throws:

java.sql.SQLException

isReadOnly

boolean isReadOnly()
            throws java.sql.SQLException

Throws:

java.sql.SQLException

setCatalog

void setCatalog(java.lang.String catalog)
         throws java.sql.SQLException

Throws:

java.sql.SQLException

getCatalog

java.lang.String getCatalog()
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

setTransactionIsolation

void setTransactionIsolation(int level)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getTransactionIsolation

int getTransactionIsolation()
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getWarnings

java.sql.SQLWarning getWarnings()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

clearWarnings

void clearWarnings()
            throws java.sql.SQLException

Throws:

java.sql.SQLException

createStatement

Statement createStatement(int resultSetType,
                          int resultSetConcurrency)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

PreparedStatement prepareStatement(java.lang.String sql,
                                   int resultSetType,
                                   int resultSetConcurrency)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getMetaData

DatabaseMetaData getMetaData()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException