mybaits mapper.xml的写法

青旅半醒 2022-06-06 09:44 223阅读 0赞

用习惯了mybaits generator，好久不写mybaits，发现都不会写了，这里先放下些例子，以供以后用的时候参考  
项目示例下载地址：  
[https://gitee.com/paincupid/simple-springmvc][https_gitee.com_paincupid_simple-springmvc]

mybaits config example

package com.paincupid.springmvc.persistence;
    
    import com.paincupid.springmvc.domain.Student;
    import org.apache.ibatis.annotations.Param;
    
    import java.util.List;
    
    public interface StudentVoMapper { 
    
        int insertStudentByVoMapper(Student student);
    
        List<Student> listStudentByClassNoAndSex(@Param("classNo") Integer classNo, @Param("sex") Boolean sex);
    
        Student getStudentById(Long id);
    
        int updateStudentNameById(@Param("id") Long id, @Param("name") String name);
    
        /** * If there is only 1 param, you do NOT need use @Param annotation * @param id * @return */
        int deleteStudentById(Long id);
    
        int updateStudent2ColumnVal(@Param("iq") Integer iq, @Param("cultivateHobby") String cultivateHobby);
    }

<?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.paincupid.springmvc.persistence.StudentVoMapper">
        <resultMap id="BaseResultMap" type="com.paincupid.springmvc.domain.Student">
            <id column="id" jdbcType="BIGINT" property="id"/>
            <result column="name" jdbcType="VARCHAR" property="name"/>
            <result column="height" jdbcType="DOUBLE" property="height"/>
            <result column="class_no" jdbcType="INTEGER" property="classNo"/>
            <result column="sex" jdbcType="BIT" property="sex"/>
            <result column="iq" jdbcType="INTEGER" property="iq"/>
            <result column="focus" jdbcType="BIT" property="focus"/>
            <result column="cultivate_hobby" jdbcType="VARCHAR" property="cultivateHobby"/>
            <result column="phone" jdbcType="INTEGER" property="phone"/>
            <result column="address" jdbcType="VARCHAR" property="address"/>
            <result column="is_delete" jdbcType="BIT" property="isDelete"/>
            <result column="modifier" jdbcType="VARCHAR" property="modifier"/>
            <result column="gmt_create" jdbcType="DATE" property="gmtCreate"/>
            <result column="gmt_modified" jdbcType="DATE" property="gmtModified"/>
            <result column="bak" jdbcType="VARCHAR" property="bak"/>
        </resultMap>
    
        <insert id="insertStudentByVoMapper" keyColumn="id" keyProperty="id" parameterType="com.paincupid.springmvc.domain.Student" useGeneratedKeys="true">
    
            INSERT INTO t_student (name,class_no,is_delete,modifier,gmt_create, gmt_modified)
              VALUES (#{name},#{classNo},#{isDelete},#{modifier},#{gmtCreate},#{gmtModified});
        </insert>
    
        <select id="listStudentByClassNoAndSex" resultMap="BaseResultMap">
            select  *  from t_student   where class_no = #{classNo} and sex=#{sex,jdbcType=BIT}
        </select>
    
        <select id="getStudentById" resultMap="BaseResultMap" parameterType="Long">
            select  *  from t_student   where id=#{id}
        </select>
    
        <update id="updateStudentNameById" parameterType="Student">
            UPDATE t_student
            SET name = #{name}
            WHERE id = #{id}
        </update>
    
        <update id="updateStudent2ColumnVal">
            UPDATE t_student
            SET cultivate_hobby =  #{cultivateHobby}, focus = '1'
            WHERE iq > #{iq}
        </update>
    
        <delete id="deleteStudentById" parameterType="Long">
            DELETE from t_student WHERE id = #{id}
        </delete>
    </mapper>

mybaits generator config example

package com.paincupid.springmvc.persistence;
    
    import com.paincupid.springmvc.domain.Student;
    import com.paincupid.springmvc.domain.StudentExample;
    import java.util.List;
    import org.apache.ibatis.annotations.Param;
    
    public interface StudentMapper { 
        long countByExample(StudentExample example);
    
        int deleteByExample(StudentExample example);
    
        int deleteByPrimaryKey(Long id);
    
        int insert(Student record);
    
        int insertSelective(Student record);
    
        List<Student> selectByExample(StudentExample example);
    
        Student selectByPrimaryKey(Long id);
    
        int updateByExampleSelective(@Param("record") Student record, @Param("example") StudentExample example);
    
        int updateByExample(@Param("record") Student record, @Param("example") StudentExample example);
    
        int updateByPrimaryKeySelective(Student record);
    
        int updateByPrimaryKey(Student record);
    }

<?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.paincupid.springmvc.persistence.StudentMapper">
      <resultMap id="BaseResultMap" type="com.paincupid.springmvc.domain.Student">
        
        <id column="id" jdbcType="BIGINT" property="id" />
        <result column="name" jdbcType="VARCHAR" property="name" />
        <result column="height" jdbcType="DOUBLE" property="height" />
        <result column="class_no" jdbcType="INTEGER" property="classNo" />
        <result column="sex" jdbcType="BIT" property="sex" />
        <result column="iq" jdbcType="INTEGER" property="iq" />
        <result column="focus" jdbcType="BIT" property="focus" />
        <result column="cultivate_hobby" jdbcType="VARCHAR" property="cultivateHobby" />
        <result column="phone" jdbcType="INTEGER" property="phone" />
        <result column="address" jdbcType="VARCHAR" property="address" />
        <result column="is_delete" jdbcType="BIT" property="isDelete" />
        <result column="modifier" jdbcType="VARCHAR" property="modifier" />
        <result column="gmt_create" jdbcType="DATE" property="gmtCreate" />
        <result column="gmt_modified" jdbcType="DATE" property="gmtModified" />
        <result column="bak" jdbcType="VARCHAR" property="bak" />
      </resultMap>
      <sql id="Example_Where_Clause">
        
        <where>
          <foreach collection="oredCriteria" item="criteria" separator="or">
            <if test="criteria.valid">
              <trim prefix="(" prefixOverrides="and" suffix=")">
                <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 close=")" collection="criterion.value" item="listItem" open="(" 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="(" prefixOverrides="and" suffix=")">
                <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 close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                        #{listItem}
                      </foreach>
                    </when>
                  </choose>
                </foreach>
              </trim>
            </if>
          </foreach>
        </where>
      </sql>
      <sql id="Base_Column_List">
        
        id, name, height, class_no, sex, iq, focus, cultivate_hobby, phone, address, is_delete,
        modifier, gmt_create, gmt_modified, bak
      </sql>
      <select id="selectByExample" parameterType="com.paincupid.springmvc.domain.StudentExample" resultMap="BaseResultMap">
        
        select
        <if test="distinct">
          distinct
        </if>
        <include refid="Base_Column_List" />
        from t_student
        <if test="_parameter != null">
          <include refid="Example_Where_Clause" />
        </if>
        <if test="orderByClause != null">
          order by ${orderByClause}
        </if>
        <if test="limit != null">
          <if test="offset != null">
            limit ${offset}, ${limit}
          </if>
          <if test="offset == null">
            limit ${limit}
          </if>
        </if>
      </select>
      <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
        
        select
        <include refid="Base_Column_List" />
        from t_student
        where id = #{id,jdbcType=BIGINT}
      </select>
      <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
        
        delete from t_student
        where id = #{id,jdbcType=BIGINT}
      </delete>
      <delete id="deleteByExample" parameterType="com.paincupid.springmvc.domain.StudentExample">
        
        delete from t_student
        <if test="_parameter != null">
          <include refid="Example_Where_Clause" />
        </if>
      </delete>
      <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.paincupid.springmvc.domain.Student" useGeneratedKeys="true">
        
        insert into t_student (name, height, class_no,
          sex, iq, focus, cultivate_hobby,
          phone, address, is_delete,
          modifier, gmt_create, gmt_modified,
          bak)
        values (#{name,jdbcType=VARCHAR}, #{height,jdbcType=DOUBLE}, #{classNo,jdbcType=INTEGER},
          #{sex,jdbcType=BIT}, #{iq,jdbcType=INTEGER}, #{focus,jdbcType=BIT}, #{cultivateHobby,jdbcType=VARCHAR},
          #{phone,jdbcType=INTEGER}, #{address,jdbcType=VARCHAR}, #{isDelete,jdbcType=BIT},
          #{modifier,jdbcType=VARCHAR}, #{gmtCreate,jdbcType=DATE}, #{gmtModified,jdbcType=DATE},
          #{bak,jdbcType=VARCHAR})
      </insert>
      <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.paincupid.springmvc.domain.Student" useGeneratedKeys="true">
        
        insert into t_student
        <trim prefix="(" suffix=")" suffixOverrides=",">
          <if test="name != null">
            name,
          </if>
          <if test="height != null">
            height,
          </if>
          <if test="classNo != null">
            class_no,
          </if>
          <if test="sex != null">
            sex,
          </if>
          <if test="iq != null">
            iq,
          </if>
          <if test="focus != null">
            focus,
          </if>
          <if test="cultivateHobby != null">
            cultivate_hobby,
          </if>
          <if test="phone != null">
            phone,
          </if>
          <if test="address != null">
            address,
          </if>
          <if test="isDelete != null">
            is_delete,
          </if>
          <if test="modifier != null">
            modifier,
          </if>
          <if test="gmtCreate != null">
            gmt_create,
          </if>
          <if test="gmtModified != null">
            gmt_modified,
          </if>
          <if test="bak != null">
            bak,
          </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
          <if test="name != null">
            #{name,jdbcType=VARCHAR},
          </if>
          <if test="height != null">
            #{height,jdbcType=DOUBLE},
          </if>
          <if test="classNo != null">
            #{classNo,jdbcType=INTEGER},
          </if>
          <if test="sex != null">
            #{sex,jdbcType=BIT},
          </if>
          <if test="iq != null">
            #{iq,jdbcType=INTEGER},
          </if>
          <if test="focus != null">
            #{focus,jdbcType=BIT},
          </if>
          <if test="cultivateHobby != null">
            #{cultivateHobby,jdbcType=VARCHAR},
          </if>
          <if test="phone != null">
            #{phone,jdbcType=INTEGER},
          </if>
          <if test="address != null">
            #{address,jdbcType=VARCHAR},
          </if>
          <if test="isDelete != null">
            #{isDelete,jdbcType=BIT},
          </if>
          <if test="modifier != null">
            #{modifier,jdbcType=VARCHAR},
          </if>
          <if test="gmtCreate != null">
            #{gmtCreate,jdbcType=DATE},
          </if>
          <if test="gmtModified != null">
            #{gmtModified,jdbcType=DATE},
          </if>
          <if test="bak != null">
            #{bak,jdbcType=VARCHAR},
          </if>
        </trim>
      </insert>
      <select id="countByExample" parameterType="com.paincupid.springmvc.domain.StudentExample" resultType="java.lang.Long">
        
        select count(*) from t_student
        <if test="_parameter != null">
          <include refid="Example_Where_Clause" />
        </if>
      </select>
      <update id="updateByExampleSelective" parameterType="map">
        
        update t_student
        <set>
          <if test="record.id != null">
            id = #{record.id,jdbcType=BIGINT},
          </if>
          <if test="record.name != null">
            name = #{record.name,jdbcType=VARCHAR},
          </if>
          <if test="record.height != null">
            height = #{record.height,jdbcType=DOUBLE},
          </if>
          <if test="record.classNo != null">
            class_no = #{record.classNo,jdbcType=INTEGER},
          </if>
          <if test="record.sex != null">
            sex = #{record.sex,jdbcType=BIT},
          </if>
          <if test="record.iq != null">
            iq = #{record.iq,jdbcType=INTEGER},
          </if>
          <if test="record.focus != null">
            focus = #{record.focus,jdbcType=BIT},
          </if>
          <if test="record.cultivateHobby != null">
            cultivate_hobby = #{record.cultivateHobby,jdbcType=VARCHAR},
          </if>
          <if test="record.phone != null">
            phone = #{record.phone,jdbcType=INTEGER},
          </if>
          <if test="record.address != null">
            address = #{record.address,jdbcType=VARCHAR},
          </if>
          <if test="record.isDelete != null">
            is_delete = #{record.isDelete,jdbcType=BIT},
          </if>
          <if test="record.modifier != null">
            modifier = #{record.modifier,jdbcType=VARCHAR},
          </if>
          <if test="record.gmtCreate != null">
            gmt_create = #{record.gmtCreate,jdbcType=DATE},
          </if>
          <if test="record.gmtModified != null">
            gmt_modified = #{record.gmtModified,jdbcType=DATE},
          </if>
          <if test="record.bak != null">
            bak = #{record.bak,jdbcType=VARCHAR},
          </if>
        </set>
        <if test="_parameter != null">
          <include refid="Update_By_Example_Where_Clause" />
        </if>
      </update>
      <update id="updateByExample" parameterType="map">
        
        update t_student
        set id = #{record.id,jdbcType=BIGINT},
          name = #{record.name,jdbcType=VARCHAR},
          height = #{record.height,jdbcType=DOUBLE},
          class_no = #{record.classNo,jdbcType=INTEGER},
          sex = #{record.sex,jdbcType=BIT},
          iq = #{record.iq,jdbcType=INTEGER},
          focus = #{record.focus,jdbcType=BIT},
          cultivate_hobby = #{record.cultivateHobby,jdbcType=VARCHAR},
          phone = #{record.phone,jdbcType=INTEGER},
          address = #{record.address,jdbcType=VARCHAR},
          is_delete = #{record.isDelete,jdbcType=BIT},
          modifier = #{record.modifier,jdbcType=VARCHAR},
          gmt_create = #{record.gmtCreate,jdbcType=DATE},
          gmt_modified = #{record.gmtModified,jdbcType=DATE},
          bak = #{record.bak,jdbcType=VARCHAR}
        <if test="_parameter != null">
          <include refid="Update_By_Example_Where_Clause" />
        </if>
      </update>
      <update id="updateByPrimaryKeySelective" parameterType="com.paincupid.springmvc.domain.Student">
        
        update t_student
        <set>
          <if test="name != null">
            name = #{name,jdbcType=VARCHAR},
          </if>
          <if test="height != null">
            height = #{height,jdbcType=DOUBLE},
          </if>
          <if test="classNo != null">
            class_no = #{classNo,jdbcType=INTEGER},
          </if>
          <if test="sex != null">
            sex = #{sex,jdbcType=BIT},
          </if>
          <if test="iq != null">
            iq = #{iq,jdbcType=INTEGER},
          </if>
          <if test="focus != null">
            focus = #{focus,jdbcType=BIT},
          </if>
          <if test="cultivateHobby != null">
            cultivate_hobby = #{cultivateHobby,jdbcType=VARCHAR},
          </if>
          <if test="phone != null">
            phone = #{phone,jdbcType=INTEGER},
          </if>
          <if test="address != null">
            address = #{address,jdbcType=VARCHAR},
          </if>
          <if test="isDelete != null">
            is_delete = #{isDelete,jdbcType=BIT},
          </if>
          <if test="modifier != null">
            modifier = #{modifier,jdbcType=VARCHAR},
          </if>
          <if test="gmtCreate != null">
            gmt_create = #{gmtCreate,jdbcType=DATE},
          </if>
          <if test="gmtModified != null">
            gmt_modified = #{gmtModified,jdbcType=DATE},
          </if>
          <if test="bak != null">
            bak = #{bak,jdbcType=VARCHAR},
          </if>
        </set>
        where id = #{id,jdbcType=BIGINT}
      </update>
      <update id="updateByPrimaryKey" parameterType="com.paincupid.springmvc.domain.Student">
        
        update t_student
        set name = #{name,jdbcType=VARCHAR},
          height = #{height,jdbcType=DOUBLE},
          class_no = #{classNo,jdbcType=INTEGER},
          sex = #{sex,jdbcType=BIT},
          iq = #{iq,jdbcType=INTEGER},
          focus = #{focus,jdbcType=BIT},
          cultivate_hobby = #{cultivateHobby,jdbcType=VARCHAR},
          phone = #{phone,jdbcType=INTEGER},
          address = #{address,jdbcType=VARCHAR},
          is_delete = #{isDelete,jdbcType=BIT},
          modifier = #{modifier,jdbcType=VARCHAR},
          gmt_create = #{gmtCreate,jdbcType=DATE},
          gmt_modified = #{gmtModified,jdbcType=DATE},
          bak = #{bak,jdbcType=VARCHAR}
        where id = #{id,jdbcType=BIGINT}
      </update>
    </mapper>

package com.paincupid.springmvc.domain;
    
    import java.io.Serializable;
    import java.util.Date;
    
    public class Student implements Serializable { 
        /** id **/
        private Long id;
    
        /** 名称 name **/
        private String name;
    
        /** 身高 height **/
        private Double height;
    
        /** 所属班级 class_no **/
        private Integer classNo;
    
        /** 性别 sex **/
        private Boolean sex;
    
        /** 智商 iq **/
        private Integer iq;
    
        /** 是否特别关注 focus **/
        private Boolean focus;
    
        /** 培养兴趣 cultivate_hobby **/
        private String cultivateHobby;
    
        /** 电话号码 phone **/
        private Integer phone;
    
        /** 地址 address **/
        private String address;
    
        /** 是否删除 is_delete **/
        private Boolean isDelete;
    
        /** 修改人 modifier **/
        private String modifier;
    
        /** 创建时间 gmt_create **/
        private Date gmtCreate;
    
        /** 修改时间 gmt_modified **/
        private Date gmtModified;
    
        /** bak **/
        private String bak;
    
        /** tableName: t_student **/
        private static final long serialVersionUID = 1L;
    
        /** id **/
        public Long getId() {
            return id;
        }
    
        /** id **/
        public void setId(Long id) {
            this.id = id;
        }
    
        /** 名称 name **/
        public String getName() {
            return name;
        }
    
        /** 名称 name **/
        public void setName(String name) {
            this.name = name;
        }
    
        /** 身高 height **/
        public Double getHeight() {
            return height;
        }
    
        /** 身高 height **/
        public void setHeight(Double height) {
            this.height = height;
        }
    
        /** 所属班级 class_no **/
        public Integer getClassNo() {
            return classNo;
        }
    
        /** 所属班级 class_no **/
        public void setClassNo(Integer classNo) {
            this.classNo = classNo;
        }
    
        /** 性别 sex **/
        public Boolean getSex() {
            return sex;
        }
    
        /** 性别 sex **/
        public void setSex(Boolean sex) {
            this.sex = sex;
        }
    
        /** 智商 iq **/
        public Integer getIq() {
            return iq;
        }
    
        /** 智商 iq **/
        public void setIq(Integer iq) {
            this.iq = iq;
        }
    
        /** 是否特别关注 focus **/
        public Boolean getFocus() {
            return focus;
        }
    
        /** 是否特别关注 focus **/
        public void setFocus(Boolean focus) {
            this.focus = focus;
        }
    
        /** 培养兴趣 cultivate_hobby **/
        public String getCultivateHobby() {
            return cultivateHobby;
        }
    
        /** 培养兴趣 cultivate_hobby **/
        public void setCultivateHobby(String cultivateHobby) {
            this.cultivateHobby = cultivateHobby;
        }
    
        /** 电话号码 phone **/
        public Integer getPhone() {
            return phone;
        }
    
        /** 电话号码 phone **/
        public void setPhone(Integer phone) {
            this.phone = phone;
        }
    
        /** 地址 address **/
        public String getAddress() {
            return address;
        }
    
        /** 地址 address **/
        public void setAddress(String address) {
            this.address = address;
        }
    
        /** 是否删除 is_delete **/
        public Boolean getIsDelete() {
            return isDelete;
        }
    
        /** 是否删除 is_delete **/
        public void setIsDelete(Boolean isDelete) {
            this.isDelete = isDelete;
        }
    
        /** 修改人 modifier **/
        public String getModifier() {
            return modifier;
        }
    
        /** 修改人 modifier **/
        public void setModifier(String modifier) {
            this.modifier = modifier;
        }
    
        /** 创建时间 gmt_create **/
        public Date getGmtCreate() {
            return gmtCreate;
        }
    
        /** 创建时间 gmt_create **/
        public void setGmtCreate(Date gmtCreate) {
            this.gmtCreate = gmtCreate;
        }
    
        /** 修改时间 gmt_modified **/
        public Date getGmtModified() {
            return gmtModified;
        }
    
        /** 修改时间 gmt_modified **/
        public void setGmtModified(Date gmtModified) {
            this.gmtModified = gmtModified;
        }
    
        /** bak **/
        public String getBak() {
            return bak;
        }
    
        /** bak **/
        public void setBak(String bak) {
            this.bak = bak;
        }
    
        @Override
        public String toString() {
            StringBuilder sb = new StringBuilder();
            sb.append(getClass().getSimpleName());
            sb.append(" [");
            sb.append("Hash = ").append(hashCode());
            sb.append(", id=").append(id);
            sb.append(", name=").append(name);
            sb.append(", height=").append(height);
            sb.append(", classNo=").append(classNo);
            sb.append(", sex=").append(sex);
            sb.append(", iq=").append(iq);
            sb.append(", focus=").append(focus);
            sb.append(", cultivateHobby=").append(cultivateHobby);
            sb.append(", phone=").append(phone);
            sb.append(", address=").append(address);
            sb.append(", isDelete=").append(isDelete);
            sb.append(", modifier=").append(modifier);
            sb.append(", gmtCreate=").append(gmtCreate);
            sb.append(", gmtModified=").append(gmtModified);
            sb.append(", bak=").append(bak);
            sb.append("]");
            return sb.toString();
        }
    }

package com.paincupid.springmvc.domain;
    
    import java.util.ArrayList;
    import java.util.Date;
    import java.util.Iterator;
    import java.util.List;
    
    public class StudentExample { 
        /** tableName: t_student **/
        protecte
        `d String orderByClause;
    
        /** tableName: t_student **/
        protected boolean distinct;
    
        /** tableName: t_student **/
        protected List<Criteria> oredCriteria;
    
        private Integer limit;
    
        private Integer offset;
    
        public StudentExample() {
            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;
        }
    
        public void setLimit(Integer limit) {
            this.limit = limit;
        }
    
        public Integer getLimit() {
            return limit;
        }
    
        public void setOffset(Integer offset) {
            this.offset = offset;
        }
    
        public Integer getOffset() {
            return offset;
        }
    
        /** t_student **/
        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));
            }
    
            protected void addCriterionForJDBCDate(String condition, Date value, String property) {
                if (value == null) {
                    throw new RuntimeException("Value for " + property + " cannot be null");
                }
                addCriterion(condition, new java.sql.Date(value.getTime()), property);
            }
    
            protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
                if (values == null || values.size() == 0) {
                    throw new RuntimeException("Value list for " + property + " cannot be null or empty");
                }
                List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
                Iterator<Date> iter = values.iterator();
                while (iter.hasNext()) {
                    dateList.add(new java.sql.Date(iter.next().getTime()));
                }
                addCriterion(condition, dateList, property);
            }
    
            protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
                if (value1 == null || value2 == null) {
                    throw new RuntimeException("Between values for " + property + " cannot be null");
                }
                addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
            }
    
            public Criteria andIdIsNull() {
                addCriterion("id is null");
                return (Criteria) this;
            }
    
            public Criteria andIdIsNotNull() {
                addCriterion("id is not null");
                return (Criteria) this;
            }
    
            public Criteria andIdEqualTo(Long value) {
                addCriterion("id =", value, "id");
                return (Criteria) this;
            }
    
            public Criteria andIdNotEqualTo(Long value) {
                addCriterion("id <>", value, "id");
                return (Criteria) this;
            }
    
            public Criteria andIdGreaterThan(Long value) {
                addCriterion("id >", value, "id");
                return (Criteria) this;
            }
    
            public Criteria andIdGreaterThanOrEqualTo(Long value) {
                addCriterion("id >=", value, "id");
                return (Criteria) this;
            }
    
            public Criteria andIdLessThan(Long value) {
                addCriterion("id <", value, "id");
                return (Criteria) this;
            }
    
            public Criteria andIdLessThanOrEqualTo(Long value) {
                addCriterion("id <=", value, "id");
                return (Criteria) this;
            }
    
            public Criteria andIdIn(List<Long> values) {
                addCriterion("id in", values, "id");
                return (Criteria) this;
            }
    
            public Criteria andIdNotIn(List<Long> values) {
                addCriterion("id not in", values, "id");
                return (Criteria) this;
            }
    
            public Criteria andIdBetween(Long value1, Long value2) {
                addCriterion("id between", value1, value2, "id");
                return (Criteria) this;
            }
    
            public Criteria andIdNotBetween(Long value1, Long value2) {
                addCriterion("id not between", value1, value2, "id");
                return (Criteria) this;
            }
    
            public Criteria andNameIsNull() {
                addCriterion("name is null");
                return (Criteria) this;
            }
    
            public Criteria andNameIsNotNull() {
                addCriterion("name is not null");
                return (Criteria) this;
            }
    
            public Criteria andNameEqualTo(String value) {
                addCriterion("name =", value, "name");
                return (Criteria) this;
            }
    
            public Criteria andNameNotEqualTo(String value) {
                addCriterion("name <>", value, "name");
                return (Criteria) this;
            }
    
            public Criteria andNameGreaterThan(String value) {
                addCriterion("name >", value, "name");
                return (Criteria) this;
            }
    
            public Criteria andNameGreaterThanOrEqualTo(String value) {
                addCriterion("name >=", value, "name");
                return (Criteria) this;
            }
    
            public Criteria andNameLessThan(String value) {
                addCriterion("name <", value, "name");
                return (Criteria) this;
            }
    
            public Criteria andNameLessThanOrEqualTo(String value) {
                addCriterion("name <=", value, "name");
                return (Criteria) this;
            }
    
            public Criteria andNameLike(String value) {
                addCriterion("name like", value, "name");
                return (Criteria) this;
            }
    
            public Criteria andNameNotLike(String value) {
                addCriterion("name not like", value, "name");
                return (Criteria) this;
            }
    
            public Criteria andNameIn(List<String> values) {
                addCriterion("name in", values, "name");
                return (Criteria) this;
            }
    
            public Criteria andNameNotIn(List<String> values) {
                addCriterion("name not in", values, "name");
                return (Criteria) this;
            }
    
            public Criteria andNameBetween(String value1, String value2) {
                addCriterion("name between", value1, value2, "name");
                return (Criteria) this;
            }
    
            public Criteria andNameNotBetween(String value1, String value2) {
                addCriterion("name not between", value1, value2, "name");
                return (Criteria) this;
            }
    
            public Criteria andHeightIsNull() {
                addCriterion("height is null");
                return (Criteria) this;
            }
    
            public Criteria andHeightIsNotNull() {
                addCriterion("height is not null");
                return (Criteria) this;
            }
    
            public Criteria andHeightEqualTo(Double value) {
                addCriterion("height =", value, "height");
                return (Criteria) this;
            }
    
            public Criteria andHeightNotEqualTo(Double value) {
                addCriterion("height <>", value, "height");
                return (Criteria) this;
            }
    
            public Criteria andHeightGreaterThan(Double value) {
                addCriterion("height >", value, "height");
                return (Criteria) this;
            }
    
            public Criteria andHeightGreaterThanOrEqualTo(Double value) {
                addCriterion("height >=", value, "height");
                return (Criteria) this;
            }
    
            public Criteria andHeightLessThan(Double value) {
                addCriterion("height <", value, "height");
                return (Criteria) this;
            }
    
            public Criteria andHeightLessThanOrEqualTo(Double value) {
                addCriterion("height <=", value, "height");
                return (Criteria) this;
            }
    
            public Criteria andHeightIn(List<Double> values) {
                addCriterion("height in", values, "height");
                return (Criteria) this;
            }
    
            public Criteria andHeightNotIn(List<Double> values) {
                addCriterion("height not in", values, "height");
                return (Criteria) this;
            }
    
            public Criteria andHeightBetween(Double value1, Double value2) {
                addCriterion("height between", value1, value2, "height");
                return (Criteria) this;
            }
    
            public Criteria andHeightNotBetween(Double value1, Double value2) {
                addCriterion("height not between", value1, value2, "height");
                return (Criteria) this;
            }
    
            public Criteria andClassNoIsNull() {
                addCriterion("class_no is null");
                return (Criteria) this;
            }
    
            public Criteria andClassNoIsNotNull() {
                addCriterion("class_no is not null");
                return (Criteria) this;
            }
    
            public Criteria andClassNoEqualTo(Integer value) {
                addCriterion("class_no =", value, "classNo");
                return (Criteria) this;
            }
    
            public Criteria andClassNoNotEqualTo(Integer value) {
                addCriterion("class_no <>", value, "classNo");
                return (Criteria) this;
            }
    
            public Criteria andClassNoGreaterThan(Integer value) {
                addCriterion("class_no >", value, "classNo");
                return (Criteria) this;
            }
    
            public Criteria andClassNoGreaterThanOrEqualTo(Integer value) {
                addCriterion("class_no >=", value, "classNo");
                return (Criteria) this;
            }
    
            public Criteria andClassNoLessThan(Integer value) {
                addCriterion("class_no <", value, "classNo");
                return (Criteria) this;
            }
    
            public Criteria andClassNoLessThanOrEqualTo(Integer value) {
                addCriterion("class_no <=", value, "classNo");
                return (Criteria) this;
            }
    
            public Criteria andClassNoIn(List<Integer> values) {
                addCriterion("class_no in", values, "classNo");
                return (Criteria) this;
            }
    
            public Criteria andClassNoNotIn(List<Integer> values) {
                addCriterion("class_no not in", values, "classNo");
                return (Criteria) this;
            }
    
            public Criteria andClassNoBetween(Integer value1, Integer value2) {
                addCriterion("class_no between", value1, value2, "classNo");
                return (Criteria) this;
            }
    
            public Criteria andClassNoNotBetween(Integer value1, Integer value2) {
                addCriterion("class_no not between", value1, value2, "classNo");
                return (Criteria) this;
            }
    
            public Criteria andSexIsNull() {
                addCriterion("sex is null");
                return (Criteria) this;
            }
    
            public Criteria andSexIsNotNull() {
                addCriterion("sex is not null");
                return (Criteria) this;
            }
    
            public Criteria andSexEqualTo(Boolean value) {
                addCriterion("sex =", value, "sex");
                return (Criteria) this;
            }
    
            public Criteria andSexNotEqualTo(Boolean value) {
                addCriterion("sex <>", value, "sex");
                return (Criteria) this;
            }
    
            public Criteria andSexGreaterThan(Boolean value) {
                addCriterion("sex >", value, "sex");
                return (Criteria) this;
            }
    
            public Criteria andSexGreaterThanOrEqualTo(Boolean value) {
                addCriterion("sex >=", value, "sex");
                return (Criteria) this;
            }
    
            public Criteria andSexLessThan(Boolean value) {
                addCriterion("sex <", value, "sex");
                return (Criteria) this;
            }
    
            public Criteria andSexLessThanOrEqualTo(Boolean value) {
                addCriterion("sex <=", value, "sex");
                return (Criteria) this;
            }
    
            public Criteria andSexIn(List<Boolean> values) {
                addCriterion("sex in", values, "sex");
                return (Criteria) this;
            }
    
            public Criteria andSexNotIn(List<Boolean> values) {
                addCriterion("sex not in", values, "sex");
                return (Criteria) this;
            }
    
            public Criteria andSexBetween(Boolean value1, Boolean value2) {
                addCriterion("sex between", value1, value2, "sex");
                return (Criteria) this;
            }
    
            public Criteria andSexNotBetween(Boolean value1, Boolean value2) {
                addCriterion("sex not between", value1, value2, "sex");
                return (Criteria) this;
            }
    
            public Criteria andIqIsNull() {
                addCriterion("iq is null");
                return (Criteria) this;
            }
    
            public Criteria andIqIsNotNull() {
                addCriterion("iq is not null");
                return (Criteria) this;
            }
    
            public Criteria andIqEqualTo(Integer value) {
                addCriterion("iq =", value, "iq");
                return (Criteria) this;
            }
    
            public Criteria andIqNotEqualTo(Integer value) {
                addCriterion("iq <>", value, "iq");
                return (Criteria) this;
            }
    
            public Criteria andIqGreaterThan(Integer value) {
                addCriterion("iq >", value, "iq");
                return (Criteria) this;
            }
    
            public Criteria andIqGreaterThanOrEqualTo(Integer value) {
                addCriterion("iq >=", value, "iq");
                return (Criteria) this;
            }
    
            public Criteria andIqLessThan(Integer value) {
                addCriterion("iq <", value, "iq");
                return (Criteria) this;
            }
    
            public Criteria andIqLessThanOrEqualTo(Integer value) {
                addCriterion("iq <=", value, "iq");
                return (Criteria) this;
            }
    
            public Criteria andIqIn(List<Integer> values) {
                addCriterion("iq in", values, "iq");
                return (Criteria) this;
            }
    
            public Criteria andIqNotIn(List<Integer> values) {
                addCriterion("iq not in", values, "iq");
                return (Criteria) this;
            }
    
            public Criteria andIqBetween(Integer value1, Integer value2) {
                addCriterion("iq between", value1, value2, "iq");
                return (Criteria) this;
            }
    
            public Criteria andIqNotBetween(Integer value1, Integer value2) {
                addCriterion("iq not between", value1, value2, "iq");
                return (Criteria) this;
            }
    
            public Criteria andFocusIsNull() {
                addCriterion("focus is null");
                return (Criteria) this;
            }
    
            public Criteria andFocusIsNotNull() {
                addCriterion("focus is not null");
                return (Criteria) this;
            }
    
            public Criteria andFocusEqualTo(Boolean value) {
                addCriterion("focus =", value, "focus");
                return (Criteria) this;
            }
    
            public Criteria andFocusNotEqualTo(Boolean value) {
                addCriterion("focus <>", value, "focus");
                return (Criteria) this;
            }
    
            public Criteria andFocusGreaterThan(Boolean value) {
                addCriterion("focus >", value, "focus");
                return (Criteria) this;
            }
    
            public Criteria andFocusGreaterThanOrEqualTo(Boolean value) {
                addCriterion("focus >=", value, "focus");
                return (Criteria) this;
            }
    
            public Criteria andFocusLessThan(Boolean value) {
                addCriterion("focus <", value, "focus");
                return (Criteria) this;
            }
    
            public Criteria andFocusLessThanOrEqualTo(Boolean value) {
                addCriterion("focus <=", value, "focus");
                return (Criteria) this;
            }
    
            public Criteria andFocusIn(List<Boolean> values) {
                addCriterion("focus in", values, "focus");
                return (Criteria) this;
            }
    
            public Criteria andFocusNotIn(List<Boolean> values) {
                addCriterion("focus not in", values, "focus");
                return (Criteria) this;
            }
    
            public Criteria andFocusBetween(Boolean value1, Boolean value2) {
                addCriterion("focus between", value1, value2, "focus");
                return (Criteria) this;
            }
    
            public Criteria andFocusNotBetween(Boolean value1, Boolean value2) {
                addCriterion("focus not between", value1, value2, "focus");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyIsNull() {
                addCriterion("cultivate_hobby is null");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyIsNotNull() {
                addCriterion("cultivate_hobby is not null");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyEqualTo(String value) {
                addCriterion("cultivate_hobby =", value, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyNotEqualTo(String value) {
                addCriterion("cultivate_hobby <>", value, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyGreaterThan(String value) {
                addCriterion("cultivate_hobby >", value, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyGreaterThanOrEqualTo(String value) {
                addCriterion("cultivate_hobby >=", value, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyLessThan(String value) {
                addCriterion("cultivate_hobby <", value, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyLessThanOrEqualTo(String value) {
                addCriterion("cultivate_hobby <=", value, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyLike(String value) {
                addCriterion("cultivate_hobby like", value, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyNotLike(String value) {
                addCriterion("cultivate_hobby not like", value, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyIn(List<String> values) {
                addCriterion("cultivate_hobby in", values, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyNotIn(List<String> values) {
                addCriterion("cultivate_hobby not in", values, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyBetween(String value1, String value2) {
                addCriterion("cultivate_hobby between", value1, value2, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andCultivateHobbyNotBetween(String value1, String value2) {
                addCriterion("cultivate_hobby not between", value1, value2, "cultivateHobby");
                return (Criteria) this;
            }
    
            public Criteria andPhoneIsNull() {
                addCriterion("phone is null");
                return (Criteria) this;
            }
    
            public Criteria andPhoneIsNotNull() {
                addCriterion("phone is not null");
                return (Criteria) this;
            }
    
            public Criteria andPhoneEqualTo(Integer value) {
                addCriterion("phone =", value, "phone");
                return (Criteria) this;
            }
    
            public Criteria andPhoneNotEqualTo(Integer value) {
                addCriterion("phone <>", value, "phone");
                return (Criteria) this;
            }
    
            public Criteria andPhoneGreaterThan(Integer value) {
                addCriterion("phone >", value, "phone");
                return (Criteria) this;
            }
    
            public Criteria andPhoneGreaterThanOrEqualTo(Integer value) {
                addCriterion("phone >=", value, "phone");
                return (Criteria) this;
            }
    
            public Criteria andPhoneLessThan(Integer value) {
                addCriterion("phone <", value, "phone");
                return (Criteria) this;
            }
    
            public Criteria andPhoneLessThanOrEqualTo(Integer value) {
                addCriterion("phone <=", value, "phone");
                return (Criteria) this;
            }
    
            public Criteria andPhoneIn(List<Integer> values) {
                addCriterion("phone in", values, "phone");
                return (Criteria) this;
            }
    
            public Criteria andPhoneNotIn(List<Integer> values) {
                addCriterion("phone not in", values, "phone");
                return (Criteria) this;
            }
    
            public Criteria andPhoneBetween(Integer value1, Integer value2) {
                addCriterion("phone between", value1, value2, "phone");
                return (Criteria) this;
            }
    
            public Criteria andPhoneNotBetween(Integer value1, Integer value2) {
                addCriterion("phone not between", value1, value2, "phone");
                return (Criteria) this;
            }
    
            public Criteria andAddressIsNull() {
                addCriterion("address is null");
                return (Criteria) this;
            }
    
            public Criteria andAddressIsNotNull() {
                addCriterion("address is not null");
                return (Criteria) this;
            }
    
            public Criteria andAddressEqualTo(String value) {
                addCriterion("address =", value, "address");
                return (Criteria) this;
            }
    
            public Criteria andAddressNotEqualTo(String value) {
                addCriterion("address <>", value, "address");
                return (Criteria) this;
            }
    
            public Criteria andAddressGreaterThan(String value) {
                addCriterion("address >", value, "address");
                return (Criteria) this;
            }
    
            public Criteria andAddressGreaterThanOrEqualTo(String value) {
                addCriterion("address >=", value, "address");
                return (Criteria) this;
            }
    
            public Criteria andAddressLessThan(String value) {
                addCriterion("address <", value, "address");
                return (Criteria) this;
            }
    
            public Criteria andAddressLessThanOrEqualTo(String value) {
                addCriterion("address <=", value, "address");
                return (Criteria) this;
            }
    
            public Criteria andAddressLike(String value) {
                addCriterion("address like", value, "address");
                return (Criteria) this;
            }
    
            public Criteria andAddressNotLike(String value) {
                addCriterion("address not like", value, "address");
                return (Criteria) this;
            }
    
            public Criteria andAddressIn(List<String> values) {
                addCriterion("address in", values, "address");
                return (Criteria) this;
            }
    
            public Criteria andAddressNotIn(List<String> values) {
                addCriterion("address not in", values, "address");
                return (Criteria) this;
            }
    
            public Criteria andAddressBetween(String value1, String value2) {
                addCriterion("address between", value1, value2, "address");
                return (Criteria) this;
            }
    
            public Criteria andAddressNotBetween(String value1, String value2) {
                addCriterion("address not between", value1, value2, "address");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteIsNull() {
                addCriterion("is_delete is null");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteIsNotNull() {
                addCriterion("is_delete is not null");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteEqualTo(Boolean value) {
                addCriterion("is_delete =", value, "isDelete");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteNotEqualTo(Boolean value) {
                addCriterion("is_delete <>", value, "isDelete");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteGreaterThan(Boolean value) {
                addCriterion("is_delete >", value, "isDelete");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteGreaterThanOrEqualTo(Boolean value) {
                addCriterion("is_delete >=", value, "isDelete");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteLessThan(Boolean value) {
                addCriterion("is_delete <", value, "isDelete");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteLessThanOrEqualTo(Boolean value) {
                addCriterion("is_delete <=", value, "isDelete");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteIn(List<Boolean> values) {
                addCriterion("is_delete in", values, "isDelete");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteNotIn(List<Boolean> values) {
                addCriterion("is_delete not in", values, "isDelete");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteBetween(Boolean value1, Boolean value2) {
                addCriterion("is_delete between", value1, value2, "isDelete");
                return (Criteria) this;
            }
    
            public Criteria andIsDeleteNotBetween(Boolean value1, Boolean value2) {
                addCriterion("is_delete not between", value1, value2, "isDelete");
                return (Criteria) this;
            }
    
            public Criteria andModifierIsNull() {
                addCriterion("modifier is null");
                return (Criteria) this;
            }
    
            public Criteria andModifierIsNotNull() {
                addCriterion("modifier is not null");
                return (Criteria) this;
            }
    
            public Criteria andModifierEqualTo(String value) {
                addCriterion("modifier =", value, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andModifierNotEqualTo(String value) {
                addCriterion("modifier <>", value, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andModifierGreaterThan(String value) {
                addCriterion("modifier >", value, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andModifierGreaterThanOrEqualTo(String value) {
                addCriterion("modifier >=", value, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andModifierLessThan(String value) {
                addCriterion("modifier <", value, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andModifierLessThanOrEqualTo(String value) {
                addCriterion("modifier <=", value, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andModifierLike(String value) {
                addCriterion("modifier like", value, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andModifierNotLike(String value) {
                addCriterion("modifier not like", value, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andModifierIn(List<String> values) {
                addCriterion("modifier in", values, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andModifierNotIn(List<String> values) {
                addCriterion("modifier not in", values, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andModifierBetween(String value1, String value2) {
                addCriterion("modifier between", value1, value2, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andModifierNotBetween(String value1, String value2) {
                addCriterion("modifier not between", value1, value2, "modifier");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateIsNull() {
                addCriterion("gmt_create is null");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateIsNotNull() {
                addCriterion("gmt_create is not null");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateEqualTo(Date value) {
                addCriterionForJDBCDate("gmt_create =", value, "gmtCreate");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateNotEqualTo(Date value) {
                addCriterionForJDBCDate("gmt_create <>", value, "gmtCreate");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateGreaterThan(Date value) {
                addCriterionForJDBCDate("gmt_create >", value, "gmtCreate");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateGreaterThanOrEqualTo(Date value) {
                addCriterionForJDBCDate("gmt_create >=", value, "gmtCreate");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateLessThan(Date value) {
                addCriterionForJDBCDate("gmt_create <", value, "gmtCreate");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateLessThanOrEqualTo(Date value) {
                addCriterionForJDBCDate("gmt_create <=", value, "gmtCreate");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateIn(List<Date> values) {
                addCriterionForJDBCDate("gmt_create in", values, "gmtCreate");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateNotIn(List<Date> values) {
                addCriterionForJDBCDate("gmt_create not in", values, "gmtCreate");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateBetween(Date value1, Date value2) {
                addCriterionForJDBCDate("gmt_create between", value1, value2, "gmtCreate");
                return (Criteria) this;
            }
    
            public Criteria andGmtCreateNotBetween(Date value1, Date value2) {
                addCriterionForJDBCDate("gmt_create not between", value1, value2, "gmtCreate");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedIsNull() {
                addCriterion("gmt_modified is null");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedIsNotNull() {
                addCriterion("gmt_modified is not null");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedEqualTo(Date value) {
                addCriterionForJDBCDate("gmt_modified =", value, "gmtModified");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedNotEqualTo(Date value) {
                addCriterionForJDBCDate("gmt_modified <>", value, "gmtModified");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedGreaterThan(Date value) {
                addCriterionForJDBCDate("gmt_modified >", value, "gmtModified");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedGreaterThanOrEqualTo(Date value) {
                addCriterionForJDBCDate("gmt_modified >=", value, "gmtModified");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedLessThan(Date value) {
                addCriterionForJDBCDate("gmt_modified <", value, "gmtModified");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedLessThanOrEqualTo(Date value) {
                addCriterionForJDBCDate("gmt_modified <=", value, "gmtModified");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedIn(List<Date> values) {
                addCriterionForJDBCDate("gmt_modified in", values, "gmtModified");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedNotIn(List<Date> values) {
                addCriterionForJDBCDate("gmt_modified not in", values, "gmtModified");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedBetween(Date value1, Date value2) {
                addCriterionForJDBCDate("gmt_modified between", value1, value2, "gmtModified");
                return (Criteria) this;
            }
    
            public Criteria andGmtModifiedNotBetween(Date value1, Date value2) {
                addCriterionForJDBCDate("gmt_modified not between", value1, value2, "gmtModified");
                return (Criteria) this;
            }
    
            public Criteria andBakIsNull() {
                addCriterion("bak is null");
                return (Criteria) this;
            }
    
            public Criteria andBakIsNotNull() {
                addCriterion("bak is not null");
                return (Criteria) this;
            }
    
            public Criteria andBakEqualTo(String value) {
                addCriterion("bak =", value, "bak");
                return (Criteria) this;
            }
    
            public Criteria andBakNotEqualTo(String value) {
                addCriterion("bak <>", value, "bak");
                return (Criteria) this;
            }
    
            public Criteria andBakGreaterThan(String value) {
                addCriterion("bak >", value, "bak");
                return (Criteria) this;
            }
    
            public Criteria andBakGreaterThanOrEqualTo(String value) {
                addCriterion("bak >=", value, "bak");
                return (Criteria) this;
            }
    
            public Criteria andBakLessThan(String value) {
                addCriterion("bak <", value, "bak");
                return (Criteria) this;
            }
    
            public Criteria andBakLessThanOrEqualTo(String value) {
                addCriterion("bak <=", value, "bak");
                return (Criteria) this;
            }
    
            public Criteria andBakLike(String value) {
                addCriterion("bak like", value, "bak");
                return (Criteria) this;
            }
    
            public Criteria andBakNotLike(String value) {
                addCriterion("bak not like", value, "bak");
                return (Criteria) this;
            }
    
            public Criteria andBakIn(List<String> values) {
                addCriterion("bak in", values, "bak");
                return (Criteria) this;
            }
    
            public Criteria andBakNotIn(List<String> values) {
                addCriterion("bak not in", values, "bak");
                return (Criteria) this;
            }
    
            public Criteria andBakBetween(String value1, String value2) {
                addCriterion("bak between", value1, value2, "bak");
                return (Criteria) this;
            }
    
            public Criteria andBakNotBetween(String value1, String value2) {
                addCriterion("bak not between", value1, value2, "bak");
                return (Criteria) this;
            }
        }
    
        /** tableName: t_student **/
        public static class Criteria extends GeneratedCriteria { 
    
            protected Criteria() {
                super();
            }
        }
    
        /** t_student **/
        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);
            }
        }
    }

## create mysql ##

DROP TABLE IF EXISTS `t_student`;
    CREATE TABLE `t_student` ( `id` bigint(20) AUTO_INCREMENT , `name` varchar(50) not NULL COMMENT '名称', `height` double(4,2) comment '身高', `class_no` int(11) COMMENT '所属班级', `sex` tinyint(1) COMMENT '性别', `iq` int(11) COMMENT '智商', `focus` tinyint(1) COMMENT '是否特别关注', `cultivate_hobby` varchar(500) COMMENT '培养兴趣', `phone` int(11) DEFAULT NULL COMMENT '电话号码', `address` varchar(500) COMMENT '地址', `is_delete` tinyint(1) not NULL COMMENT '是否删除', `modifier` varchar(50) not NULL COMMENT '修改人', `gmt_create` date not NULL COMMENT '创建时间', `gmt_modified` date not NULL COMMENT '修改时间', `bak` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET=utf8 COMMENT='学生表';

[https_gitee.com_paincupid_simple-springmvc]: https://gitee.com/paincupid/simple-springmvc