Java Doc for MultiStatement.java in  » Database-ORM » MMBase » org » mmbase » module » database » 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 » Database ORM » MMBase » org.mmbase.module.database   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.mmbase.module.database.MultiStatement MultiStatement public class MultiStatement implements Statement(Code) MultiStatement is a wrapper class for a callable Statement obtained by a MultiConnection object. The sole function of this class is to log the sql statement passed to it using the MultiConnection that called it - all calls are then passed to the Statement object passed to the constructor. author:    vpro author:    Pierre van Rooden version:    $Id: MultiStatement.java,v 1.20 2007/06/11 12:29:03 michiel Exp $ Field Summary  MultiConnection parent      The connection that created this statement. Constructor Summary   MultiStatement(MultiConnection parent, Statement s)      Method Summary public  void addBatch(String sql)      public  void cancel()      protected  Statement checkAfterException()      Tries to fix the parent connection, if it proves to be broken. public  void clearBatch()      public  void clearWarnings()      public  void close()      public  boolean execute(String sql)      public  boolean execute(String sql, int autoGeneratedKeys)      Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval. public  boolean execute(String sql, int[] columnIndexes)      Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. public  boolean execute(String sql, String[] columnNames)      Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. public  int[] executeBatch()      public  ResultSet executeQuery(String sql)      public  int executeUpdate(String sql)      public  int executeUpdate(String sql, int autoGeneratedKeys)      Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval. public  int executeUpdate(String sql, int[] columnIndexes)      Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. public  int executeUpdate(String sql, String[] columnNames)      Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. public  Connection getConnection()      public  int getFetchDirection()      public  int getFetchSize()      public  ResultSet getGeneratedKeys()      Retrieves any auto-generated keys created as a result of executing this Statement object. public  int getMaxFieldSize()      public  int getMaxRows()      public  boolean getMoreResults()      public  boolean getMoreResults(int current)      Moves to this Statement object's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object. public  int getQueryTimeout()      public  ResultSet getResultSet()      public  int getResultSetConcurrency()      public  int getResultSetHoldability()      Retrieves the result set holdability for ResultSet objects generated by this Statement object. public  int getResultSetType()      public  int getUpdateCount()      public  SQLWarning getWarnings()      public  boolean isClosed()      public  boolean isPoolable()      public  boolean isWrapperFor(Class iface)      public  void setCursorName(String name)      public  void setEscapeProcessing(boolean enable)      public  void setFetchDirection(int dir)      public  void setFetchSize(int i)      public  void setMaxFieldSize(int max)      public  void setMaxRows(int max)      public  void setPoolable(boolean p)      public  void setQueryTimeout(int seconds)      public  T unwrap(Class<T> iface)      Field Detail parent MultiConnection parent(Code) The connection that created this statement. Constructor Detail MultiStatement MultiStatement(MultiConnection parent, Statement s)(Code) Method Detail addBatch public void addBatch(String sql) throws SQLException(Code) cancel public void cancel() throws SQLException(Code) checkAfterException protected Statement checkAfterException() throws SQLException(Code) Tries to fix the parent connection, if it proves to be broken. It is supposed to be broken if the query "SELECT 1 FROM clearBatch public void clearBatch() throws SQLException(Code) clearWarnings public void clearWarnings() throws SQLException(Code) close public void close() throws SQLException(Code) execute public boolean execute(String sql) throws SQLException(Code) execute public boolean execute(String sql, int autoGeneratedKeys) throws SQLException(Code) Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval. Parameters:   sql - any SQL statement Parameters:   autoGeneratedKeys - a flag indicating whether auto-generated keys should be made available for retrieval true if the first result is a ResultSet object; false if it is an update count or there are no results since:    MMBase 1.5, JDBC 1.4 execute public boolean execute(String sql, int[] columnIndexes) throws SQLException(Code) Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. Parameters:   sql - any SQL statement Parameters:   columnIndexes - an array of column indexes indicating the columns that should be returned from the inserted row true if the first result is a ResultSet object; false if it is an update count or there are no results since:    MMBase 1.5, JDBC 1.4 execute public boolean execute(String sql, String[] columnNames) throws SQLException(Code) Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. Parameters:   sql - any SQL statement Parameters:   columnNames - - an array of the names of the columns that should be returned from the inserted row true if the first result is a ResultSet object; false if it is an update count or there are no results since:    MMBase 1.5, JDBC 1.4 executeBatch public int[] executeBatch() throws SQLException(Code) executeQuery public ResultSet executeQuery(String sql) throws SQLException(Code) executeUpdate public int executeUpdate(String sql) throws SQLException(Code) executeUpdate public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException(Code) Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval. Parameters:   sql - must be an SQL INSERT, UPDATE or DELETE statement or an SQL statement that returns nothing Parameters:   autoGeneratedKeys - a flag indicating whether auto-generated keys should be made available for retrieval either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing since:    MMBase 1.5, JDBC 1.4 executeUpdate public int executeUpdate(String sql, int[] columnIndexes) throws SQLException(Code) Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. Parameters:   sql - must be an SQL INSERT, UPDATE or DELETE statement or an SQL statement that returns nothing Parameters:   columnIndexes - an array of column indexes indicating the columns that should be returned from the inserted row either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing since:    MMBase 1.5, JDBC 1.4 executeUpdate public int executeUpdate(String sql, String[] columnNames) throws SQLException(Code) Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. Parameters:   sql - must be an SQL INSERT, UPDATE or DELETE statement or an SQL statement that returns nothing Parameters:   columnNames - - an array of the names of the columns that should be returned from the inserted row either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing since:    MMBase 1.5, JDBC 1.4 getConnection public Connection getConnection() throws SQLException(Code) getFetchDirection public int getFetchDirection() throws SQLException(Code) getFetchSize public int getFetchSize() throws SQLException(Code) getGeneratedKeys public ResultSet getGeneratedKeys() throws SQLException(Code) Retrieves any auto-generated keys created as a result of executing this Statement object. a ResultSet object containing the auto-generated key(s) generated by the execution of this Statement object since:    MMBase 1.5, JDBC 1.4 getMaxFieldSize public int getMaxFieldSize() throws SQLException(Code) getMaxRows public int getMaxRows() throws SQLException(Code) getMoreResults public boolean getMoreResults() throws SQLException(Code) getMoreResults public boolean getMoreResults(int current) throws SQLException(Code) Moves to this Statement object's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object. Parameters:   current - one of CLOSE_CURRENT_RESULT, KEEP_CURRENT_RESULT, or CLOSE_ALL_RESULTS true if the next result is a ResultSet object; false if it is an update count or there are no more results since:    MMBase 1.5, JDBC 1.4 getQueryTimeout public int getQueryTimeout() throws SQLException(Code) getResultSet public ResultSet getResultSet() throws SQLException(Code) getResultSetConcurrency public int getResultSetConcurrency() throws SQLException(Code) getResultSetHoldability public int getResultSetHoldability() throws SQLException(Code) Retrieves the result set holdability for ResultSet objects generated by this Statement object. either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT since:    MMBase 1.5, JDBC 1.4 getResultSetType public int getResultSetType() throws SQLException(Code) getUpdateCount public int getUpdateCount() throws SQLException(Code) getWarnings public SQLWarning getWarnings() throws SQLException(Code) isClosed public boolean isClosed() throws SQLException(Code) isPoolable public boolean isPoolable() throws SQLException(Code) isWrapperFor public boolean isWrapperFor(Class iface)(Code) setCursorName public void setCursorName(String name) throws SQLException(Code) setEscapeProcessing public void setEscapeProcessing(boolean enable) throws SQLException(Code) setFetchDirection public void setFetchDirection(int dir) throws SQLException(Code) setFetchSize public void setFetchSize(int i) throws SQLException(Code) setMaxFieldSize public void setMaxFieldSize(int max) throws SQLException(Code) setMaxRows public void setMaxRows(int max) throws SQLException(Code) setPoolable public void setPoolable(boolean p) throws SQLException(Code) setQueryTimeout public void setQueryTimeout(int seconds) throws SQLException(Code) unwrap public T unwrap(Class<T> iface)(Code) 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)