|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.jdbwc.core.WCStatement
public class WCStatement
Extended JDBC-API implementation for java.sql.Statement.
See this packages Statement interface for extension method details.
Field Summary | |
---|---|
protected WCConnection |
myConnection
|
protected int |
myDirection
|
protected int |
myMaxSize
|
protected int |
mySize
|
protected int |
rsConcurrency
|
protected int |
rsHoldability
|
protected int |
rsType
|
static byte |
USES_VARIABLES_FALSE
|
static byte |
USES_VARIABLES_TRUE
|
static byte |
USES_VARIABLES_UNKNOWN
|
Fields inherited from interface java.sql.Statement |
---|
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO |
Constructor Summary | |
---|---|
protected |
WCStatement()
Constructs a new instance of this. This is not used for instantiation, only for accessing prtected variables. |
protected |
WCStatement(WCConnection connection)
|
Method Summary | ||
---|---|---|
void |
addBatch(java.lang.String sql)
|
|
void |
cancel()
|
|
void |
clearBatch()
|
|
void |
clearWarnings()
|
|
void |
close()
|
|
boolean |
execute(java.lang.String sql)
|
|
boolean |
execute(java.lang.String sql,
int autoGeneratedKeys)
|
|
boolean |
execute(java.lang.String sql,
int[] columnIndexes)
|
|
boolean |
execute(java.lang.String sql,
java.lang.String[] columnNames)
|
|
int[] |
executeBatch()
|
|
WCResultSet |
executeQuery(java.lang.String sql)
|
|
protected boolean |
executeStoredRoutine(java.lang.String sqlRoutine)
PHP has trouble with custom DELIMITERS. |
|
int |
executeUpdate(java.lang.String sql)
|
|
int |
executeUpdate(java.lang.String sql,
int autoGeneratedKeys)
|
|
int |
executeUpdate(java.lang.String sql,
int[] columnIndexes)
|
|
int |
executeUpdate(java.lang.String sql,
java.lang.String[] columnNames)
|
|
protected boolean |
executeWithResults(java.lang.String sqlRoutine)
ResultSets are stored in the extra results holder. If ResultSets were found this method returns true, otherwise it returns false. |
|
WCConnection |
getConnection()
|
|
int |
getFetchDirection()
|
|
int |
getFetchSize()
|
|
WCResultSet |
getGeneratedKeys()
|
|
int |
getMaxFieldSize()
|
|
int |
getMaxRows()
|
|
boolean |
getMoreResults()
|
|
boolean |
getMoreResults(int current)
|
|
int |
getQueryTimeout()
|
|
WCResultSet |
getResultSet()
|
|
int |
getResultSetConcurrency()
|
|
int |
getResultSetHoldability()
|
|
int |
getResultSetType()
|
|
int |
getRowAffected()
|
|
int[] |
getRowsAffected()
|
|
protected WCStatement |
getStatement()
|
|
int |
getUpdateCount()
|
|
java.sql.SQLWarning |
getWarnings()
|
|
boolean |
isClosed()
|
|
boolean |
isPoolable()
|
|
boolean |
isWrapperFor(java.lang.Class<?> iface)
|
|
protected static WCResultSet[] |
prepareForJava(WCConnection connection,
WCStatement statement,
java.lang.String query,
java.lang.String rawResult)
rawResult is in standard .CVS format as a String. "," seperates entries "\n" seperates rows "\n\n" seperates files ---------------------- "__NL_" should be replaced with "\n" "__CA_" should be replaced with "," |
|
void |
setCursorName(java.lang.String name)
|
|
void |
setEscapeProcessing(boolean enable)
|
|
void |
setFetchDirection(int direction)
|
|
void |
setFetchSize(int rows)
|
|
void |
setMaxFieldSize(int max)
|
|
void |
setMaxRows(int max)
|
|
void |
setPoolable(boolean poolable)
|
|
void |
setQueryTimeout(int seconds)
|
|
|
unwrap(java.lang.Class<T> iface)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final byte USES_VARIABLES_FALSE
public static final byte USES_VARIABLES_TRUE
public static final byte USES_VARIABLES_UNKNOWN
protected transient WCConnection myConnection
protected transient int rsType
protected transient int rsConcurrency
protected transient int rsHoldability
protected transient int myDirection
protected transient int mySize
protected transient int myMaxSize
Constructor Detail |
---|
protected WCStatement()
protected WCStatement(WCConnection connection)
Method Detail |
---|
protected WCStatement getStatement()
protected static WCResultSet[] prepareForJava(WCConnection connection, WCStatement statement, java.lang.String query, java.lang.String rawResult) throws java.sql.SQLException
rawResult
- String containing valid .cvs data. First row contains column names.
java.sql.SQLException
public void addBatch(java.lang.String sql) throws java.sql.SQLException
addBatch
in interface java.sql.Statement
java.sql.SQLException
public void cancel() throws java.sql.SQLException
cancel
in interface java.sql.Statement
java.sql.SQLException
public void clearBatch() throws java.sql.SQLException
clearBatch
in interface java.sql.Statement
java.sql.SQLException
public void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface java.sql.Statement
java.sql.SQLException
public void close() throws java.sql.SQLException
close
in interface java.sql.Statement
java.sql.SQLException
public boolean execute(java.lang.String sql) throws java.sql.SQLException
execute
in interface java.sql.Statement
java.sql.SQLException
protected boolean executeStoredRoutine(java.lang.String sqlRoutine) throws java.sql.SQLException
sqlRoutine
-
java.sql.SQLException
protected boolean executeWithResults(java.lang.String sqlRoutine) throws java.sql.SQLException
sqlRoutine
-
java.sql.SQLException
public boolean execute(java.lang.String sql, int autoGeneratedKeys) throws java.sql.SQLException
execute
in interface java.sql.Statement
java.sql.SQLException
public boolean execute(java.lang.String sql, int[] columnIndexes) throws java.sql.SQLException
execute
in interface java.sql.Statement
java.sql.SQLException
public boolean execute(java.lang.String sql, java.lang.String[] columnNames) throws java.sql.SQLException
execute
in interface java.sql.Statement
java.sql.SQLException
public int[] executeBatch() throws java.sql.SQLException
executeBatch
in interface java.sql.Statement
java.sql.SQLException
public WCResultSet executeQuery(java.lang.String sql) throws java.sql.SQLException
executeQuery
in interface java.sql.Statement
java.sql.SQLException
public int executeUpdate(java.lang.String sql) throws java.sql.SQLException
executeUpdate
in interface java.sql.Statement
java.sql.SQLException
public int executeUpdate(java.lang.String sql, int autoGeneratedKeys) throws java.sql.SQLException
executeUpdate
in interface java.sql.Statement
java.sql.SQLException
public int executeUpdate(java.lang.String sql, int[] columnIndexes) throws java.sql.SQLException
executeUpdate
in interface java.sql.Statement
java.sql.SQLException
public int executeUpdate(java.lang.String sql, java.lang.String[] columnNames) throws java.sql.SQLException
executeUpdate
in interface java.sql.Statement
java.sql.SQLException
public WCConnection getConnection() throws java.sql.SQLException
getConnection
in interface java.sql.Statement
java.sql.SQLException
public int getFetchDirection() throws java.sql.SQLException
getFetchDirection
in interface java.sql.Statement
java.sql.SQLException
public int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.Statement
java.sql.SQLException
public WCResultSet getGeneratedKeys() throws java.sql.SQLException
getGeneratedKeys
in interface java.sql.Statement
java.sql.SQLException
public int getRowAffected() throws java.sql.SQLException
java.sql.SQLException
public int[] getRowsAffected() throws java.sql.SQLException
java.sql.SQLException
public int getMaxFieldSize() throws java.sql.SQLException
getMaxFieldSize
in interface java.sql.Statement
java.sql.SQLException
public int getMaxRows() throws java.sql.SQLException
getMaxRows
in interface java.sql.Statement
java.sql.SQLException
public boolean getMoreResults() throws java.sql.SQLException
getMoreResults
in interface java.sql.Statement
java.sql.SQLException
public boolean getMoreResults(int current) throws java.sql.SQLException
getMoreResults
in interface java.sql.Statement
java.sql.SQLException
public int getQueryTimeout() throws java.sql.SQLException
getQueryTimeout
in interface java.sql.Statement
java.sql.SQLException
public WCResultSet getResultSet() throws java.sql.SQLException
getResultSet
in interface java.sql.Statement
java.sql.SQLException
public int getResultSetConcurrency() throws java.sql.SQLException
getResultSetConcurrency
in interface java.sql.Statement
java.sql.SQLException
public int getResultSetHoldability() throws java.sql.SQLException
getResultSetHoldability
in interface java.sql.Statement
java.sql.SQLException
public int getResultSetType() throws java.sql.SQLException
getResultSetType
in interface java.sql.Statement
java.sql.SQLException
public int getUpdateCount() throws java.sql.SQLException
getUpdateCount
in interface java.sql.Statement
java.sql.SQLException
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
getWarnings
in interface java.sql.Statement
java.sql.SQLException
public boolean isClosed() throws java.sql.SQLException
isClosed
in interface java.sql.Statement
java.sql.SQLException
public boolean isPoolable() throws java.sql.SQLException
isPoolable
in interface java.sql.Statement
java.sql.SQLException
public void setCursorName(java.lang.String name) throws java.sql.SQLException
setCursorName
in interface java.sql.Statement
java.sql.SQLException
public void setEscapeProcessing(boolean enable) throws java.sql.SQLException
setEscapeProcessing
in interface java.sql.Statement
java.sql.SQLException
public void setFetchDirection(int direction) throws java.sql.SQLException
setFetchDirection
in interface java.sql.Statement
java.sql.SQLException
public void setFetchSize(int rows) throws java.sql.SQLException
setFetchSize
in interface java.sql.Statement
java.sql.SQLException
public void setMaxFieldSize(int max) throws java.sql.SQLException
setMaxFieldSize
in interface java.sql.Statement
java.sql.SQLException
public void setMaxRows(int max) throws java.sql.SQLException
setMaxRows
in interface java.sql.Statement
java.sql.SQLException
public void setPoolable(boolean poolable) throws java.sql.SQLException
setPoolable
in interface java.sql.Statement
java.sql.SQLException
public void setQueryTimeout(int seconds) throws java.sql.SQLException
setQueryTimeout
in interface java.sql.Statement
java.sql.SQLException
public boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException
isWrapperFor
in interface java.sql.Wrapper
java.sql.SQLException
public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException
unwrap
in interface java.sql.Wrapper
java.sql.SQLException
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |