mybatis学习(52):扩展结果的展现

前端歌谣

于 2022-07-08 09:27:14 发布

阅读量570

点赞数

文章标签：大数据

本文链接：https://blog.csdn.net/qq_41632427/article/details/125671703

版权

歌谣-java-mybatis学习专栏收录该内容

57 篇文章 1 订阅

订阅专栏

首先使用逆向工程创建相关类

数据库表

author

blog

新建一个项目，将逆向工程的生成的拷贝进来

配置文件

log4j.properties

### \u914D\u7F6E\u6839 ###
log4j.rootLogger = debug,console ,fileAppender,dailyRollingFile,ROLLING_FILE,MAIL,DATABASE

### \u8BBE\u7F6E\u8F93\u51FAsql\u7684\u7EA7\u522B\uFF0C\u5176\u4E2Dlogger\u540E\u9762\u7684\u5185\u5BB9\u5168\u90E8\u4E3Ajar\u5305\u4E2D\u6240\u5305\u542B\u7684\u5305\u540D ###
log4j.logger.org.apache=dubug
log4j.logger.java.sql.Connection=dubug
log4j.logger.java.sql.Statement=dubug
log4j.logger.java.sql.PreparedStatement=dubug
log4j.logger.java.sql.ResultSet=dubug

### \u914D\u7F6E\u8F93\u51FA\u5230\u63A7\u5236\u53F0 ###
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern = %d{ABSOLUTE} %5p %c{1}:%L - %m%n
mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
   <setting name="useGeneratedKeys" value="true"/>
</settings>
<typeAliases>
   
   <package name="com.geyao.mybatis.pojo"/>

   <package name="com.geyao.mybatis.mvo"/>
</typeAliases>



<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />

<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/blog_gp1701?serverTimezone=GMT%2B8" />
<property name="username" value="root" />
<property name="password" value="123" />
</dataSource>
</environment>
</environments>
<mappers>

<mapper resource="com/geyao/mybatis/mapper/BlogMapper.xml"/>
<mapper resource="com/geyao/mybatis/mapper/AuthorMapper.xml"/>

<mapper resource="com/geyao/mybatis/mapper/BlogMapperCustom.xml"/>
</mappers>

</configuration>
com.geyao.mybatis.mapper

BlogMapper.java

package com.geyao.mybatis.mapper;

import com.geyao.mybatis.pojo.Blog;
import com.geyao.mybatis.pojo.BlogExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface BlogMapper {
int countByExample(BlogExample example);

int deleteByExample(BlogExample example);

int insert(Blog record);

int insertSelective(Blog record);

List<Blog> selectByExample(BlogExample example);

int updateByExampleSelective(@Param("record") Blog record, @Param("example") BlogExample example);

int updateByExample(@Param("record") Blog record, @Param("example") BlogExample example);
}
BlogMapper.xml

<?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.geyao.mybatis.mapper.BlogMapper" >
<resultMap id="BaseResultMap" type="com.geyao.mybatis.pojo.Blog" >
<result column="id" property="id" jdbcType="INTEGER" />
<result column="title" property="title" jdbcType="VARCHAR" />
<result column="authod_id" property="authodId" jdbcType="INTEGER" />
<result column="state" property="state" jdbcType="VARCHAR" />
<result column="featured" property="featured" jdbcType="TINYINT" />
<result column="style" property="style" jdbcType="VARCHAR" />
</resultMap>
<sql id="Example_Where_Clause" >
<where >
<foreach collection="oredCriteria" item="criteria" separator="or" >
<if test="criteria.valid" >
<trim prefix="(" suffix=")" prefixOverrides="and" >
<foreach collection="criteria.criteria" item="criterion" >
<choose >
<when test="criterion.noValue" >
and ${criterion.condition}
</when>
<when test="criterion.singleValue" >
and ${criterion.condition} #{criterion.value}
</when>
<when test="criterion.betweenValue" >
and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
</when>
<when test="criterion.listValue" >
and ${criterion.condition}
<foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >
#{listItem}
</foreach>
</when>
</choose>
</foreach>
</trim>
</if>
</foreach>
</where>
</sql>
<sql id="Update_By_Example_Where_Clause" >
<where >
<foreach collection="example.oredCriteria" item="criteria" separator="or" >
<if test="criteria.valid" >
<trim prefix="(" suffix=")" prefixOverrides="and" >
<foreach collection="criteria.criteria" item="criterion" >
<choose >
<when test="criterion.noValue" >
and ${criterion.condition}
</when>
<when test="criterion.singleValue" >
and ${criterion.condition} #{criterion.value}
</when>
<when test="criterion.betweenValue" >
and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
</when>
<when test="criterion.listValue" >
and ${criterion.condition}
<foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >
#{listItem}
</foreach>
</when>
</choose>
</foreach>
</trim>
</if>
</foreach>
</where>
</sql>
<sql id="Base_Column_List" >
id, title, authod_id, state, featured, style
</sql>
<select id="selectByExample" resultMap="BaseResultMap" parameterType="com.geyao.mybatis.pojo.BlogExample" >
select
<if test="distinct" >
distinct
</if>
<include refid="Base_Column_List" />
from blog
<if test="_parameter != null" >
<include refid="Example_Where_Clause" />
</if>
<if test="orderByClause != null" >
order by ${orderByClause}
</if>
</select>
<delete id="deleteByExample" parameterType="com.geyao.mybatis.pojo.BlogExample" >
delete from blog
<if test="_parameter != null" >
<include refid="Example_Where_Clause" />
</if>
</delete>
<insert id="insert" parameterType="com.geyao.mybatis.pojo.Blog" >
insert into blog (id, title, authod_id,
state, featured, style
)
values (#{id,jdbcType=INTEGER}, #{title,jdbcType=VARCHAR}, #{authodId,jdbcType=INTEGER},
#{state,jdbcType=VARCHAR}, #{featured,jdbcType=TINYINT}, #{style,jdbcType=VARCHAR}
)
</insert>
<insert id="insertSelective" parameterType="com.geyao.mybatis.pojo.Blog" >
insert into blog
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="id != null" >
id,
</if>
<if test="title != null" >
title,
</if>
<if test="authodId != null" >
authod_id,
</if>
<if test="state != null" >
state,
</if>
<if test="featured != null" >
featured,
</if>
<if test="style != null" >
style,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="id != null" >
#{id,jdbcType=INTEGER},
</if>
<if test="title != null" >
#{title,jdbcType=VARCHAR},
</if>
<if test="authodId != null" >
#{authodId,jdbcType=INTEGER},
</if>
<if test="state != null" >
#{state,jdbcType=VARCHAR},
</if>
<if test="featured != null" >
#{featured,jdbcType=TINYINT},
</if>
<if test="style != null" >
#{style,jdbcType=VARCHAR},
</if>
</trim>
</insert>
<select id="countByExample" parameterType="com.geyao.mybatis.pojo.BlogExample" resultType="java.lang.Integer" >
select count(*) from blog
<if test="_parameter != null" >
<include refid="Example_Where_Clause" />
</if>
</select>
<update id="updateByExampleSelective" parameterType="map" >
update blog
<set >
<if test="record.id != null" >
id = #{record.id,jdbcType=INTEGER},
</if>
<if test="record.title != null" >
title = #{record.title,jdbcType=VARCHAR},
</if>
<if test="record.authodId != null" >
authod_id = #{record.authodId,jdbcType=INTEGER},
</if>
<if test="record.state != null" >
state = #{record.state,jdbcType=VARCHAR},
</if>
<if test="record.featured != null" >
featured = #{record.featured,jdbcType=TINYINT},
</if>
<if test="record.style != null" >
style = #{record.style,jdbcType=VARCHAR},
</if>
</set>
<if test="_parameter != null" >
<include refid="Update_By_Example_Where_Clause" />
</if>
</update>
<update id="updateByExample" parameterType="map" >
update blog
set id = #{record.id,jdbcType=INTEGER},
title = #{record.title,jdbcType=VARCHAR},
authod_id = #{record.authodId,jdbcType=INTEGER},
state = #{record.state,jdbcType=VARCHAR},
featured = #{record.featured,jdbcType=TINYINT},
style = #{record.style,jdbcType=VARCHAR}
<if test="_parameter != null" >
<include refid="Update_By_Example_Where_Clause" />
</if>
</update>
</mapper>
AuthorMapper.xml

