Java Doc for UniversalPrepStmt.java in  » Workflow-Engines » wfmopen-2.1.1 » de » danet » an » util » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation
1. 6.0 JDK Core
2. 6.0 JDK Modules
3. 6.0 JDK Modules com.sun
4. 6.0 JDK Modules com.sun.java
5. 6.0 JDK Modules sun
6. 6.0 JDK Platform
7. Ajax
8. Apache Harmony Java SE
9. Aspect oriented
10. Authentication Authorization
11. Blogger System
12. Build
13. Byte Code
14. Cache
15. Chart
16. Chat
17. Code Analyzer
18. Collaboration
19. Content Management System
20. Database Client
21. Database DBMS
22. Database JDBC Connection Pool
23. Database ORM
24. Development
25. EJB Server geronimo
26. EJB Server GlassFish
27. EJB Server JBoss 4.2.1
28. EJB Server resin 3.1.5
29. ERP CRM Financial
30. ESB
31. Forum
32. GIS
33. Graphic Library
34. Groupware
35. HTML Parser
36. IDE
37. IDE Eclipse
38. IDE Netbeans
39. Installer
40. Internationalization Localization
41. Inversion of Control
42. Issue Tracking
43. J2EE
44. JBoss
45. JMS
46. JMX
47. Library
48. Mail Clients
49. Net
50. Parser
51. PDF
52. Portal
53. Profiler
54. Project Management
55. Report
56. RSS RDF
57. Rule Engine
58. Science
59. Scripting
60. Search Engine
61. Security
62. Sevlet Container
63. Source Control
64. Swing Library
65. Template Engine
66. Test Coverage
67. Testing
68. UML
69. Web Crawler
70. Web Framework
71. Web Mail
72. Web Server
73. Web Services
74. Web Services apache cxf 2.0.1
75. Web Services AXIS2
76. Wiki Engine
77. Workflow Engines
78. XML
79. XML UI
Java
Java Tutorial
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Java Source Code / Java Documentation » Workflow Engines » wfmopen 2.1.1 » de.danet.an.util 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   de.danet.an.util.UniversalPrepStmt

UniversalPrepStmt
public class UniversalPrepStmt implements PreparedStatement(Code)
This class provides a wrapper that can handle special database requirements. Although suitable for all jdbc-driven database connections, special features of the following databases are supported: Oracle, SAPDB and Hypersonic. In addition, all set/get methods for non-primitives handle null values correctly.

Additional methods UniversalPrepStmt.setBinary setBinary and UniversalPrepStmt.setInt(int,Integer) setInt(int, Integer) UniversalPrepStmt.setLargeString setLargeString are provided for convenience.
author:
  
version:
   $Revision: 1.7 $




Constructor Summary
public  UniversalPrepStmt(Connection connection, String statement)
     Creates an instance of UniversalPrepStmt with no given primary key columns, thus assuming the 1st column of the insert statement being primary key column.
public  UniversalPrepStmt(DataSource dataSource, Connection connection, String statement)
     Creates an instance of UniversalPrepStmt with no given primary key columns, thus assuming the 1st column of the insert statement being primary key column.
public  UniversalPrepStmt(Connection connection, String statement, String primaryKeyColumns)
     Creates an instance of UniversalPrepStmt.
public  UniversalPrepStmt(Connection connection, String statement, String[] primaryKeyColumns)
     Creates an instance of UniversalPrepStmt.
public  UniversalPrepStmt(DataSource dataSource, Connection connection, String statement, String primaryKeyColumns)
     Creates an instance of UniversalPrepStmt.
public  UniversalPrepStmt(DataSource dataSource, Connection connection, String statement, String[] primaryKeyColumns)
     Creates an instance of UniversalPrepStmt.

Method Summary
public  voidaddBatch(String string)
     Calls the addBatch method on the delegee prepared statement.
public  voidaddBatch()
     Calls the addBatch method on the delegee prepared statement.
public  voidcancel()
     Calls the cancel method on the delegee prepared statement.
public  voidclearBatch()
     Calls the clearBatch method on the delegee prepared statement.
public  voidclearParameters()
     Calls the clearParameters method on the delegee prepared statement.
public  voidclearWarnings()
     Calls the clearWarnings method on the delegee prepared statement.
public  voidclose()
     Calls the close method on the delegee prepared statement.
public  booleanexecute(String string)
     Calls the execute method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value.
