<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.bgy.mybatis.dao.EmployeeMapper"><!--
参数处理,单个参数处理
where id = #{id} 中 #{参数} 可以为任意值
--><selectid="getEmpById"resultType="com.bgy.mybatis.bean.Employee">
select
id,last_name,gender,email
from
tbl_employee
where
id = #{idabc}
</select><!--
参数处理,多个参数处理
--><selectid="getEmpByIdAndLastName"resultType="com.bgy.mybatis.bean.Employee">
select
id,last_name,gender,email
from
tbl_employee
where
id=#{param1} and last_name=#{param2}
</select></mapper>
EmployeeMapper.xml(使用注解后)
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.bgy.mybatis.dao.EmployeeMapper"><!--
参数处理,单个参数处理
where id = #{id} 中 #{参数} 可以为任意值
--><selectid="getEmpById"resultType="com.bgy.mybatis.bean.Employee">
select
id,last_name,gender,email
from
tbl_employee
where
id = #{idabc}
</select><!--
参数处理,多个参数处理
--><selectid="getEmpByIdAndLastName"resultType="com.bgy.mybatis.bean.Employee">
select
id,last_name,gender,email
from
tbl_employee
where
id=#{id} and last_name=#{lastName}
</select></mapper>