oracle 使用ibatis动态多条件组合模糊查询

最新推荐文章于 2022-12-21 14:29:52 发布
最新推荐文章于 2022-12-21 14:29:52 发布
阅读量291 收藏
点赞数
分类专栏： Oracle数据库 iBatis&&myBatis学习 文章标签： ibatis oracle mysql java sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lu602171651/article/details/84486717
版权
链接地址：[url]http://kevin12.iteye.com/blog/1953571[/url]

最近将流程项目数据库由mysql数据库改成oracle数据库时，发现oracle的ibatis配置文件和mysql的ibatis的模糊查询不同，下面记录一下，以备后用。

如果是mysql的模糊查询用： 
<isNotEmpty prepend="AND" property="IM_NAME"> a.IM_NAME like concat('%',#IM_NAME#,'%')</isNotEmpty>


如果是oracle的模糊查询用： 
<isNotEmpty prepend="AND" property="IM_NAME"> a.IM_NAME like '%'||#IM_NAME#||'%'</isNotEmpty>
或者
<isNotEmpty prepend="AND" property="IM_NAME"> a.IM_NAME like '%$IM_NAME$%'</isNotEmpty>


模糊查询不能用#,#是用prepareStatement的?插入参数,$是文本替换
下面贴出一个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="IMenu">
    <typeAlias alias="iMenu" type="com.sense.workflow.model.IMenu" />
    <resultMap id="codeNodeMapping"   class="iMenu">
    <result property="IM_ID" column="IM_ID"  />
    <result property="IM_PARENT_ID" column="IM_PARENT_ID"  />
    <result property="IM_LEVEL" column="IM_LEVEL"  />
    <result property="IM_PATH" column="IM_PATH"  />
    <result property="IM_NAME" column="IM_NAME"  />
    <result property="IM_DESCRIPTION" column="IM_DESCRIPTION"  />
    <result property="IM_URL" column="IM_URL"  />
    <result property="IM_STATUS_CODE" column="IM_STATUS_CODE"  />
    <result property="IM_ORDER" column="IM_ORDER"  />
    <result property="IM_CREATE_DATETIME" column="IM_CREATE_DATETIME"  />
    <result property="IM_LAST_UPDATE_DATETIME" column="IM_LAST_UPDATE_DATETIME"  />
    <result property="IM_LAST_UPDATE_OPERATOR_ID" column="IM_LAST_UPDATE_OPERATOR_ID"  />
    <result property="IM_VERSION" column="IM_VERSION"  />
    <result property="IM_VERSION_DATE" column="IM_VERSION_DATE"  />
    <result property="IM_DATA_STATUS" column="IM_DATA_STATUS"  />
    <result property="IM_IS_ACTIVITY" column="IM_IS_ACTIVITY"  />
    </resultMap>
    <insert id="IMenu_insert" parameterClass="iMenu">
        insert into TB_I_MENU(IM_ID,IM_PARENT_ID,IM_LEVEL,IM_PATH,IM_NAME,IM_DESCRIPTION,IM_URL,IM_STATUS_CODE,IM_ORDER,IM_CREATE_DATETIME,IM_LAST_UPDATE_DATETIME,IM_LAST_UPDATE_OPERATOR_ID,IM_VERSION,IM_VERSION_DATE,IM_DATA_STATUS,IM_IS_ACTIVITY) values(#IM_ID#,#IM_PARENT_ID#,#IM_LEVEL#,#IM_PATH#,#IM_NAME#,#IM_DESCRIPTION#,#IM_URL#,#IM_STATUS_CODE#,#IM_ORDER#,#IM_CREATE_DATETIME#,#IM_LAST_UPDATE_DATETIME#,#IM_LAST_UPDATE_OPERATOR_ID#,#IM_VERSION#,#IM_VERSION_DATE#,#IM_DATA_STATUS#,#IM_IS_ACTIVITY#)
    </insert>
    <update id="IMenu_update" parameterClass="iMenu">
        update TB_I_MENU  
  <dynamic prepend="set">
  <isNotNull prepend=" " property="IM_PARENT_ID"> IM_PARENT_ID = #IM_PARENT_ID# </isNotNull>
  <isNotNull prepend="," property="IM_LEVEL"> IM_LEVEL = #IM_LEVEL# </isNotNull>
  <isNotNull prepend="," property="IM_PATH"> IM_PATH = #IM_PATH# </isNotNull>
  <isNotNull prepend="," property="IM_NAME"> IM_NAME = #IM_NAME# </isNotNull>
  <isNotNull prepend="," property="IM_DESCRIPTION"> IM_DESCRIPTION = #IM_DESCRIPTION# </isNotNull>
  <isNotNull prepend="," property="IM_URL"> IM_URL = #IM_URL# </isNotNull>
  <isNotNull prepend="," property="IM_STATUS_CODE"> IM_STATUS_CODE = #IM_STATUS_CODE# </isNotNull>
  <isNotNull prepend="," property="IM_ORDER"> IM_ORDER = #IM_ORDER# </isNotNull>
  <isNotNull prepend="," property="IM_CREATE_DATETIME"> IM_CREATE_DATETIME = #IM_CREATE_DATETIME# </isNotNull>
  <isNotNull prepend="," property="IM_LAST_UPDATE_DATETIME"> IM_LAST_UPDATE_DATETIME = #IM_LAST_UPDATE_DATETIME# </isNotNull>
  <isNotNull prepend="," property="IM_LAST_UPDATE_OPERATOR_ID"> IM_LAST_UPDATE_OPERATOR_ID = #IM_LAST_UPDATE_OPERATOR_ID# </isNotNull>
  <isNotNull prepend="," property="IM_VERSION"> IM_VERSION = #IM_VERSION# </isNotNull>
  <isNotNull prepend="," property="IM_VERSION_DATE"> IM_VERSION_DATE = #IM_VERSION_DATE# </isNotNull>
  <isNotNull prepend="," property="IM_DATA_STATUS"> IM_DATA_STATUS = #IM_DATA_STATUS# </isNotNull>
  <isNotNull prepend="," property="IM_IS_ACTIVITY"> IM_IS_ACTIVITY = #IM_IS_ACTIVITY# </isNotNull>
  </dynamic>

 where IM_ID=#IM_ID#
    </update>
    <update id="IMenu_delete" parameterClass="java.util.ArrayList"></update>
    <select id="IMenu_getObjectById" parameterClass="java.lang.String" resultMap="codeNodeMapping">
        select IM_ID,IM_PARENT_ID,IM_LEVEL,IM_PATH,IM_NAME,IM_DESCRIPTION,IM_URL,IM_STATUS_CODE,IM_ORDER,IM_CREATE_DATETIME,IM_LAST_UPDATE_DATETIME,IM_LAST_UPDATE_OPERATOR_ID,IM_VERSION,IM_VERSION_DATE,IM_DATA_STATUS,IM_IS_ACTIVITY from TB_I_MENU a 
 where IM_ID=#value# 
    </select>
    <select id="IMenu_getList" parameterClass="iMenu" resultMap="codeNodeMapping">
        select IM_ID,IM_PARENT_ID,IM_LEVEL,IM_PATH,IM_NAME,IM_DESCRIPTION,IM_URL,IM_STATUS_CODE,IM_ORDER,IM_CREATE_DATETIME,IM_LAST_UPDATE_DATETIME,IM_LAST_UPDATE_OPERATOR_ID,IM_VERSION,IM_VERSION_DATE,IM_DATA_STATUS,IM_IS_ACTIVITY  from TB_I_MENU a 
  <dynamic prepend="WHERE ">    
    <isNotEmpty prepend="AND" property="IM_ID"> a.IM_ID = #IM_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PARENT_ID"> a.IM_PARENT_ID = #IM_PARENT_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LEVEL"> a.IM_LEVEL = #IM_LEVEL#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PATH"> a.IM_PATH like '%'||#IM_PATH#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_NAME"> a.IM_NAME like '%'||#IM_NAME#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DESCRIPTION"> a.IM_DESCRIPTION like '%'||#IM_DESCRIPTION#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_URL"> a.IM_URL like '%'||#IM_URL#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_STATUS_CODE"> a.IM_STATUS_CODE = #IM_STATUS_CODE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_ORDER"> a.IM_ORDER = #IM_ORDER#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_CREATE_DATETIME"> a.IM_CREATE_DATETIME = #IM_CREATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_DATETIME"> a.IM_LAST_UPDATE_DATETIME = #IM_LAST_UPDATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_OPERATOR_ID"> a.IM_LAST_UPDATE_OPERATOR_ID = #IM_LAST_UPDATE_OPERATOR_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION"> a.IM_VERSION = #IM_VERSION#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION_DATE"> a.IM_VERSION_DATE = #IM_VERSION_DATE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DATA_STATUS"> a.IM_DATA_STATUS = #IM_DATA_STATUS#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_IS_ACTIVITY"> a.IM_IS_ACTIVITY = #IM_IS_ACTIVITY#</isNotEmpty>
  </dynamic>
 order by   IM_CREATE_DATETIME  desc

    </select>
    <select id="IMenu_getListForPage" parameterClass="java.util.HashMap" resultMap="codeNodeMapping">
        select IM_ID,IM_PARENT_ID,IM_LEVEL,IM_PATH,IM_NAME,IM_DESCRIPTION,IM_URL,IM_STATUS_CODE,IM_ORDER,IM_CREATE_DATETIME,IM_LAST_UPDATE_DATETIME,IM_LAST_UPDATE_OPERATOR_ID,IM_VERSION,IM_VERSION_DATE,IM_DATA_STATUS,IM_IS_ACTIVITY from  TB_I_MENU a 
  <dynamic prepend="WHERE ">    
    <isNotEmpty prepend="AND" property="IM_ID"> a.IM_ID = #IM_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PARENT_ID"> a.IM_PARENT_ID = #IM_PARENT_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LEVEL"> a.IM_LEVEL = #IM_LEVEL#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PATH"> a.IM_PATH like '%'||#IM_PATH#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_NAME"> a.IM_NAME like '%'||#IM_NAME#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DESCRIPTION"> a.IM_DESCRIPTION like '%'||#IM_DESCRIPTION#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_URL"> a.IM_URL like '%'||#IM_URL#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_STATUS_CODE"> a.IM_STATUS_CODE = #IM_STATUS_CODE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_ORDER"> a.IM_ORDER = #IM_ORDER#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_CREATE_DATETIME"> a.IM_CREATE_DATETIME = #IM_CREATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_DATETIME"> a.IM_LAST_UPDATE_DATETIME = #IM_LAST_UPDATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_OPERATOR_ID"> a.IM_LAST_UPDATE_OPERATOR_ID = #IM_LAST_UPDATE_OPERATOR_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION"> a.IM_VERSION = #IM_VERSION#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION_DATE"> a.IM_VERSION_DATE = #IM_VERSION_DATE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DATA_STATUS"> a.IM_DATA_STATUS = #IM_DATA_STATUS#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_IS_ACTIVITY"> a.IM_IS_ACTIVITY = #IM_IS_ACTIVITY#</isNotEmpty>
  </dynamic>
  <dynamic prepend="ORDER BY">
        <isNotEmpty property="orderSql">   
            $orderSql$   
        </isNotEmpty>
    </dynamic>   
    <dynamic prepend=" LIMIT ">
        <isNotEmpty property="startRow">
            #startRow#
        </isNotEmpty>
        <isNotEmpty  property="endRow">
            ,#endRow#
        </isNotEmpty>
   </dynamic>

     </select>
    <select id="IMenu_getCount" parameterClass="java.util.HashMap" resultClass="java.lang.Long">
        select count(1) as value from TB_I_MENU a 
  <dynamic prepend="WHERE ">    
    <isNotEmpty prepend="AND" property="IM_ID"> a.IM_ID = #IM_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PARENT_ID"> a.IM_PARENT_ID = #IM_PARENT_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LEVEL"> a.IM_LEVEL = #IM_LEVEL#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PATH"> a.IM_PATH like '%'||#IM_PATH#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_NAME"> a.IM_NAME like '%'||#IM_NAME#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DESCRIPTION"> a.IM_DESCRIPTION like '%'||#IM_DESCRIPTION#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_URL"> a.IM_URL like '%'||#IM_URL#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_STATUS_CODE"> a.IM_STATUS_CODE = #IM_STATUS_CODE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_ORDER"> a.IM_ORDER = #IM_ORDER#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_CREATE_DATETIME"> a.IM_CREATE_DATETIME = #IM_CREATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_DATETIME"> a.IM_LAST_UPDATE_DATETIME = #IM_LAST_UPDATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_OPERATOR_ID"> a.IM_LAST_UPDATE_OPERATOR_ID = #IM_LAST_UPDATE_OPERATOR_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION"> a.IM_VERSION = #IM_VERSION#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION_DATE"> a.IM_VERSION_DATE = #IM_VERSION_DATE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DATA_STATUS"> a.IM_DATA_STATUS = #IM_DATA_STATUS#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_IS_ACTIVITY"> a.IM_IS_ACTIVITY = #IM_IS_ACTIVITY#</isNotEmpty>
  </dynamic>
    </select>
    <select id="IMenu_getListForPage_Time_Order" parameterClass="java.util.HashMap" resultMap="codeNodeMapping">
        select IM_ID,IM_PARENT_ID,IM_LEVEL,IM_PATH,IM_NAME,IM_DESCRIPTION,IM_URL,IM_STATUS_CODE,IM_ORDER,IM_CREATE_DATETIME,IM_LAST_UPDATE_DATETIME,IM_LAST_UPDATE_OPERATOR_ID,IM_VERSION,IM_VERSION_DATE,IM_DATA_STATUS,IM_IS_ACTIVITY from TB_I_MENU a 
  <dynamic prepend="WHERE ">    
    <isNotEmpty prepend="AND" property="IM_ID"> a.IM_ID = #IM_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PARENT_ID"> a.IM_PARENT_ID = #IM_PARENT_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LEVEL"> a.IM_LEVEL = #IM_LEVEL#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PATH"> a.IM_PATH like '%'||#IM_PATH#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_NAME"> a.IM_NAME like '%'||#IM_NAME#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DESCRIPTION"> a.IM_DESCRIPTION like '%'||#IM_DESCRIPTION#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_URL"> a.IM_URL like '%'||#IM_URL#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_STATUS_CODE"> a.IM_STATUS_CODE = #IM_STATUS_CODE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_ORDER"> a.IM_ORDER = #IM_ORDER#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_CREATE_DATETIME"> a.IM_CREATE_DATETIME = #IM_CREATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_DATETIME"> a.IM_LAST_UPDATE_DATETIME = #IM_LAST_UPDATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_OPERATOR_ID"> a.IM_LAST_UPDATE_OPERATOR_ID = #IM_LAST_UPDATE_OPERATOR_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION"> a.IM_VERSION = #IM_VERSION#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION_DATE"> a.IM_VERSION_DATE = #IM_VERSION_DATE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DATA_STATUS"> a.IM_DATA_STATUS = #IM_DATA_STATUS#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_IS_ACTIVITY"> a.IM_IS_ACTIVITY = #IM_IS_ACTIVITY#</isNotEmpty>
  </dynamic>
    <isNotEmpty prepend="AND" property="filterStartTime">
        <![CDATA[a.CREATE_DATETIME >= #filterStartTime#]]>
    </isNotEmpty>
    <isNotEmpty prepend="AND" property="filterEndTime">
        <![CDATA[ a.CREATE_DATETIME <= #filterEndTime# ]]>
    </isNotEmpty>
     <dynamic prepend="ORDER BY">
        <isNotEmpty property="orderSql">   
            $orderSql$   
        </isNotEmpty>
    </dynamic>   
    <dynamic prepend=" LIMIT ">
        <isNotEmpty property="startRow">
            #startRow#
        </isNotEmpty>
        <isNotEmpty  property="endRow">
            ,#endRow#
        </isNotEmpty>
   </dynamic>

     </select>
    <select id="IMenu_getCount_Time_Order" parameterClass="java.util.HashMap" resultClass="java.lang.Long">
        select count(1) as value from TB_I_MENU a  
  <dynamic prepend="WHERE ">    
    <isNotEmpty prepend="AND" property="IM_ID"> a.IM_ID = #IM_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PARENT_ID"> a.IM_PARENT_ID = #IM_PARENT_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LEVEL"> a.IM_LEVEL = #IM_LEVEL#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PATH"> a.IM_PATH like '%'||#IM_PATH#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_NAME"> a.IM_NAME like '%'||#IM_NAME#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DESCRIPTION"> a.IM_DESCRIPTION like '%'||#IM_DESCRIPTION#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_URL"> a.IM_URL like '%'||#IM_URL#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_STATUS_CODE"> a.IM_STATUS_CODE = #IM_STATUS_CODE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_ORDER"> a.IM_ORDER = #IM_ORDER#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_CREATE_DATETIME"> a.IM_CREATE_DATETIME = #IM_CREATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_DATETIME"> a.IM_LAST_UPDATE_DATETIME = #IM_LAST_UPDATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_OPERATOR_ID"> a.IM_LAST_UPDATE_OPERATOR_ID = #IM_LAST_UPDATE_OPERATOR_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION"> a.IM_VERSION = #IM_VERSION#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION_DATE"> a.IM_VERSION_DATE = #IM_VERSION_DATE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DATA_STATUS"> a.IM_DATA_STATUS = #IM_DATA_STATUS#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_IS_ACTIVITY"> a.IM_IS_ACTIVITY = #IM_IS_ACTIVITY#</isNotEmpty>
  </dynamic>
    <isNotEmpty prepend="AND" property="filterStartTime">
        <![CDATA[a.CREATE_DATETIME >= #filterStartTime#]]>
    </isNotEmpty>
    <isNotEmpty prepend="AND" property="filterEndTime">
        <![CDATA[ a.CREATE_DATETIME <= #filterEndTime# ]]>
    </isNotEmpty>
    </select>

    <select id="IMenu_getLastVersion"  parameterClass="iMenu" resultClass="java.lang.Integer">
        select max(IM_VERSION) as value   from  TB_I_MENU a
  <dynamic prepend="WHERE ">    
     <isNotEmpty prepend="AND" property="IM_ID"> a.IM_ID = #IM_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PARENT_ID"> a.IM_PARENT_ID = #IM_PARENT_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LEVEL"> a.IM_LEVEL = #IM_LEVEL#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_PATH"> a.IM_PATH like '%'||#IM_PATH#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_NAME"> a.IM_NAME like '%'||#IM_NAME#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DESCRIPTION"> a.IM_DESCRIPTION like '%'||#IM_DESCRIPTION#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_URL"> a.IM_URL like '%'||#IM_URL#||'%'</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_STATUS_CODE"> a.IM_STATUS_CODE = #IM_STATUS_CODE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_ORDER"> a.IM_ORDER = #IM_ORDER#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_CREATE_DATETIME"> a.IM_CREATE_DATETIME = #IM_CREATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_DATETIME"> a.IM_LAST_UPDATE_DATETIME = #IM_LAST_UPDATE_DATETIME#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_LAST_UPDATE_OPERATOR_ID"> a.IM_LAST_UPDATE_OPERATOR_ID = #IM_LAST_UPDATE_OPERATOR_ID#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION"> a.IM_VERSION = #IM_VERSION#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_VERSION_DATE"> a.IM_VERSION_DATE = #IM_VERSION_DATE#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_DATA_STATUS"> a.IM_DATA_STATUS = #IM_DATA_STATUS#</isNotEmpty>
    <isNotEmpty prepend="AND" property="IM_IS_ACTIVITY"> a.IM_IS_ACTIVITY = #IM_IS_ACTIVITY#</isNotEmpty>
  </dynamic>
    </select>
</sqlMap>

链接地址：[url]http://kevin12.iteye.com/blog/1953571[/url]
学习地址：[url]http://www.codesky.net/article/201007/167572.html[/url]
jinyonglu168
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
ibatis动态多条件组合查询
03-17
ibatis动态多条件组合查询 实例 说明
Mybatis 中 Oracle 的拼接模糊查询及用法详解
08-27
本文将详细介绍 Mybatis 中 Oracle 的拼接模糊查询及用法，旨在帮助开发者更好地使用 Mybatis 实现 Oracle 数据库的查询操作。 一、拼接模糊查询的正确写法 在 Oracle 中，拼接模糊查询的正确写法是使用 `concat` ...
转载-ibatis中使用like模糊查询 - Oracle数据库栏目
jianxg1314的博客
07-09 652
ibatis中使用like模糊查询无效的方法：12Sql代码  select  *  from table1 where name like '%#name#%'Sql代码select  *  from table1 where name like '%#name#%'两种有效的方法：1. 使用$代替#。此种方法就是去掉了类型检查，使用字符串连接，不过可能会有sql注入风险。12Sql代码  se...
ibits和oracle模糊查询,iBATIS 模糊查询LIKE (转) - 我的博客 - ITeye技术网站
weixin_39808953的博客
04-04 138
iBatis 开发指南告诉我们，当 Person 对象的 name 属性不为 null 时启用 name 查询条件在映射文件 person.xml 中的配置为Xml代码 selectidasid,nameasname,passwdaspasswdfromperson(namelike#name#)select id as id,name as name,passwd as ...
Oracle的模糊查询
最新发布
杨大脸的博客
12-21 343
ORACLE like 模糊查询
ibatis 搭配oracle做批量插入小结
岁寒松柏
12-12 9422
比如，经常遇到的情况是，要把表A中的符合条件的数据全部取出来，形成一个结果集，  然后针对结果集中的每一条数据，循环插入到数据表B中去，除了传统的在JAVA代码中  FOR循环来做外，在ibatis 2中，还增加了iterate标签，可以用来生成循环要执行的语句，介绍如下：      property="" /*可选,            从传入的参数集合中使用属性名去
Oracle模糊查询
tiantiantbtb的博客
06-21 216
Oracle模糊查询和mysql不太一样
iBATIS模糊查询
07-23
例如，MySQL使用LIKE谓词，Oracle使用LIKE谓词或REGEXP_LIKE函数，SQL Server使用LIKE谓词或PATINDEX函数。因此，在使用iBATIS进行模糊查询时，需要根据数据库引擎的不同选择合适的查询语句。 3. 优化查询性能：...
ibatis_动态查询条件
09-03
下面是一个简单的示例，演示如何使用 iBatis 的动态查询条件： ```xml select id, note from Product id = #id# note like '%#note#%' ``` 在上面的示例中，我们使用了 `isNotNull` 和 `...
Ibatis多表查询
09-19
Ibatis多表查询，一个小小的多表查询实例教你如何用ibatis进行多表查询
ibits和oracle模糊查询,在使用ibatis实现多条件模糊查询的语句
weixin_39968128的博客
04-04 104
大家一般能想到的做法是,将String语句进行拼串例如:String sql1="select * from 表名where";String sql2="条件1";String sql3="条件2";String sql4="条件3";......String sqln="条件n";如果从页面 用户只填写了条件2,3则根据程序拼串String sql=sql1+" "+sql2+" and"+sq...
ibatis 模糊查询
RaoFaming的博客
05-07 151
select id,note from Product id = #id# ...
oracle配置ibatis动态多条件组合模糊、分页查询
天高任鸟飞，海阔凭鱼跃
10-09 261
链接地址：[url]http://kevin12.iteye.com/blog/1953780[/url] [color=red]注意的地方：&lt;就是号，即大于号；[/color] 最近将流程项目的数据库从mysql改成oracle的数据库，原先配置的mysql的ibatis文件就不能用了，比如分页功能，模糊查询都不能用了。下面记录我修改的oracle配置ibatis的分页以及动态多条件组...
使用bind进行动态模糊查询
beidaol的专栏
06-15 1269
转自：https://blog.csdn.net/yangshangwei/article/details/80073978 https://www.cnblogs.com/kangkaii/p/8421837.html 概述 bind标签可以使用OGNL表达式创建一个变量并将其绑定到上下文中。 用法 <select id="selectSysUsersAdvancedWithW...
Oracle和MySQL在标签中使用模糊查询
weixin_45849948的博客
08-19 354
Oracle动态SQL中的模糊查询 使用 || 来进行模糊匹配 <if test="name != null"> NAME like '%' || #{name} || '%' </if> MySQL动态SQL中的模糊查询 使用 concat 来进行模糊匹配 <if test="name != null"> NAME like CONCAT('%', #{name},'%') </if> ...
oracle中查询曾报错的sql,ibatis动态多条件查询及模糊查询(oracle,mysql,sql)
weixin_39612057的博客
04-14 296
.htmliBatis 开发指南告诉我们，当 Person 对象的 name 属性不为 null 时启用 name 查询条件在映射文件 person.xml 中的配置为select id as id,name as name,passwd as passwd from person(name like #name#) select id as id,name as name,passwd as p...
oracle模糊查询
a2_45688的博客
04-20 1万+
模糊查询 like 语法: select * from 表名 where 字段 like '%值%'; 匹配带有该值的所有字段的值 select * from emp where ename like '%S%'; 匹配ename字段所有值中带有S的名字 select * from 表名 where 字段 like '值%'; 匹配以该值开头的所有字段的值 select * from emp where ename like 'S%'; 匹配ename字段以S开头的所有字段值 selec...
Oracle 模糊查询方法
热门推荐
陌上花开，可缓缓归矣
10-12 3万+
在这个信息量剧增的时代，如何帮助用户从海量数据中检索到想要的数据，模糊查询是必不可少的。那么在Ｏｒａｃｌｅ中模糊查询是如何实现的呢？   一、我们可以在where子句中使用like关键字来达到Oracle模糊查询的效果；在Where子句中，可以对datetime、char、varchar字段类型的列用Like关键字配合通配符来实现模糊查询，以下是可使用的通配符： （1）% ：零或者多个字符，
Oracle 模糊查询
weixin_34248849的博客
01-12 1万+
在Where子句中，可以对datetime、char、varchar字段类型的列用Like子句配合通配符选取那些“很像...”的数据记录，以下是可使用的通配符：%   零或者多个字符_    单一任何字符（下划线）\     特殊字符[]     在某一范围内的字符，如[0-9]或者[aeth][^]    不在某范围内的字符，如[^0-9]或者[^aeth] 其中关于条件，SQL提供了...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值