public  booleanexecute(String string, int autoGeneratedKeys)
     Calls the execute method on the delegee prepared statement.
public  booleanexecute(String string, int[] columnIndexes)
     Calls the execute method on the delegee prepared statement.
public  booleanexecute(String string, String[] columnNames)
     Calls the execute method on the delegee prepared statement.
public  booleanexecute()
     Calls the execute method on the delegee prepared statement.
public  int[]executeBatch()
     Calls the executeBatch method on the delegee prepared statement.
public  ResultSetexecuteQuery(String string)
     Calls the executeQuery method on the delegee prepared statement.
public  ResultSetexecuteQuery()
     Calls the executeQuery method on the delegee prepared statement.
public  intexecuteUpdate(String string)
     Calls the executeUpdate method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value.
public  intexecuteUpdate(String string, int autoGeneratedKeys)
     Calls the executeUpdate method on the delegee prepared statement.
public  intexecuteUpdate(String string, int[] columnIndexes)
     Calls the executeUpdate method on the delegee prepared statement.
public  intexecuteUpdate(String string, String[] columnNames)
     Calls the executeUpdate method on the delegee prepared statement.
public  intexecuteUpdate()
     Calls the executeUpdate method on the delegee prepared statement and then execute the builded selectForUpdate statement to lob datas.
public  ConnectiongetConnection()
     Return the database connection.
public  intgetFetchDirection()
     Calls the getFetchDirection method on the delegee prepared statement.
public  intgetFetchSize()
     Calls the getFetchSize method on the delegee prepared statement.
public  ResultSetgetGeneratedKeys()
     Calls the getGeneratedKeys method on the delegee prepared statement.
public  intgetMaxFieldSize()
     Calls the getMaxFieldSize method on the delegee prepared statement.
public  intgetMaxRows()
     Calls the getMaxRows method on the delegee prepared statement.
public  ResultSetMetaDatagetMetaData()
     Calls the getMetaData method on the delegee prepared statement.
public  booleangetMoreResults()
     Calls the getMoreResults method on the delegee prepared statement.
public  booleangetMoreResults(int current)
     Calls the getMoreResults method on the delegee prepared statement.
public  ParameterMetaDatagetParameterMetaData()
     Calls the getParameterMetaData method on the delegee prepared statement.
public  intgetQueryTimeout()
     Calls the getQueryTimeout method on the delegee prepared statement.
public  ResultSetgetResultSet()
     Calls the getResultSet method on the delegee prepared statement.
public  intgetResultSetConcurrency()
     Calls the getResultSetConcurrency method on the delegee prepared statement.
public  intgetResultSetHoldability()
     Calls the getResultSetHoldability method on the delegee prepared statement.
public  intgetResultSetType()
     Calls the getResultSetType method on the delegee prepared statement.
public  intgetUpdateCount()
     Calls the getUpdateCount method on the delegee prepared statement.
public  SQLWarninggetWarnings()
     Calls the getWarnings method on the delegee prepared statement.
public  voidsetArray(int n, Array array)
     Calls the setArray method on the delegee prepared statement.
public  voidsetAsciiStream(int n, InputStream inputStream, int n1)
     Calls the setAsciiStream method on the delegee prepared statement.
public  voidsetBigDecimal(int n, BigDecimal bigDecimal)
     Calls the setBigDecimal method on the delegee prepared statement.
public  voidsetBinary(int offset, Object data)
     Store the object.
public  voidsetBinaryStream(int n, InputStream inputStream, int n1)
     Calls UniversalPrepStmt.setBinaryStream setBinaryStream or UniversalPrepStmt.setBlob setBlob depends on the driver for the delegee prepared statement.
public  voidsetBlob(int n, Blob blob)
     Calls the setBlob method on the delegee prepared statement.
public  voidsetBoolean(int n, boolean flag)
     Calls the setBoolean method on the delegee prepared statement.
public  voidsetByte(int n, byte b)
     Calls the setByte method on the delegee prepared statement.
public  voidsetBytes(int n, byte[] byteArray)
     Store the object.
public  voidsetCharacterStream(int n, Reader reader, int n1)
     Calls the setCharacterStream method on the delegee prepared statement.
public  voidsetClob(int n, Clob clob)
     Calls the setClob method on the delegee prepared statement.
public  voidsetCursorName(String string)
     Calls the setCursorName method on the delegee prepared statement.
