Package totalcross.sql.sqlite4j

Class SQLite4JConnection

java.lang.Object

totalcross.sql.sqlite4j.SQLite4JConnection

All Implemented Interfaces:

java.lang.AutoCloseable, Connection

public class SQLite4JConnection
extends java.lang.Object
implements Connection

Field Summary

Fields

Modifier and Type	Field	Description
org.sqlite.SQLiteConnection	con

Fields inherited from interface totalcross.sql.Connection

TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Constructor Summary

Constructors

Constructor	Description
SQLite4JConnection(org.sqlite.SQLiteConnection con)

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)

Methods inherited from class java.lang.Object

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

Field Detail

con

public org.sqlite.SQLiteConnection con

Constructor Detail

SQLite4JConnection

public SQLite4JConnection(org.sqlite.SQLiteConnection con)

Method Detail

createStatement

public Statement createStatement()
                          throws java.sql.SQLException

Specified by:

createStatement in interface Connection

Throws:

java.sql.SQLException

prepareStatement

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

Specified by:

prepareStatement in interface Connection

Throws:

java.sql.SQLException

nativeSQL

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

Specified by:

nativeSQL in interface Connection

Throws:

java.sql.SQLException

setAutoCommit

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

Specified by:

setAutoCommit in interface Connection

Throws:

java.sql.SQLException

getAutoCommit

public boolean getAutoCommit()
                      throws java.sql.SQLException

Specified by:

getAutoCommit in interface Connection

Throws:

java.sql.SQLException

commit

public void commit()
            throws java.sql.SQLException

Specified by:

commit in interface Connection

Throws:

java.sql.SQLException

rollback

public void rollback()
              throws java.sql.SQLException

Specified by:

rollback in interface Connection

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface Connection

Throws:

java.sql.SQLException

isClosed

public boolean isClosed()
                 throws java.sql.SQLException

Specified by:

isClosed in interface Connection

Throws:

java.sql.SQLException

setReadOnly

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

Specified by:

setReadOnly in interface Connection

Throws:

java.sql.SQLException

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException

Specified by:

isReadOnly in interface Connection

Throws:

java.sql.SQLException

setCatalog

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

Specified by:

setCatalog in interface Connection

Throws:

java.sql.SQLException

getCatalog

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

Specified by:

getCatalog in interface Connection

Throws:

java.sql.SQLException

setTransactionIsolation

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

Specified by:

setTransactionIsolation in interface Connection

Throws:

java.sql.SQLException

getTransactionIsolation

public int getTransactionIsolation()
                            throws java.sql.SQLException

Specified by:

getTransactionIsolation in interface Connection

Throws:

java.sql.SQLException

getWarnings

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

Specified by:

getWarnings in interface Connection

Throws:

java.sql.SQLException

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Specified by:

clearWarnings in interface Connection

Throws:

java.sql.SQLException

createStatement

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

Specified by:

createStatement in interface Connection

Throws:

java.sql.SQLException

prepareStatement

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

Specified by:

prepareStatement in interface Connection

Throws:

java.sql.SQLException

getMetaData

public DatabaseMetaData getMetaData()
                             throws java.sql.SQLException

Specified by:

getMetaData in interface Connection

Throws:

java.sql.SQLException