commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dgra...@apache.org
Subject cvs commit: jakarta-commons/dbutils/xdocs examples.xml
Date Sun, 19 Dec 2004 01:15:33 GMT
dgraham     2004/12/18 17:15:33

  Modified:    dbutils/xdocs examples.xml
  Log:
  Added tips for mapping strange column names to bean properties.
  PR: 32414
  
  Revision  Changes    Path
  1.7       +20 -0     jakarta-commons/dbutils/xdocs/examples.xml
  
  Index: examples.xml
  ===================================================================
  RCS file: /home/cvs/jakarta-commons/dbutils/xdocs/examples.xml,v
  retrieving revision 1.6
  retrieving revision 1.7
  diff -u -r1.6 -r1.7
  --- examples.xml	19 Mar 2004 00:25:39 -0000	1.6
  +++ examples.xml	19 Dec 2004 01:15:33 -0000	1.7
  @@ -149,6 +149,26 @@
   your application.  The provided implementation delegates datatype conversion to 
   the JDBC driver.
   </p>
  +<p>
  +BeanProcessor maps columns to bean properties as documented in the 
  +<a href="apidocs/org/apache/commons/dbutils/BeanProcessor.html#toBean(java.sql.ResultSet,%20java.lang.Class)">BeanProcessor.toBean()</a>
javadoc.  
  +Column names must match the bean's property names case insensitively.  
  +For example, the <code>firstname</code> column would be stored in the bean

  +by calling its <code>setFirstName()</code> method.  However, many database

  +column names include characters that either can't be used or are not typically 
  +used in Java method names.  You can do one of the following to map 
  +these columns to bean properties:
  +<ol>
  +    <li>
  +        Alias the column names in the SQL so they match the Java names:  
  +        <code>select social_sec# as socialSecurityNumber from person</code>
  +    </li>
  +    <li>
  +        Subclass BeanProcessor and override the <a href="apidocs/org/apache/commons/dbutils/BeanProcessor.html#mapColumnsToProperties(java.sql.ResultSetMetaData,%20java.beans.PropertyDescriptor[])">mapColumnsToProperties()</a>

  +        method to strip out the offending characters.
  +    </li>
  +</ol>
  +</p>
   </section>
   
   </body>
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org


Mime
View raw message