public  voidsetDate(int n, Date date, Calendar calendar)
     Calls the setDate method on the delegee prepared statement.
public  voidsetDate(int n, Date date)
     Calls the setDate method on the delegee prepared statement.
public  voidsetDouble(int n, double d)
     Calls the setDouble method on the delegee prepared statement.
public  voidsetEscapeProcessing(boolean flag)
     Calls the setEscapeProcessing method on the delegee prepared statement.
public  voidsetFetchDirection(int n)
     Calls the setFetchDirection method on the delegee prepared statement.
public  voidsetFetchSize(int n)
     Calls the setFetchSize method on the delegee prepared statement.
public  voidsetFloat(int n, float f)
     Calls the setFloat method on the delegee prepared statement.
public  voidsetInt(int n, int index)
     Calls the setInt method on the delegee prepared statement.
public  voidsetInt(int offset, Integer value)
     Calls either setInt or setNull on the prepared statement, depending on the value of the object to be stored.
public  voidsetLargeString(int n, String string)
     Calls UniversalPrepStmt.setString setString or UniversalPrepStmt.setClob setClob depending on the driver for the delegee prepared statement.
public  voidsetLong(int n, long l)
     Calls the setLong method on the delegee prepared statement.
public  voidsetLong(int offset, Long value)
     Calls either setLong or setNull on the prepared statement, depending on the value of the object to be stored.
public  voidsetMaxFieldSize(int n)
     Calls the setMaxFieldSize method on the delegee prepared statement.
public  voidsetMaxRows(int n)
     Calls the setMaxRows method on the delegee prepared statement.
public  voidsetNull(int n, int index)
     Calls the setNull method on the delegee prepared statement.
public  voidsetNull(int n, int n1, String string)
     Calls the setNull method on the delegee prepared statement.
public  voidsetObject(int n, Object object, int n1, int n2)
     Calls the setObject method on the delegee prepared statement.
public  voidsetObject(int n, Object object, int n1)
     Calls the setObject method on the delegee prepared statement.
public  voidsetObject(int n, Object object)
     Delegates to setLargeString if object is of type String and the driver requires special handling of large strings.
public  voidsetQueryTimeout(int n)
     Calls the setQueryTimeout method on the delegee prepared statement.
public  voidsetRef(int n, Ref ref)
     Calls the setRef method on the delegee prepared statement.
public  voidsetShort(int n, short s)
     Calls the setShort method on the delegee prepared statement.
public  voidsetString(int n, String string)
     Calls the setString method on the delegee prepared statement.
public  voidsetTime(int n, Time time, Calendar calendar)
     Calls the setTime method on the delegee prepared statement.
public  voidsetTime(int n, Time time)
     Calls the setTime method on the delegee prepared statement.
public  voidsetTimestamp(int n, Timestamp timestamp)
     Calls the setTimestamp method on the delegee prepared statement.
public  voidsetTimestamp(int n, Timestamp timestamp, Calendar calendar)
     Calls the setTimestamp method on the delegee prepared statement.
public  voidsetURL(int parameterIndex, URL x)
     Calls the setURL method on the delegee prepared statement.
public  voidsetUnicodeStream(int n, InputStream inputStream, int n1)
     Calls the setUnicodeStream method on the delegee prepared statement.


Constructor Detail
UniversalPrepStmt
public UniversalPrepStmt(Connection connection, String statement) throws IllegalArgumentException, SQLException(Code)
Creates an instance of UniversalPrepStmt with no given primary key columns, thus assuming the 1st column of the insert statement being primary key column. NOTE: In this case, only insert statements without column name listings (format: INSERT INTO ) are supported. An internal delegee prepared statement is generated using the given connection for the supported databases.
Parameters:
  connection - the connection to be used to generate the delegeePrepareStatement.
Parameters:
  statement - the statement to be executed.
throws:
  IllegalArgumentException - if the statement cannot be parsed.
throws:
  SQLException - if an error occurs.



UniversalPrepStmt
public UniversalPrepStmt(DataSource dataSource, Connection connection, String statement) throws IllegalArgumentException, SQLException(Code)
Creates an instance of UniversalPrepStmt with no given primary key columns, thus assuming the 1st column of the insert statement being primary key column. NOTE: In this case, only insert statements without column name listings (format: INSERT INTO ) are supported. An internal delegee prepared statement is generated using the given connection for the supported databases.
Parameters:
  dataSource - used for caching properties of the database
