Merge branch 'master' of https://gitee.com/xiaochen991015/xizang
| | |
| | | }).sheet().doRead(); |
| | | // 导出导入结果 |
| | | HttpServletResponse response = WebUtils.response(); |
| | | response.setContentType("application/vnd.ms-excel;charset=utf-8"); |
| | | response.setContentType("application/vnd.ms-excel;charset=UTF-8"); |
| | | response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); |
| | | response.setHeader("Content-Length","1"); |
| | | response.setHeader("Pragma", "no-cache"); |
| | | if (failList.size() > 0) { |
| | | EasyExcel.write(response.getOutputStream(), TBankFlowImportExcel.class).sheet("Sheet1").doWrite(failList); |
| | |
| | | </sql> |
| | | <insert id="insertBatchUserDept"> |
| | | insert into t_dept_to_user (dept_id, user_id) values |
| | | <foreach collection="list" item="item" separator=","> |
| | | <foreach collection="deptToUserList" item="item" separator=","> |
| | | (#{item.deptId},#{item.userId}) |
| | | </foreach> |
| | | </insert> |