ibatis sqlMap.xml 文件 like 查询的三种方案

ibatis sqlMap.xml 文件 like 查询的三种方案

dtd 的修改在这里有说明 http://wuxiubing.iteye.com/blog/1010635
原: dtd 位置 “http://ibatis.apache.org/dtd/sql-map-2.dtd”

<?xml version="1.0" encoding="UTF-8" ?> 

<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "./sql-map-2.dtd"> 

<sqlMap namespace="Account"> 
<select id="getAllStudentLike1" resultClass="hashmap" parameterClass="String"> 
    select * from student where name like #name# 
    <!-- sqlMapClient.queryForList("getAllStudentLike1" , "%张") ; --> 
</select> 
<select id="getAllStudentLike2" resultClass="hashmap" parameterClass="String"> 
    select * from student where name like '%$name$%' 
    <!-- sqlMapClient.queryForList("getAllStudentLike2" , "张") ; --> 
</select> 
<select id="getAllStudentLike3" resultClass="hashmap" parameterClass="String"> 
    select * from student where name like '%'||#name#||'%' 
    <!-- sqlMapClient.queryForList("getAllStudentLike3" , "张") ; --> 
</select> 
</sqlMap>

转自:http://wuxiubing.iteye.com/blog/1010648