Parameters:
  connection - the connection to be used to generate the delegeePrepareStatement.
Parameters:
  statement - the statement to be executed.
throws:
  IllegalArgumentException - if the statement cannot be parsed.
throws:
  SQLException - if an error occurs.



UniversalPrepStmt
public UniversalPrepStmt(Connection connection, String statement, String primaryKeyColumns) throws IllegalArgumentException, SQLException(Code)
Creates an instance of UniversalPrepStmt. An internal delegee prepared statement is generated using the given connection for the supported databases.
Parameters:
  connection - the connection to be used.
Parameters:
  statement - the statement to be executed.
Parameters:
  primaryKeyColumns - the comma separated primary keylist. The column names must be in the same sequence as theyappear in the field list of the insert statement.
throws:
  IllegalArgumentException - if the statement cannot be parsed.
throws:
  SQLException - if an error occurs.



UniversalPrepStmt
public UniversalPrepStmt(Connection connection, String statement, String[] primaryKeyColumns) throws IllegalArgumentException, SQLException(Code)
Creates an instance of UniversalPrepStmt. An internal delegee prepared statement is generated using the given connection for the supported databases.
Parameters:
  connection - the connection to be used.
Parameters:
  statement - the statement to be executed.
Parameters:
  primaryKeyColumns - the primary key column name list. Thecolumn names must be in the same sequence as they appear in thefield list of the insert statement.
throws:
  IllegalArgumentException - if the statement cannot be parsed.
throws:
  SQLException - if an error occurs.



UniversalPrepStmt
public UniversalPrepStmt(DataSource dataSource, Connection connection, String statement, String primaryKeyColumns) throws IllegalArgumentException, SQLException(Code)
Creates an instance of UniversalPrepStmt. An internal delegee prepared statement is generated using the given connection for the supported databases.
Parameters:
  dataSource - used for caching properties of the database
Parameters:
  connection - the connection to be used.
Parameters:
  statement - the statement to be executed.
Parameters:
  primaryKeyColumns - the comma separated primary keylist. The column names must be in the same sequence as theyappear in the field list of the insert statement.
throws:
  IllegalArgumentException - if the statement cannot be parsed.
throws:
  SQLException - if an error occurs.



UniversalPrepStmt
public UniversalPrepStmt(DataSource dataSource, Connection connection, String statement, String[] primaryKeyColumns) throws IllegalArgumentException, SQLException(Code)
Creates an instance of UniversalPrepStmt. An internal delegee prepared statement is generated using the given connection for the supported databases.
Parameters:
  dataSource - used for caching properties of the database
Parameters:
  connection - the connection to be used.
Parameters:
  statement - the statement to be executed.
Parameters:
  primaryKeyColumns - the primary key column name list. Thecolumn names must be in the same sequence as they appear in thefield list of the insert statement.
throws:
  IllegalArgumentException - if the statement cannot be parsed.
throws:
  SQLException - if an error occurs.




Method Detail
addBatch
public void addBatch(String string) throws SQLException(Code)
Calls the addBatch method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.addBatch



addBatch
public void addBatch() throws SQLException(Code)
Calls the addBatch method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.addBatch



cancel
public void cancel() throws SQLException(Code)
Calls the cancel method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.cancel



clearBatch
public void clearBatch() throws SQLException(Code)
Calls the clearBatch method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.clearBatch



clearParameters
public void clearParameters() throws SQLException(Code)
Calls the clearParameters method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.clearParameters



clearWarnings
public void clearWarnings() throws SQLException(Code)
Calls the clearWarnings method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.clearWarnings



close
public void close() throws SQLException(Code)
Calls the close method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
throws:
  SQLException - if an error occurs
See Also:   java.sql.PreparedStatement.close



execute
public boolean execute(String string) throws SQLException(Code)
Calls the execute method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value. a boolean value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.execute



execute
public boolean execute(String string, int autoGeneratedKeys) throws SQLException(Code)
Calls the execute method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value.
Parameters:
  autoGeneratedKeys - see java.sql.Statement.execute(Stringint)Statement a boolean value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.Statement.execute(Stringint)



execute
public boolean execute(String string, int[] columnIndexes) throws SQLException(Code)
Calls the execute method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value.
Parameters:
  columnIndexes - see java.sql.Statement.execute(Stringint[])Statement a boolean value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.Statement.execute(Stringint[])



