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>
推荐阅读
-
外星人|人类起源的另类解释,这个神秘女人的故事,彻底颠覆了人们的三观
-
北京|北京线上线下生鲜供应基本稳定,市民无需紧张囤菜
-
小弟车评:连跌7万,迷倒一片,这才是年轻人想要的“撩妹车”
-
首选好助手|网络营销的简单分类你知道吗?,「首选好商家」互联网时代
-
-
-
乔欣|讲解扑克牌怎么从背面看出,普通扑克认牌器,无需复杂
-
-
-
昆仑基地|对中国军力“开刀”,真当解放军是摆设?,特朗普又想联合俄罗斯
-
-
-
明星照片|11岁背着父母出道,被富豪狂追10年嫁入豪门,如今被宠成公主
-
-
吴孟达|吴孟达遗作将上映,扫黑题材令网友关注,秦海璐王劲松共同加盟
-
酱油的存在|但最终成了你们眼中的坑,王者荣耀之其实我也不想坑
-
-
穿搭|简约宽松白衬衫搭配浅色超短裙,时尚精致,又仙又美
-
生活侣行社|越企濒临倒闭,如今想让我国接盘?,为巴结美国抵制中国产品
-
『走在城长的旅途』放假回来她进家门就送上了一个香吻!,幽默笑话:和媳妇异地