ibais常用16条SQL语句.docVIP

HYPERLINK /blog/1135561 ibatis常用16条SQL语句 博客分类： HYPERLINK /category/128793 ibatis专栏 ? (1) 输入参数为单个值 Xml代码? delete?id=com.fashionfree.stat.accesslog.deleteMemberAccessLogsBefore? ?? parameterClass=long? ?? delete?from? ?? MemberAccessLog? ?? where? ?? accessTimestamp?=?#value#? ?? /delete??? ?(2) 输入参数为一个对象 ? Xml代码 insert?id=com.fashionfree.stat.accesslog.MemberAccessLog.insert? ?? parameterClass=com.fashionfree.stat.accesslog.model.MemberAccessLog? ?? insert?into?MemberAccessLog? ?? (? ?? accessLogId,?memberId,?clientIP,? ?? httpMethod,?actionId,?requestURL,? ?? accessTimestamp,?extend1,?extend2,? ?? extend3? ?? )? ?? values? ?? (? ?? #accessLogId#,?#memberId#,? ?? #clientIP#,?#httpMethod#,? ?? #actionId#,?#requestURL#,? ?? #accessTimestamp#,?#extend1#,? ?? #extend2#,?#extend3#? ?? )? ?? /insert??? ? (3) 输入参数为一个java.util.HashMap? Xml代码 select?id=com.fashionfree.stat.accesslog.selectActionIdAndActionNumber? ?? parameterClass=hashMap? ?? resultMap=getActionIdAndActionNumber? ?? select? ?? actionId,?count(*)?as?count? ?? from? ?? MemberAccessLog? ?? where? ?? memberId?=?#memberId#? ?? and?accessTimestamp?gt;?#start#? ?? and?accessTimestamp?lt;=?#end#? ?? group?by?actionId? ?? /select?? ? ? (4) 输入参数中含有数组 ??? Xml代码 insert?id=updateStatusBatch?parameterClass=hashMap? ?? update? ?? Question? ?? set? ?? status?=?#status#? ?? dynamic?prepend=where?questionId?in? ?? isNotNull?property=actionIds? ?? iterate?property=actionIds?open=(?close=)?conjunction=,? ?? #actionIds[]#? ?? /iterate? ?? /isNotNull? ?? /dynamic? ?? /insert??? ?? 说明：actionIds为传入的数组的名字；????使用dynamic标签避免数组为空时导致sql语句语法出错； ?? 使用isNotNull标签避免数组为null时ibatis解析出错 ? ?? (5)传递参数只含有一个数组??? Xml代码 select?id=com.fashionfree.stat.accesslog.model.StatMemberAction.selectActionIdsOfModule? ?? resultClass=hashMap? ?? select? ?? moduleId,?actionId? ?? from? ?? StatMemberAction? ?? dynamic?prepend=where?moduleId?in? ?? iterate?open=(?close=)?conjunction=,? ?? #[]#? ?? /iterate? ?? /dynamic? ?? order?by? ?? moduleId?