<?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.geyao.mybatis.mapper.AuthorMapper">
<resultMap type="Author" id="authorResultMap">
<id column="id" property="id" jdbcType="INTEGER"></id>

</resultMap>
<select id="selectAuthorById" parameterType="int" resultMap="authorResultMap">
select * from author where id=#{id}
</select>
</mapper>
AuthorMapper类

package com.geyao.mybatis.mapper;

import com.geyao.mybatis.pojo.Author;
public interface AuthorMapper {
Author selectAuthorById(Integer id);
}
BlogAuthorMapperCustom.xml

<?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.geyao.mybatis.mapper.BlogMapperCustom" >
<sql id="baseColumn">
   b.`id`,
   b.`title`,
   b.`state`,
   b.`featured`,
   b.`style`,
   a.username as authorUsername

</sql>
<select id="selectBlogById" parameterType="int" resultType="BlogCustom">
       select
       <include refid="baseColumn"></include>
       from blog b
       left join author a
       on b.author =a.id
       where b.id=#{id}
</select>
</mapper>
BlogMapperCustom类

package com.geyao.mybatis.mapper;

import com.geyao.mybatis.mvo.BlogCustom;

public interface BlogMapperCustom {
BlogCustom selectBlogById(Integer id);
}
com.geyao.mybatis.pojo

Blog

package com.geyao.mybatis.pojo;

public class Blog {
private Integer id;

private String title;

private Integer authodId;

private String state;

private Byte featured;

private String style;

public Integer getId() {
return id;
}

public void setId(Integer id) {
this.id = id;
}

public String getTitle() {
return title;
}

public void setTitle(String title) {
this.title = title == null ? null : title.trim();
}

public Integer getAuthodId() {
return authodId;
}

public void setAuthodId(Integer authodId) {
this.authodId = authodId;
}

public String getState() {
return state;
}

public void setState(String state) {
this.state = state == null ? null : state.trim();
}

public Byte getFeatured() {
return featured;
}

public void setFeatured(Byte featured) {
this.featured = featured;
}

public String getStyle() {
return style;
}

public void setStyle(String style) {
this.style = style == null ? null : style.trim();
}
}
BlogExample

package com.geyao.mybatis.pojo;

import java.util.ArrayList;
import java.util.List;

