江苏龙网

  1. 主页 > 生活百科 > >

Mybatis代码生成器Mybatis-Generator使用详解( 七 )

Mybatis-Gene

纯注解使用纯注解需要引入mybatis-dynamic-sql：
<dependency><groupId>org.mybatis.dynamic-sql</groupId><artifactId>mybatis-dynamic-sql</artifactId><version>1.1.4</version></dependency>需要修改两个位置：
<context id="default" targetRuntime="MyBatis3DynamicSql">...<javaClientGenerator type="ANNOTATEDMAPPER"...运行结果会生成三个类：
// club.throwable.entitypublic class Order {@Generated("org.mybatis.generator.api.MyBatisGenerator")private Long id;@Generated("org.mybatis.generator.api.MyBatisGenerator")private String orderId;@Generated("org.mybatis.generator.api.MyBatisGenerator")private Date createTime;@Generated("org.mybatis.generator.api.MyBatisGenerator")private BigDecimal amount;@Generated("org.mybatis.generator.api.MyBatisGenerator")private Byte orderStatus;@Generated("org.mybatis.generator.api.MyBatisGenerator")public Long getId() {return id;}@Generated("org.mybatis.generator.api.MyBatisGenerator")public void setId(Long id) {this.id = id;}@Generated("org.mybatis.generator.api.MyBatisGenerator")public String getOrderId() {return orderId;}@Generated("org.mybatis.generator.api.MyBatisGenerator")public void setOrderId(String orderId) {this.orderId = orderId;}@Generated("org.mybatis.generator.api.MyBatisGenerator")public Date getCreateTime() {return createTime;}@Generated("org.mybatis.generator.api.MyBatisGenerator")public void setCreateTime(Date createTime) {this.createTime = createTime;}@Generated("org.mybatis.generator.api.MyBatisGenerator")public BigDecimal getAmount() {return amount;}@Generated("org.mybatis.generator.api.MyBatisGenerator")public void setAmount(BigDecimal amount) {this.amount = amount;}@Generated("org.mybatis.generator.api.MyBatisGenerator")public Byte getOrderStatus() {return orderStatus;}@Generated("org.mybatis.generator.api.MyBatisGenerator")public void setOrderStatus(Byte orderStatus) {this.orderStatus = orderStatus;}}// club.throwable.daopublic final class OrderDynamicSqlSupport {@Generated("org.mybatis.generator.api.MyBatisGenerator")public static final Order order = new Order();@Generated("org.mybatis.generator.api.MyBatisGenerator")public static final SqlColumn<Long> id = order.id;@Generated("org.mybatis.generator.api.MyBatisGenerator")public static final SqlColumn<String> orderId = order.orderId;@Generated("org.mybatis.generator.api.MyBatisGenerator")public static final SqlColumn<Date> createTime = order.createTime;@Generated("org.mybatis.generator.api.MyBatisGenerator")public static final SqlColumn<BigDecimal> amount = order.amount;@Generated("org.mybatis.generator.api.MyBatisGenerator")public static final SqlColumn<Byte> orderStatus = order.orderStatus;@Generated("org.mybatis.generator.api.MyBatisGenerator")public static final class Order extends SqlTable {public final SqlColumn<Long> id = column("id", JDBCType.BIGINT);public final SqlColumn<String> orderId = column("order_id", JDBCType.VARCHAR);public final SqlColumn<Date> createTime = column("create_time", JDBCType.TIMESTAMP);public final SqlColumn<BigDecimal> amount = column("amount", JDBCType.DECIMAL);public final SqlColumn<Byte> orderStatus = column("order_status", JDBCType.TINYINT);public Order() {super("t_order");}}}@Mapperpublic interface OrderMapper {@Generated("org.mybatis.generator.api.MyBatisGenerator")BasicColumn[] selectList = BasicColumn.columnList(id, orderId, createTime, amount, orderStatus);@Generated("org.mybatis.generator.api.MyBatisGenerator")@SelectProvider(type=SqlProviderAdapter.class, method="select")long count(SelectStatementProvider selectStatement);@Generated("org.mybatis.generator.api.MyBatisGenerator")@DeleteProvider(type=SqlProviderAdapter.class, method="delete")int delete(DeleteStatementProvider deleteStatement);@Generated("org.mybatis.generator.api.MyBatisGenerator")@InsertProvider(type=SqlProviderAdapter.class, method="insert")@SelectKey(statement="SELECT LAST_INSERT_ID()", keyProperty="record.id", before=true, resultType=Long.class)int insert(InsertStatementProvider<Order> insertStatement);@Generated("org.mybatis.generator.api.MyBatisGenerator")@SelectProvider(type=SqlProviderAdapter.class, method="select")@Results(id="OrderResult", value = https://www.isolves.com/it/cxkf/kj/2021-08-12/{@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)})Optional


推荐阅读


上一篇：数据库简述与常用操作指南

下一篇：紫薇树修剪,长寿花这样修剪