public class TExcelConnection extends TConnection
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE
Constructor and Description |
---|
TExcelConnection(Properties props) |
Modifier and Type | Method and Description |
---|---|
void |
beginExcelTransaction()
Begin transaction method for Excel connections, This will reread the workbook and acquire the lock as well.
|
void |
close() |
void |
commit() |
Statement |
createStatement() |
Statement |
createStatement(String sql) |
org.apache.poi.ss.usermodel.Workbook |
getWorkbook() |
CallableStatement |
prepareCall(String sql) |
CallableStatement |
prepareCall(String sql,
int resultSetType,
int resultSetConcurrency) |
CallableStatement |
prepareCall(String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability) |
PreparedStatement |
prepareStatement(String sql) |
PreparedStatement |
prepareStatement(String sql,
int autoGeneratedKeys) |
PreparedStatement |
prepareStatement(String sql,
int[] columnIndexes) |
PreparedStatement |
prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency) |
PreparedStatement |
prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability) |
PreparedStatement |
prepareStatement(String sql,
String[] columnNames) |
void |
rollback() |
abort, clearWarnings, createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStatement, createStatement, createStruct, getAutoCommit, getCatalog, getClientInfo, getClientInfo, getHoldability, getMaxColumns, getMetaData, getNetworkTimeout, getPassword, getPath, getSchema, getTransactionIsolation, getType, getTypeMap, getUsername, getWarnings, hasHeader, isClosed, isReadOnly, isValid, isWrapperFor, nativeSQL, releaseSavepoint, rollback, setAutoCommit, setCatalog, setClientInfo, setClientInfo, setHoldability, setNetworkTimeout, setReadOnly, setSavepoint, setSavepoint, setSchema, setTransactionIsolation, setTypeMap, unwrap
public TExcelConnection(Properties props) throws SQLException
SQLException
public org.apache.poi.ss.usermodel.Workbook getWorkbook()
public Statement createStatement(String sql) throws SQLException
SQLException
public Statement createStatement() throws SQLException
SQLException
public PreparedStatement prepareStatement(String sql) throws SQLException
SQLException
public CallableStatement prepareCall(String sql) throws SQLException
SQLException
public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency) throws SQLException
SQLException
public CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency) throws SQLException
SQLException
public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
SQLException
public CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
SQLException
public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException
SQLException
public PreparedStatement prepareStatement(String sql, int[] columnIndexes) throws SQLException
SQLException
public PreparedStatement prepareStatement(String sql, String[] columnNames) throws SQLException
SQLException
public void beginExcelTransaction() throws SQLException
SQLException
public void commit() throws SQLException
commit
in interface Connection
commit
in class TConnection
SQLException
public void rollback() throws SQLException
rollback
in interface Connection
rollback
in class TConnection
SQLException
public void close() throws SQLException
close
in interface AutoCloseable
close
in interface Connection
close
in class TConnection
SQLException
Copyright © 2018 WSO2. All rights reserved.