Java Doc for SqlQuery.java in  » J2EE » spring-framework-2.5 » org » springframework » jdbc » object » 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 » J2EE » spring framework 2.5 » org.springframework.jdbc.object 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   org.springframework.jdbc.object.RdbmsOperation
      org.springframework.jdbc.object.SqlOperation
         org.springframework.jdbc.object.SqlQuery

All known Subclasses:   org.springframework.jdbc.object.MappingSqlQueryWithParameters,  org.springframework.jdbc.object.UpdatableSqlQuery,
SqlQuery
abstract public class SqlQuery extends SqlOperation (Code)
Reusable operation object representing a SQL query.

Subclasses must implement the SqlQuery.newRowMapper method to provide an object that can extract the results of iterating over the ResultSet created during the execution of the query.

This class provides a number of public execute methods that are analogous to the different convenient JDO query execute methods. Subclasses can either rely on one of these inherited methods, or can add their own custom execution methods, with meaningful names and typed parameters (definitely a best practice). Each custom query method will invoke one of this class's untyped query methods.

Like all RdbmsOperation classes that ship with the Spring Framework, SqlQuery instances are thread-safe after their initialization is complete. That is, after they are constructed and configured via their setter methods, they can be used safely from multiple threads.
author:
   Rod Johnson
author:
   Juergen Hoeller
author:
   Thomas Risberg
See Also:   SqlUpdate




Constructor Summary
public  SqlQuery()
     Constructor to allow use as a JavaBean.
public  SqlQuery(DataSource ds, String sql)
     Convenient constructor with a DataSource and SQL string.

Method Summary
public  Listexecute(Object[] params, Map context)
     Central execution method.
public  Listexecute(Object[] params)
     Convenient method to execute without context.
Parameters:
  params - parameters for the query.
public  Listexecute(Map context)
     Convenient method to execute without parameters.
public  Listexecute()
     Convenient method to execute without parameters nor context.
public  Listexecute(int p1, Map context)
     Convenient method to execute with a single int parameter and context.
public  Listexecute(int p1)
     Convenient method to execute with a single int parameter.
public  Listexecute(int p1, int p2, Map context)
     Convenient method to execute with two int parameters and context.
public  Listexecute(int p1, int p2)
     Convenient method to execute with two int parameters.
public  Listexecute(long p1, Map context)
     Convenient method to execute with a single long parameter and context.
public  Listexecute(long p1)
     Convenient method to execute with a single long parameter.
public  Listexecute(String p1, Map context)
     Convenient method to execute with a single String parameter and context.
public  Listexecute(String p1)
     Convenient method to execute with a single String parameter.
public  ListexecuteByNamedParam(Map paramMap, Map context)
     Central execution method.
public  ListexecuteByNamedParam(Map paramMap)
     Convenient method to execute without context.
Parameters:
  paramMap - parameters associated with the name specified while declaringthe SqlParameters.
public  ObjectfindObject(Object[] params, Map context)
     Generic object finder method, used by all other findObject methods. Object finder methods are like EJB entity bean finders, in that it is considered an error if they return more than one result. the result object, or null if not found.
public  ObjectfindObject(Object[] params)
     Convenient method to find a single object without context.
public  ObjectfindObject(int p1, Map context)
     Convenient method to find a single object given a single int parameter and a context.
public  ObjectfindObject(int p1)
     Convenient method to find a single object given a single int parameter.
public  ObjectfindObject(int p1, int p2, Map context)
     Convenient method to find a single object given two int parameters and a context.
public  ObjectfindObject(int p1, int p2)
     Convenient method to find a single object given two int parameters.
public  ObjectfindObject(long p1, Map context)
     Convenient method to find a single object given a single long parameter and a context.
public  ObjectfindObject(long p1)
     Convenient method to find a single object given a single long parameter.
public  ObjectfindObject(String p1, Map context)
     Convenient method to find a single object given a single String parameter and a context.
public  ObjectfindObject(String p1)
     Convenient method to find a single object given a single String parameter.
public  ObjectfindObjectByNamedParam(Map paramMap, Map context)
     Generic object finder method for named parameters.
Parameters:
  paramMap - Map of parameter name to parameter object,matching named parameters specified in the SQL statement.Ordering is not significant.
Parameters:
  context - contextual information passed to the mapRowcallback method.
public  ObjectfindObjectByNamedParam(Map paramMap)
     Convenient method to execute without context.
public  intgetRowsExpected()
     Get the number of rows expected.
abstract protected  RowMappernewRowMapper(Object[] parameters, Map context)
     Subclasses must implement this method to extract an object per row, to be returned by the execute method as an aggregated List .
Parameters:
  parameters - the parameters to the execute() method,in case subclass is interested; may be null if therewere no parameters.
Parameters:
  context - contextual information passed to the mapRowcallback method.
public  voidsetRowsExpected(int rowsExpected)
     Set the number of rows expected.

This can be used to ensure efficient storage of results.



Constructor Detail
SqlQuery
public SqlQuery()(Code)
Constructor to allow use as a JavaBean.

