new dynamic sql support

[GoogleCodeExporter]

{{{
<?xml version="1.0" encoding="UTF-8"?>

<properties>
       <property name="getRequesterDaoListInfo">
               <![CDATA[
                       select r.*, o.ORG_NAME as service_requester_org_name from TD_ESB_REQUESTER r left join TD_SM_ORGANIZATION o
                        on r.SERVICE_REQUESTER_ORG = o.ORG_ID
                        where 1=1
                       #if($service_requester_code && !$service_requester_code.equals(""))
                        and SERVICE_REQUESTER_CODE = #[service_requester_code]
                       #end
                       #if($service_requester_account && !$service_requester_account.equals(""))
                        and SERVICE_REQUESTER_ACCOUNT like #[service_requester_account]
                       #end
                       #if($service_requester_name && !$service_requester_name.equals(""))
                        and SERVICE_REQUESTER_NAME like #[service_requester_name]
                       #end
                       #if($service_requester_org && !$service_requester_org.equals(""))
                        and SERVICE_REQUESTER_ORG = #[service_requester_org]
                       #end

                       order by create_time desc
               ]]>
       </property>
       <property name="delete">
               <![CDATA[
                       delete from TD_ESB_REQUESTER where SERVICE_REQUESTER_ID = ?
               ]]>
       </property>
       <property name="findObjectById">
               <![CDATA[
                       select r.*, o.ORG_NAME as service_requester_org_name from TD_ESB_REQUESTER r left join TD_SM_ORGANIZATION o
                        on r.SERVICE_REQUESTER_ORG = o.ORG_ID where SERVICE_REQUESTER_ID = ?
               ]]>
       </property>
       <property name="insert">
               <![CDATA[
                       insert into TD_ESB_REQUESTER(ADDRESS ,BUSINESS_LINE_CODE ,CONTACT ,CREATE_TIME ,CREATOR ,EMAIL ,MODIFIER ,MODIFY_TIME ,PHONE ,SERVICE_REQUESTER_ACCOUNT ,SERVICE_REQUESTER_DESP ,SERVICE_REQUESTER_ID ,SERVICE_REQUESTER_NAME ,SERVICE_REQUESTER_ORG ,SERVICE_REQUESTER_PASSWORD ,USED_FLAG) values(#[address] ,#[business_line_code] ,#[contact] ,#[create_time] ,#[creator] ,#[email] ,#[modifier] ,#[modify_time] ,#[phone] ,#[service_requester_account] ,#[service_requester_desp] ,#[service_requester_id] ,#[service_requester_name] ,#[service_requester_org] ,#[service_requester_password] ,#[used_flag])
               ]]>
       </property>
       <property name="update">
               <![CDATA[
                       update TD_ESB_REQUESTER set ADDRESS=#[address] ,BUSINESS_LINE_CODE=#[business_line_code] ,CONTACT=#[contact] ,EMAIL=#[email] ,MODIFIER=#[modifier] ,MODIFY_TIME=#[modify_time] ,PHONE=#[phone] ,SERVICE_REQUESTER_ACCOUNT=#[service_requester_account] ,SERVICE_REQUESTER_DESP=#[service_requester_desp] ,SERVICE_REQUESTER_ID=#[service_requester_id] ,SERVICE_REQUESTER_NAME=#[service_requester_name] ,SERVICE_REQUESTER_ORG=#[service_requester_org] ,SERVICE_REQUESTER_PASSWORD=#[service_requester_password] where SERVICE_REQUESTER_ID = #[service_requester_id]
               ]]>
       </property>
       <property name="updateFlag">
               <![CDATA[
                       update TD_ESB_REQUESTER set USED_FLAG = #[used_flag], Modifier = #[modifier], Modify_time = #[modify_time]
                       where SERVICE_REQUESTER_ID = #[service_requester_id]
               ]]>
       </property>     

</properties>
}}}

[http://bbossgroups.group.iteye.com/group/wiki/3092-mvc-bboss-config]

Original issue reported on code.google.com by liukaix...@gmail.com on 5 Jul 2011 at 8:58

[GoogleCodeExporter]

fixed in 1.3.1

Original comment by liukaix...@gmail.com on 25 Jul 2012 at 2:53

• Changed state: Fixed