<?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"><mapper namespace="com.atguigu.mybatis.dao.EmployeeMapperDynamicSQL"><select id="getEmpsTestInnerParameter" resultType="com.atguigu.mybatis.bean.Employee"><bind name="_lastName" value="'%'+lastName+'%'"/><if test="_databaseId=='mysql'">
select * from tbl_employee
<if test="_parameter!=null">
where last_name like #{_lastName}</if></if><if test="_databaseId=='oracle'">
select * from employees
<!--<if test="_parameter!=null">
where last_name like #{_parameter.lastName}</if>--></if></select></mapper>