[jira] Created: (IBATIS-119) use label from sql for mapping

["Dharmendra Chauhan (JIRA)" <ib...@incubator.apache.org>]

use label from sql for mapping
------------------------------

         Key: IBATIS-119
         URL: http://issues.apache.org/jira/browse/IBATIS-119
     Project: iBatis for Java
        Type: New Feature
  Components: SQL Maps  
 Environment: N/A
    Reporter: Dharmendra Chauhan
    Priority: Minor


Simple way to map bean properties to sql column is by labels. e.g. If I provide contact bean to iBatis for sql select from contact_data table, I can write sql like this to avoid verbose mapping (though not very clean!):

"select first_name as firstname, last_name as lastname, mobile_phone as phone.mobile from contact_data as contact"

Here I am mapping contact_data table to contact object, first_name to firstname property of contact object(contact.firstname), mobile_phone to contact.phone.mobile, etc. ...

Same concept can be extended for xml mapping also where instead of object property with '.' notation, I use xpath in sql label to map result to return xml.

"select first_name as name/first, last_name as name/last, mobile_phone as access/phone/mobile from contact as contact-root-element"



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira