selectOne(SelectStatementProvider selectStatement);@Generated("org.mybatis.generator.api.MyBatisGenerator")@SelectProvider(type=SqlProviderAdapter.class, method="select")@Results(id="OrderResult", value = {@Result(column="id", property="id", jdbcType=JdbcType.BIGINT, id=true),@Result(column="order_id", property="orderId", jdbcType=JdbcType.VARCHAR),@Result(column="create_time", property="createTime", jdbcType=JdbcType.TIMESTAMP),@Result(column="amount", property="amount", jdbcType=JdbcType.DECIMAL),@Result(column="order_status", property="orderStatus", jdbcType=JdbcType.TINYINT)})List selectMany(SelectStatementProvider selectStatement);@Generated("org.mybatis.generator.api.MyBatisGenerator")@UpdateProvider(type=SqlProviderAdapter.class, method="update")int update(UpdateStatementProvider updateStatement);@Generated("org.mybatis.generator.api.MyBatisGenerator")default long count(CountDSLCompleter completer) {return MyBatis3Utils.countFrom(this::count, order, completer);}@Generated("org.mybatis.generator.api.MyBatisGenerator")default int delete(DeleteDSLCompleter completer) {return MyBatis3Utils.deleteFrom(this::delete, order, completer);}@Generated("org.mybatis.generator.api.MyBatisGenerator")default int deleteByPrimaryKey(Long id_) {return delete(c ->c.where(id, isEqualTo(id_)));}@Generated("org.mybatis.generator.api.MyBatisGenerator")default int insert(Order record) {return MyBatis3Utils.insert(this::insert, record, order, c ->c.map(id).toProperty("id").map(orderId).toProperty("orderId").map(createTime).toProperty("createTime").map(amount).toProperty("amount").map(orderStatus).toProperty("orderStatus"));}@Generated("org.mybatis.generator.api.MyBatisGenerator")default int insertSelective(Order record) {return MyBatis3Utils.insert(this::insert, record, order, c ->c.map(id).toProperty("id").map(orderId).toPropertyWhenPresent("orderId", record::getOrderId).map(createTime).toPropertyWhenPresent("createTime", record::getCreateTime).map(amount).toPropertyWhenPresent("amount", record::getAmount).map(orderStatus).toPropertyWhenPresent("orderStatus", record::getOrderStatus));}@Generated("org.mybatis.generator.api.MyBatisGenerator")default Optional selectOne(SelectDSLCompleter completer) {return MyBatis3Utils.selectOne(this::selectOne, selectList, order, completer);}@Generated("org.mybatis.generator.api.MyBatisGenerator")default List select(SelectDSLCompleter completer) {return MyBatis3Utils.selectList(this::selectMany, selectList, order, completer);}@Generated("org.mybatis.generator.api.MyBatisGenerator")default List selectDistinct(SelectDSLCompleter completer) {return MyBatis3Utils.selectDistinct(this::selectMany, selectList, order, completer);}@Generated("org.mybatis.generator.api.MyBatisGenerator")default Optional selectByPrimaryKey(Long id_) {return selectOne(c ->c.where(id, isEqualTo(id_)));}@Generated("org.mybatis.generator.api.MyBatisGenerator")default int update(UpdateDSLCompleter completer) {return MyBatis3Utils.update(this::update, order, completer);}@Generated("org.mybatis.generator.api.MyBatisGenerator")static UpdateDSL updateAllColumns(Order record, UpdateDSL dsl) {return dsl.set(id).equalTo(record::getId).set(orderId).equalTo(record::getOrderId).set(createTime).equalTo(record::getCreateTime).set(amount).equalTo(record::getAmount).set(orderStatus).equalTo(record::getOrderStatus);}@Generated("org.mybatis.generator.api.MyBatisGenerator")static UpdateDSL updateSelectiveColumns(Order record, UpdateDSL dsl) {return dsl.set(id).equalToWhenPresent(record::getId).set(orderId).equalToWhenPresent(record::getOrderId).set(createTime).equalToWhenPresent(record::getCreateTime).set(amount).equalToWhenPresent(record::getAmount).set(orderStatus).equalToWhenPresent(record::getOrderStatus);}@Generated("org.mybatis.generator.api.MyBatisGenerator")default int updateByPrimaryKey(Order record) {return update(c ->c.set(orderId).equalTo(record::getOrderId).set(createTime).equalTo(record::getCreateTime).set(amount).equalTo(record::getAmount).set(orderStatus).equalTo(record::getOrderStatus).where(id, isEqualTo(record::getId)));}@Generated("org.mybatis.generator.api.MyBatisGenerator")default int updateByPrimaryKeySelective(Order record) {return update(c ->c.set(orderId).equalToWhenPresent(record::getOrderId).set(createTime).equalToWhenPresent(record::getCreateTime).set(amount).equalToWhenPresent(record::getAmount).set(orderStatus).equalToWhenPresent(record::getOrderStatus).where(id, isEqualTo(record::getId)));}}极简XML映射文件极简XML映射文件生成只需要简单修改配置文件:
<context id="default" targetRuntime="MyBatis3Simple">...<javaClientGenerator type="XMLMAPPER"...生成三个文件:
// club.throwable.entitypublic class Order {private Long id;private String orderId;private Date createTime;private BigDecimal amount;private Byte orderStatus;public Long getId() {return id;}public void setId(Long id) {this.id = id;}public String getOrderId() {return orderId;}public void setOrderId(String orderId) {this.orderId = orderId;}public Date getCreateTime() {return createTime;}public void setCreateTime(Date createTime) {this.createTime = createTime;}public BigDecimal getAmount() {return amount;}public void setAmount(BigDecimal amount) {this.amount = amount;}public Byte getOrderStatus() {return orderStatus;}public void setOrderStatus(Byte orderStatus) {this.orderStatus = orderStatus;}}// club.throwable.daopublic interface OrderMapper {int deleteByPrimaryKey(Long id);int insert(Order record);Order selectByPrimaryKey(Long id);List<Order> selectAll();int updateByPrimaryKey(Order record);}// mappings<?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="club.throwable.dao.OrderMapper"><resultMap id="BaseResultMap" type="club.throwable.entity.Order"><id column="id" jdbcType="BIGINT" property="id"/><result column="order_id" jdbcType="VARCHAR" property="orderId"/><result column="create_time" jdbcType="TIMESTAMP" property="createTime"/><result column="amount" jdbcType="DECIMAL" property="amount"/><result column="order_status" jdbcType="TINYINT" property="orderStatus"/></resultMap><delete id="deleteByPrimaryKey" parameterType="java.lang.Long">deletefrom t_orderwhere id = #{id,jdbcType=BIGINT}</delete><insert id="insert" parameterType="club.throwable.entity.Order"><selectKey keyProperty="id" order="AFTER" resultType="java.lang.Long">SELECT LAST_INSERT_ID()</selectKey>insert into t_order (order_id, create_time, amount,order_status)values (#{orderId,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, #{amount,jdbcType=DECIMAL},#{orderStatus,jdbcType=TINYINT})</insert><update id="updateByPrimaryKey" parameterType="club.throwable.entity.Order">update t_orderset order_id= #{orderId,jdbcType=VARCHAR},create_time= #{createTime,jdbcType=TIMESTAMP},amount= #{amount,jdbcType=DECIMAL},order_status = #{orderStatus,jdbcType=TINYINT}where id = #{id,jdbcType=BIGINT}</update><select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">select id, order_id, create_time, amount, order_statusfrom t_orderwhere id = #{id,jdbcType=BIGINT}</select><select id="selectAll" resultMap="BaseResultMap">select id, order_id, create_time, amount, order_statusfrom t_order</select><resultMap id="BaseResultMap" type="club.throwable.entity.Order"><id column="id" jdbcType="BIGINT" property="id"/><result column="order_id" jdbcType="VARCHAR" property="orderId"/><result column="create_time" jdbcType="TIMESTAMP" property="createTime"/><result column="amount" jdbcType="DECIMAL" property="amount"/><result column="order_status" jdbcType="TINYINT" property="orderStatus"/></resultMap><delete id="deleteByPrimaryKey" parameterType="java.lang.Long">deletefrom t_orderwhere id = #{id,jdbcType=BIGINT}</delete><insert id="insert" parameterType="club.throwable.entity.Order"><selectKey keyProperty="id" order="BEFORE" resultType="java.lang.Long">SELECT LAST_INSERT_ID()</selectKey>insert into t_order (id, order_id, create_time,amount, order_status)values (#{id,jdbcType=BIGINT}, #{orderId,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP},#{amount,jdbcType=DECIMAL}, #{orderStatus,jdbcType=TINYINT})</insert><update id="updateByPrimaryKey" parameterType="club.throwable.entity.Order">update t_orderset order_id= #{orderId,jdbcType=VARCHAR},create_time= #{createTime,jdbcType=TIMESTAMP},amount= #{amount,jdbcType=DECIMAL},order_status = #{orderStatus,jdbcType=TINYINT}where id = #{id,jdbcType=BIGINT}</update><select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">select id, order_id, create_time, amount, order_statusfrom t_orderwhere id = #{id,jdbcType=BIGINT}</select><select id="selectAll" resultMap="BaseResultMap">select id, order_id, create_time, amount, order_statusfrom t_order</select></mapper>
推荐阅读
-
清朝|康熙和乾隆谁是真正的千古一帝?御前侍卫的亲身经历给出答案
-
-
穿越火线|穿越火线《雪山突袭》发生的事情,这个版本或许说服力更高
-
-
「肿瘤专科医生」是否预示着到晚期了呢?,食管癌患者吃东西会反流
-
芜湖新闻网|芜湖繁昌县连续10年居全省第1位,人均GDP10w+
-
全景|全民狂欢影业发布系列战略合作 打出影视作品全景发展组合拳
-
车市进言▲顶配锐际和低配冒险家怎么选?,鸡头凤尾之争
-
顾拜蛋蛋|1080P,年轻人第一款便携投影仪来了,小巧机身+长续航
-
卡莉时尚:为什么气场170?除了会穿,练瑜伽也有很大关系,只有162的王子文
-
中国日报|多久了,还在说“甩锅中国”那一套!美国白宫顾问遭群嘲,被骂上了热搜......
-
消失|农村正在消失的老物件,城里人大多数没见过,有的价值十几万
-
-
-
隽北少爷|G2教练发推调侃,韩服第一也被峡谷打服了!DWG中单峡谷之巅五连败
-
年报|*ST皇台:更新2017年报,2017年年度净利润约-1.18亿元,同比增加28.49%
-
-
美食的眷恋■私房菜:红烧冬瓜,香辣蛤蜊,黑椒杏鲍菇牛肉粒,干锅虾
-
馨馨娱乐看|52岁后该何去何从?家有属猴的速看,致1968年“生肖猴”最终宿命
-
「堂小堂」哈弗F7怎么样?“全球神车”屹立世界潮头