1.linux环境
通过mysql -uroot -p
password:输入密码
进入mysql,
use 库名; 进入相应数据库
select 需要导出的数据
1
,需要导出的数据
2
,
from
数据库表 where 导出过滤条件 into outfile '
要导出文件名以及格式'
默认文件会放在
/var/lib/mysql/数据库名 这个文件夹下
2.windows环境
1.通过IO读写
导包:
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.10-FINAL</version>
</dependency>
Service层:
List<CinemaReport> cinemaReportList = cinemaReportRepository.findAll();
XSSFWorkbook wb = new XSSFWorkbook();
Sheet sheet = wb.createSheet("CinemaReport"); //创建一张表
Row titleRow = sheet.createRow(0);//创建第一行,起始为0
titleRow.createCell(0).setCellValue("序号");//第一列
titleRow.createCell(1).setCellValue("省份");
titleRow.createCell(2).setCellValue("影院名称");
titleRow.createCell(3).setCellValue("天数");
int cell = 1;
for(CinemaReport cinema : cinemaReportList) {
Row row = sheet.createRow(cell);//从第二行开始保存数据
row.createCell(0).setCellValue(cell);
row.createCell(1).setCellValue(cinema.getProvince());
row.createCell(2).setCellValue(cinema.getCinemaName());
row.createCell(3).setCellValue(cinema.getTotalDays());
cell++;
}
return wb;
}
Controller层:
@RequestMapping(value = "/export/cinemaReport",method = RequestMethod.GET)
public void importCinemaReport(HttpServletResponse response) {
XSSFWorkbook wb = fileImportServiceImpl.exportCinemaReport();
String fileName = "电影报表.xlsx";
OutputStream out = null;
try {
fileName = URLEncoder.encode(fileName,"UTF-8");
//设置ContentType请求信息格式
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment;filename=" + fileName);
out = response.getOutputStream();
wb.write(out);
out.flush();
out.close();
} catch (IOException e) {
e.printStackTrace();
}
}