目录mybatis group by substr传参报错报异常原因使用group by 分组查http://询返回为null解决方法 mybatis group by substr传参报错 报异常 ### Cause: java.sql.SQLSyntaxErrorException: ORA-00979: 不是 GROUP BY 表达式 SELECT SUBSTR( region_code, 1,#{ queryMap.groupCodeLength, jdbcType = INTEGER }...
--整合mybatis--><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.0.1</version></dependency><!--mybatis的分页插件--><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper-spring-boot-starter</artifactId><...
String fileName;//设置文件名称fileName = "投诉信息.xlsx";//创建标题映射exportTitleMap(writer);//未映射的不显示writer.setOnlyAlias(true);//设置分页条件//获取数据IPage<Map> excelList = taTsWorksheetTargetDDao.getMapData(newPage(1,99999),monthId,prvnceId,tsType); writer.write(excelList.getRe...