原创力文档- 1、本文档共9页，可阅读全部内容。
- 2、原创力文档（book118）网站文档一经付费（服务费），不意味着购买了该文档的版权，仅供个人/单位学习、研究之用，不得用于商业用途，未经授权，严禁复制、发行、汇编、翻译或者网络传播等，侵权必究。
- 3、本站所有内容均由合作方或网友上传，本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺！文档内容仅供研究参考，付费前请自行鉴别。如您付费，意味着您自己接受本站规则且自行承担风险，本站不退款、不进行额外附加服务；查看《如何避免下载的几个坑》。如果您已付费下载过本站文档，您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等，请点击“版权申诉”（推荐），也可以打举报电话：400-050-0827(电话支持时间：9:00-18:30)。
查看更多
SelectingDatafromaDatabase.PDF
Adobe Enterprise Technical Enablement
Selecting Data from a Database
In this topic, you will learn about the Query Single Row operation and how it is used to
interact with databases.
Objectives
After completing this unit, you should be able to
? Use the Query Single Row operation to select data from a database
Concepts
In this topic, you will learn about the following concepts
? Selecting database data
Copyright ? 2011 Adobe Systems Incorporated 1
Selecting database data
? The JDBC service offers two operations to select database data
■ Query Single Row
■ Query Multiple Rows as XML
Query Single Row operation
? The Query Single Row operation queries the database using a SQL statement and saves the
first row of the result set
■ Located in Foundation JDBC - 1.0
Figure 1: Locating the Query Single Row operation of the JDBC service
Setting Query Single Row operation properties
? When a Query Single Row operation is added to a process, the following properties can be
defined in the Properties view
■ Datasource Name
– literal value or variable
– corresponds to the JNDI name configured for the data source
– formatted with a ‘java:/’ prefix
? java:/adobeTraining
■ SQL Statement - the SQL statement to execute on the database server
2 Copyright ? 2011 Adobe Systems Incorporated
■ Data Mapping
– the locations in the process data model to use for saving the data in the first row
of the query result set
– Specified through the SQL Results Mapping Editor
Figure 2: Query Single Row properties
文档评论（0）