com.inet.jj.cli
Class JJStatement
java.lang.Object
com.inet.jj.cli.JJStatement
- All Implemented Interfaces:
- java.sql.Statement
- Direct Known Subclasses:
- JJPreparedStatement
- public class JJStatement
- extends java.lang.Object
- implements java.sql.Statement
The JJStatement class is a implementation of the java.sql.Statement interface.
Statement objects obtained from i-net Konnekter can be cast to this class to access
i-net Konnekter - specific methods or to use JDBC 2.0 features under Java 1.1.x.
E.g. JJStatement st = (JJStatement)con.createStatement()
Below listed the i-net Konnekter - specific methods different from the JDBC API.
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 |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface java.sql.Statement |
execute, execute, execute, executeUpdate, executeUpdate, executeUpdate, getGeneratedKeys, getMoreResults, getResultSetHoldability |
addBatch
public void addBatch(java.lang.String sql)
throws java.sql.SQLException
- Specified by:
addBatch
in interface java.sql.Statement
- Throws:
java.sql.SQLException
cancel
public void cancel()
throws java.sql.SQLException
- Specified by:
cancel
in interface java.sql.Statement
- Throws:
java.sql.SQLException
clearBatch
public void clearBatch()
throws java.sql.SQLException
- Specified by:
clearBatch
in interface java.sql.Statement
- Throws:
java.sql.SQLException
clearWarnings
public void clearWarnings()
throws java.sql.SQLException
- Specified by:
clearWarnings
in interface java.sql.Statement
- Throws:
java.sql.SQLException
close
public void close()
throws java.sql.SQLException
- Specified by:
close
in interface java.sql.Statement
- Throws:
java.sql.SQLException
finalize
public void finalize()
execute
public boolean execute(java.lang.String sql)
throws java.sql.SQLException
- Specified by:
execute
in interface java.sql.Statement
- Throws:
java.sql.SQLException
executeCommand
public boolean executeCommand(java.lang.String cmd)
throws java.sql.SQLException
- Execute the specified command saved on the server that may return multiple results.
- Parameters:
cmd
- the command name.
- Returns:
true
if the next result is a ResultSet; false
if it is an update count or there are no more results
- Throws:
java.sql.SQLException
- if a database access error occurs- See Also:
JJServer.addCommand(String, String)
,
JJServer.addCommand(String, JavaCommandFactory)
executeBatch
public int[] executeBatch()
throws java.sql.SQLException
- Specified by:
executeBatch
in interface java.sql.Statement
- Throws:
java.sql.SQLException
executeQuery
public java.sql.ResultSet executeQuery(java.lang.String sql)
throws java.sql.SQLException
- Specified by:
executeQuery
in interface java.sql.Statement
- Throws:
java.sql.SQLException
executeQueryCommand
public java.sql.ResultSet executeQueryCommand(java.lang.String cmd)
throws java.sql.SQLException
- Execute the specified command saved on the server that returns a single ResultSet.
- Parameters:
cmd
- the command name.
- Returns:
- a java.sql.ResultSet that contains the data produced by the query; never null
- Throws:
java.sql.SQLException
- if a database access error occurs- See Also:
JJServer.addCommand(String, String)
,
JJServer.addCommand(String, JavaCommandFactory)
executeUpdate
public int executeUpdate(java.lang.String sql)
throws java.sql.SQLException
- Specified by:
executeUpdate
in interface java.sql.Statement
- Throws:
java.sql.SQLException
executeUpdateCommand
public int executeUpdateCommand(java.lang.String cmd)
throws java.sql.SQLException
- Execute the specified command saved on the server.
- Parameters:
cmd
- the command name.
- Returns:
- either the row count for INSERT, UPDATE or DELETE or 0 for SQL statements that return nothing.
- Throws:
java.sql.SQLException
- if a database access error occurs- See Also:
JJServer.addCommand(String, String)
,
JJServer.addCommand(String, JavaCommandFactory)
getConnection
public java.sql.Connection getConnection()
throws java.sql.SQLException
- Specified by:
getConnection
in interface java.sql.Statement
- Throws:
java.sql.SQLException
getFetchDirection
public int getFetchDirection()
throws java.sql.SQLException
- Specified by:
getFetchDirection
in interface java.sql.Statement
- Throws:
java.sql.SQLException
getFetchSize
public int getFetchSize()
throws java.sql.SQLException
- Specified by:
getFetchSize
in interface java.sql.Statement
- Throws:
java.sql.SQLException
getMaxFieldSize
public int getMaxFieldSize()
throws java.sql.SQLException
- Specified by:
getMaxFieldSize
in interface java.sql.Statement
- Throws:
java.sql.SQLException
getMaxRows
public int getMaxRows()
throws java.sql.SQLException
- Specified by:
getMaxRows
in interface java.sql.Statement
- Throws:
java.sql.SQLException
getMoreResults
public boolean getMoreResults()
throws java.sql.SQLException
- Specified by:
getMoreResults
in interface java.sql.Statement
- Throws:
java.sql.SQLException
getQueryTimeout
public int getQueryTimeout()
throws java.sql.SQLException
- Specified by:
getQueryTimeout
in interface java.sql.Statement
- Throws:
java.sql.SQLException
getResultSet
public java.sql.ResultSet getResultSet()
throws java.sql.SQLException
- Specified by:
getResultSet
in interface java.sql.Statement
- Throws:
java.sql.SQLException
getResultSetConcurrency
public int getResultSetConcurrency()
throws java.sql.SQLException
- Specified by:
getResultSetConcurrency
in interface java.sql.Statement
- Throws:
java.sql.SQLException
getResultSetType
public int getResultSetType()
throws java.sql.SQLException
- Specified by:
getResultSetType
in interface java.sql.Statement
- Throws:
java.sql.SQLException
getUpdateCount
public int getUpdateCount()
throws java.sql.SQLException
- Specified by:
getUpdateCount
in interface java.sql.Statement
- Throws:
java.sql.SQLException
getWarnings
public java.sql.SQLWarning getWarnings()
throws java.sql.SQLException
- Specified by:
getWarnings
in interface java.sql.Statement
- Throws:
java.sql.SQLException
setCursorName
public void setCursorName(java.lang.String name)
throws java.sql.SQLException
- Specified by:
setCursorName
in interface java.sql.Statement
- Throws:
java.sql.SQLException
setEscapeProcessing
public void setEscapeProcessing(boolean enable)
throws java.sql.SQLException
- Specified by:
setEscapeProcessing
in interface java.sql.Statement
- Throws:
java.sql.SQLException
setFetchDirection
public void setFetchDirection(int direction)
throws java.sql.SQLException
- Specified by:
setFetchDirection
in interface java.sql.Statement
- Throws:
java.sql.SQLException
setFetchSize
public void setFetchSize(int rows)
throws java.sql.SQLException
- Specified by:
setFetchSize
in interface java.sql.Statement
- Throws:
java.sql.SQLException
setMaxFieldSize
public void setMaxFieldSize(int max)
throws java.sql.SQLException
- Specified by:
setMaxFieldSize
in interface java.sql.Statement
- Throws:
java.sql.SQLException
setMaxRows
public void setMaxRows(int max)
throws java.sql.SQLException
- Specified by:
setMaxRows
in interface java.sql.Statement
- Throws:
java.sql.SQLException
setQueryTimeout
public void setQueryTimeout(int seconds)
throws java.sql.SQLException
- Specified by:
setQueryTimeout
in interface java.sql.Statement
- Throws:
java.sql.SQLException
copyright by i-net software