Difference between revisions of "Documentation/DevGuide/Database/Retrieving Values from Result Sets"
From Apache OpenOffice Wiki
< Documentation | DevGuide
m (1 revision(s)) |
m |
||
| Line 9: | Line 9: | ||
A call to <code>execute()</code> on a <idl>com.sun.star.sdb.RowSet</idl> or a call to <code>executeQuery()</code> on a Statement produces a <idl>com.sun.star.sdb.ResultSet</idl>. | A call to <code>execute()</code> on a <idl>com.sun.star.sdb.RowSet</idl> or a call to <code>executeQuery()</code> on a Statement produces a <idl>com.sun.star.sdb.ResultSet</idl>. | ||
<!--[SOURCE:Database/Sales.java]--> | <!--[SOURCE:Database/Sales.java]--> | ||
| − | + | <source lang="java"> | |
com.sun.star.sdbc.XResultSet xResult = xStatement.executeQuery("SELECT FIRSTNAME, LASTNAME, STREET " + | com.sun.star.sdbc.XResultSet xResult = xStatement.executeQuery("SELECT FIRSTNAME, LASTNAME, STREET " + | ||
"FROM SALESMAN " + | "FROM SALESMAN " + | ||
"VWHERE BIRTHDATE < '1950-01-01'"); | "VWHERE BIRTHDATE < '1950-01-01'"); | ||
| − | + | </source> | |
{{PDL1}} | {{PDL1}} | ||
[[Category: Database Access]] | [[Category: Database Access]] | ||
Revision as of 15:22, 31 May 2008
- Retrieving Values from Result Sets
- Moving the Result Set Cursor
- Using the getXXX Methods
- Scrollable Result Sets
- Modifiable Result Sets
- Update
- Insert
- Delete
- Seeing Changes in Result Sets
A call to execute() on a com.sun.star.sdb.RowSet or a call to executeQuery() on a Statement produces a com.sun.star.sdb.ResultSet.
com.sun.star.sdbc.XResultSet xResult = xStatement.executeQuery("SELECT FIRSTNAME, LASTNAME, STREET " + "FROM SALESMAN " + "VWHERE BIRTHDATE < '1950-01-01'");
| Content on this page is licensed under the Public Documentation License (PDL). |
