一.Mapper.xml 传递参数详解:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--
parameterType:参数类型
简单类型:基本数据类型,String类型 参数名随便写
pojo 类型: 参数名pojo类型中的属性名
-->
<mapper namespace="com.project.project.UserDao">
<!--#{user.name} 引用属性中的属性名-->
<select id="findUserByQueryVo" parameterType="queryVO" resultType="sysUser">
select * from sys_user where name like "%"#{user.name}"%" limit #{startIndex},#{pageSize}
</select>
<!--
如果传递的多个参数
parameterType:省略不配置
引入时: param1 ,param2,......
-->
<select id="findUsers" resultType="sysUser">
select * from sys_user where name like "%"#{param3}"%" limit #{param1},#{param2}
</select>
<!--
传递map
属性名自己指定
引用时引用属性名即可
-->
<select id="findUserByMap" parameterType="map" resultType="sysUser">
select * from sys_user where name like "%"#{name}"%" limit #{startIndex},#{pageSize}
</select>
</mapper>
Mybatis 框架配置文件详解(SqlMapConfig.xml&&Mapper.xml)
Mybatis Mapper.xml 增删改查详解