`UserMapper.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" > <mapper namespace="net.youworker.mapper.UserMapper"> <!--auto generated Code--> <resultMap id="AllColumnMap" type="net.youworker.domain.User"> <result column="id" property="id"/> <result column="username" property="username"/> <result column="birthday" property="birthday"/> <result column="sex" property="sex"/> <result column="address" property="address"/> </resultMap> <!--auto generated Code--> <sql id="all_column"> id, username, birthday, sex, address </sql> <!--查询所有--> <select id="findAll" resultMap="AllColumnMap"> SELECT <include refid="all_column"/> FROM user LIMIT 1000 </select> </mapper> ~~~