一个标准化的ibatis的CRUD sql语句
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="Calib0">
?
?<insert id="calib0.insert" parameterparameterproperty="departmentCode">
???<isNotEmpty prepend="" property="subOrganFlag">
????c.DEPARTMENT_CODE in
?????(select tdd01.internal_department_code from t_department_define tdd01
?????????? connect by prior tdd01.internal_department_code = tdd01.upper_department_code
?????????? start with tdd01.internal_department_code=#departmentCode#)?
???</isNotEmpty>
???<isEmpty prepend="" property="subOrganFlag">
????c.DEPARTMENT_CODE = #departmentCode#
???</isEmpty>
??</isNotEmpty>
??<isNotEmpty prepend="and" property="channelSourceCode">
???c.CHANNEL_SOURCE_CODE = #channelSourceCode#
??</isNotEmpty>
??<isNotEmpty prepend="and" property="businessType">
???c.BUSINESS_TYPE = #businessType#
??</isNotEmpty>
??<isNotEmpty prepend="and" property="applyType">
???c.APPLY_TYPE = #applyType#
??</isNotEmpty>
??<isNotEmpty prepend="AND" property="userDept">
?????????? c.DEPARTMENT_CODE IN
????????????? (select tdd01.internal_department_code from t_department_define tdd01
????????????????? connect by prior tdd01.internal_department_code = tdd01.upper_department_code
????????????????? start with tdd01.internal_department_code=#userDept#)
?????? </isNotEmpty>
?</select>
?
?<select id="calib0.searchById" parameterparameterparameterparameterClass="com.tpaic.ruleengine.domain.VehicleBlackList">
??UPDATE T_VEHICLE_BLACK_LIST set
???updated_date ? =sysdate,
???updated_by?? ? =#updatedBy#,
???ENGINE_NO ? ? =#engineNo#,
????? VEHICLE_FRAME_NO =#vehicleFrameNo#,
????? SORT_DISPLAY ? =#sortDisplay#,
????? CLAIM_TIMES ? =#claimTimes#,
????? CLAIM_RATIO ? =#claimRatio#,
????? REMARK????? ? =#remark#
???WHERE? ??ID ? = #id#
?</update>
</sqlMap>??
