批量查詢寫法 === > minidao的SQL怎么寫批量查詢的SQL語句，需要借助格式化類DaoFormat > 寫法：select * from employee where id in ( `${DaoFormat.getInStrs(ids)}` ) > 說明：參數ids是list<String>,返回的類型是字符串【'zhangsan','nihao','小王'】 第一步： 升級minidao 版本到 1.6.6+ ``` <dependency> <groupId>org.jeecgframework</groupId> <artifactId>minidao-pe</artifactId> <version>1.8.5</version> </dependency ``` 第二步： 編寫dao ``` /** * 查詢返回Java對象 * @param ids * @return */ @Sql("select * from employee where id in ( ${DaoFormat.getInStrs(ids)} )") List<Map<String,Object>> getEmployeeByIds(@Param("ids") String[] ids); ``` 第三步： 調用測試 ``` List<Map<String,Object>> ls = employeeDao.getEmployeeByIds(new String[]{"45266BB08B9B45B3B9BA8F9488495623","603D9DB409FE407183156BAA8FA779CD"}); for(Map<String,Object> p:ls){ System.out.println(p.get("name")); System.out.println(p.get("salary")); } ```