execute
public boolean execute(String string, String[] columnNames) throws SQLException(Code)
Calls the execute method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value.
Parameters:
  columnNames - see java.sql.Statement.execute(StringString[])Statement a boolean value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.Statement.execute(StringString[])



execute
public boolean execute() throws SQLException(Code)
Calls the execute method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. a boolean value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.execute



executeBatch
public int[] executeBatch() throws SQLException(Code)
Calls the executeBatch method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. an int[] value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.executeBatch



executeQuery
public ResultSet executeQuery(String string) throws SQLException(Code)
Calls the executeQuery method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value. a ResultSet value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.executeQuery



executeQuery
public ResultSet executeQuery() throws SQLException(Code)
Calls the executeQuery method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. a ResultSet value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.executeQuery



executeUpdate
public int executeUpdate(String string) throws SQLException(Code)
Calls the executeUpdate method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value. an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.executeUpdate



executeUpdate
public int executeUpdate(String string, int autoGeneratedKeys) throws SQLException(Code)
Calls the executeUpdate method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value.
Parameters:
  autoGeneratedKeys - see java.sql.Statement.executeUpdate(Stringint)Statement an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.Statement.executeUpdate(Stringint)



executeUpdate
public int executeUpdate(String string, int[] columnIndexes) throws SQLException(Code)
Calls the executeUpdate method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value.
Parameters:
  columnIndexes - see java.sql.Statement.executeUpdate(Stringint[])Statement an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.Statement.executeUpdate(Stringint[])



executeUpdate
public int executeUpdate(String string, String[] columnNames) throws SQLException(Code)
Calls the executeUpdate method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value.
Parameters:
  columnNames - see java.sql.Statement.executeUpdate(StringString[])Statement an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.Statement.executeUpdate(StringString[])



executeUpdate
public int executeUpdate() throws SQLException(Code)
Calls the executeUpdate method on the delegee prepared statement and then execute the builded selectForUpdate statement to lob datas. Throws a UnsupportedOperationException if no delegee is available. an int value
throws:
  SQLException - if an error occurs



getConnection
public Connection getConnection() throws SQLException(Code)
Return the database connection. the database connection.
throws:
  SQLException - if an error occurs.



getFetchDirection
public int getFetchDirection() throws SQLException(Code)
Calls the getFetchDirection method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getFetchDirection



getFetchSize
public int getFetchSize() throws SQLException(Code)
Calls the getFetchSize method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getFetchSize



getGeneratedKeys
public ResultSet getGeneratedKeys() throws SQLException(Code)
Calls the getGeneratedKeys method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. a ResultSet value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getMoreResults



getMaxFieldSize
public int getMaxFieldSize() throws SQLException(Code)
Calls the getMaxFieldSize method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getMaxFieldSize



getMaxRows
public int getMaxRows() throws SQLException(Code)
Calls the getMaxRows method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getMaxRows



getMetaData
public ResultSetMetaData getMetaData() throws SQLException(Code)
Calls the getMetaData method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. a ResultSetMetaData value.
throws:
  SQLException - if an error occurs
See Also:   java.sql.PreparedStatement.getMetaData



getMoreResults
public boolean getMoreResults() throws SQLException(Code)
Calls the getMoreResults method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. a boolean value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getMoreResults



getMoreResults
public boolean getMoreResults(int current) throws SQLException(Code)
Calls the getMoreResults method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  current - see java.sql.Statement.getMoreResults(int)Statement a boolean value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.Statement.getMoreResults(int)



getParameterMetaData
public ParameterMetaData getParameterMetaData() throws SQLException(Code)
Calls the getParameterMetaData method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. the result.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getParameterMetaData



getQueryTimeout
public int getQueryTimeout() throws SQLException(Code)
Calls the getQueryTimeout method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getQueryTimeout



getResultSet
public ResultSet getResultSet() throws SQLException(Code)
Calls the getResultSet method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. a ResultSet value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getResultSet



getResultSetConcurrency
public int getResultSetConcurrency() throws SQLException(Code)
Calls the getResultSetConcurrency method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getResultSetConcurrency



getResultSetHoldability
public int getResultSetHoldability() throws SQLException(Code)
Calls the getResultSetHoldability method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. a int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getResultSetHoldability



