mybatis的注解使用

@Select("SELECT * FROM orders where id=#{id}")
@Results({
        @Result(id=true,property = "id",column = "id"),
        @Result(id=true,property = "orderNum",column = "orderNum"),
        @Result(id=true,property = "orderTime",column = "orderTime"),
        @Result(id=true,property = "peopleCount",column = "peopleCount"),
        @Result(id=true,property = "orderDesc",column = "orderDesc"),
        @Result(id=true,property = "payType",column = "payType"),
        @Result(id=true,property = "orderStatus",column = "orderStatus"),
        @Result(id=true,property = "product",column = "productId",javaType = Product.class,one = @One(select = "com.jiu.dao.ProductDao.insertProduct")),//返回一个对象
        @Result(id=true,property = "member",column = "memberId",javaType = Member.class,one = @One(select = "com.jiu.dao.MemberDao.findById")),//返回一个对象

 @Result(id = true,property = "travellers", column="id",javaType =java.util.List.class,many = @Many(select = "com.jiu.dao.TravellerDao.findById"))//返回一个集合对象
})

Orders findById(Integer   id);

@Select("SELECT * FROM role WHERE id IN (SELECT roleId FROM `users_role` WHERE userId=#{id})")
  List <Role> findName(Integer id);