MyBatis简单使用

╰+攻爆jí腚メ 2023-01-16 11:15 96阅读 0赞

# MyBatis概述 #

MyBatis 是一款优秀的持久层框架，是一个半ORM框架，它支持自定义 SQL、存储过程以及高级映射。MyBatis 免除了几乎所有的 JDBC 代码以及设置参数和获取结果集的工作。MyBatis 可以通过简单的 XML 或注解来配置和映射原始类型、接口和 Java POJO（Plain Old Java Objects，普通老式 Java 对象）为数据库中的记录。

# MyBatis基础用法 #

pom.xml中引入相应的依赖包

<dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.0</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.11</version>
    </dependency>

MyBatis配置文件**mybatis-config.xml**

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    
        <properties resource="db.properties"></properties>
        <settings>
            
            <setting name="logImpl" value="STDOUT_LOGGING" />
    
            
            <setting name="cacheEnabled" value="true"/>
    
            
            <setting name="lazyLoadingEnabled" value="true"/>
            
            <setting name="aggressiveLazyLoading" value="false"/>
            
            
            
            
            <setting name="localCacheScope" value="SESSION"/>
        </settings>
    
        <typeAliases>
            
            <package name="com.lucifer.mybatis.domain"/>
        </typeAliases>
    
        
        <typeHandlers>
            <typeHandler handler="com.lucifer.mybatis.type.MyTypeHandler" jdbcType="VARCHAR" javaType="String"></typeHandler>
            
        </typeHandlers>
    
        
        <objectFactory type="com.lucifer.mybatis.objectfactory.GpObjectFactory">
            <property name="gupao" value="666"/>
        </objectFactory>
    
       <plugins>
    
           
           
           <plugin interceptor="com.github.pagehelper.PageHelper">
               <property name="dialect" value="mysql" />
               
               
               
               <property name="offsetAsPageNum" value="true" />
               
               
               <property name="rowBoundsWithCount" value="true" />
               
               
               <property name="pageSizeZero" value="true" />
               
               
               
               <property name="reasonable" value="false" />
               
               
               
               
               <property name="params" value="pageNum=start;pageSize=limit;" />
               
               <property name="returnPageInfo" value="check" />
           </plugin>
        </plugins>
    
        <environments default="development">
            <environment id="development">
                <transactionManager type="JDBC"/>
                <dataSource type="POOLED">
                    <property name="driver" value="${jdbc.driver}"/>
                    <property name="url" value="${jdbc.url}"/>
                    <property name="username" value="${jdbc.username}"/>
                    <property name="password" value="${jdbc.password}"/>
                </dataSource>
            </environment>
        </environments>
    
        <mappers>
            <mapper resource="mapper/UserMapper.xml"/>
        </mappers>
    
    </configuration>

数据库信息配置文件**db.properties**

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/mybatisdb?characterEncoding=utf-8&serverTimezone=UTC
    jdbc.username=root
    jdbc.password=123456

实体对象

@Data
    public class User implements Serializable {
        private Integer id;
        private String userName;
        private String realName;
        private String password;
        private Integer age;
        private Integer dId;
        private Dept dept;
    }

Mapper类

public interface UserMapper {
    
        public List<User> selectUserList();
    
        public User selectUserById(Integer id);
    
        public Integer insertUser(User user);
    
        public Integer insertUserList(List<User> list);
    
        public Integer updateUserList(List<User> list);
    
        public List<User> queryUserNested();
    
        public List<User> queryUserNestedLazy();
    
        public List<Dept> queryDeptNested();
    
        public List<User> queryUserList(RowBounds rowBounds);
    }

