springboot使用mybatis plus总会涉及手写mapper，这么难用为啥还这么多人用?

# Django的写法，优雅如诗 User.objects.filter(age__gt=18).order_by('-create_time')

// MyBatis Plus的写法，像在写SQL @Select("SELECT * FROM user WHERE age > #{age} ORDER BY create_time DESC") List<User> getAdultUsers(@Param("age") Integer age);

// 自定义SQL，性能自己说了算 @Select("SELECT id, name FROM user WHERE age > #{age} AND city = #{city}") List<User> getUsers(Integer age, String city);

SELECT ... FROM ... LEFT JOIN ... LEFT JOIN ... -- 明明只想要两个字段，结果查了整张表

// 复杂统计场景 @Select(""" SELECT dept_id, COUNT(*) as count, AVG(salary) as avg_salary FROM employee e LEFT JOIN department d ON e.dept_id = d.id WHERE e.status = 1 GROUP BY dept_id HAVING COUNT(*) > 10 """) List<DeptStats> getDeptStats();

// 增删改查都不用写了 public interface UserMapper extends BaseMapper<User> { } // 一行代码搞定复杂查询 userMapper.selectList( new QueryWrapper<User>() .gt("age", 18) .like("name", "张") .orderByDesc("create_time") );

// 不用写任何SQL userMapper.insert(user); userMapper.deleteById(1L);

QueryWrapper<User> wrapper = new QueryWrapper<>(); wrapper.select("id", "name", "age") // 指定字段 .gt("age", 18) .orderByDesc("create_time");

@Select("你的复杂SQL") List<DTO> getComplexData();