@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