public class BlogExample {
protected String orderByClause;

protected boolean distinct;

protected List<Criteria> oredCriteria;

public BlogExample() {
oredCriteria = new ArrayList<Criteria>();
}

public void setOrderByClause(String orderByClause) {
this.orderByClause = orderByClause;
}

public String getOrderByClause() {
return orderByClause;
}

public void setDistinct(boolean distinct) {
this.distinct = distinct;
}

public boolean isDistinct() {
return distinct;
}

public List<Criteria> getOredCriteria() {
return oredCriteria;
}

public void or(Criteria criteria) {
oredCriteria.add(criteria);
}

public Criteria or() {
Criteria criteria = createCriteriaInternal();
oredCriteria.add(criteria);
return criteria;
}

public Criteria createCriteria() {
Criteria criteria = createCriteriaInternal();
if (oredCriteria.size() == 0) {
oredCriteria.add(criteria);
}
return criteria;
}

protected Criteria createCriteriaInternal() {
Criteria criteria = new Criteria();
return criteria;
}

public void clear() {
oredCriteria.clear();
orderByClause = null;
distinct = false;
}

protected abstract static class GeneratedCriteria {
protected List<Criterion> criteria;

protected GeneratedCriteria() {
super();
criteria = new ArrayList<Criterion>();
}

public boolean isValid() {
return criteria.size() > 0;
}

public List<Criterion> getAllCriteria() {
return criteria;
}

public List<Criterion> getCriteria() {
return criteria;
}

protected void addCriterion(String condition) {
if (condition == null) {
throw new RuntimeException("Value for condition cannot be null");
}
criteria.add(new Criterion(condition));
}

protected void addCriterion(String condition, Object value, String property) {
if (value == null) {
throw new RuntimeException("Value for " + property + " cannot be null");
}
criteria.add(new Criterion(condition, value));
}

protected void addCriterion(String condition, Object value1, Object value2, String property) {
if (value1 == null || value2 == null) {
throw new RuntimeException("Between values for " + property + " cannot be null");
}
criteria.add(new Criterion(condition, value1, value2));
}

public Criteria andIdIsNull() {
addCriterion("id is null");
return (Criteria) this;
}

public Criteria andIdIsNotNull() {
addCriterion("id is not null");
return (Criteria) this;
}

public Criteria andIdEqualTo(Integer value) {
addCriterion("id =", value, "id");
return (Criteria) this;
}

public Criteria andIdNotEqualTo(Integer value) {
addCriterion("id <>", value, "id");
return (Criteria) this;
}

public Criteria andIdGreaterThan(Integer value) {
addCriterion("id >", value, "id");
return (Criteria) this;
}

public Criteria andIdGreaterThanOrEqualTo(Integer value) {
addCriterion("id >=", value, "id");
return (Criteria) this;
}

public Criteria andIdLessThan(Integer value) {
addCriterion("id <", value, "id");
return (Criteria) this;
}

public Criteria andIdLessThanOrEqualTo(Integer value) {
addCriterion("id <=", value, "id");
return (Criteria) this;
}

public Criteria andIdIn(List<Integer> values) {
addCriterion("id in", values, "id");
return (Criteria) this;
}

public Criteria andIdNotIn(List<Integer> values) {
addCriterion("id not in", values, "id");
return (Criteria) this;
}

public Criteria andIdBetween(Integer value1, Integer value2) {
addCriterion("id between", value1, value2, "id");
return (Criteria) this;
}

public Criteria andIdNotBetween(Integer value1, Integer value2) {
addCriterion("id not between", value1, value2, "id");
return (Criteria) this;
}

public Criteria andTitleIsNull() {
addCriterion("title is null");
return (Criteria) this;
}

public Criteria andTitleIsNotNull() {
addCriterion("title is not null");
return (Criteria) this;
}

public Criteria andTitleEqualTo(String value) {
addCriterion("title =", value, "title");
return (Criteria) this;
}

public Criteria andTitleNotEqualTo(String value) {
addCriterion("title <>", value, "title");
return (Criteria) this;
}

public Criteria andTitleGreaterThan(String value) {
addCriterion("title >", value, "title");
return (Criteria) this;
}

public Criteria andTitleGreaterThanOrEqualTo(String value) {
addCriterion("title >=", value, "title");
return (Criteria) this;
}

public Criteria andTitleLessThan(String value) {
addCriterion("title <", value, "title");
return (Criteria) this;
}

public Criteria andTitleLessThanOrEqualTo(String value) {
addCriterion("title <=", value, "title");
return (Criteria) this;
}

public Criteria andTitleLike(String value) {
addCriterion("title like", value, "title");
return (Criteria) this;
}

public Criteria andTitleNotLike(String value) {
addCriterion("title not like", value, "title");
return (Criteria) this;
}

public Criteria andTitleIn(List<String> values) {
addCriterion("title in", values, "title");
return (Criteria) this;
}

public Criteria andTitleNotIn(List<String> values) {
addCriterion("title not in", values, "title");
return (Criteria) this;
}

public Criteria andTitleBetween(String value1, String value2) {
addCriterion("title between", value1, value2, "title");
return (Criteria) this;
}

public Criteria andTitleNotBetween(String value1, String value2) {
addCriterion("title not between", value1, value2, "title");
return (Criteria) this;
}

public Criteria andAuthodIdIsNull() {
addCriterion("authod_id is null");
return (Criteria) this;
}

public Criteria andAuthodIdIsNotNull() {
addCriterion("authod_id is not null");
return (Criteria) this;
}

public Criteria andAuthodIdEqualTo(Integer value) {
addCriterion("authod_id =", value, "authodId");
return (Criteria) this;
}

public Criteria andAuthodIdNotEqualTo(Integer value) {
addCriterion("authod_id <>", value, "authodId");
return (Criteria) this;
}

public Criteria andAuthodIdGreaterThan(Integer value) {
addCriterion("authod_id >", value, "authodId");
return (Criteria) this;
}

public Criteria andAuthodIdGreaterThanOrEqualTo(Integer value) {
addCriterion("authod_id >=", value, "authodId");
return (Criteria) this;
}

public Criteria andAuthodIdLessThan(Integer value) {
addCriterion("authod_id <", value, "authodId");
return (Criteria) this;
}

public Criteria andAuthodIdLessThanOrEqualTo(Integer value) {
addCriterion("authod_id <=", value, "authodId");
return (Criteria) this;
}

public Criteria andAuthodIdIn(List<Integer> values) {
addCriterion("authod_id in", values, "authodId");
return (Criteria) this;
}

public Criteria andAuthodIdNotIn(List<Integer> values) {
addCriterion("authod_id not in", values, "authodId");
return (Criteria) this;
}

public Criteria andAuthodIdBetween(Integer value1, Integer value2) {
addCriterion("authod_id between", value1, value2, "authodId");
return (Criteria) this;
}

public Criteria andAuthodIdNotBetween(Integer value1, Integer value2) {
addCriterion("authod_id not between", value1, value2, "authodId");
return (Criteria) this;
}

public Criteria andStateIsNull() {
addCriterion("state is null");
return (Criteria) this;
}

public Criteria andStateIsNotNull() {
addCriterion("state is not null");
return (Criteria) this;
}

public Criteria andStateEqualTo(String value) {
addCriterion("state =", value, "state");
return (Criteria) this;
}

public Criteria andStateNotEqualTo(String value) {
addCriterion("state <>", value, "state");
return (Criteria) this;
}

public Criteria andStateGreaterThan(String value) {
addCriterion("state >", value, "state");
return (Criteria) this;
}

public Criteria andStateGreaterThanOrEqualTo(String value) {
addCriterion("state >=", value, "state");
return (Criteria) this;
}

public Criteria andStateLessThan(String value) {
addCriterion("state <", value, "state");
return (Criteria) this;
}

public Criteria andStateLessThanOrEqualTo(String value) {
addCriterion("state <=", value, "state");
return (Criteria) this;
}

public Criteria andStateLike(String value) {
addCriterion("state like", value, "state");
return (Criteria) this;
}

public Criteria andStateNotLike(String value) {
addCriterion("state not like", value, "state");
return (Criteria) this;
}

public Criteria andStateIn(List<String> values) {
addCriterion("state in", values, "state");
return (Criteria) this;
}

public Criteria andStateNotIn(List<String> values) {
addCriterion("state not in", values, "state");
return (Criteria) this;
}

public Criteria andStateBetween(String value1, String value2) {
addCriterion("state between", value1, value2, "state");
return (Criteria) this;
}

public Criteria andStateNotBetween(String value1, String value2) {
addCriterion("state not between", value1, value2, "state");
return (Criteria) this;
}

public Criteria andFeaturedIsNull() {
addCriterion("featured is null");
return (Criteria) this;
}

public Criteria andFeaturedIsNotNull() {
addCriterion("featured is not null");
return (Criteria) this;
}

public Criteria andFeaturedEqualTo(Byte value) {
addCriterion("featured =", value, "featured");
return (Criteria) this;
}

public Criteria andFeaturedNotEqualTo(Byte value) {
addCriterion("featured <>", value, "featured");
return (Criteria) this;
}

public Criteria andFeaturedGreaterThan(Byte value) {
addCriterion("featured >", value, "featured");
return (Criteria) this;
}

public Criteria andFeaturedGreaterThanOrEqualTo(Byte value) {
addCriterion("featured >=", value, "featured");
return (Criteria) this;
}

public Criteria andFeaturedLessThan(Byte value) {
addCriterion("featured <", value, "featured");
return (Criteria) this;
}

public Criteria andFeaturedLessThanOrEqualTo(Byte value) {
addCriterion("featured <=", value, "featured");
return (Criteria) this;
}

public Criteria andFeaturedIn(List<Byte> values) {
addCriterion("featured in", values, "featured");
return (Criteria) this;
}

public Criteria andFeaturedNotIn(List<Byte> values) {
addCriterion("featured not in", values, "featured");
return (Criteria) this;
}

public Criteria andFeaturedBetween(Byte value1, Byte value2) {
addCriterion("featured between", value1, value2, "featured");
return (Criteria) this;
}

public Criteria andFeaturedNotBetween(Byte value1, Byte value2) {
addCriterion("featured not between", value1, value2, "featured");
return (Criteria) this;
}

public Criteria andStyleIsNull() {
addCriterion("style is null");
return (Criteria) this;
}

public Criteria andStyleIsNotNull() {
addCriterion("style is not null");
return (Criteria) this;
}

public Criteria andStyleEqualTo(String value) {
addCriterion("style =", value, "style");
return (Criteria) this;
}

public Criteria andStyleNotEqualTo(String value) {
addCriterion("style <>", value, "style");
return (Criteria) this;
}

public Criteria andStyleGreaterThan(String value) {
addCriterion("style >", value, "style");
return (Criteria) this;
}

public Criteria andStyleGreaterThanOrEqualTo(String value) {
addCriterion("style >=", value, "style");
return (Criteria) this;
}

public Criteria andStyleLessThan(String value) {
addCriterion("style <", value, "style");
return (Criteria) this;
}

public Criteria andStyleLessThanOrEqualTo(String value) {
addCriterion("style <=", value, "style");
return (Criteria) this;
}

public Criteria andStyleLike(String value) {
addCriterion("style like", value, "style");
return (Criteria) this;
}

public Criteria andStyleNotLike(String value) {
addCriterion("style not like", value, "style");
return (Criteria) this;
}

public Criteria andStyleIn(List<String> values) {
addCriterion("style in", values, "style");
return (Criteria) this;
}

public Criteria andStyleNotIn(List<String> values) {
addCriterion("style not in", values, "style");
return (Criteria) this;
}

public Criteria andStyleBetween(String value1, String value2) {
addCriterion("style between", value1, value2, "style");
return (Criteria) this;
}

public Criteria andStyleNotBetween(String value1, String value2) {
addCriterion("style not between", value1, value2, "style");
return (Criteria) this;
}
}

public static class Criteria extends GeneratedCriteria {

protected Criteria() {
super();
}
}

public static class Criterion {
private String condition;

private Object value;

private Object secondValue;

private boolean noValue;

private boolean singleValue;

private boolean betweenValue;

private boolean listValue;

private String typeHandler;

public String getCondition() {
return condition;
}

public Object getValue() {
return value;
}

public Object getSecondValue() {
return secondValue;
}

public boolean isNoValue() {
return noValue;
}

public boolean isSingleValue() {
return singleValue;
}

public boolean isBetweenValue() {
return betweenValue;
}

public boolean isListValue() {
return listValue;
}

public String getTypeHandler() {
return typeHandler;
}

protected Criterion(String condition) {
super();
this.condition = condition;
this.typeHandler = null;
this.noValue = true;
}

protected Criterion(String condition, Object value, String typeHandler) {
super();
this.condition = condition;
this.value = value;
this.typeHandler = typeHandler;
if (value instanceof List<?>) {
this.listValue = true;
} else {
this.singleValue = true;
}
}

protected Criterion(String condition, Object value) {
this(condition, value, null);
}

protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
super();
this.condition = condition;
this.value = value;
this.secondValue = secondValue;
this.typeHandler = typeHandler;
this.betweenValue = true;
}

protected Criterion(String condition, Object value, Object secondValue) {
this(condition, value, secondValue, null);
}
}
}
Aothor类

