Java Doc for MappingSqlQueryWithParameters.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
            org.springframework.jdbc.object.MappingSqlQueryWithParameters

All known Subclasses:   org.springframework.jdbc.object.MappingSqlQuery,
MappingSqlQueryWithParameters
abstract public class MappingSqlQueryWithParameters extends SqlQuery (Code)
Reusable RDBMS query in which concrete subclasses must implement the abstract mapRow(ResultSet, int) method to map each row of the JDBC ResultSet into an object.

Such manual mapping is usually preferable to "automatic" mapping using reflection, which can become complex in non-trivial cases. For example, the present class allows different objects to be used for different rows (for example, if a subclass is indicated). It allows computed fields to be set. And there's no need for ResultSet columns to have the same names as bean properties. The Pareto Principle in action: going the extra mile to automate the extraction process makes the framework much more complex and delivers little real benefit.

Subclasses can be constructed providing SQL, parameter types and a DataSource. SQL will often vary between subclasses.
author:
   Rod Johnson
author:
   Thomas Risberg
author:
   Jean-Pierre Pawlak
See Also:   org.springframework.jdbc.object.MappingSqlQuery
See Also:   org.springframework.jdbc.object.SqlQuery


Inner Class :protected class RowMapperImpl implements RowMapper


Constructor Summary
public  MappingSqlQueryWithParameters()
    
public  MappingSqlQueryWithParameters(DataSource ds, String sql)
     Convenient constructor with DataSource and SQL string.

Method Summary
abstract protected  ObjectmapRow(ResultSet rs, int rowNum, Object[] parameters, Map context)
     Subclasses must implement this method to convert each row of the ResultSet into an object of the result type.
Parameters:
  rs - ResultSet we're working through
Parameters:
  rowNum - row number (from 0) we're up to
Parameters:
  parameters - to the query (passed to the execute() method).Subclasses are rarely interested in these.It can be null if there are no parameters.
Parameters:
  context - passed to the execute() method.It can be null if no contextual information is need.
protected  RowMappernewRowMapper(Object[] parameters, Map context)
     Implementation of protected abstract method.


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



MappingSqlQueryWithParameters
public MappingSqlQueryWithParameters(DataSource ds, String sql)(Code)
Convenient constructor with DataSource and SQL string.
Parameters:
  ds - DataSource to use to get connections
Parameters:
  sql - SQL to run




Method Detail
mapRow
abstract protected Object mapRow(ResultSet rs, int rowNum, Object[] parameters, Map context) throws SQLException(Code)
Subclasses must implement this method to convert each row of the ResultSet into an object of the result type.
Parameters:
  rs - ResultSet we're working through
Parameters:
  rowNum - row number (from 0) we're up to
Parameters:
  parameters - to the query (passed to the execute() method).Subclasses are rarely interested in these.It can be null if there are no parameters.
Parameters:
  context - passed to the execute() method.It can be null if no contextual information is need. an object of the result type
throws:
  SQLException - if there's an error extracting data.Subclasses can simply not catch SQLExceptions, relying on theframework to clean up.



newRowMapper
protected RowMapper newRowMapper(Object[] parameters, Map context)(Code)
Implementation of protected abstract method. This invokes the subclass's implementation of the mapRow() method.



Methods inherited from org.springframework.jdbc.object.SqlQuery
public List execute(Object[] params, Map context) throws DataAccessException(Code)(Java Doc)
public List execute(Object[] params) throws DataAccessException(Code)(Java Doc)
public List execute(Map context) throws DataAccessException(Code)(Java Doc)
public List execute() throws DataAccessException(Code)(Java Doc)
public List execute(int p1, Map context) throws DataAccessException(Code)(Java Doc)
public List execute(int p1) throws DataAccessException(Code)(Java Doc)
public List execute(int p1, int p2, Map context) throws DataAccessException(Code)(Java Doc)
public List execute(int p1, int p2) throws DataAccessException(Code)(Java Doc)
public List execute(long p1, Map context) throws DataAccessException(Code)(Java Doc)
public List execute(long p1) throws DataAccessException(Code)(Java Doc)
public List execute(String p1, Map context) throws DataAccessException(Code)(Java Doc)
public List execute(String p1) throws DataAccessException(Code)(Java Doc)
public List executeByNamedParam(Map paramMap, Map context) throws DataAccessException(Code)(Java Doc)
public List executeByNamedParam(Map paramMap) throws DataAccessException(Code)(Java Doc)
public Object findObject(Object[] params, Map context) throws DataAccessException(Code)(Java Doc)
public Object findObject(Object[] params) throws DataAccessException(Code)(Java Doc)
public Object findObject(int p1, Map context) throws DataAccessException(Code)(Java Doc)
public Object findObject(int p1) throws DataAccessException(Code)(Java Doc)
public Object findObject(int p1, int p2, Map context) throws DataAccessException(Code)(Java Doc)
public Object findObject(int p1, int p2) throws DataAccessException(Code)(Java Doc)
public Object findObject(long p1, Map context) throws DataAccessException(Code)(Java Doc)
public Object findObject(long p1) throws DataAccessException(Code)(Java Doc)
public Object findObject(String p1, Map context) throws DataAccessException(Code)(Java Doc)
public Object findObject(String p1) throws DataAccessException(Code)(Java Doc)
public Object findObjectByNamedParam(Map paramMap, Map context) throws DataAccessException(Code)(Java Doc)
public Object findObjectByNamedParam(Map paramMap) throws DataAccessException(Code)(Java Doc)
public int getRowsExpected()(Code)(Java Doc)
abstract protected RowMapper newRowMapper(Object[] parameters, Map context)(Code)(Java Doc)
public void setRowsExpected(int rowsExpected)(Code)(Java Doc)

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.