mybatis系列总结

最新推荐文章于 2023-06-03 19:20:22 发布

liyang_com

最新推荐文章于 2023-06-03 19:20:22 发布

阅读量586

点赞数

mybatis 简介

Hibernate是当前最流行的 O/R mapping框架。mybatis 是一种"Sql Mapping"的ORM实现。
Hibernate对数据库结构提供较为完整的封装，实现POJO和数据库表之间的映射，以及SQL的自动生成和执行。只需定义好POJO到数据库表的映射关系，即可通过 Hibernate 提供的方法完成持久层操作。甚至不需要对SQL的熟练掌握，Hibernate/OJB会根据制定的存储逻辑，自动生成对应的 SQL并调用JDBC接口加以执行。
mybatis的着力点，则在于POJO与SQL之间的映射关系。iBATIS并不会在运行期自动生成SQL执行。具体的SQL需要程序员编写，然后通过映射配置文件，将SQL所需的参数，以及返回的结果字段映射到指定POJO。使用mybatis提供的ORM机制，对业务逻辑实现人员而言，面对的是纯粹的Java对象，这一层与通过Hibernate 实现ORM而言基本一致，而对于具体的数据操作，Hibernate会自动生成SQL语句。相对 Hibernate而言，mybatis以SQL开发的工作量和数据库移植性上的让步，为系统设计提供更大的自由空间。

mybatis 与 hibernate 区别

mybatis 简单易学，轻量；Hibernate相对较复杂，门槛较高，设计O/R映射，在性能和对象模型之间如何权衡取得平衡。Hibernate功能强大，数据库无关性好，O/R映射能力强。
当系统属于二次开发，无法对数据库结构做到控制和修改，那mybatis的灵活性将比Hibernate更适合。
系统数据处理量巨大，性能要求极为苛刻，这往往意味着必须通过经过高度优化的SQL语句（或存储过程）才能达到系统性能设计指标。在这种情况下mybatis会有更好的可控性和表现。mybatis比Hibernate更容易进行sql的优化。鉴于一般系统性能的瓶颈都在数据库上，所以这一点是mybatis非常重要的一个优势。
mybatis 需要手写sql语句，也可以生成，Hibernate则基本上可以自动生成，偶尔会写一些Hql。同样的需求，mybatis 的工作量比Hibernate要大很多。类似的，如果涉及到数据库字段的修改，Hibernate修改的地方很少，而mybatis 要把那些sql mapping的地方一一修改。
运行效率：在不考虑cache的情况下，mybatis 应该会比hibernate快一些或者很多（根据实际情况会有所不同）。

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘blah’ at row 1

