mybaits mapper.xml的写法

最新推荐文章于 2025-05-28 20:51:03 发布
最新推荐文章于 2025-05-28 20:51:03 发布
阅读量2.4k 收藏 3
点赞数
CC 4.0 BY-SA版权
分类专栏： mybatis 文章标签： mybatis mapper
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/paincupid/article/details/78453855
本文提供了一个基于MyBatis的学生信息管理系统的示例代码，包括Java接口定义、XML映射文件及实体类等内容，展示了如何进行增删改查等操作。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

用习惯了mybaits generator，好久不写mybaits，发现都不会写了，这里先放下些例子，以供以后用的时候参考
项目示例下载地址：
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">
<!-- Important: StudentVoMapper's name must be the same as the Java file!!!!!!!!!   -->
<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='学生表';
mybatis mapper.xml 比较运算符（大于|小于|等于）的写法: 转义和＜![CDATA[]]＞
专注于计算机研发知识和资讯分享
07-03 1752
CDATA[ 内容 ]]> 中的内容 部分，不能再包含 ，也不能嵌套使用。[CDATA[]]> 是一个整体，处理放置内容文本的部分之外，不能出现 空格 或者 换行。个人比较喜欢使用 ，因为我记不住那个转义的意思。这种格式时，会把方块中的内容直接输出，不做任何的解析转义。背景：在 *.xml 中使用常规的。会与xml的语法存在冲突。【MarkDown】小知识。在 xml 格式中，当遇到。应用场景：查询时间范围。
Mybatis在Mapper.xml文件中的转义字符处理方式
hlli86的博客
10-10 2130
文章目录Mybatis在Mapper.xml文件中的转义字符处理方式1、常用的XML转义字符写法2、使用CDATA标志处理转义字符3、应用案例 Mybatis在Mapper.xml文件中的转义字符处理方式 1、常用的XML转义字符写法 字符 转义 说明 < < 小于 <= <= 小于等于 > > 大于 >= >= 大于等于 <> <> 不等于 & & 和 ’ ' 单引号 " "
mybatis的mapper对应的xml写法
最新发布
abcnull 的博客
05-28 1391
在MyBatis中，如果不写这样的条件判断，如果是对表的写操作，如 update，其中的 set 中当name参数为null时，生成的SQL语句会直接包含name = null，从而将数据库中的对应字段更新为NULL。如果没写 @Param，MyBatis 默认将未使用 @Param 注解的参数封装为 Map，键名为 param1、param2、…if 是独立的判断，而 choose when 更像 ifelse 逻辑，一旦判断一个满足，后续的 when 就不执行了！是可选的，但如果省略且所有。
mybatis的mapper.xml编写
qq_44527508的博客
02-22 2580
自用
mybatis的 mapper.xml 书写
qq_44182694的博客
06-03 1271
mapper.xml
mybatis映射文件mapper.xml的写法。
热门推荐
依木前行的博客
06-25 10万+
在学习mybatis的时候我们通常会在映射文件这样写：&lt;?xml version="1.0" encoding="UTF-8" ?&gt; &lt;!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"&gt; &lt;mappe
mapper.xml的基本写法
Types_c的博客
10-26 3773
修改代码块 <update id="editContent" parameterType="com.ilearning.ssm.pojo.LessionContent"> update tb_lession_content <set> <if test="tb_le_con_content!=null"> tb_le_con_content=#{tb_le_con_conten
Mybaits的mapper.xml文件test表达式比较字符串与纯数字问题
hydy的博客
08-03 1770
原本写法 <if test="filter.bugId != null and filter.bugId != ''"> AND <choose> <when test="filter.bugId == '0'"> (a_s.bug_id is null or a_s.bug_id = '' or a_s.bug_id = '0') </when> <otherw
mybatis mapper 传 List Map mapper.xml解析
Mclaughling的博客
11-25 867
mapper public interface StandingBookMangerMapper { /*** * * @param tableName * @param id * @return */ Map<Object,Object> getStandingBookFile(@Param("tableName") String tableName, @Param("id") Integer id); /**
Mybatis的多对一与一对多查询 Mapper.xml 讲解
JssenJ的博客
02-06 1505
文章目录Mybatis、一、数据库搭建二、多对一查询**1.创建Student实体类****2.创建Teacher实体类****3.StudentMapper构建****4. StudentMapper.xml 讲解（只展示核心代码部分）****4.1 按照查询嵌套处理****4.2 按照结果嵌套处理**三、一对多1. 创建Student实体类2. 创建Teacher实体类对象3. TeacherMapper构建4. TeacherMapper.xml讲解（只展示核心代码部分）4.1 按照结果嵌套处理4
MyBatis的模糊查询mapper.xml的写法
唯爱沁源的博客
11-05 3万+
模糊查询语句不建议使用${}的方式，还是建议采用MyBatis自带的#{}方式，#{}是预加载的方式运行的，比较安全，${}方式可以用但是有SQL注入的风险！！！ 1.直接传参 在controller类中 String id = "%"+ id +"%"; String name = "%"+ name +"%"; dao.selectByIdAndName(id,name); 在map...
mybatis_02:Mapper.xml映射文件的写法
jupiter_888的博客
11-01 415
${}和#{}的用法区分: ${}表示拼接字符串，通过${}可以将parameterType传入的 内容拼接在sql中且不进行jdbc类型转换，${}可以接收简单 类型值或pojo属性值，如果parameter传输的是单个简单类 型值，${}括号内只能是value #{}表示一个占位符，通过#{}向占位符中设置值，自动进行 java类型和jdbc类型转换，#{}可以有效防止sql...
Mybatis常用的mapper.xml文件的编写
q614543393的博客
03-22 524
【代码】Mybatis常用的mapper.xml文件的编写。
有关mapper.xml编写问题
mmmmhello的博客
01-20 639
1、动态sql If 条件判断比较简单 但是如果是下面这样 当 name为 null时 sql语句语法就错误。这时可以用 where解决 WHERE 这时mybatis会自动为我们处理 and 即使 name为null 也会自动去除and. 其实 还有一种方法 就是trim TRIM 解释：prefix 前缀， 意思是会自动删除where后边的AND 或者 OR
mybatis中的ResultMap使用
平凡的鱼
02-20 962
mybatis中的ResultMap使用 文章目录mybatis中的ResultMap使用一、自动映射二、手动映射1、返回值类型为resultMap2、编写resultMap，实现手动映射！总结 一、自动映射 resultMap 元素是 MyBatis 中最重要最强大的元素。它可以让你从 90% 的 JDBC ResultSets 数据提取代码中解放出来。 实际上，在为一些比如连接的复杂语句编写映射代码的时候，一份 resultMap 能够代替实现同等功能的长达数千行的代码。 ResultM
mapper的xml格式（内含动态sql语句）
wwsbb11的博客
11-15 366
id= #{id}
mybatis框架之mapper的xml映射配置的编写（insert、delete、update、select标签使用）
IT_CREATE的博客
01-03 1万+
spring整合mybatis的配置文件applicatonContext.xml：https://blog.csdn.net/IT_CREATE/article/details/85329007 mybtis中的级联关系（关联关系、集合关系）association、collection（一对一关系、一对多关系、多对多关系）：https://blog.csdn.net/IT_CREATE/art...
select * from Student where student_id =1 and ( student_no=21 or age=2)用mybaits xml 文件怎么写
11-27
在MyBatis XML映射文件中，你可以使用`<select>`标签来编写SQL查询，结合`if`条件和`or`逻辑来满足这样的需求。假设你有一个名为`StudentMapper`的XML文件，并且其中包含一个名为`selectStudent`的方法，对应的XML会像这样： ```xml <select id="selectStudent" parameterType="map" resultType="com.example.Student"> SELECT * FROM Student WHERE student_id = #{studentId} <if test="studentNo != null"> AND student_no = #{studentNo} </if> <if test="age != null"> OR age = #{age} </if> </select> <!-- 使用示例 --> <sqlMap namespace="YourNamespace"> <!-- ... 其他映射定义 ... --> <mapper> <select refid="selectStudent" /> </mapper> </sqlMap> ``` 在这里，`#{studentId}`、`#{studentNo}`和`#{age}`是占位符，用于动态绑定实际传入的参数值。当传入`studentNo`或`age`时，相应的`if`块内的SQL条件才会生效。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值