The DataSource and SQL must be supplied before compilation and use.




SqlQuery
public SqlQuery(DataSource ds, String sql)(Code)
Convenient constructor with a DataSource and SQL string.
Parameters:
  ds - the DataSource to use to get connections
Parameters:
  sql - the SQL to execute; SQL can also be supplied at runtimeby overriding the SqlQuery.getSql() method.




Method Detail
execute
public List execute(Object[] params, Map context) throws DataAccessException(Code)
Central execution method. All un-named parameter execution goes through this method.
Parameters:
  params - parameters, similar to JDO query parameters.Primitive parameters must be represented by their Object wrapper type.The ordering of parameters is significant.
Parameters:
  context - contextual information passed to the mapRowcallback method. The JDBC operation itself doesn't rely on this parameter,but it can be useful for creating the objects of the result list. a List of objects, one per row of the ResultSet. Normally all thesewill be of the same class, although it is possible to use different types.



execute
public List execute(Object[] params) throws DataAccessException(Code)
Convenient method to execute without context.
Parameters:
  params - parameters for the query. Primitive parameters mustbe represented by their Object wrapper type. The ordering of parameters issignificant.



execute
public List execute(Map context) throws DataAccessException(Code)
Convenient method to execute without parameters.
Parameters:
  context - the contextual information for object creation



execute
public List execute() throws DataAccessException(Code)
Convenient method to execute without parameters nor context.



execute
public List execute(int p1, Map context) throws DataAccessException(Code)
Convenient method to execute with a single int parameter and context.
Parameters:
  p1 - single int parameter
Parameters:
  context - the contextual information for object creation



execute
public List execute(int p1) throws DataAccessException(Code)
Convenient method to execute with a single int parameter.
Parameters:
  p1 - single int parameter



execute
public List execute(int p1, int p2, Map context) throws DataAccessException(Code)
Convenient method to execute with two int parameters and context.
Parameters:
  p1 - first int parameter
Parameters:
  p2 - second int parameter
Parameters:
  context - the contextual information for object creation



execute
public List execute(int p1, int p2) throws DataAccessException(Code)
Convenient method to execute with two int parameters.
Parameters:
  p1 - first int parameter
Parameters:
  p2 - second int parameter



execute
public List execute(long p1, Map context) throws DataAccessException(Code)
Convenient method to execute with a single long parameter and context.
Parameters:
  p1 - single long parameter
Parameters:
  context - the contextual information for object creation



execute
public List execute(long p1) throws DataAccessException(Code)
Convenient method to execute with a single long parameter.
Parameters:
  p1 - single long parameter



execute
public List execute(String p1, Map context) throws DataAccessException(Code)
Convenient method to execute with a single String parameter and context.
Parameters:
  p1 - single String parameter
Parameters:
  context - the contextual information for object creation



execute
public List execute(String p1) throws DataAccessException(Code)
Convenient method to execute with a single String parameter.
Parameters:
  p1 - single String parameter



executeByNamedParam
public List executeByNamedParam(Map paramMap, Map context) throws DataAccessException(Code)
Central execution method. All named parameter execution goes through this method.
Parameters:
  paramMap - parameters associated with the name specified while declaringthe SqlParameters. Primitive parameters must be represented by their Object wrappertype. The ordering of parameters is not significant since they are supplied in aSqlParameterMap which is an implementation of the Map interface.
Parameters:
  context - contextual information passed to the mapRowcallback method. The JDBC operation itself doesn't rely on this parameter,but it can be useful for creating the objects of the result list. a List of objects, one per row of the ResultSet. Normally all thesewill be of the same class, although it is possible to use different types.



executeByNamedParam
public List executeByNamedParam(Map paramMap) throws DataAccessException(Code)
Convenient method to execute without context.
Parameters:
  paramMap - parameters associated with the name specified while declaringthe SqlParameters. Primitive parameters must be represented by their Object wrappertype. The ordering of parameters is not significant.



findObject
public Object findObject(Object[] params, Map context) throws DataAccessException(Code)
Generic object finder method, used by all other findObject methods. Object finder methods are like EJB entity bean finders, in that it is considered an error if they return more than one result. the result object, or null if not found. Subclasses maychoose to treat this as an error and throw an exception.
See Also:   org.springframework.dao.support.DataAccessUtils.singleResult



findObject
public Object findObject(Object[] params) throws DataAccessException(Code)
Convenient method to find a single object without context.



findObject
public Object findObject(int p1, Map context) throws DataAccessException(Code)
Convenient method to find a single object given a single int parameter and a context.



findObject
public Object findObject(int p1) throws DataAccessException(Code)
Convenient method to find a single object given a single int parameter.



findObject
public Object findObject(int p1, int p2, Map context) throws DataAccessException(Code)
Convenient method to find a single object given two int parameters and a context.



findObject
public Object findObject(int p1, int p2) throws DataAccessException(Code)
Convenient method to find a single object given two int parameters.



findObject
public Object findObject(long p1, Map context) throws DataAccessException(Code)
Convenient method to find a single object given a single long parameter and a context.



