← 返回首页 ❓ 面试题库
📑 本篇章节导航 (共5章,点击直达)
一、MyBatis核心原理(1-12)二、MyBatis-Plus深入(13-24)三、JPA与Hibernate深入(25-35)四、数据访问层设计(36-42)五、数据层实战与调优(43-50)

Q36 - MyBatis源码与ORM深入


一、MyBatis核心原理(1-12)

MyBatis的架构分层?

★★★★★

MyBatis的初始化流程?

★★★★

MyBatis的SQL执行流程?

★★★★★

MyBatis的一级缓存和二级缓存?

★★★★★

MyBatis的插件(Interceptor)机制?

★★★★★


@Intercepts({
    @Signature(type = Executor.class, method = "query", 
               args = {MappedStatement.class, Object.class, RowBounds.class, ResultHandler.class})
})
public class SlowSqlInterceptor implements Interceptor {
    @Override
    public Object intercept(Invocation invocation) throws Throwable {
        long start = System.currentTimeMillis();
        Object result = invocation.proceed();
        long cost = System.currentTimeMillis() - start;
        if (cost > 1000) log.warn("慢SQL: {}ms", cost);
        return result;
    }
}

MyBatis的动态SQL原理?

★★★★

MyBatis的结果集映射原理?

★★★★

MyBatis的Mapper接口绑定原理?

★★★★★

MyBatis的TypeHandler?

★★★★


@MappedTypes(MyEnum.class)
@MappedJdbcTypes(JdbcType.INTEGER)
public class EnumTypeHandler extends BaseTypeHandler<MyEnum> {
    @Override
    public void setNonNullParameter(PreparedStatement ps, int i, MyEnum param, JdbcType type) {
        ps.setInt(i, param.getCode());
    }
    @Override
    public MyEnum getNullableResult(ResultSet rs, String columnName) {
        return MyEnum.fromCode(rs.getInt(columnName));
    }
}

MyBatis的事务管理?

★★★

MyBatis与Hibernate/JPA的对比?

★★★★

MyBatis的Configuration核心配置?

★★★


二、MyBatis-Plus深入(13-24)

MyBatis-Plus的核心增强?

★★★★★

MyBatis-Plus的条件构造器?

★★★★


// LambdaQueryWrapper(推荐,类型安全)
LambdaQueryWrapper<User> wrapper = new LambdaQueryWrapper<>();
wrapper.eq(User::getStatus, 1)
       .like(User::getUsername, "张")
       .between(User::getAge, 18, 35)
       .orderByDesc(User::getCreateTime)
       .last("LIMIT 10");
List<User> users = userMapper.selectList(wrapper);

// 动态条件
wrapper.eq(StringUtils.hasText(name), User::getUsername, name)
       .ge(minAge != null, User::getAge, minAge);

MyBatis-Plus的分页原理?

★★★★★


@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
    MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
    interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
    return interceptor;
}

Page<User> page = new Page<>(1, 10); // 第1页,每页10条
userMapper.selectPage(page, wrapper);
page.getRecords(); // 数据列表
page.getTotal();   // 总记录数

MyBatis-Plus的自动填充?

★★★★


@TableField(fill = FieldFill.INSERT)
private LocalDateTime createTime;

@TableField(fill = FieldFill.INSERT_UPDATE)
private LocalDateTime updateTime;

@Component
public class AutoFillHandler implements MetaObjectHandler {
    @Override
    public void insertFill(MetaObject metaObject) {
        this.strictInsertFill(metaObject, "createTime", LocalDateTime::now, LocalDateTime.class);
    }
    @Override
    public void updateFill(MetaObject metaObject) {
        this.strictUpdateFill(metaObject, "updateTime", LocalDateTime::now, LocalDateTime.class);
    }
}

MyBatis-Plus的逻辑删除?

★★★★


@TableLogic
private Integer deleted;

MyBatis-Plus的乐观锁?

★★★★


@Version
private Integer version;

User user = userMapper.selectById(1L); // version=1
user.setName("newName");
userMapper.updateById(user); // UPDATE user SET name='newName', version=2 WHERE id=1 AND version=1

MyBatis-Plus的多租户?

★★★★


@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
    interceptor.addInnerInterceptor(new TenantLineInnerInterceptor(
        () -> new LongValue(TenantContext.getTenantId())));
}

MyBatis-Plus的SQL注入器?

★★★


public class InsertBatchMethod extends AbstractMethod {
    @Override
    public MappedStatement injectMappedStatement(Class<?> mapperClass, TableInfo tableInfo) {
        String sql = "INSERT INTO " + tableInfo.getTableName() + " (...) VALUES (...)";
        return addInsertMappedStatement(mapperClass, tableInfo, "insertBatch", sqlSource, mapperType);
    }
}

MyBatis-Plus的枚举处理?

★★★


public enum UserStatus {
    ACTIVE(1, "正常"), DISABLED(0, "禁用");
    @EnumValue
    private final int code;
    private final String desc;
}

MyBatis-Plus的字段类型处理器?

