Ibatis实战

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap     
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"     
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="OperationLog">

<typeAlias alias="OperationLogVO" type="com.huawei.vo.OperationLogVO" />

<resultMap class="OperationLogVO" id="query_logs_map">

<result property="oper_id" column="OPER_ID" />
<result property="user_name" column="USER_NAME" />
<result property="role_id" column="org_id" />
<result property="user_host" column="USER_HOST" />
<result property="oper_type" column="OPER_TYPE" />
<result property="oper_object_type" column="OPER_OBJECT_TYPE" />
<result property="oper_object_tname" column="OPER_OBJECT_NAME" />
<result property="oper_context" column="oper_context" />
<result property="oper_time" column="OPER_TIME" />
<result property="oper_result" column="OPER_RESULT" />


</resultMap>

<select id="query_oper_log_infos" parameterClass="java.util.HashMap"
resultMap="query_logs_map">
<![CDATA[
SELECT * FROM (SELECT ROWNUM r,in_log.* FROM ESB_LOG_USER_OPER in_log WHERE ROWNUM <= #ENDROWNUM#) log
WHERE log.r >= #STARTROWNUM#
]]>


<!--  <isNotEmpty property="CONDITION1">
<isNotEmpty prepend="AND" property="CONDITION1.user_name">
log.USER_NAME like #CONDITION1.user_name#
</isNotEmpty>

<isNotEmpty prepend="AND" property="CONDITION1.oper_object_type">
log.OPER_OBJECT_TYPE=#CONDITION1.oper_object_type#
</isNotEmpty>

<isNotEmpty prepend="AND" property="CONDITION1.oper_result">
log.OPER_RESULT=#CONDITION1.oper_result#
</isNotEmpty>
</isNotEmpty>
-->
<isNotEmpty property="CONDITION1">
<isNotEmpty prepend="AND" property="CONDITION1.user_name">
log.USER_NAME like #CONDITION1.user_name#
</isNotEmpty>

<isNotEmpty prepend="AND" property="CONDITION1.oper_type">
<isNotEqual property="CONDITION1.oper_type" compareValue="-1">
log.OPER_TYPE = #CONDITION1.oper_type#
</isNotEqual>
</isNotEmpty>

<isNotEmpty prepend="AND" property="CONDITION1.oper_object_type">
log.OPER_OBJECT_TYPE=#CONDITION1.oper_object_type#
</isNotEmpty>

<isNotEmpty prepend="AND" property="CONDITION1.oper_result">
log.OPER_RESULT=#CONDITION1.oper_result#
</isNotEmpty>

<isNotEmpty prepend="AND" property="CONDITION1.beginTime">
log.OPER_TIME between to_date(#CONDITION1.beginTime#,'YYYY/MM/DD HH24:mi:ss')
</isNotEmpty>

<isNotEmpty prepend="AND" property="CONDITION1.endTime">
to_date(#CONDITION1.endTime#,'YYYY/MM/DD HH24:mi:ss')
</isNotEmpty>



</isNotEmpty>





</select>


<resultMap class="OperationLogVO" id="query_oper_types">
<result property="oper_type" column="OPER_TYPE" />
</resultMap>

<resultMap class="OperationLogVO" id="query_oper_object_types">
<result property="oper_object_type" column="OPER_OBJECT_TYPE" />
</resultMap>

<resultMap class="OperationLogVO" id="query_oper_results">
<result property="oper_result" column="OPER_RESULT" />
</resultMap>

<select id="query_oper_object_type_infos" resultMap="query_oper_object_types">
select
distinct OPER_OBJECT_TYPE from ESB_LOG_USER_OPER
</select>

<select id="query_oper_type_infos" resultMap="query_oper_types">
select distinct
OPER_TYPE from ESB_LOG_USER_OPER
</select>

<select id="query_oper_results" resultMap="query_oper_results">
select distinct
OPER_RESULT from ESB_LOG_USER_OPER
</select>




</sqlMap>