getResultSetType
public int getResultSetType() throws SQLException(Code)
Calls the getResultSetType method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getResultSetType



getUpdateCount
public int getUpdateCount() throws SQLException(Code)
Calls the getUpdateCount method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getUpdateCount



getWarnings
public SQLWarning getWarnings() throws SQLException(Code)
Calls the getWarnings method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. a SQLWarning value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.getWarnings



setArray
public void setArray(int n, Array array) throws SQLException(Code)
Calls the setArray method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  array - an Array value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setArray



setAsciiStream
public void setAsciiStream(int n, InputStream inputStream, int n1) throws SQLException(Code)
Calls the setAsciiStream method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value
Parameters:
  inputStream - an InputStream value.
Parameters:
  n1 - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setAsciiStream



setBigDecimal
public void setBigDecimal(int n, BigDecimal bigDecimal) throws SQLException(Code)
Calls the setBigDecimal method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  bigDecimal - a BigDecimal value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setBigDecimal



setBinary
public void setBinary(int offset, Object data) throws IOException, SQLException(Code)
Store the object. Uses UniversalPrepStmt.setBytes setBytes or UniversalPrepStmt.setBinaryStream setBinaryStream as appropriate for the driver. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  offset - an int offset for the PreparedStatement
Parameters:
  data - an Object
throws:
  IOException - any of the usual Input/Output related exceptions.
throws:
  SQLException - if a sql error occurs.



setBinaryStream
public void setBinaryStream(int n, InputStream inputStream, int n1) throws SQLException(Code)
Calls UniversalPrepStmt.setBinaryStream setBinaryStream or UniversalPrepStmt.setBlob setBlob depends on the driver for the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  inputStream - an InputStream value.
Parameters:
  n1 - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setBinaryStream
See Also:   java.sql.PreparedStatement.setBlob



setBlob
public void setBlob(int n, Blob blob) throws SQLException(Code)
Calls the setBlob method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  blob - a Blob value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setBlob



setBoolean
public void setBoolean(int n, boolean flag) throws SQLException(Code)
Calls the setBoolean method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  flag - a boolean value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setBoolean



setByte
public void setByte(int n, byte b) throws SQLException(Code)
Calls the setByte method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  b - a byte value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setByte



setBytes
public void setBytes(int n, byte[] byteArray) throws SQLException(Code)
Store the object. Uses UniversalPrepStmt.setBytes setBytes or UniversalPrepStmt.setBlob setBlob depending on the driver for the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  byteArray - a byte[] value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setBytes



setCharacterStream
public void setCharacterStream(int n, Reader reader, int n1) throws SQLException(Code)
Calls the setCharacterStream method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  reader - a Reader value.
Parameters:
  n1 - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setCharacterStream



setClob
public void setClob(int n, Clob clob) throws SQLException(Code)
Calls the setClob method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  clob - a Clob value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setClob



setCursorName
public void setCursorName(String string) throws SQLException(Code)
Calls the setCursorName method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  string - a String value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setCursorName



setDate
public void setDate(int n, Date date, Calendar calendar) throws SQLException(Code)
Calls the setDate method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  date - a Date value.
Parameters:
  calendar - a Calendar value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setDate



setDate
public void setDate(int n, Date date) throws SQLException(Code)
Calls the setDate method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  date - a Date value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setDate



setDouble
public void setDouble(int n, double d) throws SQLException(Code)
Calls the setDouble method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  d - a double value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setDouble



setEscapeProcessing
public void setEscapeProcessing(boolean flag) throws SQLException(Code)
Calls the setEscapeProcessing method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  flag - a boolean value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setEscapeProcessing



setFetchDirection
public void setFetchDirection(int n) throws SQLException(Code)
Calls the setFetchDirection method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setFetchDirection



setFetchSize
public void setFetchSize(int n) throws SQLException(Code)
Calls the setFetchSize method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setFetchSize



setFloat
public void setFloat(int n, float f) throws SQLException(Code)
Calls the setFloat method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  f - a float value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setFloat



setInt
public void setInt(int n, int index) throws SQLException(Code)
Calls the setInt method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  index - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setInt



setInt
public void setInt(int offset, Integer value) throws SQLException(Code)
Calls either setInt or setNull on the prepared statement, depending on the value of the object to be stored. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  offset - position of paramter in prepared statement.
Parameters:
  value - the value to be stored.