findObject
public Object findObject(long p1) throws DataAccessException(Code)
Convenient method to find a single object given a single long parameter.



findObject
public Object findObject(String p1, Map context) throws DataAccessException(Code)
Convenient method to find a single object given a single String parameter and a context.



findObject
public Object findObject(String p1) throws DataAccessException(Code)
Convenient method to find a single object given a single String parameter.



findObjectByNamedParam
public Object findObjectByNamedParam(Map paramMap, Map context) throws DataAccessException(Code)
Generic object finder method for named parameters.
Parameters:
  paramMap - Map of parameter name to parameter object,matching named parameters specified in the SQL statement.Ordering is not significant.
Parameters:
  context - contextual information passed to the mapRowcallback method. The JDBC operation itself doesn't rely on this parameter,but it can be useful for creating the objects of the result list. a List of objects, one per row of the ResultSet. Normally all thesewill be of the same class, although it is possible to use different types.



findObjectByNamedParam
public Object findObjectByNamedParam(Map paramMap) throws DataAccessException(Code)
Convenient method to execute without context.
Parameters:
  paramMap - Map of parameter name to parameter object,matching named parameters specified in the SQL statement.Ordering is not significant.



getRowsExpected
public int getRowsExpected()(Code)
Get the number of rows expected.



newRowMapper
abstract protected RowMapper newRowMapper(Object[] parameters, Map context)(Code)
Subclasses must implement this method to extract an object per row, to be returned by the execute method as an aggregated List .
Parameters:
  parameters - the parameters to the execute() method,in case subclass is interested; may be null if therewere no parameters.
Parameters:
  context - contextual information passed to the mapRowcallback method. The JDBC operation itself doesn't rely on this parameter,but it can be useful for creating the objects of the result list.
See Also:   SqlQuery.execute



setRowsExpected
public void setRowsExpected(int rowsExpected)(Code)
Set the number of rows expected.

This can be used to ensure efficient storage of results. The default behavior is not to expect any specific number of rows.




Methods inherited from org.springframework.jdbc.object.SqlOperation
final protected void compileInternal()(Code)(Java Doc)
protected ParsedSql getParsedSql()(Code)(Java Doc)
final protected PreparedStatementCreator newPreparedStatementCreator(Object[] params)(Code)(Java Doc)
final protected PreparedStatementCreator newPreparedStatementCreator(String sqlToUse, Object[] params)(Code)(Java Doc)
final protected PreparedStatementSetter newPreparedStatementSetter(Object[] params)(Code)(Java Doc)
protected void onCompileInternal()(Code)(Java Doc)

Fields inherited from org.springframework.jdbc.object.RdbmsOperation
final protected Log logger(Code)(Java Doc)

Methods inherited from org.springframework.jdbc.object.RdbmsOperation
public void afterPropertiesSet()(Code)(Java Doc)
protected boolean allowsUnusedParameters()(Code)(Java Doc)
protected void checkCompiled()(Code)(Java Doc)
final public void compile() throws InvalidDataAccessApiUsageException(Code)(Java Doc)
abstract protected void compileInternal() throws InvalidDataAccessApiUsageException(Code)(Java Doc)
public void declareParameter(SqlParameter param) throws InvalidDataAccessApiUsageException(Code)(Java Doc)
protected List getDeclaredParameters()(Code)(Java Doc)
public String[] getGeneratedKeysColumnNames()(Code)(Java Doc)
public JdbcTemplate getJdbcTemplate()(Code)(Java Doc)
public int getResultSetType()(Code)(Java Doc)
public String getSql()(Code)(Java Doc)
public boolean isCompiled()(Code)(Java Doc)
public boolean isReturnGeneratedKeys()(Code)(Java Doc)
public boolean isUpdatableResults()(Code)(Java Doc)
public void setDataSource(DataSource dataSource)(Code)(Java Doc)
public void setFetchSize(int fetchSize)(Code)(Java Doc)
public void setGeneratedKeysColumnNames(String[] names)(Code)(Java Doc)
public void setJdbcTemplate(JdbcTemplate jdbcTemplate)(Code)(Java Doc)
public void setMaxRows(int maxRows)(Code)(Java Doc)
public void setParameters(SqlParameter[] parameters)(Code)(Java Doc)
public void setQueryTimeout(int queryTimeout)(Code)(Java Doc)
public void setResultSetType(int resultSetType)(Code)(Java Doc)
public void setReturnGeneratedKeys(boolean returnGeneratedKeys)(Code)(Java Doc)
public void setSql(String sql)(Code)(Java Doc)
public void setTypes(int[] types) throws InvalidDataAccessApiUsageException(Code)(Java Doc)
public void setUpdatableResults(boolean updatableResults)(Code)(Java Doc)
protected boolean supportsLobParameters()(Code)(Java Doc)
protected void validateNamedParameters(Map parameters) throws InvalidDataAccessApiUsageException(Code)(Java Doc)
protected void validateParameters(Object[] parameters) throws InvalidDataAccessApiUsageException(Code)(Java Doc)

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.