easyfk-orm-mybatis MyBatis

<dependency>
    <groupId>com.mcst</groupId>
    <artifactId>orm-mybatis</artifactId>
</dependency>

dependencies {
    implementation 'com.mcst:orm-mybatis'
}

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/mydb?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis-plus:
  mapper-locations: classpath*:mapper/**/*.xml
  configuration:
    map-underscore-to-camel-case: true
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl  # 开发环境打印 SQL
  global-config:
    db-config:
      logic-delete-field: deleted
      logic-delete-value: 1
      logic-not-delete-value: 0

@Data
@TableName("t_order")
@EqualsAndHashCode(callSuper = true)
public class OrderPO extends BaseMyBatisPlusEntity<OrderPO> {

    @TableId(type = IdType.AUTO)
    private Long id;

    private String orderNo;
    private BigDecimal amount;
    private Integer status;

    // 继承字段：insertTime、lastUpdateTime、deleted
}

@Data
@TableName("t_operation_log")
@EqualsAndHashCode(callSuper = true)
public class OperationLogPO extends BaseMyBatisPlusSimpleEntity<OperationLogPO> {

    @TableId(type = IdType.AUTO)
    private Long id;

    private String operationType;
    private String content;

    // 继承字段：insertTime、lastUpdateTime
}

public interface OrderMapper extends BaseMapper<OrderPO> {
}

@Repository
public class OrderRepository extends BaseMyBatisRepositoryImpl<OrderMapper, OrderDTO, OrderPO, Long> {
}

@Resource
private OrderRepository orderRepository;

// 查询全部字段
OrderDTO order = orderRepository.queryById(1L);

// 查询指定字段
OrderDTO order = orderRepository.queryById(1L, "orderNo", "amount", "status");

SearchCondition condition = new SearchCondition();

// 等值条件
Map<String, Object> eqMap = new HashMap<>();
eqMap.put("status", 1);
eqMap.put("userId", 100L);
condition.setEqualsConditions(eqMap);

// 模糊查询
Map<String, String> likeMap = new HashMap<>();
likeMap.put("orderNo", "ORD2024");
condition.setLikeConditions(likeMap);

// 排序
condition.setDescFields(new String[]{"insertTime"});

List<OrderDTO> orders = orderRepository.queryByCondition(condition);

SearchCondition condition = new SearchCondition();

List<RangeCondition> ranges = new ArrayList<>();
ranges.add(new RangeCondition("amount", RangeConditionType.GreaterThan, 100, null));
ranges.add(new RangeCondition("insertTime", RangeConditionType.Between, "2024-01-01", "2024-12-31"));
condition.setRangeConditions(ranges);

List<OrderDTO> orders = orderRepository.queryByCondition(condition);

SearchCondition condition = new SearchCondition();

Map<String, List<?>> inMap = new HashMap<>();
inMap.put("status", List.of(1, 2, 3));
condition.setInConditions(inMap);

List<OrderDTO> orders = orderRepository.queryByCondition(condition);

SearchCondition condition = new SearchCondition();
condition.setPageSearch(new PageSearch(1, 20));
condition.setDescFields(new String[]{"insertTime"});

PageResult<OrderDTO> pageResult = orderRepository.queryByPage(condition);
long total = pageResult.getTotal();
List<OrderDTO> rows = pageResult.getRows();

// 插入
OrderDTO order = new OrderDTO();
order.setOrderNo("ORD_001");
order.setAmount(new BigDecimal("99.99"));
order.setStatus(0);
orderRepository.insert(order);

// 插入并返回主键
Long id = orderRepository.insertAndReturnId(order);

// 批量插入（使用 MyBatis-Plus saveBatch）
List<OrderDTO> orders = List.of(order1, order2, order3);
orderRepository.insertBatch(orders);

// 选择性更新
OrderDTO updateDTO = new OrderDTO();
updateDTO.setId(1L);
updateDTO.setStatus(2);
orderRepository.updateBySelective(updateDTO);

// 选择性更新 + 指定置空字段
orderRepository.updateBySelective(updateDTO, "remark", "memo");

// 保存或更新
orderRepository.saveOrUpdateBySelective(order);

// 单个删除
orderRepository.deleteById(1L);

// 批量删除（逗号分隔）
orderRepository.deleteById("1,2,3");

// 批量删除（集合）
orderRepository.deleteById(List.of(1L, 2L, 3L));

// 按条件删除
SearchCondition condition = new SearchCondition();
condition.setEqualsConditions(Map.of("status", 0));
orderRepository.deleteByCondition(condition);

// Lambda 查询
List<OrderPO> list = orderRepository.lambdaQuery()
    .eq(OrderPO::getStatus, 1)
    .ge(OrderPO::getAmount, 100)
    .orderByDesc(OrderPO::getInsertTime)
    .list();

// Lambda 更新
orderRepository.lambdaUpdate()
    .set(OrderPO::getStatus, 2)
    .eq(OrderPO::getId, 1L)
    .update();

// 批量保存（分批提交）
orderRepository.saveBatch(poList, 500);

com.mcst.easyfk.service.mybatisplus
├── ApplicationStarter.java                    # 启动入口（集成 Mapper 扫描）
├── MybatisPlusServiceScanner.java             # Mapper 包扫描配置
├── annotation
│   └── Column.java                            # 字段注解
├── config
│   └── MybatisPlusConfigure.java              # 自动配置（分页/防攻击/填充/数据库类型识别）
├── handler
│   └── AutoSetValueHandler.java               # MetaObjectHandler 自动填充
├── impl
│   └── BaseMyBatisRepositoryImpl.java         # IBaseRepository + ServiceImpl 实现
├── persistence
│   ├── BaseMyBatisPlusEntity.java             # 实体基类（完整版：时间 + 逻辑删除）
│   └── BaseMyBatisPlusSimpleEntity.java       # 实体基类（简化版：仅时间）
└── util
    ├── EqualConditionUtil.java                # 等值条件构建
    ├── InConditionUtil.java                   # IN 条件构建
    ├── LikeConditionUtil.java                 # 模糊查询条件构建
    ├── MyBatisPlusWrapperUtil.java            # QueryWrapper 核心构建器
    ├── MybatisPlusUtil.java                   # 通用工具（ID 查询/删除/分页/保存更新）
    ├── NullConditionUtil.java                 # NULL 条件构建
    └── RangeConditionUtil.java                # 区间条件构建