Mapping:
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mapper namespace="com.hey.liyankun.admin.mapper.HeyArticleCustomMapper" > <resultMap id="article_map" type="com.hey.liyankun.admin.pojo.HeyArticle" > <id column="id" property="id" jdbcType="INTEGER" /> <result column="title" property="title" jdbcType="VARCHAR" /> <result column="create_time" property="createTime" jdbcType="TIMESTAMP" /> <result column="author" property="author" jdbcType="VARCHAR" /> <result column="category_id" property="categoryId" jdbcType="INTEGER" /> <result column="content" property="content" jdbcType="LONGVARCHAR" /> <association property="heyCategory" javaType="com.hey.liyankun.admin.pojo.HeyCategory"> <id column="id" property="id" jdbcType="INTEGER"/> <result column="name" property="name"/> </association> </resultMap> <select id="getArticleList" resultMap="article_map"> SELECT hey_article.*, hey_category.id, hey_category.name FROM hey_article LEFT JOIN hey_category ON hey_article.category_id = hey_category.id </select> </mapper>
pojo:
package com.hey.liyankun.admin.pojo; import java.util.Date; import javax.persistence.*; @Table(name = "hey_article") public class HeyArticle { /** * 文章id */ @Id private Integer id; /** * 文章标题 */ private String title; /** * 创建时间 */ @Column(name = "create_time") private Date createTime; /** * 文章作者 */ private String author; /** * 文章分类id */ @Column(name = "category_id") private Integer categoryId; /** * 文章内容 */ private String content; private HeyCategory heyCategory; public HeyCategory getHeyCategory() { return heyCategory; } public void setHeyCategory(HeyCategory heyCategory) { this.heyCategory = heyCategory; } /** * 获取文章id * * @return id - 文章id */ public Integer getId() { return id; } /** * 设置文章id * * @param id 文章id */ public void setId(Integer id) { this.id = id; } /** * 获取文章标题 * * @return title - 文章标题 */ public String getTitle() { return title; } /** * 设置文章标题 * * @param title 文章标题 */ public void setTitle(String title) { this.title = title; } /** * 获取创建时间 * * @return create_time - 创建时间 */ public Date getCreateTime() { return createTime; } /** * 设置创建时间 * * @param createTime 创建时间 */ public void setCreateTime(Date createTime) { this.createTime = createTime; } /** * 获取文章作者 * * @return author - 文章作者 */ public String getAuthor() { return author; } /** * 设置文章作者 * * @param author 文章作者 */ public void setAuthor(String author) { this.author = author; } /** * 获取文章分类id * * @return category_id - 文章分类id */ public Integer getCategoryId() { return categoryId; } /** * 设置文章分类id * * @param categoryId 文章分类id */ public void setCategoryId(Integer categoryId) { this.categoryId = categoryId; } /** * 获取文章内容 * * @return content - 文章内容 */ public String getContent() { return content; } /** * 设置文章内容 * * @param content 文章内容 */ public void setContent(String content) { this.content = content; } public HeyArticle(Integer id, String title, Date createTime, String author, Integer categoryId, String content, HeyCategory heyCategory) { this.id = id; this.title = title; this.createTime = createTime; this.author = author; this.categoryId = categoryId; this.content = content; this.heyCategory = heyCategory; } public HeyArticle() { } @Override public String toString() { return "HeyArticle{" + "id=" + id + ", title='" + title + '\'' + ", createTime=" + createTime + ", author='" + author + '\'' + ", categoryId=" + categoryId + ", content='" + content + '\'' + ", heyCategory=" + heyCategory + '}'; } }