public class BaseInsertTemplate extends MapperTemplate
context, mapperClass| 构造器和说明 |
|---|
BaseInsertTemplate(java.lang.Class<?> mapperClass,
TemplateContext mapperResolver) |
| 限定符和类型 | 方法和说明 |
|---|---|
java.lang.String |
insert(org.apache.ibatis.mapping.MappedStatement ms)
插入全部,这段代码比较复杂,这里举个例子
CountryU生成的insert方法结构如下:
<bind name="countryname_bind" value='@java.util.UUID@randomUUID().toString().replace("-", "")'/>
INSERT INTO country_u(id,countryname,countrycode) VALUES
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id !
|
java.lang.String |
insertList(org.apache.ibatis.mapping.MappedStatement ms)
批量插入
|
java.lang.String |
insertListFromMySql(org.apache.ibatis.mapping.MappedStatement ms) |
java.lang.String |
insertListFromOracle(org.apache.ibatis.mapping.MappedStatement ms) |
java.lang.String |
insertSelective(org.apache.ibatis.mapping.MappedStatement ms)
插入不为null的字段,这段代码比较复杂,这里举个例子
CountryU生成的insertSelective方法结构如下:
<bind name="countryname_bind" value='@java.util.UUID@randomUUID().toString().replace("-", "")'/>
INSERT INTO country_u
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id !
|
java.lang.String |
insertUseGeneratedKeys(org.apache.ibatis.mapping.MappedStatement ms)
插入,主键id,自增
|
addMethodMap, createSqlSource, dynamicSQL, getConfig, getDialectType, getEntityClass, getIdentity, getSeqNextVal, setResultType, setSqlSource, setSqlSource, supportMethod, tableName, tableNamepublic BaseInsertTemplate(java.lang.Class<?> mapperClass,
TemplateContext mapperResolver)
public java.lang.String insert(org.apache.ibatis.mapping.MappedStatement ms)
<bind name="countryname_bind" value='@java.util.UUID@randomUUID().toString().replace("-", "")'/>
INSERT INTO country_u(id,countryname,countrycode) VALUES
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">#{id,javaType=java.lang.Integer},</if>
<if test="id == null">#{id,javaType=java.lang.Integer},</if>
<if test="countryname != null">#{countryname,javaType=java.lang.String},</if>
<if test="countryname == null">#{countryname_bind,javaType=java.lang.String},</if>
<if test="countrycode != null">#{countrycode,javaType=java.lang.String},</if>
<if test="countrycode == null">#{countrycode,javaType=java.lang.String},</if>
</trim>
ms - 映射申明public java.lang.String insertSelective(org.apache.ibatis.mapping.MappedStatement ms)
<bind name="countryname_bind" value='@java.util.UUID@randomUUID().toString().replace("-", "")'/>
INSERT INTO country_u
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
countryname,
<if test="countrycode != null">countrycode,</if>
</trim>
VALUES
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">#{id,javaType=java.lang.Integer},</if>
<if test="countryname != null">#{countryname,javaType=java.lang.String},</if>
<if test="countryname == null">#{countryname_bind,javaType=java.lang.String},</if>
<if test="countrycode != null">#{countrycode,javaType=java.lang.String},</if>
</trim>
这段代码可以注意对countryname的处理ms - 映射申明public java.lang.String insertList(org.apache.ibatis.mapping.MappedStatement ms)
ms - 映射申明public java.lang.String insertListFromOracle(org.apache.ibatis.mapping.MappedStatement ms)
public java.lang.String insertListFromMySql(org.apache.ibatis.mapping.MappedStatement ms)
public java.lang.String insertUseGeneratedKeys(org.apache.ibatis.mapping.MappedStatement ms)
ms - 映射申明Copyright © 2019. All Rights Reserved.