可以用这种查到N表
背景:活动推荐关联活动关联商家, 活动推荐需要显示活动信息及商家name,并模糊查询活动结束时间段,活动主题,商家名称
1.活动推荐实体类: 定义活动属性,商家属性,及需要用到的字段属性 getset
2.活动推荐实体类:
// 取出需要的关联表里的字段
,joinTable = {@JoinTable(type = Type.LEFT_JOIN, entity = ZepodActivity.class, alias = "c", on = "c.id =a.activity_id", attrName = "zactivity", columns = { @Column(name="activity_title", label="活动主题"), @Column(name="activity_city", label="活动城市" ), @Column(name="activity_image", label="活动图片" ), @Column(name="activity_intro", label="活动简介" ), @Column(name="activity_begin_time", label="活动开始时间" ), @Column(name="activity_end_time", label="活动结束时间" , attrName ="activityEndTime" ,queryType=QueryType.LTE), @Column(name="activity_year", label="活动年份"), @Column(name="activity_month", label="活动月份" ), @Column(name="activity_end_time", attrName ="time" , label="活动结束时间" ,queryType=QueryType.GTE), }),@JoinTable(type = Type.LEFT_JOIN, entity = ZepodBusiness.class, alias = "b", on = "b.id =c.business_id", attrName = "zbusiness", columns = { @Column(name="business_name", label="商家名称" ,queryType=QueryType.LIKE), })},orderBy="a.create_date DESC"
3:list页面 加上需要模糊查询的东西就OK、了