★★★


@TableField(typeHandler = JacksonTypeHandler.class)
private List<String> tags;

MyBatis-Plus的代码生成器?

★★★★


FastAutoGenerator.create("jdbc:mysql://localhost:3306/mydb", "root", "password")
    .globalConfig(builder -> builder.outputDir("src/main/java"))
    .packageConfig(builder -> builder.parent("com.example").moduleName("system"))
    .strategyConfig(builder -> builder
        .addInclude("sys_user", "sys_role")
        .entityBuilder().enableLombok().enableTableFieldAnnotation()
        .controllerBuilder().enableRestStyle())
    .execute();

MyBatis-Plus的动态表名?

★★★


 interceptor.addInnerInterceptor(new DynamicTableNameInnerInterceptor());
 // 使用时
 TableNameContext.set("orders_202601");
 userMapper.selectList(wrapper);

三、JPA与Hibernate深入(25-35)

JPA的核心概念?

★★★★

JPA的N+1问题?

★★★★★


@EntityGraph(attributePaths = {"user"})
List<Order> findAll();

JPA的延迟加载和FetchType?

★★★★

JPA的JPQL和Criteria API?

★★★★


@Query("SELECT o FROM Order o WHERE o.user.id = :userId AND o.status = :status")
List<Order> findByUserAndStatus(@Param("userId") Long userId, @Param("status") OrderStatus status);

CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Order> cq = cb.createQuery(Order.class);
Root<Order> root = cq.from(Order.class);
cq.where(cb.equal(root.get("userId"), userId), cb.ge(root.get("amount"), minAmount));

JPA的审计功能(Auditing)?

★★★


@EntityListeners(AuditingEntityListener.class)
@Entity
public class BaseEntity {
    @CreatedDate private LocalDateTime createdAt;
    @LastModifiedDate private LocalDateTime updatedAt;
    @CreatedBy private String createdBy;
}

Spring Data JPA的Specification?

★★★★


public class OrderSpecs {
    public static Specification<Order> userIdEq(Long userId) {
        return (root, query, cb) -> cb.equal(root.get("userId"), userId);
    }
    public static Specification<Order> statusIn(List<Status> statuses) {
        return (root, query, cb) -> root.get("status").in(statuses);
    }
}
// 使用
repository.findAll(where(userIdEq(1L)).and(statusIn(Arrays.asList(Status.ACTIVE))));

Hibernate的性能优化?

★★★★


@Query("SELECT new com.example.dto.OrderDTO(o.id, o.amount, u.name) FROM Order o JOIN o.user u")
List<OrderDTO> findOrderDTOs();

Flyway/Liquibase数据库迁移?

★★★★

JPA的继承映射策略?

★★★

JPA的乐观锁?

★★★★


@Version
private Long version;

JPA vs MyBatis-Plus的选型?

★★★★★

维度MyBatis-PlusJPA/Hibernate
SQL控制完全控制,手写SQL自动生成,复杂场景需调优
学习曲线低(会SQL即可)高(需理解实体状态/缓存)
动态查询QueryWrapper简单直观Specification/Criteria复杂
性能调优直接优化SQL需理解Hibernate机制(N+1等)
多表关联手动resultMap@OneToMany自动管理
国内使用90%+主流外企/部分新项目

四、数据访问层设计(36-42)

多数据源怎么配置?

★★★★


@DS("slave")
public List<User> listUsers() { return userMapper.selectList(null); }

@DS("master")
public void saveUser(User user) { userMapper.insert(user); }

读写分离方案?

★★★★

分库分表方案?

★★★★★


sharding:
  tables:
    t_order:
      actual-data-nodes: ds0.t_order_${0..99}
      table-strategy:
        standard:
          sharding-column: user_id
          sharding-algorithm: t-order-inline
          props:
            algorithm-expression: t_order_${user_id % 100}

跨分片查询怎么处理?

★★★★

分布式ID生成方案?

★★★★★

数据访问层的设计模式?

★★★★

Spring Data的统一数据访问层?

★★★★


五、数据层实战与调优(43-50)

MyBatis的慢SQL诊断?

★★★★

批量操作的性能优化?

★★★★★


<insert id="batchInsert">
    INSERT INTO user (name, age) VALUES
    <foreach collection="list" item="item" separator=",">
        (#{item.name}, #{item.age})
    </foreach>
</insert>

大数据量查询的流式读取?

★★★★


try (SqlSession session = sqlSessionFactory.openSession()) {
    session.select("selectAll", resultContext -> {
        // 每次处理一行,不全部加载到内存
        process(resultContext.getResultObject());
    });
}

连接池的配置和调优?

★★★★


spring:
  datasource:
    hikari:
      maximum-pool-size: 20
      minimum-idle: 5
      idle-timeout: 600000
      max-lifetime: 1800000
      connection-timeout: 30000

MyBatis与Spring的整合原理?

★★★★

数据库连接泄露怎么排查?

★★★★

MyBatis的XML和注解SQL的选择?

★★★★

ORM框架的未来趋势?

★★★★