纯注解使用纯注解需要引入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
推荐阅读
-
-
茵曼老方▲茵曼老方空降淘宝直播间,2小时带货125万!
-
「宋雨琦」网爆宋雨琦退出跑男录制和baby有关,得知真实原因:你不来更好!
-
-
-
『长打王中国』从药店走出的世界高尔夫长打王“恐怖”统治者
-
-
星座听语|心在跳,情在烧,重逢旧爱,坦诚表达,对你执着到底,9月下旬
-
-
-
幽默搞笑段子集锦|累得半死回到家,发现老公居然在玩游戏,幽默笑话:昨晚加班
-
「真心」服务区睡了一晚,下高速时却被罚款,车主:想睡,但真
-
魔术气球如何制作帽子,魔术气球制作之 如何制作手枪
-
-
福田汽车|中国乘用车市场进一步复苏;宁德时代加速全球扩张;特斯拉宣布股票一拆五计划
-
-
王晓晨|娱记曝女星王晓晨被知名导演灌酒,遭上下其手,女方霸气反抗!
-
『万茜回应周深』周深称不认识万茜引发热议 万茜回应周深
-
-
「驱动之家」小米有品上架海底捞自煮火锅:8种口味 不用电、不用火