package com.geyao.mybatis.pojo;

public class Author {
   private Integer id;
   private String username;
   private String password;
   private String email;
   private String bio;
   private String favouriteSection;
   private String nickname;
   private String realname;
   public Author() {
       super();
   }
   public Integer getId() {
       return id;
   }
   public void setId(Integer id) {
       this.id = id;
   }
   public String getUsername() {
       return username;
   }
   public void setUsername(String username) {
       this.username = username;
   }
   public String getPassword() {
       return password;
   }
   public void setPassword(String password) {
       this.password = password;
   }
   public String getEmail() {
       return email;
   }
   public void setEmail(String email) {
       this.email = email;
   }
   public String getBio() {
       return bio;
   }
   public void setBio(String bio) {
       this.bio = bio;
   }
   public String getFavouriteSection() {
       return favouriteSection;
   }
   public void setFavouriteSection(String favouriteSection) {
       this.favouriteSection = favouriteSection;
   }
   public String getNickname() {
       return nickname;
   }
   public void setNickname(String nickname) {
       this.nickname = nickname;
   }
   public String getRealname() {
       return realname;
   }
   public void setRealname(String realname) {
       this.realname = realname;
   }
   public Author(Integer id, String username, String password, String email, String bio, String favouriteSection,
           String nickname, String realname) {
       super();
       this.id = id;
       this.username = username;
       this.password = password;
       this.email = email;
       this.bio = bio;
       this.favouriteSection = favouriteSection;
       this.nickname = nickname;
       this.realname = realname;
   }
   @Override
   public String toString() {
       return "Author [id=" + id + ", username=" + username + ", password=" + password + ", email=" + email + ", bio="
               + bio + ", favouriteSection=" + favouriteSection + ", nickname=" + nickname + ", realname=" + realname
               + "]";
   }



}
AuthorExample

