1、映射语句
<select> <insert> <selectKey> <update> <delete> <statement> <sql> <include> <procedure>
举个例子:
<
sql
id
=
"resultValue"
>
SELECT DISTINCT userName
</
sql
>
<
sql
id
=
"from-user"
>
FROM `user`
</
sql
>
<
select
id
=
"queryAllUser"
resultClass
=
"string"
>
<
include
refid
=
"resultValue"
/>
<
include
refid
=
"from-user"
/>
</
select
>
2、内联参数
两个占位符 # 和 $
select * from user where userId = #userId#
select * from user where userName like '%$userName$%'
区别:ibatis处理方式不一样, #会被处理成一个预备语句参数, 而$不会做任何处理
select * from user where userId = ?
select * from user where userName like '%bluse%'
3、参数: javaBean和hashMap的区别
userName被错误的引用为 #user#, javaBean会报异常, 而hashmap只会返回null,不会报错
4、调用存储过程: