Java Doc for Database.java in  » Web-Framework » jWebApp » jpersist » 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 » Web Framework » jWebApp » jpersist   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    jpersist.Database Database final public class Database (Code) The center of JPersist, the Database class provides a seemless integration of the JDBC classes Connection, Statement, and ResultSet, while also providing object oriented database access. Constructor Summary   Database(DatabaseManager databaseManager)      public   Database(String databaseName, Connection connection)      Create a Database instance. Method Summary public  void beginTransaction()      Starts a transaction by setting auto commit to false. public  void clearWarnings()      public  void close()      Closes the Database (returns pooled connections to the pool). public  void commit()      public  CallableStatement createCallableStatement(String sql)      Creates a callable statement that can be used to interact with PL/SQL, and can also continue to be used with the database handler (i.e. public  PreparedStatement createPreparedStatement(String sql)      Creates a prepared statement that can continue to be used with the database handler (i.e. public  Statement createStatement()      Creates a simple statement that can continue to be used with the database handler (i.e. public  int deleteObject(Object object)      Builds a delete statement from the object. public  int deleteObject(Object object, Set<String> nullValuesToInclude)      Builds a delete statement from the object. public  int deleteObject(Object object, String externalClauses, Object... externalClausesParameters)      Builds a delete statement from the object. public  int deleteObject(Object object, Set<String> nullValuesToInclude, String externalClauses, Object... externalClausesParameters)      Builds a delete statement from the object. public  void endTransaction()      Ends a transaction by setting auto commit to true (also commits the transaction). public  Result executeQuery()      Executes a query from a previously created (and setup) prepared or callable statement. public  Result executeQuery(String sql)      Executes a simple query. public  int executeUpdate(String sql)      Executes a simple update. public  int executeUpdate(String sql, Vector keys)      Executes a simple update. Parameters:   sql - the SQL statement Parameters:   keys - is a Vector. public  boolean getAutoCommit()       String getCatalogPattern()      public  String getClose()      Closes the Database (simply calls close()), can be used in EL.  ColumnMapping getColumnMapper()      public  Connection getConnection()      Returns the database connection.  DatabaseManager getDatabaseManager()      public  String getDatabaseName()      Returns the name of the current dtabase handler. public  MetaData getMetaData()      Returns the database meta data associated with the current database. public  Result getNextQuery()      Simply calls nextQuery().  String getSchemaPattern()       TableMapping getTableMapper()      public  SQLWarning getWarnings()       void initDatabase()      public  boolean isClosed()      Returns true if the database is closed, false otherwise. public  void loadAssociations(Object object)      Loads an objects associations. public  Result nextQuery()      If a query exists in the query queue it is executed and a Result instance is returned, otherwise null is returned. public  Result parameterizedQuery(String sql, Object... parameters)      Executes a parameterized query. public  int parameterizedUpdate(String sql, Object... parameters)      Executes a parameterized update. public  int parameterizedUpdate(String sql, Vector keys, Object... parameters)      Executes a parameterized update. public  Result<T> queryObject(T object)      Builds a select query from the object and executes it. public  Result<T> queryObject(T object, Set<String> nullValuesToInclude)      Builds a select query from the object and executes it. public  Result<T> queryObject(T object, String externalClauses, Object... externalClausesParameters)      Builds a select query from the object and executes it. public  Result<T> queryObject(T object, Set<String> nullValuesToInclude, String externalClauses, Object... externalClausesParameters)      Builds a select query from the object and executes it. public  Result<T> queryObject(Class<T> cs)      Builds a select query from a class that matches up to a table. public  Result<T> queryObject(Class<T> cs, String externalClauses, Object... externalClausesParameters)      Builds a select query from a class that matches up to a table. public  void queueParameterizedQuery(String sql, Object... parameters)      Adds a parameterized query to the query queue. public  void queueQuery(String sql)      Adds a query to the query queue. public  void releaseSavepoint(Savepoint savepoint)      public  void rollback()      public  void rollback(Savepoint savepoint)      public  int saveObject(Object object)      Builds either an update or an insert depending on whether the object is persistent and was previously loaded, or not, respectively. public  int saveObject(Object object, Set<String> nullValuesToInclude)      Builds either an update or an insert depending on whether the object is persistent and was previously loaded, or not, respectively. public  int saveObject(Object object, String externalClauses, Object... externalClausesParameters)      Builds either an update or an insert depending on whether the object is persistent and was previously loaded, or not, respectively. externalClauses can begin with a where clause or anything after the where clause. public  int saveObject(Object object, Set<String> nullValuesToInclude, String externalClauses, Object... externalClausesParameters)      Builds either an update or an insert depending on whether the object is persistent and was previously loaded, or not, respectively. externalClauses can begin with a where clause or anything after the where clause. public  void setAutoCommit(boolean autoCommit)      public  void setClosed(boolean true_only)      Closes the Database (simply calls close()), via a JavaBeans setter.  void setConnection(Connection connection)       void setDatabaseName(String databaseName)      public  void setFetchSize(int fetchSize)      public  void setGlobalMappers(TableMapping tableMapper, ColumnMapping columnMapper)      This method can be used to add global table and column mappers. public  void setMaxRows(int maximumResultRows)      public  void setMetaDataLimits(String catalogPattern, String schemaPattern)      Sets limits on the meta data table information returned. public static  void setPreparedStatementObjects(PreparedStatement preparedStatement, Object... objects)      Sets the prepared statement (using appropriate set methods) with objects from array. public  void setResultSetConcurrency(int resultSetConcurrency)      Defaults to ResultSet.CONCUR_READ_ONLY. public  void setResultSetType(int resultSetType)      Defaults to ResultSet.TYPE_SCROLL_INSENSITIVE. public  Savepoint setSavepoint()      public  Savepoint setSavepoint(String name)      Constructor Detail Database Database(DatabaseManager databaseManager)(Code) Database public Database(String databaseName, Connection connection)(Code) Create a Database instance. Parameters:   databaseName - the name of this database Parameters:   connection - a java.sql.Connection instance Method Detail beginTransaction public void beginTransaction() throws JPersistException(Code) Starts a transaction by setting auto commit to false. endTransaction() should allways be called to reset the auto commit mode. clearWarnings public void clearWarnings() throws JPersistException(Code) See same in java.sql.Connection See Also:   java.sql.Connection close public void close() throws JPersistException(Code) Closes the Database (returns pooled connections to the pool). throws:   JPersistException - commit public void commit() throws JPersistException(Code) See same in java.sql.Connection See Also:   java.sql.Connection createCallableStatement public CallableStatement createCallableStatement(String sql) throws JPersistException(Code) Creates a callable statement that can be used to interact with PL/SQL, and can also continue to be used with the database handler (i.e. query results can be loaded into objects and so forth). Parameters:   sql - the sql statement to be used (eg. "{call getName(?, ?)}") a JDBC CallableStatement instance throws:   JPersistException - createPreparedStatement public PreparedStatement createPreparedStatement(String sql) throws JPersistException(Code) Creates a prepared statement that can continue to be used with the database handler (i.e. query results can be loaded into objects and so forth). Parameters:   sql - the sql statement to be used (eg. "select * from tbl where id = ?") a JDBC PreparedStatement instance throws:   JPersistException - createStatement public Statement createStatement() throws JPersistException(Code) Creates a simple statement that can continue to be used with the database handler (i.e. query results can be loaded into objects and so forth). a JDBC Statement instance throws:   JPersistException - deleteObject public int deleteObject(Object object) throws JPersistException(Code) Builds a delete statement from the object. Parameters:   object - any Object (POJO, PersistentObject, etc.) number of rows deleted throws:   JPersistException - deleteObject public int deleteObject(Object object, Set<String> nullValuesToInclude) throws JPersistException(Code) Builds a delete statement from the object. Parameters:   object - any Object (POJO, PersistentObject, etc.) Parameters:   nullValuesToInclude - is a Set of set methods without the 'set', or table column names, to include in the where clause if null number of rows deleted throws:   JPersistException - deleteObject public int deleteObject(Object object, String externalClauses, Object... externalClausesParameters) throws JPersistException(Code) Builds a delete statement from the object. externalClauses can begin with a where clause or anything after the where clause. Parameters:   object - any Object (POJO, PersistentObject, etc.) Parameters:   externalClauses - external clauses beginning with a where or after Parameters:   externalClausesParameters - the parameters to use with external clauses, can be null number of rows deleted throws:   JPersistException - deleteObject public int deleteObject(Object object, Set<String> nullValuesToInclude, String externalClauses, Object... externalClausesParameters) throws JPersistException(Code) Builds a delete statement from the object. externalClauses can begin with a where clause or anything after the where clause. Parameters:   object - any Object (POJO, PersistentObject, etc.) Parameters:   nullValuesToInclude - is a Set of set methods without the 'set', or table column names, to include in the where clause if null Parameters:   externalClauses - external clauses beginning with a where or after Parameters:   externalClausesParameters - the parameters to use with external clauses, can be null number of rows deleted throws:   JPersistException - endTransaction public void endTransaction() throws JPersistException(Code) Ends a transaction by setting auto commit to true (also commits the transaction). Should allways be called, even after commit or rollback. executeQuery public Result executeQuery() throws JPersistException(Code) Executes a query from a previously created (and setup) prepared or callable statement. a jpersist.Result instance throws:   JPersistException - executeQuery public Result executeQuery(String sql) throws JPersistException(Code) Executes a simple query. Parameters:   sql - the SQL statement a jpersist.Result instance throws:   JPersistException - executeUpdate public int executeUpdate(String sql) throws JPersistException(Code) Executes a simple update. Parameters:   sql - the SQL statement throws:   JPersistException - executeUpdate public int executeUpdate(String sql, Vector keys) throws JPersistException(Code) Executes a simple update. Parameters:   sql - the SQL statement Parameters:   keys - is a Vector. If keys is non-null, then generated keys will be returned in the keys vector. Vector can also define the key columns required (depending on the database). throws:   JPersistException - getAutoCommit public boolean getAutoCommit() throws JPersistException(Code) See same in java.sql.Connection See Also:   java.sql.Connection getCatalogPattern String getCatalogPattern()(Code) getClose public String getClose() throws JPersistException(Code) Closes the Database (simply calls close()), can be used in EL. For example: ${db.close} throws:   JPersistException - getColumnMapper ColumnMapping getColumnMapper()(Code) getConnection public Connection getConnection() throws JPersistException(Code) Returns the database connection. the JDBC connection instance throws:   JPersistException - getDatabaseManager DatabaseManager getDatabaseManager()(Code) getDatabaseName public String getDatabaseName()(Code) Returns the name of the current dtabase handler. a string representing the database handler name getMetaData public MetaData getMetaData() throws JPersistException(Code) Returns the database meta data associated with the current database. The MetaData class can be used to access information about tables in the database. It can also be used to add table and column mapping. an instance of MetaData throws:   JPersistException - getNextQuery public Result getNextQuery() throws JPersistException(Code) Simply calls nextQuery(). Usefull in environments where it is easier to call get methods. a jpersist.Result instance throws:   JPersistException - getSchemaPattern String getSchemaPattern()(Code) getTableMapper TableMapping getTableMapper()(Code) getWarnings public SQLWarning getWarnings() throws JPersistException(Code) See same in java.sql.Connection See Also:   java.sql.Connection initDatabase void initDatabase()(Code) isClosed public boolean isClosed()(Code) Returns true if the database is closed, false otherwise. true or false loadAssociations public void loadAssociations(Object object) throws JPersistException(Code) Loads an objects associations. Parameters:   object - the object whose associations are to be loaded throws:   jpersist.JPersistException - nextQuery public Result nextQuery() throws JPersistException(Code) If a query exists in the query queue it is executed and a Result instance is returned, otherwise null is returned. The query queue is very useful for building up several queries to be executed at a later time (page rendering for example). Each call to nextQuery() executes the queries in the query queue in the order they where added. a jpersist.Result instance throws:   JPersistException - parameterizedQuery public Result parameterizedQuery(String sql, Object... parameters) throws JPersistException(Code) Executes a parameterized query. A paramterized query allows the use of '?' in SQL statements. Parameters:   sql - the SQL statement Parameters:   parameters - an array of objects used to set the parameters to the query a jpersist.Result instance throws:   JPersistException - parameterizedUpdate public int parameterizedUpdate(String sql, Object... parameters) throws JPersistException(Code) Executes a parameterized update. A paramterized update allows the use of '?' in SQL statements. Parameters:   sql - the SQL statement Parameters:   parameters - an array of objects used to set the parameters to the update throws:   JPersistException - parameterizedUpdate public int parameterizedUpdate(String sql, Vector keys, Object... parameters) throws JPersistException(Code) Executes a parameterized update. A paramterized update allows the use of '?' in SQL statements. Parameters:   sql - the SQL statement Parameters:   keys - is a Vector. If keys is non-null, then generated keys will be returned in the keys vector. Vector can also define the key columns required (depending on the database). Parameters:   parameters - an array of objects used to set the parameters to the update throws:   JPersistException - queryObject public Result<T> queryObject(T object) throws JPersistException(Code) Builds a select query from the object and executes it. Any methods matching table columns will be returned, and any values set will be used to build the where clause. Parameters:   object - any Object (POJO, PersistentObject, etc.) a jpersist.Result instance throws:   JPersistException - queryObject public Result<T> queryObject(T object, Set<String> nullValuesToInclude) throws JPersistException(Code) Builds a select query from the object and executes it. Any methods matching table columns will be returned, and any values set will be used to build the where clause. Parameters:   object - any Object (POJO, PersistentObject, etc.) Parameters:   nullValuesToInclude - is a Set of set methods without the 'set', or table column names, to include in the where clause if null a jpersist.Result instance throws:   JPersistException - queryObject public Result<T> queryObject(T object, String externalClauses, Object... externalClausesParameters) throws JPersistException(Code) Builds a select query from the object and executes it. Any methods matching table columns will be returned. externalClauses can begin with a where clause or anything after the where clause. Parameters:   object - any Object (POJO, PersistentObject, etc.) Parameters:   externalClauses - external clauses beginning with a where or after Parameters:   externalClausesParameters - the parameters to use with external clauses, can be null a jpersist.Result instance throws:   JPersistException - queryObject public Result<T> queryObject(T object, Set<String> nullValuesToInclude, String externalClauses, Object... externalClausesParameters) throws JPersistException(Code) Builds a select query from the object and executes it. Any methods matching table columns will be returned. externalClauses can begin with a where clause or anything after the where clause. Parameters:   object - any Object (POJO, PersistentObject, etc.) Parameters:   nullValuesToInclude - is a Set of set methods without the 'set', or table column names, to include in the where clause if null Parameters:   externalClauses - external clauses beginning with a where or after Parameters:   externalClausesParameters - the parameters to use with external clauses, can be null a jpersist.Result instance throws:   JPersistException - queryObject public Result<T> queryObject(Class<T> cs) throws JPersistException(Code) Builds a select query from a class that matches up to a table. Any methods matching table columns will be used to build the column list. externalClauses can begin with a where clause or anything after the where clause. Parameters:   cs - any class that matches up to a table a jpersist.Result instance throws:   JPersistException - queryObject public Result<T> queryObject(Class<T> cs, String externalClauses, Object... externalClausesParameters) throws JPersistException(Code) Builds a select query from a class that matches up to a table. Any methods matching table columns will be used to build the column list. externalClauses can begin with a where clause or anything after the where clause. Parameters:   cs - any class that matches up to a table Parameters:   externalClauses - external clauses beginning with a where or after Parameters:   externalClausesParameters - the parameters to use with external clauses, can be null a jpersist.Result instance throws:   JPersistException - queueParameterizedQuery public void queueParameterizedQuery(String sql, Object... parameters) throws JPersistException(Code) Adds a parameterized query to the query queue. The query queue is very useful for building up several queries to be executed at a later time (page rendering for example). Each call to nextQuery() executes the queries in the query queue in the order they where added. Parameters:   sql - parameterized query sql Parameters:   parameters - an array of objects used to set the parameters to the query throws:   JPersistException - queueQuery public void queueQuery(String sql) throws JPersistException(Code) Adds a query to the query queue. The query queue is very useful for building up several queries to be executed at a later time (page rendering for example). Each call to nextQuery() executes the queries in the query queue in the order they where added. Parameters:   sql - simple query sql throws:   JPersistException - releaseSavepoint public void releaseSavepoint(Savepoint savepoint) throws JPersistException(Code) See same in java.sql.Connection See Also:   java.sql.Connection rollback public void rollback() throws JPersistException(Code) See same in java.sql.Connection See Also:   java.sql.Connection rollback public void rollback(Savepoint savepoint) throws JPersistException(Code) See same in java.sql.Connection See Also:   java.sql.Connection saveObject public int saveObject(Object object) throws JPersistException(Code) Builds either an update or an insert depending on whether the object is persistent and was previously loaded, or not, respectively. Parameters:   object - any Object (POJO, PersistentObject, etc.) number of rows updated throws:   JPersistException - saveObject public int saveObject(Object object, Set<String> nullValuesToInclude) throws JPersistException(Code) Builds either an update or an insert depending on whether the object is persistent and was previously loaded, or not, respectively. Parameters:   object - any Object (POJO, PersistentObject, etc.) Parameters:   nullValuesToInclude - is a Set of set methods without the 'set', or table column names, to include in the update number of rows updated throws:   JPersistException - saveObject public int saveObject(Object object, String externalClauses, Object... externalClausesParameters) throws JPersistException(Code) Builds either an update or an insert depending on whether the object is persistent and was previously loaded, or not, respectively. externalClauses can begin with a where clause or anything after the where clause. Parameters:   object - any Object (POJO, PersistentObject, etc.) Parameters:   externalClauses - external clauses beginning with a where or after Parameters:   externalClausesParameters - the parameters to use with external clauses, can be null number of rows updated throws:   JPersistException - saveObject public int saveObject(Object object, Set<String> nullValuesToInclude, String externalClauses, Object... externalClausesParameters) throws JPersistException(Code) Builds either an update or an insert depending on whether the object is persistent and was previously loaded, or not, respectively. externalClauses can begin with a where clause or anything after the where clause. Parameters:   object - any Object (POJO, PersistentObject, etc.) Parameters:   nullValuesToInclude - is a Set of set methods without the 'set', or table column names, to include in the update Parameters:   externalClauses - external clauses beginning with a where or after Parameters:   externalClausesParameters - the parameters to use with external clauses, can be null number of rows updated throws:   JPersistException - setAutoCommit public void setAutoCommit(boolean autoCommit) throws JPersistException(Code) See same in java.sql.Connection See Also:   java.sql.Connection setClosed public void setClosed(boolean true_only) throws JPersistException(Code) Closes the Database (simply calls close()), via a JavaBeans setter. For example: throws:   JPersistException - setConnection void setConnection(Connection connection)(Code) setDatabaseName void setDatabaseName(String databaseName)(Code) setFetchSize public void setFetchSize(int fetchSize) throws JPersistException(Code) See same in java.sql.Statement See Also:   java.sql.Statement setGlobalMappers public void setGlobalMappers(TableMapping tableMapper, ColumnMapping columnMapper)(Code) This method can be used to add global table and column mappers. Objects implementaing TableMapping and/or ColumnMapping override the global mappers. Parameters:   tableMapper - an instance of TableMapping Parameters:   columnMapper - an instance of ColumnMapping setMaxRows public void setMaxRows(int maximumResultRows) throws JPersistException(Code) See same in java.sql.Statement See Also:   java.sql.Statement setMetaDataLimits public void setMetaDataLimits(String catalogPattern, String schemaPattern)(Code) Sets limits on the meta data table information returned. Defining catalogPattern and schemaPattern can help reduce the amount of time spent loading table information. With some databases, it is absolutely needed. This can also be set with databases.xml and/or DatabaseManager constructors. Meta data limits will be reset (using the values in DatabaseManager) with each call to DatabaseManager.getDatabase(). Parameters:   catalogPattern - the catalogPattern (can contain SQL wildcards) Parameters:   schemaPattern - the schemaPattern (can contain SQL wildcards) setPreparedStatementObjects public static void setPreparedStatementObjects(PreparedStatement preparedStatement, Object... objects) throws SQLException, JPersistException(Code) Sets the prepared statement (using appropriate set methods) with objects from array. Parameters:   preparedStatement - an instance of java.sql.PreparedStatement Parameters:   objects - an array of objects setResultSetConcurrency public void setResultSetConcurrency(int resultSetConcurrency) throws JPersistException(Code) Defaults to ResultSet.CONCUR_READ_ONLY. See Also:   java.sql.Connection See Also:   java.sql.ResultSet throws:   JPersistException - setResultSetType public void setResultSetType(int resultSetType) throws JPersistException(Code) Defaults to ResultSet.TYPE_SCROLL_INSENSITIVE. See Also:   java.sql.Connection See Also:   java.sql.ResultSet throws:   JPersistException - setSavepoint public Savepoint setSavepoint() throws JPersistException(Code) See same in java.sql.Connection See Also:   java.sql.Connection setSavepoint public Savepoint setSavepoint(String name) throws JPersistException(Code) See same in java.sql.Connection See Also:   java.sql.Connection 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)