package com.geyao.mybatis.pojo;

import java.util.ArrayList;
import java.util.List;

public class AuthorExample {
protected String orderByClause;

protected boolean distinct;

protected List<Criteria> oredCriteria;

public AuthorExample() {
oredCriteria = new ArrayList<Criteria>();
}

public void setOrderByClause(String orderByClause) {
this.orderByClause = orderByClause;
}

public String getOrderByClause() {
return orderByClause;
}

public void setDistinct(boolean distinct) {
this.distinct = distinct;
}

public boolean isDistinct() {
return distinct;
}

public List<Criteria> getOredCriteria() {
return oredCriteria;
}

public void or(Criteria criteria) {
oredCriteria.add(criteria);
}

public Criteria or() {
Criteria criteria = createCriteriaInternal();
oredCriteria.add(criteria);
return criteria;
}

public Criteria createCriteria() {
Criteria criteria = createCriteriaInternal();
if (oredCriteria.size() == 0) {
oredCriteria.add(criteria);
}
return criteria;
}

protected Criteria createCriteriaInternal() {
Criteria criteria = new Criteria();
return criteria;
}

public void clear() {
oredCriteria.clear();
orderByClause = null;
distinct = false;
}

protected abstract static class GeneratedCriteria {
protected List<Criterion> criteria;

protected GeneratedCriteria() {
super();
criteria = new ArrayList<Criterion>();
}

public boolean isValid() {
return criteria.size() > 0;
}

public List<Criterion> getAllCriteria() {
return criteria;
}

public List<Criterion> getCriteria() {
return criteria;
}

protected void addCriterion(String condition) {
if (condition == null) {
throw new RuntimeException("Value for condition cannot be null");
}
criteria.add(new Criterion(condition));
}

protected void addCriterion(String condition, Object value, String property) {
if (value == null) {
throw new RuntimeException("Value for " + property + " cannot be null");
}
criteria.add(new Criterion(condition, value));
}

protected void addCriterion(String condition, Object value1, Object value2, String property) {
if (value1 == null || value2 == null) {
throw new RuntimeException("Between values for " + property + " cannot be null");
}
criteria.add(new Criterion(condition, value1, value2));
}

public Criteria andIdIsNull() {
addCriterion("id is null");
return (Criteria) this;
}

public Criteria andIdIsNotNull() {
addCriterion("id is not null");
return (Criteria) this;
}

public Criteria andIdEqualTo(Integer value) {
addCriterion("id =", value, "id");
return (Criteria) this;
}

public Criteria andIdNotEqualTo(Integer value) {
addCriterion("id <>", value, "id");
return (Criteria) this;
}

public Criteria andIdGreaterThan(Integer value) {
addCriterion("id >", value, "id");
return (Criteria) this;
}

public Criteria andIdGreaterThanOrEqualTo(Integer value) {
addCriterion("id >=", value, "id");
return (Criteria) this;
}

public Criteria andIdLessThan(Integer value) {
addCriterion("id <", value, "id");
return (Criteria) this;
}

public Criteria andIdLessThanOrEqualTo(Integer value) {
addCriterion("id <=", value, "id");
return (Criteria) this;
}

public Criteria andIdIn(List<Integer> values) {
addCriterion("id in", values, "id");
return (Criteria) this;
}

public Criteria andIdNotIn(List<Integer> values) {
addCriterion("id not in", values, "id");
return (Criteria) this;
}

public Criteria andIdBetween(Integer value1, Integer value2) {
addCriterion("id between", value1, value2, "id");
return (Criteria) this;
}

public Criteria andIdNotBetween(Integer value1, Integer value2) {
addCriterion("id not between", value1, value2, "id");
return (Criteria) this;
}

public Criteria andUsernameIsNull() {
addCriterion("username is null");
return (Criteria) this;
}

public Criteria andUsernameIsNotNull() {
addCriterion("username is not null");
return (Criteria) this;
}

public Criteria andUsernameEqualTo(String value) {
addCriterion("username =", value, "username");
return (Criteria) this;
}

public Criteria andUsernameNotEqualTo(String value) {
addCriterion("username <>", value, "username");
return (Criteria) this;
}

public Criteria andUsernameGreaterThan(String value) {
addCriterion("username >", value, "username");
return (Criteria) this;
}

public Criteria andUsernameGreaterThanOrEqualTo(String value) {
addCriterion("username >=", value, "username");
return (Criteria) this;
}

public Criteria andUsernameLessThan(String value) {
addCriterion("username <", value, "username");
return (Criteria) this;
}

public Criteria andUsernameLessThanOrEqualTo(String value) {
addCriterion("username <=", value, "username");
return (Criteria) this;
}

public Criteria andUsernameLike(String value) {
addCriterion("username like", value, "username");
return (Criteria) this;
}

public Criteria andUsernameNotLike(String value) {
addCriterion("username not like", value, "username");
return (Criteria) this;
}

public Criteria andUsernameIn(List<String> values) {
addCriterion("username in", values, "username");
return (Criteria) this;
}

public Criteria andUsernameNotIn(List<String> values) {
addCriterion("username not in", values, "username");
return (Criteria) this;
}

public Criteria andUsernameBetween(String value1, String value2) {
addCriterion("username between", value1, value2, "username");
return (Criteria) this;
}

public Criteria andUsernameNotBetween(String value1, String value2) {
addCriterion("username not between", value1, value2, "username");
return (Criteria) this;
}

public Criteria andPasswordIsNull() {
addCriterion("password is null");
return (Criteria) this;
}

public Criteria andPasswordIsNotNull() {
addCriterion("password is not null");
return (Criteria) this;
}

public Criteria andPasswordEqualTo(String value) {
addCriterion("password =", value, "password");
return (Criteria) this;
}

public Criteria andPasswordNotEqualTo(String value) {
addCriterion("password <>", value, "password");
return (Criteria) this;
}

public Criteria andPasswordGreaterThan(String value) {
addCriterion("password >", value, "password");
return (Criteria) this;
}

public Criteria andPasswordGreaterThanOrEqualTo(String value) {
addCriterion("password >=", value, "password");
return (Criteria) this;
}

public Criteria andPasswordLessThan(String value) {
addCriterion("password <", value, "password");
return (Criteria) this;
}

public Criteria andPasswordLessThanOrEqualTo(String value) {
addCriterion("password <=", value, "password");
return (Criteria) this;
}

public Criteria andPasswordLike(String value) {
addCriterion("password like", value, "password");
return (Criteria) this;
}

public Criteria andPasswordNotLike(String value) {
addCriterion("password not like", value, "password");
return (Criteria) this;
}

public Criteria andPasswordIn(List<String> values) {
addCriterion("password in", values, "password");
return (Criteria) this;
}

public Criteria andPasswordNotIn(List<String> values) {
addCriterion("password not in", values, "password");
return (Criteria) this;
}

public Criteria andPasswordBetween(String value1, String value2) {
addCriterion("password between", value1, value2, "password");
return (Criteria) this;
}

public Criteria andPasswordNotBetween(String value1, String value2) {
addCriterion("password not between", value1, value2, "password");
return (Criteria) this;
}

public Criteria andEmailIsNull() {
addCriterion("email is null");
return (Criteria) this;
}

public Criteria andEmailIsNotNull() {
addCriterion("email is not null");
return (Criteria) this;
}

public Criteria andEmailEqualTo(String value) {
addCriterion("email =", value, "email");
return (Criteria) this;
}

public Criteria andEmailNotEqualTo(String value) {
addCriterion("email <>", value, "email");
return (Criteria) this;
}

public Criteria andEmailGreaterThan(String value) {
addCriterion("email >", value, "email");
return (Criteria) this;
}

public Criteria andEmailGreaterThanOrEqualTo(String value) {
addCriterion("email >=", value, "email");
return (Criteria) this;
}

public Criteria andEmailLessThan(String value) {
addCriterion("email <", value, "email");
return (Criteria) this;
}

public Criteria andEmailLessThanOrEqualTo(String value) {
addCriterion("email <=", value, "email");
return (Criteria) this;
}

public Criteria andEmailLike(String value) {
addCriterion("email like", value, "email");
return (Criteria) this;
}

public Criteria andEmailNotLike(String value) {
addCriterion("email not like", value, "email");
return (Criteria) this;
}

public Criteria andEmailIn(List<String> values) {
addCriterion("email in", values, "email");
return (Criteria) this;
}

public Criteria andEmailNotIn(List<String> values) {
addCriterion("email not in", values, "email");
return (Criteria) this;
}

public Criteria andEmailBetween(String value1, String value2) {
addCriterion("email between", value1, value2, "email");
return (Criteria) this;
}

public Criteria andEmailNotBetween(String value1, String value2) {
addCriterion("email not between", value1, value2, "email");
return (Criteria) this;
}

public Criteria andBioIsNull() {
addCriterion("bio is null");
return (Criteria) this;
}

public Criteria andBioIsNotNull() {
addCriterion("bio is not null");
return (Criteria) this;
}

public Criteria andBioEqualTo(String value) {
addCriterion("bio =", value, "bio");
return (Criteria) this;
}

public Criteria andBioNotEqualTo(String value) {
addCriterion("bio <>", value, "bio");
return (Criteria) this;
}

public Criteria andBioGreaterThan(String value) {
addCriterion("bio >", value, "bio");
return (Criteria) this;
}

public Criteria andBioGreaterThanOrEqualTo(String value) {
addCriterion("bio >=", value, "bio");
return (Criteria) this;
}

public Criteria andBioLessThan(String value) {
addCriterion("bio <", value, "bio");
return (Criteria) this;
}

public Criteria andBioLessThanOrEqualTo(String value) {
addCriterion("bio <=", value, "bio");
return (Criteria) this;
}

public Criteria andBioLike(String value) {
addCriterion("bio like", value, "bio");
return (Criteria) this;
}

public Criteria andBioNotLike(String value) {
addCriterion("bio not like", value, "bio");
return (Criteria) this;
}

public Criteria andBioIn(List<String> values) {
addCriterion("bio in", values, "bio");
return (Criteria) this;
}

public Criteria andBioNotIn(List<String> values) {
addCriterion("bio not in", values, "bio");
return (Criteria) this;
}

public Criteria andBioBetween(String value1, String value2) {
addCriterion("bio between", value1, value2, "bio");
return (Criteria) this;
}

public Criteria andBioNotBetween(String value1, String value2) {
addCriterion("bio not between", value1, value2, "bio");
return (Criteria) this;
}

public Criteria andFavouritesectionIsNull() {
addCriterion("favouriteSection is null");
return (Criteria) this;
}

public Criteria andFavouritesectionIsNotNull() {
addCriterion("favouriteSection is not null");
return (Criteria) this;
}

public Criteria andFavouritesectionEqualTo(String value) {
addCriterion("favouriteSection =", value, "favouritesection");
return (Criteria) this;
}

public Criteria andFavouritesectionNotEqualTo(String value) {
addCriterion("favouriteSection <>", value, "favouritesection");
return (Criteria) this;
}

public Criteria andFavouritesectionGreaterThan(String value) {
addCriterion("favouriteSection >", value, "favouritesection");
return (Criteria) this;
}

public Criteria andFavouritesectionGreaterThanOrEqualTo(String value) {
addCriterion("favouriteSection >=", value, "favouritesection");
return (Criteria) this;
}

public Criteria andFavouritesectionLessThan(String value) {
addCriterion("favouriteSection <", value, "favouritesection");
return (Criteria) this;
}

public Criteria andFavouritesectionLessThanOrEqualTo(String value) {
addCriterion("favouriteSection <=", value, "favouritesection");
return (Criteria) this;
}

public Criteria andFavouritesectionLike(String value) {
addCriterion("favouriteSection like", value, "favouritesection");
return (Criteria) this;
}

public Criteria andFavouritesectionNotLike(String value) {
addCriterion("favouriteSection not like", value, "favouritesection");
return (Criteria) this;
}

public Criteria andFavouritesectionIn(List<String> values) {
addCriterion("favouriteSection in", values, "favouritesection");
return (Criteria) this;
}

public Criteria andFavouritesectionNotIn(List<String> values) {
addCriterion("favouriteSection not in", values, "favouritesection");
return (Criteria) this;
}

public Criteria andFavouritesectionBetween(String value1, String value2) {
addCriterion("favouriteSection between", value1, value2, "favouritesection");
return (Criteria) this;
}

public Criteria andFavouritesectionNotBetween(String value1, String value2) {
addCriterion("favouriteSection not between", value1, value2, "favouritesection");
return (Criteria) this;
}

public Criteria andNicknameIsNull() {
addCriterion("nickname is null");
return (Criteria) this;
}

public Criteria andNicknameIsNotNull() {
addCriterion("nickname is not null");
return (Criteria) this;
}

public Criteria andNicknameEqualTo(String value) {
addCriterion("nickname =", value, "nickname");
return (Criteria) this;
}

public Criteria andNicknameNotEqualTo(String value) {
addCriterion("nickname <>", value, "nickname");
return (Criteria) this;
}

public Criteria andNicknameGreaterThan(String value) {
addCriterion("nickname >", value, "nickname");
return (Criteria) this;
}

public Criteria andNicknameGreaterThanOrEqualTo(String value) {
addCriterion("nickname >=", value, "nickname");
return (Criteria) this;
}

public Criteria andNicknameLessThan(String value) {
addCriterion("nickname <", value, "nickname");
return (Criteria) this;
}

public Criteria andNicknameLessThanOrEqualTo(String value) {
addCriterion("nickname <=", value, "nickname");
return (Criteria) this;
}

public Criteria andNicknameLike(String value) {
addCriterion("nickname like", value, "nickname");
return (Criteria) this;
}

public Criteria andNicknameNotLike(String value) {
addCriterion("nickname not like", value, "nickname");
return (Criteria) this;
}

public Criteria andNicknameIn(List<String> values) {
addCriterion("nickname in", values, "nickname");
return (Criteria) this;
}

public Criteria andNicknameNotIn(List<String> values) {
addCriterion("nickname not in", values, "nickname");
return (Criteria) this;
}

public Criteria andNicknameBetween(String value1, String value2) {
addCriterion("nickname between", value1, value2, "nickname");
return (Criteria) this;
}

public Criteria andNicknameNotBetween(String value1, String value2) {
addCriterion("nickname not between", value1, value2, "nickname");
return (Criteria) this;
}

public Criteria andRealnameIsNull() {
addCriterion("realname is null");
return (Criteria) this;
}

public Criteria andRealnameIsNotNull() {
addCriterion("realname is not null");
return (Criteria) this;
}

public Criteria andRealnameEqualTo(String value) {
addCriterion("realname =", value, "realname");
return (Criteria) this;
}

public Criteria andRealnameNotEqualTo(String value) {
addCriterion("realname <>", value, "realname");
return (Criteria) this;
}

public Criteria andRealnameGreaterThan(String value) {
addCriterion("realname >", value, "realname");
return (Criteria) this;
}

public Criteria andRealnameGreaterThanOrEqualTo(String value) {
addCriterion("realname >=", value, "realname");
return (Criteria) this;
}

public Criteria andRealnameLessThan(String value) {
addCriterion("realname <", value, "realname");
return (Criteria) this;
}

public Criteria andRealnameLessThanOrEqualTo(String value) {
addCriterion("realname <=", value, "realname");
return (Criteria) this;
}

public Criteria andRealnameLike(String value) {
addCriterion("realname like", value, "realname");
return (Criteria) this;
}

public Criteria andRealnameNotLike(String value) {
addCriterion("realname not like", value, "realname");
return (Criteria) this;
}

public Criteria andRealnameIn(List<String> values) {
addCriterion("realname in", values, "realname");
return (Criteria) this;
}

public Criteria andRealnameNotIn(List<String> values) {
addCriterion("realname not in", values, "realname");
return (Criteria) this;
}

public Criteria andRealnameBetween(String value1, String value2) {
addCriterion("realname between", value1, value2, "realname");
return (Criteria) this;
}

public Criteria andRealnameNotBetween(String value1, String value2) {
addCriterion("realname not between", value1, value2, "realname");
return (Criteria) this;
}
}

public static class Criteria extends GeneratedCriteria {

protected Criteria() {
super();
}
}

public static class Criterion {
private String condition;

private Object value;

private Object secondValue;

private boolean noValue;

private boolean singleValue;

private boolean betweenValue;

private boolean listValue;

private String typeHandler;

public String getCondition() {
return condition;
}

public Object getValue() {
return value;
}

public Object getSecondValue() {
return secondValue;
}

public boolean isNoValue() {
return noValue;
}

public boolean isSingleValue() {
return singleValue;
}

public boolean isBetweenValue() {
return betweenValue;
}

public boolean isListValue() {
return listValue;
}

public String getTypeHandler() {
return typeHandler;
}

protected Criterion(String condition) {
super();
this.condition = condition;
this.typeHandler = null;
this.noValue = true;
}

protected Criterion(String condition, Object value, String typeHandler) {
super();
this.condition = condition;
this.value = value;
this.typeHandler = typeHandler;
if (value instanceof List<?>) {
this.listValue = true;
} else {
this.singleValue = true;
}
}

protected Criterion(String condition, Object value) {
this(condition, value, null);
}

protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
super();
this.condition = condition;
this.value = value;
this.secondValue = secondValue;
this.typeHandler = typeHandler;
this.betweenValue = true;
}

protected Criterion(String condition, Object value, Object secondValue) {
this(condition, value, secondValue, null);
}
}
}
com.geyao.mybatis.mvo

