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>

 

 

评论

1 楼 aniyo 2012-03-02  

恩，学习了，原来只知道like只能用$$钱钱这个，不知道还可以这样用