配置User对象对应SQL的xml文件**UserMapper.xml**

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.lucifer.mybatis.mapper.UserMapper">
    
      <resultMap id="BaseResultMap" type="user">
        <id property="id" column="id" jdbcType="INTEGER"/>
        <result property="userName" column="user_name" jdbcType="VARCHAR" />
        <result property="realName" column="real_name" jdbcType="VARCHAR" />
        <result property="password" column="password" jdbcType="VARCHAR"/>
        <result property="age" column="age" jdbcType="INTEGER"/>
        <result property="dId" column="d_id" jdbcType="INTEGER"/>
      </resultMap>
    
        <sql id="baseSQL">
            id,user_name,real_name,password,age,d_id
        </sql>
    
      <select id="selectUserById" resultType="user" statementType="PREPARED"  >
            select
             id,
             user_name userName,
             real_name realName,
             password,
             age,
             d_id
             from t_user where id = #{id}
        </select>
    
      
      <select id="selectUserByBean"  parameterType="user" resultMap="BaseResultMap" >
            select * from t_user where user_name = '${userName}'
        </select>
    
      <select id="selectUserList" resultMap="BaseResultMap" >
            select * from t_user
        </select>
    
        <select id="queryUserList" resultMap="BaseResultMap" >
            select * from t_user
        </select>
    
        <insert id="insertUser" parameterType="user">
            insert into t_user(user_name,real_name)values(#{userName},#{realName})
        </insert>
    
        
        <insert id="insertUserList" parameterType="java.util.List" >
            insert into t_user(user_name,real_name)
            values
            <foreach collection="list" item="user" separator=",">
                (#{user.userName},#{user.realName})
            </foreach>
    
        </insert>
    
        <update id="updateUserList">
         update t_user set
            user_name =
            <foreach collection="list" item="user" index="index" separator=" " open="case id" close="end">
            when #{user.id} then #{user.userName}
            </foreach>
             ,real_name =
             <foreach collection="list" item="user" index="index" separator=" " open="case id" close="end">
              when #{user.id} then #{user.realName}
             </foreach>
             where id in
             <foreach collection="list" item="item" open="(" separator="," close=")">
              #{item.id,jdbcType=INTEGER}
             </foreach>
         </update>
    
        <delete id="deleteByList" parameterType="java.util.List">
             delete from t_user where id in
             
            <foreach collection="list" item="item" open="(" separator="," close=")">
                #{item.id,jdbcType=INTEGER}
            </foreach>
        </delete>
    
    
        
        <select id="selectListIf" parameterType="user" resultMap="BaseResultMap" >
            select
                <include refid="baseSQL"></include>
            from t_user
            <where>
                <if test="id != null">
                    and id = #{id}
                </if>
                <if test="userName != null">
                    and user_name = #{userName}
                </if>
            </where>
        </select>
    
        
        <select id="selectListChoose" parameterType="user" resultMap="BaseResultMap" >
            select
            <include refid="baseSQL"></include>
            from t_user
            <where>
                <choose>
                    <when test="id != null">
                        id = #{id}
                    </when>
                    <when test="userName != null and userName != ''">
                        and user_name like CONCAT(CONCAT('%',#{userName,jdbcType=VARCHAR}),'%')
                    </when>
                    <otherwise>
    
                    </otherwise>
                </choose>
            </where>
        </select>
    
        
        <select id="selectListTrim" resultMap="BaseResultMap"
                parameterType="user">
            select <include refid="baseSQL"></include>
            
            <trim prefix="where" prefixOverrides="AND |OR ">
                <if test="userName!=null">
                    and user_name = #{userName}
                </if>
                <if test="age != 0">
                    and age = #{age}
                </if>
            </trim>
        </select>
    
        
        <update id="updateUser" parameterType="User">
            update t_user
            <trim prefix="set" suffixOverrides=",">
                <if test="userName!=null">
                    user_name = #{userName},
                </if>
                <if test="age != 0">
                    age = #{age}
                </if>
            </trim>
            where id=#{id}
        </update>
    
    
    
        
        <resultMap id="nestedMap1" type="user">
            <id property="id" column="id" jdbcType="INTEGER"/>
            <result property="userName" column="user_name" jdbcType="VARCHAR" />
            <result property="realName" column="real_name" jdbcType="VARCHAR" />
            <result property="password" column="password" jdbcType="VARCHAR"/>
            <result property="age" column="age" jdbcType="INTEGER"/>
            <result property="dId" column="d_id" jdbcType="INTEGER"/>
            <association property="dept" javaType="dept">
                <id column="did" property="dId"/>
                <result column="d_name" property="dName"/>
                <result column="d_desc" property="dDesc"/>
            </association>
        </resultMap>
    
        <select id="queryUserNested" resultMap="nestedMap1">
            SELECT
                t1.`id`
                ,t1.`user_name`
                ,t1.`real_name`
                ,t1.`password`
                ,t1.`age`
                ,t2.`did`
                ,t2.`d_name`
                ,t2.`d_desc`
            FROM t_user t1
            LEFT JOIN
                t_department t2
                ON t1.`d_id` = t2.`did`
        </select>
    
        
        <resultMap id="nestedMap1Lazy" type="user">
            <id property="id" column="id" jdbcType="INTEGER"/>
            <result property="userName" column="user_name" jdbcType="VARCHAR" />
            <result property="realName" column="real_name" jdbcType="VARCHAR" />
            <result property="password" column="password" jdbcType="VARCHAR"/>
            <result property="age" column="age" jdbcType="INTEGER"/>
            <result property="dId" column="d_id" jdbcType="INTEGER"/>
            <association property="dept" javaType="dept" column="d_id" select="queryDeptByUserIdLazy">
    
            </association>
        </resultMap>
        <resultMap id="baseDept" type="dept">
            <id column="did" property="dId"/>
            <result column="d_name" property="dName"/>
            <result column="d_desc" property="dDesc"/>
        </resultMap>
        <select id="queryUserNestedLazy" resultMap="nestedMap1Lazy">
            SELECT
                t1.`id`
                ,t1.`user_name`
                ,t1.`real_name`
                ,t1.`password`
                ,t1.`age`
                ,t1.d_id
            FROM t_user t1
        </select>
        <select id="queryDeptByUserIdLazy" parameterType="int" resultMap="baseDept">
            select * from t_department where did = #{did}
        </select>
    
        
        <resultMap id="nestedMap2" type="dept">
            <id column="did" property="dId"/>
            <result column="d_name" property="dName"/>
            <result column="d_desc" property="dDesc"/>
            <collection property="users" ofType="user">
                <id property="id" column="id" jdbcType="INTEGER"/>
                <result property="userName" column="user_name" jdbcType="VARCHAR" />
                <result property="realName" column="real_name" jdbcType="VARCHAR" />
                <result property="password" column="password" jdbcType="VARCHAR"/>
                <result property="age" column="age" jdbcType="INTEGER"/>
                <result property="dId" column="d_id" jdbcType="INTEGER"/>
            </collection>
        </resultMap>
        <select id="queryDeptNested" resultMap="nestedMap2">
            SELECT
                t1.`id`
                ,t1.`user_name`
                ,t1.`real_name`
                ,t1.`password`
                ,t1.`age`
                ,t2.`did`
                ,t2.`d_name`
                ,t2.`d_desc`
            FROM t_user t1
            RIGHT JOIN
                t_department t2
                ON t1.`d_id` = t2.`did`
        </select>
    
        
        <resultMap id="nestedMap2Lazy" type="dept">
            <id column="did" property="dId"/>
            <result column="d_name" property="dName"/>
            <result column="d_desc" property="dDesc"/>
            <collection property="users" ofType="user" column="did" select="queryUserByDeptLazy">
            </collection>
        </resultMap>
    
        <select id="queryDeptNestedLazy" resultMap="nestedMap2">
            SELECT
                ,t2.`did`
                ,t2.`d_name`
                ,t2.`d_desc`
            FROM
                t_department t2
    
        </select>
    
        <select id="queryUserByDeptLazy"  resultMap="BaseResultMap" >
            select * from t_user where d_id = #{did}
        </select>
    
    </mapper>

调用

public class Test01 {
        public SqlSession session;
    
        public void init() throws IOException {
            // 1.获取配置文件
            InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
            // 2.加载解析配置文件并获取SqlSessionFactory对象
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
            // 3.根据SqlSessionFactory对象获取SqlSession对象
            session = factory.openSession();
        }
    
        @Test
        public void test01() throws Exception{
            init();
            // 4.通过代理对象MapperProxyFactory来操作数据库
            UserMapperExt mapper = session.getMapper(UserMapperExt.class);
            List<User> users = mapper.selectUserByName("zhangsan");
            for (User user : users) {
                System.out.println(user.getId() + "" + user.getUserName() + " " + user.getRealName());
            }
            // 5.关闭会话
            session.close();
        }
    
        @Test
        public void test02() throws  Exception{
            // 4.通过SqlSession中提供的 API方法来操作数据库
            List<User> list = sqlSession.selectList("com.lucifer.mybatis.mapper.UserMapper.selectUserList");
            for (User user : list) {
                System.out.println(user);
            }
            // 5.关闭会话
            sqlSession.close();
        }
    }

# MyBatis-generator #

可自动生成数据库表表对应的实体类和映射文件

在pom.xml中引入mybatis-generator对应jar包

<build>
        <plugins>
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                    <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
                </configuration>
            </plugin>
        </plugins>
    </build>

配置**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="C:\Users\dpb\.m2\repository\mysql\mysql-connector-java\8.0.11\mysql-connector-java-8.0.11.jar" />
    
        <context id="DB2Tables" targetRuntime="MyBatis3">
            
            <commentGenerator>
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/mybatisdb?characterEncoding=utf-8&serverTimezone=UTC"
                            userId="root"
                            password="123456">
                <property name="nullCatalogMeansCurrent" value="true" />
            </jdbcConnection>
            
    
            <javaTypeResolver >
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
            
            <javaModelGenerator targetPackage="com.lucifer.mybatis.domain" targetProject="./src/main/java">
                
                <property name="enableSubPackages" value="false" />
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="com.lucifer.mybatis.mapper"  targetProject="./src/main/java">
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.lucifer.mybatis.mapper"  targetProject="./src/main/java">
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
    
            <table  tableName="t_user" domainObjectName="User"   />
        </context>
    </generatorConfiguration>

针对已经生成的对象和映射文件，如果需要新加方法，可以添加新的Mapper，并extends原有Mapper，减少对生成Mapper的改动

public interface UserMapperExt extends UserMapper {
        public List<User> selectUserByName(String userName);
    }

同时添加对应的xml文件UserMapperExt.xml

# MyBatis高级用法 #

1. 可以继承redis使用redis作为二级缓存

2. 可以自定义ObjectFactory，根据需求重写对象生成工厂

3. 可以自定义TypeHandler去实现JDBC表字段与Java对象属性之间的类型转换

4. MyBatis自带RowBounds逻辑分页，一般开发过程中不会使用，需要使用分页插件实现物理分页

# 工作中复杂映射文件写法 #

<?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.lucifer.mybatis.mapper.UserMapper" >
      <resultMap id="BaseResultMap" type="com.lucifer.mybatis.domain.User" >
        <id column="id" property="id" jdbcType="INTEGER" />
        <result column="user_name" property="userName" jdbcType="VARCHAR" />
        <result column="real_name" property="realName" jdbcType="VARCHAR" />
        <result column="password" property="password" jdbcType="VARCHAR" />
        <result column="age" property="age" jdbcType="INTEGER" />
        <result column="d_id" property="dId" jdbcType="INTEGER" />
        <result column="i_id" property="iId" jdbcType="INTEGER" />
      </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, user_name, real_name, password, age, d_id, i_id
      </sql>
      <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.lucifer.mybatis.domain.UserExample" >
        select
        <if test="distinct" >
          distinct
        </if>
        <include refid="Base_Column_List" />
        from t_user
        <if test="_parameter != null" >
          <include refid="Example_Where_Clause" />
        </if>
        <if test="orderByClause != null" >
          order by ${orderByClause}
        </if>
      </select>
      <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
        select 
        <include refid="Base_Column_List" />
        from t_user
        where id = #{id,jdbcType=INTEGER}
      </select>
      <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
        delete from t_user
        where id = #{id,jdbcType=INTEGER}
      </delete>
      <delete id="deleteByExample" parameterType="com.lucifer.mybatis.domain.UserExample" >
        delete from t_user
        <if test="_parameter != null" >
          <include refid="Example_Where_Clause" />
        </if>
      </delete>
      <insert id="insert" parameterType="com.lucifer.mybatis.domain.User" >
        insert into t_user (id, user_name, real_name, 
          password, age, d_id, 
          i_id)
        values (#{id,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR}, #{realName,jdbcType=VARCHAR}, 
          #{password,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER}, #{dId,jdbcType=INTEGER}, 
          #{iId,jdbcType=INTEGER})
      </insert>
      <insert id="insertSelective" parameterType="com.lucifer.mybatis.domain.User" >
        insert into t_user
        <trim prefix="(" suffix=")" suffixOverrides="," >
          <if test="id != null" >
            id,
          </if>
          <if test="userName != null" >
            user_name,
          </if>
          <if test="realName != null" >
            real_name,
          </if>
          <if test="password != null" >
            password,
          </if>
          <if test="age != null" >
            age,
          </if>
          <if test="dId != null" >
            d_id,
          </if>
          <if test="iId != null" >
            i_id,
          </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides="," >
          <if test="id != null" >
            #{id,jdbcType=INTEGER},
          </if>
          <if test="userName != null" >
            #{userName,jdbcType=VARCHAR},
          </if>
          <if test="realName != null" >
            #{realName,jdbcType=VARCHAR},
          </if>
          <if test="password != null" >
            #{password,jdbcType=VARCHAR},
          </if>
          <if test="age != null" >
            #{age,jdbcType=INTEGER},
          </if>
          <if test="dId != null" >
            #{dId,jdbcType=INTEGER},
          </if>
          <if test="iId != null" >
            #{iId,jdbcType=INTEGER},
          </if>
        </trim>
      </insert>
      <select id="countByExample" parameterType="com.lucifer.mybatis.domain.UserExample" resultType="java.lang.Integer" >
        select count(*) from t_user
        <if test="_parameter != null" >
          <include refid="Example_Where_Clause" />
        </if>
      </select>
      <update id="updateByExampleSelective" parameterType="map" >
        update t_user
        <set >
          <if test="record.id != null" >
            id = #{record.id,jdbcType=INTEGER},
          </if>
          <if test="record.userName != null" >
            user_name = #{record.userName,jdbcType=VARCHAR},
          </if>
          <if test="record.realName != null" >
            real_name = #{record.realName,jdbcType=VARCHAR},
          </if>
          <if test="record.password != null" >
            password = #{record.password,jdbcType=VARCHAR},
          </if>
          <if test="record.age != null" >
            age = #{record.age,jdbcType=INTEGER},
          </if>
          <if test="record.dId != null" >
            d_id = #{record.dId,jdbcType=INTEGER},
          </if>
          <if test="record.iId != null" >
            i_id = #{record.iId,jdbcType=INTEGER},
          </if>
        </set>
        <if test="_parameter != null" >
          <include refid="Update_By_Example_Where_Clause" />
        </if>
      </update>
      <update id="updateByExample" parameterType="map" >
        update t_user
        set id = #{record.id,jdbcType=INTEGER},
          user_name = #{record.userName,jdbcType=VARCHAR},
          real_name = #{record.realName,jdbcType=VARCHAR},
          password = #{record.password,jdbcType=VARCHAR},
          age = #{record.age,jdbcType=INTEGER},
          d_id = #{record.dId,jdbcType=INTEGER},
          i_id = #{record.iId,jdbcType=INTEGER}
        <if test="_parameter != null" >
          <include refid="Update_By_Example_Where_Clause" />
        </if>
      </update>
      <update id="updateByPrimaryKeySelective" parameterType="com.lucifer.mybatis.domain.User" >
        update t_user
        <set >
          <if test="userName != null" >
            user_name = #{userName,jdbcType=VARCHAR},
          </if>
          <if test="realName != null" >
            real_name = #{realName,jdbcType=VARCHAR},
          </if>
          <if test="password != null" >
            password = #{password,jdbcType=VARCHAR},
          </if>
          <if test="age != null" >
            age = #{age,jdbcType=INTEGER},
          </if>
          <if test="dId != null" >
            d_id = #{dId,jdbcType=INTEGER},
          </if>
          <if test="iId != null" >
            i_id = #{iId,jdbcType=INTEGER},
          </if>
        </set>
        where id = #{id,jdbcType=INTEGER}
      </update>
      <update id="updateByPrimaryKey" parameterType="com.lucifer.mybatis.domain.User" >
        update t_user
        set user_name = #{userName,jdbcType=VARCHAR},
          real_name = #{realName,jdbcType=VARCHAR},
          password = #{password,jdbcType=VARCHAR},
          age = #{age,jdbcType=INTEGER},
          d_id = #{dId,jdbcType=INTEGER},
          i_id = #{iId,jdbcType=INTEGER}
        where id = #{id,jdbcType=INTEGER}
      </update>
    </mapper>