- 博客(9)
- 收藏
- 关注
RSS订阅原创 excel导出
public void exportExamSituation( HttpServletResponse response,Map<String, Object> params) { List<Map<String, Object>> resultList = this.preparationRepository.examHistory((String) params.get("examName"), Long.val...
2022-05-24 09:02:28
121
原创 从json数组中获取某一属性的集合
//此处需要捕获异常 try {//先构件一个json数组对象 JSONArray jsonArray = new JSONArray(jsonStr); for (int i = 0; i < jsonArray.length(); i++) {//循环遍历该数组，取出其中的json对象（即{}包含的内容） JSONObject jsonObject = (JSONObject) json.
2022-03-08 10:40:15
1427
原创 按条件分组
SELECT * FROM USER_FINISTORDER BY CASE FINIST_CD=17 THEN 0 CASE FINIST_CD=5 THEN 1 CASE FINIST_CD=3 THEN 2 CASE FINIST_CD=12 THEN 3 END ASC/DESC
2022-03-04 10:32:35
156
原创 ExcelUtils.downloadExcel导出excel表
log.info("---进入 FapiaoReportServiceImpl 类中 importExcel 方法!---"); String taxName= CommonUtils.trim(request.getParameter("taxName")); String taxID = CommonUtils.trim(request.getParameter("taxID")); String goodsName = CommonUtils.tri..
2021-11-19 09:22:27
1580
原创 template might not exist or might not be accessible by any of the configured Template Resolvers 工作台报
org.thymeleaf.exceptions.TemplateInputException: Error resolving template "xxx/xxx", template might not exist or might not be accessible by any of the configured Template Resolvers at org.thymeleaf.engine.TemplateManager.resolveTemplate(TemplateManager.j.
2021-11-17 16:29:30
239
原创 Mysql查询两个时间段内的数据
select DATE_FORMAT(create_time, '%Y-%m-%d %H:%i:%s') create_time from user where 1=1 <if test="startTime !=null and startTime !=''"> AND create_time <![CDATA[ >= ]]> #{startTime} </if> <if test="...
2021-11-16 23:30:47
1333
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人