commons-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From denn...@apache.org
Subject svn commit: r637681 - /commons/proper/dbutils/trunk/xdocs/examples.xml
Date Sun, 16 Mar 2008 22:49:40 GMT
Author: dennisl
Date: Sun Mar 16 15:49:34 2008
New Revision: 637681

URL: http://svn.apache.org/viewvc?rev=637681&view=rev
Log:
[DBUTILS-38] example documentation page, update query.

- Add examples on how to insert and update data.
- Add an example on how to use the BeanListHandler to fetch a List of beans.

Modified:
    commons/proper/dbutils/trunk/xdocs/examples.xml

Modified: commons/proper/dbutils/trunk/xdocs/examples.xml
URL: http://svn.apache.org/viewvc/commons/proper/dbutils/trunk/xdocs/examples.xml?rev=637681&r1=637680&r2=637681&view=diff
==============================================================================
--- commons/proper/dbutils/trunk/xdocs/examples.xml (original)
+++ commons/proper/dbutils/trunk/xdocs/examples.xml Sun Mar 16 15:49:34 2008
@@ -99,6 +99,34 @@
 }
 ]]>
 </source>
+
+<p>
+  You can not only fetch data from the database - you can also insert or update
+  data. The following example will first insert a person into the database and
+  after that change the person's height. 
+</p>
+
+<source>
+QueryRunner run = new QueryRunner( dataSource );
+try
+{
+    // Create an object array to hold the values to insert
+    Object[] insertParams = {"John Doe", new Double( 1.82 )};
+    // Execute the SQL update statement and return the number of
+    // inserts that were made
+    int inserts = run.update( "INSERT INTO Person (name,height) VALUES (?,?)",
+                              insertParams );
+
+    // Now it's time to rise to the occation...
+    Object[] updateParams = {new Double( 2.05 ), "John Doe"};
+    int updates = run.update( "UPDATE Person SET height=? WHERE name=?",
+                              updateParams );
+}
+catch(SQLException sqle) {
+    // Handle it
+}
+</source>
+
 </section>
 
 
@@ -115,6 +143,11 @@
 another that converts all rows in the <code>ResultSet</code>. 
 </p>
 
+<p>
+  We'll start with an example using the <code>BeanHandler</code> to fetch one
+  row from the <code>ResultSet</code> and turn it into a JavaBean. 
+</p>
+
 <source>
 QueryRunner run = new QueryRunner(dataSource);
 
@@ -126,6 +159,23 @@
 // return the results in a new Person object generated by the BeanHandler.
 Person p = (Person) run.query(
     "SELECT * FROM Person WHERE name=?", "John Doe", h); 
+</source>
+
+<p>
+  This time we will use the BeanListHandler to fetch all rows from the
+  <code>ResultSet</code> and turn them into a <code>List</code> of
JavaBeans. 
+</p>
+
+<source>
+QueryRunner run = new QueryRunner(dataSource);
+
+// Use the BeanListHandler implementation to convert all
+// ResultSet rows into a List of Person JavaBeans.
+ResultSetHandler h = new BeanListHandler(Person.class);
+
+// Execute the SQL statement and return the results in a List of
+// Person objects generated by the BeanListHandler.
+List persons = (List) run.query("SELECT * FROM Person", h);
 </source>
 
 </section>



Mime
View raw message