mybatis学习（三）

一对多

private int id;
    private String username;// 用户姓名
    private String sex;// 性别
    private Date birthday;// 生日
    private String address;// 地址
    //建立用户与订单的多表关系：一对多
    private List<Orders> ordersList;

<mapper namespace="cn.hskj.mapper.UserMapper">

    <resultMap id="userMap" type="user">
        <id column="id" property="id"/>
        <result column="username" property="username"/>
        <!--配置用户与订单的映射关系：一对多
            对多的配置使用<collection>标签：
                property：对象中封装的集合属性
                ofType：集合对象的泛型
        -->
        <collection property="ordersList" ofType="orders">
            <id column="oid" property="id"/>
            <result column="number" property="number"/>
        </collection>
    </resultMap>
    <select id="findAll" resultMap="userMap">
        select u.*,o.id oid,o.number from user u
        left outer join
        orders o
        on u.id=o.user_id
    </select>
</mapper>

<mapper namespace="cn.hskj.mapper.OrdersMapper">

    <resultMap id="orderMap" type="orders">
        <id column="id" property="id"/>
        <result column="number" property="number"/>
        <!--订单与用户映射关系：一对一-->
        <association property="user" javaType="user">
            <result column="username" property="username"/>
        </association>
        <!--订单与商品的映射关系：对多-->
        <collection property="itemsList" ofType="items">
           <result column="name" property="name"/>
            <result column="price" property="price"/>
        </collection>
    </resultMap>

    <select id="findAll" resultMap="orderMap">
        select o.*,u.username,i.name,i.price
        from orders o
        LEFT JOIN user u on o.user_id=u.id
        left join orderdetail d on o.id=d.orders_id
        LEFT JOIN items i on d.items_id=i.id
    </select>
</mapper>

<mapper namespace="cn.hskj.mapper.UserMapper">

    <resultMap id="userMap" type="user">
        <id column="id" property="id"/>
        <result column="username" property="username"/>
        <!--配置用户与订单的映射关系：对多-->
        <collection property="ordersList" ofType="orders">
            <result column="number" property="number"/>
            <!--订单与商品的映射关系：对多-->
            <collection property="itemsList" ofType="items">
                <result column="name" property="name"/>
                <result column="price" property="price"/>
            </collection>
        </collection>
    </resultMap>
    <select id="findAll" resultMap="userMap">
        select u.*,o.number,i.name,i.price
        from user u
        LEFT JOIN orders o on u.id=o.user_id
        LEFT JOIN orderdetail d on o.id=d.orders_id
        LEFT JOIN items i on d.items_id=i.id
    </select>
</mapper>

延迟加载

对一

<mapper namespace="cn.hskj.mapper.OrdersMapper">

    <!--resultMap-->
    <resultMap id="ordersMap" type="orders">
        <id column="id" property="id"/>
        <result column="number" property="number"/>
        <!--配置关联查询用户信息
            select:关联查询的statement对象
            column:需要传入参数的查询列
        -->
        <association property="user" javaType="user" column="user_id" select="cn.itcast.mapper.UserMapper.findById" fetchType="lazy"/>
    </resultMap>
    <select id="findAll" resultMap="ordersMap">
        select * from orders
    </select>
</mapper>

对多

<mapper namespace="cn.hskj.mapper.UserMapper">

    <resultMap id="userMap" type="user">
        <id column="id" property="id"/>
        <result column="username" property="username"/>
       <!--订单关联查询-->
        <collection property="ordersList" ofType="orders" column="id" select="cn.itcast.mapper.OrdersMapper.findByUid" fetchType="lazy"/>
    </resultMap>
    <select id="findAll" resultMap="userMap">
        select * from user
    </select>
</mapper>

延迟加载的配置方式

1.全局延迟加载
	在核心配置文件中配置
	   <settings>
        <!--开启全局延迟加载-->
        <setting name="lazyLoadingEnabled" value="true"/>
    </settings>
2.局部延迟加载
	在需要延迟加载的关联查询中设置：fetchType="lazy"

1.延迟加载（按需加载，懒加载）
	需要时查询，不需要时不查询
2.立即加载
   需不需要都查询出来
   
一般来说：一对一选择立即加载，对多的查询选择延迟加载

注解

1.@Select(sql语句)
2.@Delete(sql语句)
3.@Update(sql语句)
4.@Insert(sql语句)
5.@Results():相当于
6.@Result()
7.@ResultMap:通过id调用已有的@Results
对多

public interface UserMapper {

    //查询所用用户信息
    @Select("select * from user")
    @Results({
            @Result(id = true,column = "id",property = "id"),
            @Result(column = "username",property = "username"),
            @Result(property = "ordersList",javaType = List.class,column = "id",
                    many = @Many(select = "cn.hskj.mapper.OrdersMapper.findByUid",fetchType = FetchType.LAZY))
    })
    List<User> findAll();
}

public interface OrdersMapper {
    @Select("select * from orders")
    //手动指定映射关系
    @Results(id="ordersMap",value = {
            //id:确定配置的是否是主键列
            @Result(id=true,column = "id",property = "id"),//主键列
            @Result(column = "number",property = "number"),
            @Result(property = "user",javaType =User.class,column = "user_id",
                    one = @One(select = "cn.hskj.mapper.UserMapper.findById",fetchType = FetchType.LAZY))
    })
    List<Orders> findAll();


    @Select("select number from orders where id=#{id}")
    @ResultMap("ordersMap")
    Orders findById(int id);
}