fastmybatis 2.8.1 发布，支持JPA Query Method查询

fastmybatis 2.8.1 发布，本次更新内如下：

• 新增JPA Query Method查询

 /** * … where x.lastname = ?1 and x.firstname = ?2 * @param lastname * @param firstname * @return */ List<Student> findByLastnameAndFirstname(String lastname, String firstname);

  @Test public void findByLastnameAndFirstname() { List<Student> users = mapper.findByLastnameAndFirstname("张", "三"); Assert.assertEquals(1, users.size()); users.forEach(System.out::println); }

完整测试用例：

  /** * 演示JPA findBy查询，根据方法名称自动生成查询语句，无需编写SQL * @author tanghc */ public interface StudentMapper extends CrudMapper<Student, Integer> { /** * … where x.lastname = ?1 and x.firstname = ?2 * @param lastname * @param firstname * @return */ List<Student> findByLastnameAndFirstname(String lastname, String firstname); /** * * … where x.lastname = ?1 or x.firstname = ?2 * @param lastname * @param firstname * @return */ List<Student> findByLastnameOrFirstname(String lastname, String firstname); /** * where x.firstname = ? * @param firstname * @return */ List<Student> findByFirstname(String firstname); List<Student> findByFirstnameIs(String firstname); List<Student> findByFirstnameEquals(String firstname); /** * … where x.startDate between ?1 and ?2 * @param begin * @param end * @return */ List<Student> findByStartDateBetween(Date begin, Date end); /** * … where x.age < ?1 * @param age * @return */ List<Student> findByAgeLessThan(int age); /** * … where x.age <= ?1 * @param age * @return */ List<Student> findByAgeLessThanEqual(int age); /** * … where x.age > ?1 * @param age * @return */ List<Student> findByAgeGreaterThan(int age); /** * … where x.age >= ?1 * @param age * @return */ List<Student> findByAgeGreaterThanEqual(int age); /** * … where x.startDate > ?1 * @param date * @return */ List<Student> findByStartDateAfter(Date date); /** * … where x.startDate < ?1 * @param date * @return */ List<Student> findByStartDateBefore(Date date); /** * … where x.age is null * @return */ List<Student> findByAgeNull(); List<Student> findByAgeIsNull(); /** * … where x.firstname like ?1 * @param firstname * @return * @see #findByFirstnameContaining(String) */ List<Student> findByFirstnameLike(String firstname); /** * … where x.firstname not like ?1 * @param firstname * @return */ List<Student> findByFirstnameNotLike(String firstname); /** * … where x.firstname like 'xx%' * @param firstname * @return */ List<Student> findByFirstnameStartingWith(String firstname); /** * … where x.firstname like '%xx' * @param firstname * @return */ List<Student> findByFirstnameEndingWith(String firstname); /** * 等同于like * … where x.firstname like '%xx%' * @param firstname * @return */ List<Student> findByFirstnameContaining(String firstname); /** * … where x.age = ?1 order by x.lastname desc * @param age * @return */ List<Student> findByAgeOrderByLastnameDesc(int age); /** * … where x.lastname <> ?1 * @param lastname * @return */ List<Student> findByLastnameNot(String lastname); /** * … where x.age in ?1 * * @param ages * @return */ List<Student> findByAgeIn(Collection<Integer> ages); /** * … where x.age not in ?1 * * @param ages * @return */ List<Student> findByAgeNotIn(Collection<Integer> ages); List<Student> findByAgeNotInAndIdIn(Collection<Integer> ages, List<Integer> ids); /** * … where x.active = 1 * @return */ List<Student> findByActiveTrue(); /** * … where x.active = 0 * @return */ List<Student> findByActiveFalse(); /** * … where UPPER(x.firstname) = UPPER(?1) * @param firstname * @return */ List<Student> findByFirstnameIgnoreCase(String firstname); // 复杂的例子 List<Student> findByLastnameOrFirstnameAndIdBetweenOrderByAgeDescIdAsc(String lastname, String firstname, int id1, int id2); }

JPA查询使用注意事项：

• 方法名称必须findBy开头
• 数据库字段名必须遵从下划线模式，如：name, add_time，驼峰命名方式不支持JPA查询

关于fastmybatis

fastmybatis是一个mybatis开发框架，其宗旨为：简单、快速、有效。

• 零配置快速上手，无需依赖Spring
• 无需编写xml文件即可完成增删改查操作，支持LambdaQuery查询、支持JPA Query Method查询（findByXxx）
• 支持mysql、sqlserver、oracle、postgresql、sqlite、StarRocks（原DorisDB）
• 支持自定义sql，对于基本的增删改查不需要写SQL，对于其它特殊SQL（如统计SQL）可写在xml中
• 支持与spring-boot集成，依赖starter即可，支持Springboot3.0
• 支持插件编写
• 支持ActiveRecord模式
• 支持多租户
• 提供通用Service
• API丰富，多达40+方法，满足日常开发需求
• 轻量级，无侵入性，是官方mybatis的一种扩展