throws:
  SQLException - if a database error occurs.
See Also:   java.sql.PreparedStatement.setInt



setLargeString
public void setLargeString(int n, String string) throws SQLException(Code)
Calls UniversalPrepStmt.setString setString or UniversalPrepStmt.setClob setClob depending on the driver for the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  string - a String value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setString
See Also:   java.sql.PreparedStatement.setClob



setLong
public void setLong(int n, long l) throws SQLException(Code)
Calls the setLong method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  l - a long value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setLong



setLong
public void setLong(int offset, Long value) throws SQLException(Code)
Calls either setLong or setNull on the prepared statement, depending on the value of the object to be stored. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  offset - position of paramter in prepared statement.
Parameters:
  value - the value to be stored.
throws:
  SQLException - if a database error occurs.
See Also:   java.sql.PreparedStatement.setInt



setMaxFieldSize
public void setMaxFieldSize(int n) throws SQLException(Code)
Calls the setMaxFieldSize method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setMaxFieldSize



setMaxRows
public void setMaxRows(int n) throws SQLException(Code)
Calls the setMaxRows method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setMaxRows



setNull
public void setNull(int n, int index) throws SQLException(Code)
Calls the setNull method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  index - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setNull



setNull
public void setNull(int n, int n1, String string) throws SQLException(Code)
Calls the setNull method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  n1 - an int value.
Parameters:
  string - a String value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setNull



setObject
public void setObject(int n, Object object, int n1, int n2) throws SQLException(Code)
Calls the setObject method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  object - an Object value.
Parameters:
  n1 - an int value.
Parameters:
  n2 - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setObject



setObject
public void setObject(int n, Object object, int n1) throws SQLException(Code)
Calls the setObject method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  object - an Object value.
Parameters:
  n1 - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setObject



setObject
public void setObject(int n, Object object) throws SQLException(Code)
Delegates to setLargeString if object is of type String and the driver requires special handling of large strings. Else calls the setObject method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  object - an Object value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setObject



setQueryTimeout
public void setQueryTimeout(int n) throws SQLException(Code)
Calls the setQueryTimeout method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setQueryTimeout



setRef
public void setRef(int n, Ref ref) throws SQLException(Code)
Calls the setRef method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  ref - a Ref value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setRef



setShort
public void setShort(int n, short s) throws SQLException(Code)
Calls the setShort method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  s - a short value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setShort



setString
public void setString(int n, String string) throws SQLException(Code)
Calls the setString method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  string - a String value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setString



setTime
public void setTime(int n, Time time, Calendar calendar) throws SQLException(Code)
Calls the setTime method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  time - a Time value.
Parameters:
  calendar - a Calendar value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setTime



setTime
public void setTime(int n, Time time) throws SQLException(Code)
Calls the setTime method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  time - a Time value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setTime



setTimestamp
public void setTimestamp(int n, Timestamp timestamp) throws SQLException(Code)
Calls the setTimestamp method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  timestamp - a Timestamp value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setTimestamp



setTimestamp
public void setTimestamp(int n, Timestamp timestamp, Calendar calendar) throws SQLException(Code)
Calls the setTimestamp method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  timestamp - a Timestamp value.
Parameters:
  calendar - a Calendar value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setTimestamp



setURL
public void setURL(int parameterIndex, URL x) throws SQLException(Code)
Calls the setURL method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  parameterIndex - an int value
Parameters:
  x - an URL value
exception:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setURL



setUnicodeStream
public void setUnicodeStream(int n, InputStream inputStream, int n1) throws SQLException(Code)
Calls the setUnicodeStream method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available.
Parameters:
  n - an int value.
Parameters:
  inputStream - an InputStream value.
Parameters:
  n1 - an int value.
throws:
  SQLException - if an error occurs.
See Also:   java.sql.PreparedStatement.setUnicodeStream



Methods inherited from java.lang.Object
native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc)
public boolean equals(Object obj)(Code)(Java Doc)
protected void finalize() throws Throwable(Code)(Java Doc)
final native public Class getClass()(Code)(Java Doc)
native public int hashCode()(Code)(Java Doc)
final native public void notify()(Code)(Java Doc)
final native public void notifyAll()(Code)(Java Doc)
public String toString()(Code)(Java Doc)
final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc)
final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc)
final public void wait() throws InterruptedException(Code)(Java Doc)

www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.