| | |
| | | package com.ycl.jxkg.controller.admin; |
| | | |
| | | import com.alibaba.excel.EasyExcel; |
| | | import com.alibaba.excel.ExcelWriter; |
| | | import com.alibaba.excel.write.metadata.WriteSheet; |
| | | import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper; |
| | | import com.github.pagehelper.PageInfo; |
| | | import com.ycl.jxkg.base.BaseApiController; |
| | |
| | | import com.ycl.jxkg.utils.DateTimeUtil; |
| | | import com.ycl.jxkg.utils.PageInfoHelper; |
| | | import lombok.RequiredArgsConstructor; |
| | | import lombok.SneakyThrows; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.web.bind.annotation.*; |
| | |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import javax.validation.Valid; |
| | | import java.util.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.UUID; |
| | |
| | | } |
| | | |
| | | @GetMapping("importTemplate") |
| | | @SneakyThrows |
| | | public void importTemplate(HttpServletResponse response) { |
| | | List<UserExcelVo> list = new ArrayList<>(); |
| | | list.add(new UserExcelVo().setUserName("zhangSan").setPassword("123456").setRealName("张三").setSex(1).setRole(1).setPhone("12345678901").setAge(24).setBirthDay("2000-01-01")); |
| | | ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream(), UserExcelVo.class).build(); |
| | | WriteSheet writeSheet = EasyExcel.writerSheet(0, "用户信息").build(); |
| | | excelWriter.write(list, writeSheet); |
| | | excelWriter.finish(); |
| | | userService.importTemplate(response); |
| | | } |
| | | |
| | | @PostMapping("import") |