sql語(yǔ)句(拼接條件后):SELECT?DISTINCT?article.id,article.title,article.content,article.summarize,article.publish_time?as?publish_time,article.page_views?as?pageViews?,?
topic.id?as?topic_id,?topic.name?as?topic_name,?topic.summarize?as?topic_summarize?,?
tag.id?as?tag_id,?tag.name?as?tag_name?
FROM?tb_article?article?LEFT?JOIN?tb_topic?topic?ON?article.topic_id?=?topic.id?
LEFT?JOIN?tb_article_tag?article_tag?ON?article.id?=?article_tag.article_id
?LEFT?JOIN?tb_tag?tag?ON?tag.id?=?article_tag.tag_id
??ORDER?BY?article.id?limit?0,5xml映射:<resultMap?id="allResult"?type="space.entity.Article">
????<id?column="id"?property="id"/>
????<result?column="title"?property="title"/>
????<result?column="content"?property="content"/>
????<result?column="summarize"?property="summarize"/>
????<result?column="publish_time"?property="publishTime"/>
????<result?column="page_views"?property="pageViews"/>
????<association?column="topic_id"?property="topic"?resultMap="space.dao.TopicDao.openResultMapper"/>
????<collection?property="tagList"?ofType="Tag"?resultMap="space.dao.TagDao.openResultMapper"/>
</resultMap>會(huì)出現(xiàn)這種情況mybatis會(huì)把兩條記錄合并成一條,就少了一條記錄也出現(xiàn)了這種情況當(dāng)兩個(gè)條記錄不在同一頁(yè),mybatis是看不到他們的,就會(huì)出現(xiàn)這種總數(shù)+1的情況現(xiàn)在問(wèn)題來(lái)了,sql語(yǔ)句怎么寫(xiě),才能把多對(duì)多的記錄放在一行,并且配合mybatis的映射呢?
添加回答
舉報(bào)
0/150
提交
取消