mybatis many to one

    @Select("select * from box where box_manager_id=#{mid}" )
    @Results({
            @Result(property = "id",column = "id"),
            @Result(property = "no",column = "_no"),
            @Result(property = "status",column = "_status"),
            @Result(property = "useStatus",column = "_usestatus"),
            @Result(property = "cardNo",column = "card_no"),
            @Result(property = "username",column = "_username"),
            @Result(property = "boxManager",column = "box_manager_id",javaType = BoxManager.class,
                    one = @One(select = "com.smokecat.intelliRobot.mapper.BoxManagerDao.select")
            )
    })
    List<Box> findBymid(@Param("mid") Long mid);
    @Select("select * from box_manager where id=#{sid}")
    @Results({
            @Result(property = "id",column = "id"),
            @Result(property = "name",column = "_name"),
            @Result(property = "row",column = "_row"),
            @Result(property = "column",column = "_column"),
            @Result(property = "totalNum",column = "_total"),
            @Result(property = "num",column = "_num"),
            @Result(property = "storeid",column = "storeid"),
            @Result(property = "boxs",column = "mid",javaType = List.class,
            many = @Many( fetchType = FetchType.LAZY,select = "com.smokecat.intelliRobot.mapper.BoxDao.findBymid")),
    })
    BoxManager select(@Param("sid") Long id);


特别需要注意的是List 里面的column指向的是 many select方法里面的mid



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值