BlogCustom

package com.geyao.mybatis.mvo;

import com.geyao.mybatis.pojo.Blog;

public class BlogCustom extends Blog {
   private String authorUsername;

   public String getAuthorUsername() {
       return authorUsername;
   }

   public void setAuthorUsername(String authorUsername) {
       this.authorUsername = authorUsername;
   }

}
com.geyao.mybatis.util

MybatisUtil

package com.geyao.mybatis.util;

import java.io.InputStream;
import java.io.Reader;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class MyBatisUtil {
   private static SqlSessionFactory sqlSessionFactory =null;
   static {
       try {
           InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
           sqlSessionFactory = new SqlSessionFactoryBuilder().build(in);
       } catch (Exception e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }
   }
   private MyBatisUtil() {}

   public static SqlSession getSqlSession() {
       return sqlSessionFactory.openSession();
   }
}
com.geyao.mybatis.mapper

BlogMapperCustomTest

package com.geyao.mybatis.mapper;

import java.util.ArrayList;
import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import com.geyao.mybatis.mvo.BlogCustom;

import com.geyao.mybatis.util.MyBatisUtil;

public class BlogMapperCustomTest {
   @Test
   public void testselectBlogById() {
       SqlSession session =MyBatisUtil.getSqlSession();
       BlogMapperCustom blogMapper =session.getMapper(BlogMapperCustom.class);
       BlogCustom blog=blogMapper.selectBlogById(1);
       session.close();
       System.out.println(blog);
   }
}
运行结果