前言：

1，实体类之类如果自己写的话，比较繁琐，还容易出错，所以用generate自动生成

2，int类型可能会生成为short类型，建议不要手动改回int类。因为下次生成又是short类型了，可能会对代码有影响，每次都更改又比较麻烦

正文：

用法：点击generate.bat即可执行，如果报错，需要看执行的信息，就用命令行执行

注：有的时候再次生成mapper之后，启动项目会报错。删除生成的mapper文件，重新生成一次就好了

jar包：ojdbc6.jar（这是oracle的驱动jar包，mysql是mysql-connector-java-3.1.12-bin.jar），mybatis-generator-core-1.3.2.jar（网盘链接：https://pan.baidu.com/s/1sE3wAbbcXLCmMvY_OfSw5g 提取码：qy2p ）

generatorConfig.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

<generatorConfiguration>

<classPathEntry location="G:\lib\ojdbc6.jar" /> <!-- 数据库驱动jar包 -->

  <context id="context1">

    <plugin type="org.mybatis.generator.plugins.RowBoundsPlugin"></plugin> <!-- 翻页 -->

    <commentGenerator>

      <property name="suppressAllComments" value="true"/>

    </commentGenerator>

    <jdbcConnection connectionURL="jdbc:oracle:thin:@172.1.1.0:1521/test" driverClass="oracle.jdbc.driver.OracleDriver" userId="test" password="test" /> <!-- 数据库账号密码 -->

    <javaTypeResolver>

          <property name="forceBigDecimals" value="false" />

    </javaTypeResolver>

    <javaModelGenerator targetPackage="com.bf.doctor.entity" targetProject="G:\BFDoctor\Source\src\main\java" /> <!-- 实体类 -->

    <sqlMapGenerator targetPackage="mybatis.mapper" targetProject="G:\BFDoctor\Source\src\main\resources" /> <!-- 数据库xml文件 -->

    <javaClientGenerator type="XMLMAPPER" targetPackage="com.bf.doctor.dao.mapper"  targetProject="G:\BFDoctor\Source\src\main\java" /><!-- 数据库接口文件 -->

    <table tableName="A" /> <!-- 表名 -->

    <!--

    <table tableName="A" />

    <table tableName="B" />

    <table tableName="C" />

    --> <!-- 全部表名，用完不要删除，之后生成单个表就拿出去 -->

  </context>

</generatorConfiguration>

generate.bat

java -jar G:\lib\mybatis-generator-core-1.3.2.jar -configfile generatorConfig.xml -overwrite

生成的文件：

实体类Test

package com.bf.doctor.entity;

public class Test {

    private String id;

    public String getId() {

        return id;

    }

    public void setId(String id) {

        this.id = id;

    }

}

映射TestExample

package com.bf.doctor.entity;

import java.util.ArrayList;

import java.util.List;

public class TestExample {

    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TestExample() {

        oredCriteria = new ArrayList<Criteria>();

    }

    public void setOrderByClause(String orderByClause) {

        this.orderByClause = orderByClause;

    }

    public String getOrderByClause() {

        return orderByClause;

    }

    public void setDistinct(boolean distinct) {

        this.distinct = distinct;

    }

    public boolean isDistinct() {

        return distinct;

    }

    public List<Criteria> getOredCriteria() {

        return oredCriteria;

    }

    public void or(Criteria criteria) {

        oredCriteria.add(criteria);

    }

    public Criteria or() {

        Criteria criteria = createCriteriaInternal();

        oredCriteria.add(criteria);

        return criteria;

    }

    public Criteria createCriteria() {

        Criteria criteria = createCriteriaInternal();

        if (oredCriteria.size() == 0) {

            oredCriteria.add(criteria);

        }

        return criteria;

    }

    protected Criteria createCriteriaInternal() {

        Criteria criteria = new Criteria();

        return criteria;

    }

    public void clear() {

        oredCriteria.clear();

        orderByClause = null;

        distinct = false;

    }

    protected abstract static class GeneratedCriteria {

        protected List<Criterion> criteria;

        protected GeneratedCriteria() {

            super();

            criteria = new ArrayList<Criterion>();

        }

        public boolean isValid() {

            return criteria.size() > 0;

        }

        public List<Criterion> getAllCriteria() {

            return criteria;

        }

        public List<Criterion> getCriteria() {

            return criteria;

        }

        protected void addCriterion(String condition) {

            if (condition == null) {

                throw new RuntimeException("Value for condition cannot be null");

            }

            criteria.add(new Criterion(condition));

        }