mybatis + MySQL 存储数据时遇到上面的报错，第一反应是去检查数据库表的DDL语句，以及查看待执行的 SQL 语句，但是两者都没有问题。最后才发现 mybatis 的 mapper.xml 文件里面的需要严格对应起来，即顺序。

 <insert id="insert" parameterType="SomePO">
    INSERT INTO order_data (
      DemandOrderId, OrderFromWeight, OtherRequirementWeight, InterceptWeight)
    VALUES  (
      #{po.demandOrderId},
      #{po.orderFromWeight},
      #{po.interceptWeight},
      #{po.otherRequirementWeight})
</insert>

   
   
   
   1
2
3
4
5
6
7
8
9

比如上面的sampleMapper.xml 文件的写法有问题，

mybatis mapper xml 特殊符号转义写法

&lt;          <   小于
&lt;=         <=   小于或等于
&gt;          >    大于
&gt;=        >=    大于或等于
&lt;&gt;   <>   不等于
&amp;      & 
&apos;      '
&quot;      "

   
   1
2
3
4
5
6
7
8

也可以使用<[CDATA[ ]]>符号进行说明，将此类符号不进行解析，比如写 < > = 等：
<![CDATA[ 这里写你的sql ]]>
MySQL like的写法
like concat('%',#{param},'%') 或者 like '%${param}%'，推荐使用前者，可以避免SQL注入。

Mybatis 模糊查询 MySQL 中记录的三种常用方法

以MySQL数据库为例（不同的数据库，有些可能不支持）
常用的模糊查询有三种方法:

直接使用 % 拼接字符串，如'%'#{name}'%'或"%"#{name}"%"，单引号或双引号都可以。
使用concat（str1,str2）函数拼接
使用mybatis的bind标签

示例：在userMapper.xml文件中新建映射sql的标签：

<!-- 模糊查询的常用的3种方式 -->
<select id="getUsersByFuzzyQuery" parameterType="User" resultType="User">
    select <include refid="columns"/> from users
    <where>
        <!--
            方法一: 直接使用 % 拼接字符串 
            注意:此处不能写成  "%#{name}%" ,#{name}就成字符串的一部分,
            会发生这样一个异常: The error occurred while setting parameters,
            应该写成: "%"#{name}"%",即#{name}是一个整体,前后加上%
        -->
        <if test="name != null">
            name like "%"#{name}"%"
        </if>
        <!--方法二: 使用concat(str1,str2)函数将两个参数连接 -->
        <if test="phone != null">
            and phone like concat(concat("%",#{phone}),"%")
        </if>
        <!--方法三: 使用 bind 标签，对字符串进行绑定，然后对绑定后的字符串使用 like 关键字进行模糊查询 -->
        <if test="email != null">
            <bind name="pattern" value="'%'+email+'%'"/>
            and email like #{pattern}
        </if>
    </where>
</select>

   
   
   
   1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

java.lang.IllegalArgumentException: Result Maps collection already contains value for *

常规的SSM应用启动失败，报错：

Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.RuntimeException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for GeographyMapper.getByCode.

   
   1

定位原因是在 mybatis 的 mapper.xml 文件里面有重复的 id 定义。

<!-- 按code码得到一个对象-->  
<select id="getByCode" resultType="Geography"  
    parameterType="java.lang.String">  
    select * from Geography where code = ${code}  
</select>

<!-- 按地名getByName得到一个对象–>
<select id=“getByCode” resultType=“Geography”
parameterType=“java.lang.String”>
select * from Geography where fullName = ${fullName}
</select>

The entity name must immediately follow the ‘&’ in the entity reference

mybatis 解析不了&&，mapper.xml 文件如下：

<update id="update" parameterType="Geography">  
    update Geography  
    <trim prefix="set" suffixOverrides=",">  
        <if test="code != null && code !=''">  
            code=#{code},  
        </if>  
        <if test="name != null && name != ''">  
            name=#{name},  
        </if>  
    </trim>  
    where id= #{id}  
</update>

 
 
 
 1
2
3
4
5
6
7
8
9
10
11
12

解决方法：使用正确的语法，用and替换&&

@Param注解

当你使用@Param注解来声明参数时，如果使用 #{} 或 ${} 的方式都可以。
不使用@Param注解来声明参数时，必须使用使用 #{}方式。使用 ${} 的方式，会报错：org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'day' in 'class java.lang.String'

@Select("select column from table where userid = #{userid} ")
public int selectColumn(int userid);

 
 1
2

那么#{}和${}有什么区别呢？
#{} 表示一个占位符，通过 #{} 可以实现preparedStatement 向占位符中设置值，自动进行java 类型和 JDBC 类型转换；${}将传入的数据直接显示生成在sql中。#{} 可以有效防止 SQL 注入。

Mybatis 传递多个参数的几种方式

方法1：顺序传参法
public User selectUser(String name, int deptId);

<select id="selectUser" resultMap="UserResultMap">
    select * from user
    where user_name = #{0} and dept_id = #{1}
</select>

 
 
 
 1
2
3
4

#{}里面的数字代表你传入参数的顺序。
不建议使用，1. 参考上文，只能使用#{}，且易导致SQL 注入；2. 顺序需要严格控制；3. 参数过大，影响阅读代码，不符合编码规范。

方法2：@Param注解传参法
public User selectUser(@Param("name") String name, @Param("deptId") int deptId);
略，有效防止 SQL 注入，但是仅仅推荐在参数不多的情况使用。

方法3：Java Bean传参法
public User selectUser(Map<String, Object> params);

<select id="selectUser" parameterType="com.johnny.demo.domain.User" resultMap="UserResultMap">
    select * from user
    where user_name = #{User.userName} and dept_id = #{User.deptId}
</select>

 
 
 
 1
2
3
4

#{}里面的名称对应的是 User类里面的成员属性。直观。

方法4：Map 传参法
public User selectUser(Map<String, Object> params);

<select id="selectUser" parameterType="java.util.Map" resultMap="UserResultMap">
    select * from user
    where user_name = #{userName} and dept_id = #{deptId}
</select>

 
 
 
 1
2
3
4

#{}里面的名称对应的是 Map里面的key名称。
这种方法适合传递多个参数，且参数易变能灵活传递的情况。但是 HashMap 的 key 存在 hard code 的问题。

批量更新以及单个更新

实现批量更新on duplicate key UPDATE ：

<insert id="duplicateUpdate" parameterType="User">
    insert into user(id, uid, name, certificate_type, certificate_no, from_app_name, mobile, mobile_id_md5)
    VALUES
    <foreach collection="list" item="user" separator=",">
        (#{user.id}, #{user.uid}, #{user.name}, #{user.certificateType}, #{user.certificateNo},#{user.fromAppName}, #{user.mobile}, #{user.mobileAndCertificateNoMD5})
    </foreach>
    on duplicate key UPDATE
    id = VALUES (id)
</insert>

 
 
 
 1
2
3
4
5
6
7
8
9

单个记录的更新on duplicate key UPDATE：

<update id="insertUpdate" parameterType="User">
insert into user(id, uid, name, certificate_type, certificate_no, from_app_name, mobile, mobile_id_md5)
VALUES
(#{id}, #{uid},#{name}, #{certificateType}, #{certificateNo}, #{fromAppName}, #{mobile}, #{mobileAndCertificateNoMD5})
on duplicate key UPDATE
id =  VALUES (id)
</update>

 
 
 
 1
2
3
4
5
6
7

generatorConfig

使用 mybatis-generator 步骤：

pom.xml 文件新增配置：

<!--mybatis-generator-->
<plugin>
    <groupId>org.mybatis.generator</groupId>
    <artifactId>mybatis-generator-maven-plugin</artifactId>
    <version>1.3.7</version>
    <configuration>
        <!--配置文件路径-->
        <configurationFile>${basedir}/src/main/resources/mybatis/generatorConfig.xml</configurationFile>
        <!--打印日志-->
        <verbose>true</verbose>
        <!--覆盖存在的文件-->
        <overwrite>true</overwrite>
    </configuration>
</plugin>

 
 
 
 1
2
3
4
5
6
7
8
9
10
11
12
13
14

新增 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>
    <!--导入属性配置 -->
    <!--<properties url="file:///mybatisGenerator/generator.properties"></properties>-->
<span class="token comment">&lt;!--指定特定数据库的jdbc驱动jar包的位置 --&gt;</span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>classPathEntry</span> <span class="token attr-name">location</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>mysql-connector-java-5.1.45-bin.jar<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>

<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>context</span> <span class="token attr-name">id</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>default<span class="token punctuation">"</span></span> <span class="token attr-name">targetRuntime</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>MyBatis3<span class="token punctuation">"</span></span><span class="token punctuation">&gt;</span></span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>beginningDelimiter<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>`<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>endingDelimiter<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>`<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>
    <span class="token comment">&lt;!-- optional，旨在创建class时，对注释进行控制 --&gt;</span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>commentGenerator</span><span class="token punctuation">&gt;</span></span>
        <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>suppressDate<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>true<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>
        <span class="token comment">&lt;!-- This property is used to specify whether MBG will include any coments in the generated code --&gt;</span>
        <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>suppressAllComments<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>false<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>commentGenerator</span><span class="token punctuation">&gt;</span></span>

    <span class="token comment">&lt;!--jdbc的数据库连接 --&gt;</span>
    <span class="token comment">&lt;!--&lt;jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/seq"--&gt;</span>
    <span class="token comment">&lt;!--userId="root" password=""&gt;--&gt;</span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>jdbcConnection</span> <span class="token attr-name">driverClass</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>com.mysql.jdbc.Driver<span class="token punctuation">"</span></span>
                    <span class="token attr-name">connectionURL</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>jdbc:mysql://&lt;prod_hostname&gt;:3306/&lt;app_name&gt;?useUnicode=true<span class="token entity" title="&amp;">&amp;amp;</span>characterEncoding=UTF-8<span class="token punctuation">"</span></span>
                    <span class="token attr-name">userId</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>me<span class="token punctuation">"</span></span> <span class="token attr-name">password</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>myPass<span class="token punctuation">"</span></span><span class="token punctuation">&gt;</span></span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>jdbcConnection</span><span class="token punctuation">&gt;</span></span>

    <span class="token comment">&lt;!-- 非必需，类型处理器，在数据库类型和java类型之间的转换控制--&gt;</span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>javaTypeResolver</span><span class="token punctuation">&gt;</span></span>
        <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>forceBigDecimals<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>false<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>javaTypeResolver</span><span class="token punctuation">&gt;</span></span>

    <span class="token comment">&lt;!-- Model模型生成器,用来生成含有主键key的类，记录类 以及查询Example类
        targetPackage     指定生成的model生成所在的包名
        targetProject     指定在该项目下所在的路径--&gt;</span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>javaModelGenerator</span> <span class="token attr-name">targetPackage</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>com.johnny.onlinemall.domain<span class="token punctuation">"</span></span> <span class="token attr-name">targetProject</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>../src/main/java<span class="token punctuation">"</span></span><span class="token punctuation">&gt;</span></span>
        <span class="token comment">&lt;!-- 是否对model添加构造函数 --&gt;</span>
        <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>constructorBased<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>false<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>

        <span class="token comment">&lt;!-- 是否允许子包，即targetPackage.schemaName.tableName --&gt;</span>
        <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>enableSubPackages<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>false<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>

        <span class="token comment">&lt;!-- 建立的Model对象是否不可改变,即生成的Model对象不会有 setter方法，只有构造方法 --&gt;</span>
        <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>immutable<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>false<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>

        <span class="token comment">&lt;!-- 给Model添加一个父类 --&gt;</span>

        <span class="token comment">&lt;!-- 是否对类CHAR类型的列的数据进行trim操作 --&gt;</span>
        <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>trimStrings<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>true<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>javaModelGenerator</span><span class="token punctuation">&gt;</span></span>

    <span class="token comment">&lt;!--Mapper映射文件生成所在的目录 为每一个数据库的表生成对应的SqlMap文件 --&gt;</span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>sqlMapGenerator</span> <span class="token attr-name">targetPackage</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>com.johnny.onlinemall.mapper<span class="token punctuation">"</span></span> <span class="token attr-name">targetProject</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>../src/main/resources<span class="token punctuation">"</span></span><span class="token punctuation">&gt;</span></span>
        <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>enableSubPackages<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>false<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>sqlMapGenerator</span><span class="token punctuation">&gt;</span></span>

    <span class="token comment">&lt;!-- 客户端代码，生成易于使用的针对Model对象和XML配置文件 的代码
            type="ANNOTATEDMAPPER",生成Java Model 和基于注解的Mapper对象
            type="MIXEDMAPPER",生成基于注解的Java Model 和相应的Mapper对象
            type="XMLMAPPER",生成SQLMap XML文件和独立的Mapper接口--&gt;</span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>javaClientGenerator</span> <span class="token attr-name">targetPackage</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>com.johnny.onlinemall.mapper<span class="token punctuation">"</span></span> <span class="token attr-name">targetProject</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>../src/main/java<span class="token punctuation">"</span></span> <span class="token attr-name">type</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>MIXEDMAPPER<span class="token punctuation">"</span></span><span class="token punctuation">&gt;</span></span>
        <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>enableSubPackages<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span><span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>
        <span class="token comment">&lt;!-- 定义Maper.java 源代码中的ByExample() 方法的可视性，可选的值有：public;private;protected;default;注意：如果 targetRuntime="MyBatis3",此参数被忽略--&gt;</span>
        <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>exampleMethodVisibility<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span><span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>
<span class="token comment">&lt;!--方法名计数器 Important note: this property is ignored if the target runtime is MyBatis3. --&gt;</span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>methodNameCalculator<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span><span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>

        <span class="token comment">&lt;!-- 为生成的接口添加父接口 --&gt;</span>
        <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>property</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>rootInterface<span class="token punctuation">"</span></span> <span class="token attr-name">value</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span><span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>

    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>javaClientGenerator</span><span class="token punctuation">&gt;</span></span>

    <span class="token comment">&lt;!--_column防止字段名和数据库关键字一样--&gt;</span>
    <span class="token comment">&lt;!--&lt;table tableName="margin_balance"  domainObjectName="MarginBalance"&gt;&lt;/table&gt;--&gt;</span>
    <span class="token comment">&lt;!--&amp;lt;!&amp;ndash;防止表名和数据库关键字一样&amp;ndash;&amp;gt;--&gt;</span>
    <span class="token comment">&lt;!--&lt;property name="runtimeTableName" value="`column`"&gt;&lt;/property&gt;--&gt;</span>
    <span class="token comment">&lt;!--&amp;lt;!&amp;ndash;&lt;/table&gt;&amp;ndash;&amp;gt;--&gt;</span>
    <span class="token comment">&lt;!-- optional   , only for mybatis3 runtime
         自动生成的键值（identity,或者序列值）
       如果指定此元素，MBG将会生成&lt;selectKey&gt;元素，然后将此元素插入到SQL Map的&lt;insert&gt; 元素之中
       sqlStatement 的语句将会返回新的值
       如果是一个自增主键的话，你可以使用预定义的语句,或者添加自定义的SQL语句. 预定义的值如下:
          Cloudscape    This will translate to: VALUES IDENTITY_VAL_LOCAL()
          DB2:      VALUES IDENTITY_VAL_LOCAL()
          DB2_MF:       SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1
          Derby:        VALUES IDENTITY_VAL_LOCAL()
          HSQLDB:   CALL IDENTITY()
          Informix:     select dbinfo('sqlca.sqlerrd1') from systables where tabid=1
          MySql:        SELECT LAST_INSERT_ID()
          SqlServer:    SELECT SCOPE_IDENTITY()
          SYBASE:   SELECT @@IDENTITY
          JDBC:     This will configure MBG to generate code for MyBatis3 suport of JDBC standard generated keys. This is a database independent method of obtaining the value from identity columns. identity: 自增主键  If true, then the column is flagged as an identity column and the generated &lt;selectKey&gt; element will be placed after the insert (for an identity column). If false, then the generated &lt;selectKey&gt; will be placed before the insert (typically for a sequence).--&gt;</span>
    <span class="token comment">&lt;!--&lt;generatedKey column="" sqlStatement="" identity="" type=""/&gt;--&gt;</span>
    <span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>table</span> <span class="token attr-name">tableName</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>trans_log<span class="token punctuation">"</span></span> <span class="token attr-name">delimitIdentifiers</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>true<span class="token punctuation">"</span></span> <span class="token attr-name">delimitAllColumns</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>true<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span>
    <span class="token comment">&lt;!-- optional.
            列的命名规则：
            MBG使用 &lt;columnRenamingRule&gt; 元素在计算列名的对应 名称之前，先对列名进行重命名，
            作用：一般需要对BUSI_CLIENT_NO 前的BUSI_进行过滤，支持正则表达式
         searchString 表示要被换掉的字符串，replaceString 则是要换成的字符串，默认情况下为空字符串，可选 --&gt;</span>
    <span class="token comment">&lt;!--&lt;columnRenamingRule searchString="" replaceString=""/&gt;--&gt;</span>

    <span class="token comment">&lt;!-- optional.告诉 MBG 忽略某一列，column，需要忽略的列；delimitedColumnName:true ,匹配column的值和数据库列的名称 大小写完全匹配，false 忽略大小写匹配;是否限定表的列名，即固定表列在Model中的名称--&gt;</span>
    <span class="token comment">&lt;!--&lt;ignoreColumn column="PLAN_ID" delimitedColumnName="true"/&gt;--&gt;</span>

    <span class="token comment">&lt;!--optional.覆盖MBG对Model 的生成规则
         column: 数据库的列名
         javaType: 对应的Java数据类型的完全限定名
         在必要的时候可以覆盖由JavaTypeResolver计算得到的java数据类型. For some databases, this is necessary to handle "odd" database types (e.g. MySql's unsigned bigint type should be mapped to java.lang.Object).
         jdbcType:该列的JDBC数据类型(INTEGER, DECIMAL, NUMERIC, VARCHAR, etc.)，该列可以覆盖由JavaTypeResolver计算得到的Jdbc类型，对某些数据库而言，对于处理特定的JDBC 驱动癖好 很有必要(e.g. DB2's LONGVARCHAR type should be mapped to VARCHAR for iBATIS).
         typeHandler: --&gt;</span>
    <span class="token comment">&lt;!--&lt;columnOverride column="" javaType="" jdbcType="" typeHandler="" delimitedColumnName=""/&gt;--&gt;</span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>context</span><span class="token punctuation">&gt;</span></span>

</generatorConfiguration>

命令行：mvn mybatis-generator:generate -e，-e参数是为了输出错误信息，方便排查问题。看到“BUILD SUCCESS”表示成功生成。

        </div>
					<link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-778f64ae39.css" rel="stylesheet">
            </div>

liyang_com

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
mybatis系列总结

mybatis 简介Hibernate是当前最流行的 O/R mapping框架。mybatis 是一种"Sql Mapping"的ORM实现。Hibernate对数据库结构提供较为完整的封装，实现POJO和数据库表之间的映射，以及SQL的自动生成和执行。只需定义好POJO到数据库表的映射关系，即可通过 ...
复制链接

扫一扫