MyBatis 注解查询一对多(@Results @One)
作者:
何佳阳 | 来源:发表于
2020-07-29 00:43 被阅读0次//在userMapper里:
@Results({
@Result(property = "id", column = "id"),
@Result(property = "username", column = "username"),
@Result(property = "orders", column = "uid", javaType = List.class,
many = @Many(select = "OrderMapper.findOrderByUserId"))
})
@Select("select * from User")
public List<Order> findUserAndOrders();
//在orderMapper里:
@Select("select * from orders where user_id = #{userId}")
public User findOrderByUserId(Integer userId);
本文标题:MyBatis 注解查询一对多(@Results @One)
本文链接:https://www.haomeiwen.com/subject/qsycrktx.html
网友评论