1.一个参数直接传

2.多参数，占位符顺序遍历参数：
Public User selectUser(String name,String password);
select * from t_user where name = #{0} and password=#{1}

3.Map传多参数
Public User selectUser(Map paramMap);
select * from t_user where name = #{paramMap.name} and password = #{paramMap.password}

4.@param传多参数
Public User selectUser(@param(“name”)String name, @param(“password”)String password);
select * from t_user where name = #{name} and password = #{password}

5.pojo传多参数
public List<User> getUserByParam(User user);
<select id="getUserByParam" resultType="com.wds.demo.entity.User" parameterType="com.wds.demo.entity.User" >
    select * from t_user t
    <where>
       <if test="{name} != null">
            t.name like CONCAT('%',#{name},'%')
       </if>
       <if test="{password} != null">
           and t.password like CONCAT('%',#{password},'%')
       </if>
    </where> 
</select> 

// 执行器
Executor (update, query, flushStatements, commit, rollback, getTransaction, close, isClosed)
// 请求参数处理
ParameterHandler (getParameterObject, setParameters)
// 返回结果集处理
ResultSetHandler (handleResultSets, handleOutputParameters)
// SQL语句构建
StatementHandler (prepare, parameterize, batch, update, query)

@Slf4j
@Intercepts({ @Signature(type = Executor.class, method = "update", args = { MappedStatement.class, Object.class }) })
public class CommonFieldInterceptor implements Interceptor { 
	// 公共字段值设置
	public void setCommonFieldValues(Object bean) {
		if(bean == null) {
			return;
		}
		try {
			// 创建时间，在为空时写入当前时间
			if (BeanUtil.containsProp(bean, "updateTime") && BeanUtil.getPropValue(bean, "updateTime") == null) {
				BeanUtil.setPropValue(bean, "updateTime", new Date());
			}
			// 修改时间，始终写入当前时间
			if (BeanUtil.containsProp(bean, "updateTime")) { 
				BeanUtil.setPropValue(bean, "updateTime", new Date());
			}
		} catch (Exception e) {
			logger.error("设置{}对象公共字段时出错！", new Object[] { bean.getClass().getName() }, e);
		}
	}

	@Override
	public Object intercept(Invocation invocation) throws Throwable {
		// MappedStatement mappedStatement = (MappedStatement)
		// invocation.getArgs()[0];
		// String sqlId = mappedStatement.getId();
		// String namespace = sqlId.substring(0, sqlId.lastIndexOf('.'));
		// Executor exe = (Executor) invocation.getTarget();
		String methodName = invocation.getMethod().getName();
		if (methodName.equals("update")) {
			// 对pojo对象设置公共字段
			Object bean = invocation.getArgs()[1];
			setCommonFieldValues(bean);
		}
		return invocation.proceed();
	}

	@Override
	public Object plugin(Object target) {  //Object target 被代理的目标对象
		return Plugin.wrap(target, this);  //wrap把拦截器对象封装成Plugin代理对象.
	}

	@Override
	public void setProperties(Properties properties) {

	}
}

//示例：三表级联，两层嵌套
<resultMap id="PerquisiteResultMap" type="com.wds.entity.model.Organization">
    <id column="id" property="id" jdbcType="INTEGER"/>
    <result column="name" property="name" jdbcType="VARCHAR"/>

    <collection property="perquisites" ofType="com.wds.entity.model.Perquisite">
        <id column="per_id" jdbcType="INTEGER" property="id"/>
        <result column="org_id" jdbcType="INTEGER" property="orgId"/>
        <result column="per_name" jdbcType="VARCHAR" property="name"/>

        <collection property="perquisiteSpans" ofType="com.wds.entity.model.PerquisiteSpan">
            <id column="span_id" jdbcType="INTEGER" property="id"/>
            <result column="perquisite_id" jdbcType="INTEGER" property="perquisiteId"/>
        </collection>
    </collection>
</resultMap>

<select id="selectOrgWithPerquisite" resultMap="PerquisiteResultMap">
    select org.id as id, org.name as name, 
        per.id as per_id, per.name as per_name,
	    span.id span_id, span.perquisite_id
    from organization org 
    left join perquisite per on per.org_id = org.id
	left join perquisite_span span on span.perquisite_id = per.id
    where org.delete_tate = 'A' and per.delete_state = 'A'  and span.delete_state = 'A'
</select>