sqltoy-orm 5.1.42 已经发布,ORM 框架
此版本更新内容包括:
1、支持多字段in,例如:(id,type) in ((:ids,:types)) 或 (id,type) in (:ids,:types)
List<StaffInfoVO> staffs = sqlToyLazyDao.findEntity(StaffInfoVO.class,
EntityQuery.create().values(new StaffInfoVO()));
String sql = "select * from sqltoy_staff_info where (staff_id,STAFF_CODE) "
+ "in ((:staffIdVOs.staffId,:staffIdVOs.staffCode))";
List<StaffInfoVO> staffVOs = sqlToyLazyDao.findBySql(sql,
MapKit.keys("staffIdVOs").values(staffs), StaffInfoVO.class);
<dependency>
<groupId>com.sagframe</groupId>
<artifactId>sagacity-sqltoy</artifactId>
<version>5.1.42</version>
</dependency>
<dependency>
<groupId>com.sagframe</groupId>
<artifactId>sagacity-sqltoy-starter</artifactId>
<version>5.1.42</version>
</dependency>
详情查看:https://gitee.com/sagacity/sagacity-sqltoy/releases/5.1.42