<!-- 查詢所有的訂單數(shù)據(jù) -->
    <!-- resultMap:填入配置的resultMap標簽的id值 -->
    <select id="queryOrderAll" resultMap="orderResultMap">
        SELECT id, user_id,
        number,
        createtime, note FROM `order`
    </select>

<!-- resultMap最終還是要將結(jié)果映射到pojo上，type就是指定映射到哪一個pojo -->
    <!-- id：設置ResultMap的id -->
    <resultMap type="order" id="orderResultMap">
        <!-- 定義主鍵 ,非常重要。如果是多個字段,則定義多個id -->
        <!-- property：主鍵在pojo中的屬性名 -->
        <!-- column：主鍵在數(shù)據(jù)庫中的列名 -->
        <id property="id" column="id" />
 
        <!-- 定義普通屬性 -->
        <result property="userId" column="user_id" />
        <result property="number" column="number" />
        <result property="createtime" column="createtime" />
        <result property="note" column="note" />
    </resultMap>

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private int id;
    private String name;
    private String password;
}

<select id="getUserList" resultType="User">
    select * from user;
</select>

<select id="getUserList" resultMap="UserMap">
    select * from user;
</select>
<resultMap id="UserMap" type="User">
    <result column="id" property="id"/>
    <result column="name" property="name"/>
    <result column="pwd" property="password"/>
</resultMap>