一对多：需要使用many属性和@Many注解
@Result(
property = “1表JavaBean属性名”,
column = “1表字段名”,
many = @Many(select = “多表Mapper的方法签名”)
)
JavaBean类之间的关系：
public class User {
@Id
private String uid;
private String username;
..
//一个用户有多个订单
private List orderList = new ArrayList<>();
}
public class Order {
private String oid; // 订单编号
private Date ordertime; // 下单时间
...
//一个订单对应一个用户
private User user;
}
Mapper：
public interface OrderMapper {
@Select("select * from orders where uid = #{uid}")
public Order findOrdersByUserId(@Param("uid") String uid) ;
}
public interface UserMapper {
@Select("select * from user")
@Results(id = "userResult", value = {
@Result(property = "uid", column = "uid", id = true),
@Result(property = "username", column = "username"),
@Result(property = "password", column = "password"),
@Result(property="orderList" ,
many=@Many(select="com.czxy.ssm.mapper.OrderMapper.findOrdersByUserId"),
column="uid")
})
public List selectAll();
}
