<resultMap id="type" type="com.jiuqi.entity.Type"> <id property="id" column="tid"/> <result property="name" column="name"/> <collection property="blogs" ofType="com.jiuqi.entity.Blog"> <id property="id" column="bid"/> <result property="title" column="title"/> <result property="typeId" column="type_id"/> </collection> </resultMap> <!--分类页面查询--> <select id="getAllTypeAndBlog" resultMap="type"> select t.id tid, t.name, b.id bid, b.title,b.type_id from t_type t,t_blog b where t.id = b.type_id </select>
sql语句写在接口对应的方法上。@Select等注解
在Type类里面定义一个Blog类类的集合,sql语句类似这样:
@Select(" SELECT * FROM z_function_menu WHERE zfm_level = 1 ORDER BY zfm_order") @Results(id = "MenuDTO", value = { @Result(column = "{id = zfm_id}", property = "sonMenu", many = @Many(select = "com.inphase.wxVip.mapper.menu.ZFunctionMenuMapper.selectSonMenu")) })
您好,我是有问必答小助手,您的问题已经有小伙伴解答了,您看下是否解决,可以追评进行沟通哦~
如果有您比较满意的答案 / 帮您提供解决思路的答案,可以点击【采纳】按钮,给回答的小伙伴一些鼓励哦~~
ps:问答VIP仅需29元,即可享受5次/月 有问必答服务,了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632