<?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"><!--namespace必须是dao接口的全限定类名--><mappernamespace="xyz.zhouzhousag.dao.IUserDAO"><!--根据查询的条件生成:有可能有地址,有可能有姓名,有可能没有--><selectid="findUserByCondition"parameterType="user"resultMap="userMap">
select * from user where 1 = 1
<iftest="userName !=null and userName!=''">
and username = #{userName}
</if></select></mapper>