数据库的模糊查询mybatis

<!-- oracle -->
<select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
    select * from t_user where user_name like CONCAT('%',#{search_name},'%')
</select>
<!-- 或者 -->
<select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
    select * from t_user where user_name like '%'||#{search_name}||'%' 
</select>

<!-- mysql -->
<select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
    select * from t_user where user_name like CONCAT('%',#{search_name},'%')
</select>
    
<!-- sql server -->
<select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
    select * from t_user where user_name like '%'+#{search_name}+'%'
</select>

<!-- db2 -->
<select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
    select * from t_user where user_name like CONCAT('%',#{search_name},'%')  
</select>
<!-- 或者 -->
<select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
    select * from t_user where user_name like '%'||#{search_name}||'%' 
</select>

 

posted @ 2015-12-08 23:54  夏末、初秋  阅读(247)  评论(0)    收藏  举报