        protected void addCriterion(String condition, Object value, String property) {

            if (value == null) {

                throw new RuntimeException("Value for " + property + " cannot be null");

            }

            criteria.add(new Criterion(condition, value));

        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {

            if (value1 == null || value2 == null) {

                throw new RuntimeException("Between values for " + property + " cannot be null");

            }

            criteria.add(new Criterion(condition, value1, value2));

        }

        public Criteria andIdIsNull() {

            addCriterion("ID is null");

            return (Criteria) this;

        }

        public Criteria andIdIsNotNull() {

            addCriterion("ID is not null");

            return (Criteria) this;

        }

        public Criteria andIdEqualTo(String value) {

            addCriterion("ID =", value, "id");

            return (Criteria) this;

        }

        public Criteria andIdNotEqualTo(String value) {

            addCriterion("ID <>", value, "id");

            return (Criteria) this;

        }

        public Criteria andIdGreaterThan(String value) {

            addCriterion("ID >", value, "id");

            return (Criteria) this;

        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {

            addCriterion("ID >=", value, "id");

            return (Criteria) this;

        }

        public Criteria andIdLessThan(String value) {

            addCriterion("ID <", value, "id");

            return (Criteria) this;

        }

        public Criteria andIdLessThanOrEqualTo(String value) {

            addCriterion("ID <=", value, "id");

            return (Criteria) this;

        }

        public Criteria andIdLike(String value) {

            addCriterion("ID like", value, "id");

            return (Criteria) this;

        }

        public Criteria andIdNotLike(String value) {

            addCriterion("ID not like", value, "id");

            return (Criteria) this;

        }

        public Criteria andIdIn(List<String> values) {

            addCriterion("ID in", values, "id");

            return (Criteria) this;

        }

        public Criteria andIdNotIn(List<String> values) {

            addCriterion("ID not in", values, "id");

            return (Criteria) this;

        }

        public Criteria andIdBetween(String value1, String value2) {

            addCriterion("ID between", value1, value2, "id");

            return (Criteria) this;

        }

        public Criteria andIdNotBetween(String value1, String value2) {

            addCriterion("ID not between", value1, value2, "id");

            return (Criteria) this;

        }

    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {

            super();

        }

    }

    public static class Criterion {

        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {

            return condition;

        }

        public Object getValue() {

            return value;

        }

        public Object getSecondValue() {

            return secondValue;

        }

        public boolean isNoValue() {

            return noValue;

        }

        public boolean isSingleValue() {

            return singleValue;

        }

        public boolean isBetweenValue() {

            return betweenValue;

        }

        public boolean isListValue() {

            return listValue;

        }

        public String getTypeHandler() {

            return typeHandler;

        }

        protected Criterion(String condition) {

            super();

            this.condition = condition;

            this.typeHandler = null;

            this.noValue = true;

        }

        protected Criterion(String condition, Object value, String typeHandler) {

            super();

            this.condition = condition;

            this.value = value;

            this.typeHandler = typeHandler;

            if (value instanceof List<?>) {

                this.listValue = true;

            } else {

                this.singleValue = true;

            }

        }

        protected Criterion(String condition, Object value) {

            this(condition, value, null);

        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {

            super();

            this.condition = condition;

            this.value = value;

            this.secondValue = secondValue;

            this.typeHandler = typeHandler;

            this.betweenValue = true;

        }

        protected Criterion(String condition, Object value, Object secondValue) {

            this(condition, value, secondValue, null);

        }

    }

}

数据库接口TestMapper

package com.bf.doctor.dao.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import org.apache.ibatis.session.RowBounds;

public interface TestMapper {

    int countByExample(TestExample example);

    int deleteByExample(TestExample example);

    int insert(Test record);

    int insertSelective(Test record);

    List<Test> selectByExampleWithRowbounds(TestExample example, RowBounds rowBounds);

    List<Test> selectByExample(TestExample example);

    int updateByExampleSelective(@Param("record") Test record, @Param("example") TestExample example);

    int updateByExample(@Param("record") Test record, @Param("example") TestExample example);

}

数据库mapper

<?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.bf.doctor.dao.mapper.TestMapper" >

  <resultMap id="BaseResultMap" type="com.bf.doctor.entity.Test" >

    <result column="ID" property="id" jdbcType="VARCHAR" />

  </resultMap>

  <sql id="Example_Where_Clause" >

    <where >

      <foreach collection="oredCriteria" item="criteria" separator="or" >

        <if test="criteria.valid" >

          <trim prefix="(" suffix=")" prefixOverrides="and" >

            <foreach collection="criteria.criteria" item="criterion" >

              <choose >

                <when test="criterion.noValue" >

                  and ${criterion.condition}

                </when>

                <when test="criterion.singleValue" >

                  and ${criterion.condition} #{criterion.value}

                </when>

                <when test="criterion.betweenValue" >

                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

                </when>

                <when test="criterion.listValue" >

                  and ${criterion.condition}

                  <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >

                    #{listItem}

                  </foreach>

                </when>

              </choose>

            </foreach>

          </trim>

        </if>

      </foreach>

    </where>

  </sql>

  <sql id="Update_By_Example_Where_Clause" >

    <where >

      <foreach collection="example.oredCriteria" item="criteria" separator="or" >

        <if test="criteria.valid" >

          <trim prefix="(" suffix=")" prefixOverrides="and" >

            <foreach collection="criteria.criteria" item="criterion" >

              <choose >

                <when test="criterion.noValue" >

                  and ${criterion.condition}

                </when>

                <when test="criterion.singleValue" >

                  and ${criterion.condition} #{criterion.value}

                </when>

                <when test="criterion.betweenValue" >

                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

                </when>

                <when test="criterion.listValue" >

                  and ${criterion.condition}

                  <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >

                    #{listItem}

                  </foreach>

                </when>

              </choose>

            </foreach>

          </trim>

        </if>

      </foreach>

    </where>

  </sql>

  <sql id="Base_Column_List" >

    ID

  </sql>

  <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.bf.doctor.entity.TestExample" >

    select

    <if test="distinct" >

      distinct

    </if>

    <include refid="Base_Column_List" />

    from TEST

    <if test="_parameter != null" >

      <include refid="Example_Where_Clause" />

    </if>

    <if test="orderByClause != null" >

      order by ${orderByClause}

    </if>

  </select>

  <delete id="deleteByExample" parameterType="com.bf.doctor.entity.TestExample" >

    delete from TEST

    <if test="_parameter != null" >

      <include refid="Example_Where_Clause" />

    </if>

  </delete>

  <insert id="insert" parameterType="com.bf.doctor.entity.Test" >

    insert into TEST (ID)

    values (#{id,jdbcType=VARCHAR})

  </insert>

  <insert id="insertSelective" parameterType="com.bf.doctor.entity.Test" >

    insert into TEST

    <trim prefix="(" suffix=")" suffixOverrides="," >

      <if test="id != null" >

        ID,

      </if>

    </trim>

    <trim prefix="values (" suffix=")" suffixOverrides="," >

      <if test="id != null" >

        #{id,jdbcType=VARCHAR},

      </if>

    </trim>

  </insert>

  <select id="countByExample" parameterType="com.bf.doctor.entity.TestExample" resultType="java.lang.Integer" >

    select count(*) from TEST

    <if test="_parameter != null" >

      <include refid="Example_Where_Clause" />

    </if>

  </select>

  <update id="updateByExampleSelective" parameterType="map" >

    update TEST

    <set >

      <if test="record.id != null" >

        ID = #{record.id,jdbcType=VARCHAR},

      </if>

    </set>

    <if test="_parameter != null" >

      <include refid="Update_By_Example_Where_Clause" />

    </if>

  </update>

  <update id="updateByExample" parameterType="map" >

    update TEST

    set ID = #{record.id,jdbcType=VARCHAR}

    <if test="_parameter != null" >

      <include refid="Update_By_Example_Where_Clause" />

    </if>

  </update>

  <select resultMap="BaseResultMap" parameterType="com.bf.doctor.entity.TestExample" id="selectByExampleWithRowbounds" >

    select

    <if test="distinct" >

      distinct

    </if>

    <include refid="Base_Column_List" />

    from TEST

    <if test="_parameter != null" >

      <include refid="Example_Where_Clause" />

    </if>

    <if test="orderByClause != null" >

      order by ${orderByClause}

    </if>

  </select>

</mapper>

参考博客：

1，mybatis三剑客之mybatis-generator生成数据对象和时间戳优化 - xyphf的博客 - CSDN博客
https://blog.csdn.net/xyphf/article/details/81229636

最新文章

  1. 进击的Python【第一章】：Python背景初探与Python基础(一)
  2. 如果类的属性是copy的NSString类型 用set方法拦截时
  3. Index of my articles
  4. java设计模式—Adapter模式
  5. Polymorphism
  6. nodejs教程
  7. easyui给select控件绑定change事件
  8. PAT乙级1034. 有理数四则运算(20)
  9. Unity3d ShaderLab之WorldNormalVector
  10. Initialize the shader 初始化着色器
  11. git删除文件夹
  12. A1028. List Sorting
  13. Bitmap Byte[] 互转
  14. WAF Bypass数据库特性（Mysql探索篇）
  15. yum第三方安装-软件包没签名及更新错误
  16. laravel 命令行输出进度条
  17. （32位）本体学习程序（ontoEnrich）系统配置说明文档
  18. 20135302魏静静——linux课程第八周实验及总结
  19. Linux和Windows的遍历目录下所有文件的方法对比
  20. MySQL服务停止，无法启动了~

热门文章

  1. 在centos7下安装python3的步骤
  2. python摸爬滚打之day21---- 模块
  3. Mac 启动或者禁用翻盖自动开关机
  4. vue的二维码生成器
  5. swagger：API在线文档自动生成框架
  6. SV class
  7. CentOS 7 系统优化
  8. zw量化交易·实盘操作·系列培训班
  9. 牛客网 完数VS盈数
  10. C/C++ strict-aliasing