//根据查询条件批量下载文件(PDF)
public String executePDF() throws Exception {
String sitStateIds = get("sitStateIds");
String sitTypeIds = get("sitTypeIds");
Long years = getLong("years");
String name = get("name");
String schoolname = get("schoolname");
Long sbmh = getLong("sbmh");
Long provinces = getLong("provinces");
Long sitTypeId = getLong("sitTypeId");
Long statuId = getLong("statuId");
Long studentstatusId = getLong("studentstatusId");
String checkStuSit = get("checkStuSit");
String identity = get("identity");
String blsx = get("blsx");
if(blsx == null){
blsx = "";
}
String qjbl = get(blsx);
// EntityQuery query = sitTypeInfoService.searchList(years, name,
// schoolname, sbmh, provinces, sitTypeId, statuId,
// studentstatusId, checkStuSit, identity);
EntityQuery query = sitTypeInfoService.searchList2(years, name, schoolname, sbmh, provinces, sitTypeIds, sitStateIds, studentstatusId, checkStuSit, identity, blsx, qjbl);
String orderByPras = get("orderBy");
if (StringUtils.isEmpty(orderByPras)) {
orderByPras = "studentsInfo.id ";
} else {
if (orderByPras.equals("studentsInfo.sbmh asc") || orderByPras.equals("studentsInfo.name asc") || orderByPras.equals("studentsInfo.sexid.gbname asc") || orderByPras.equals("studentsInfo.schoolname asc") || orderByPras.equals("studentsInfo.gkprovinceid.gbname asc") || orderByPras.equals("studentsInfo.studentstatusid.parametername asc")) {
orderByPras = "studentsInfo.id desc";
}
}
if (get("Bkwtxjl") == null) {
query.add(new Condition("studentsInfo.sexid is not null"));
}
// 必须要加的 组合查询
query.addOrder(Order.parse(orderByPras));
query.setLimit(getPageLimit());
List<StudentsInfo> stulist = entityService.search(query);
//for循环遍历学生id
Long studentid = null;
String str = "";
if(stulist != null && stulist.size() != 0){
for (int i=0;i<stulist.size();i++) {
if(i!=stulist.size()-1) {
str+= stulist.get(i).getId()+",";
} else {
//拿到循环后的,分隔学生id
str+= stulist.get(i).getId();
}
}
}
String uuid = "";
String filepath = "";
String basePath = "D:\\uploadPDF";
OutputStream out = null;
String fileName = null;
//根据遍历拿到的学生id查询文件uuid(每个文件存在一个唯一的uuid),
List<FileUploadInfo> lists = entityService.searchHQLQuery("from FileUploadInfo f where f.studentsInfo.id in ("+str+")" );
File file = new File(basePath);
if(!file.exists()){
file.mkdirs();
}
file = new File(basePath+"/file");
if(!file.exists()){
file.mkdirs();
}
file = new File(basePath+"/zip");
if(!file.exists()){
file.mkdirs();
}
if(lists != null && lists.size() != 0){
//根据遍历拿到的 lists 集合中的uuid,遍历上传的文件
for (FileUploadInfo fileUploadInfo:lists) {
if(fileUploadInfo.getFileInfo() == null){
continue;
}
uuid = fileUploadInfo.getFileInfo().getUuid();
filepath = fileUploadInfo.getFileInfo().getFilepath();
File uploadFile = new File(filepath);
//下载的文件地址
//fileName = basePath+"/file/"+uploadFile.getName();
fileName = basePath+"/file/"+fileUploadInfo.getStudentsInfo().getSbmh()+".pdf";
out = new FileOutputStream(fileName);
byte[] bytes = this.File2byte(uploadFile);
out.write(bytes);
try{
if(out != null){
out.close();
}
}catch (Exception e){
e.printStackTrace();
}
}
}
//压缩成.zip后的地址
String zipFilePath = basePath+"/zip/"+System.currentTimeMillis()+".zip";
FileOutputStream fos1 = new FileOutputStream(new File(zipFilePath));
//压缩成.zip压缩包
toZip(new File(basePath+"/file"), fos1,true);
HttpServletResponse response = (HttpServletResponse) ActionContext.getContext().get(ServletActionContext.HTTP_RESPONSE);
OutputStream outNew = response.getOutputStream();
File zipFile = new File(zipFilePath);
String zipFileName = zipFile.getName();
response.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode(zipFileName != null ? zipFileName : System.currentTimeMillis()+".zip", "utf-8"));
byte[] zipBytes = File2byte(zipFile);
outNew.write(zipBytes);
try{
if(outNew != null){
outNew.close();
}
}catch (Exception e){
e.printStackTrace();
}
//清空文件夹
String pdfPath = "D:\\uploadPDF/file";
deleteDir(pdfPath);
zipFile.delete();
return null;
}
public byte[] File2byte(File tradeFile){
byte[] buffer = null;
try
{
FileInputStream fis = new FileInputStream(tradeFile);
ByteArrayOutputStream bos = new ByteArrayOutputStream();
byte[] b = new byte[1024];
int n;
while ((n = fis.read(b)) != -1)
{
bos.write(b, 0, n);
}
fis.close();
bos.close();
buffer = bos.toByteArray();
}catch (FileNotFoundException e){
e.printStackTrace();
}catch (IOException e){
e.printStackTrace();
}
return buffer;
}
private static final int BUFFER_SIZE = 2 * 1024;
/**
* 压缩成ZIP 方法1
* @param sourceFile 压缩文件夹路径
* @param out 压缩文件输出流
* @param KeepDirStructure 是否保留原来的目录结构,true:保留目录结构;
* false:所有文件跑到压缩包根目录下(注意:不保留目录结构可能会出现同名文件,会压缩失败)
* @throws RuntimeException 压缩失败会抛出运行时异常
*/
public static void toZip(File sourceFile, OutputStream out, boolean KeepDirStructure)
throws RuntimeException{
ZipOutputStream zos = null ;
try {
zos = new ZipOutputStream(out);
compress(sourceFile,zos,sourceFile.getName(),KeepDirStructure);
} catch (Exception e) {
throw new RuntimeException("zip error from ZipUtils",e);
}finally{
if(zos != null){
try {
zos.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
/**
* 压缩成ZIP 方法2
* @param srcFiles 需要压缩的文件列表
* @param out 压缩文件输出流
* @throws RuntimeException 压缩失败会抛出运行时异常
*/
public static void toZip(List<File> srcFiles , OutputStream out)throws RuntimeException {
long start = System.currentTimeMillis();
ZipOutputStream zos = null ;
try {
zos = new ZipOutputStream(out);
for (File srcFile : srcFiles) {
byte[] buf = new byte[BUFFER_SIZE];
zos.putNextEntry(new ZipEntry(srcFile.getName()));
int len;
FileInputStream in = new FileInputStream(srcFile);
while ((len = in.read(buf)) != -1){
zos.write(buf, 0, len);
}
zos.closeEntry();
in.close();
}
long end = System.currentTimeMillis();
System.out.println("压缩完成,耗时:" + (end - start) +" ms");
} catch (Exception e) {
throw new RuntimeException("zip error from ZipUtils",e);
}finally{
if(zos != null){
try {
zos.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
/**
* 递归压缩方法
* @param sourceFile 源文件
* @param zos zip输出流
* @param name 压缩后的名称
* @param KeepDirStructure 是否保留原来的目录结构,true:保留目录结构;
* false:所有文件跑到压缩包根目录下(注意:不保留目录结构可能会出现同名文件,会压缩失败)
* @throws Exception
*/
private static void compress(File sourceFile, ZipOutputStream zos, String name,
boolean KeepDirStructure) throws Exception{
byte[] buf = new byte[BUFFER_SIZE];
if(sourceFile.isFile()){
// 向zip输出流中添加一个zip实体,构造器中name为zip实体的文件的名字
zos.putNextEntry(new ZipEntry(name));
// copy文件到zip输出流中
int len;
FileInputStream in = new FileInputStream(sourceFile);
while ((len = in.read(buf)) != -1){
zos.write(buf, 0, len);
}
// Complete the entry
zos.closeEntry();
in.close();
} else {
File[] listFiles = sourceFile.listFiles();
if(listFiles == null || listFiles.length == 0){
// 需要保留原来的文件结构时,需要对空文件夹进行处理
if(KeepDirStructure){
// 空文件夹的处理
zos.putNextEntry(new ZipEntry(name + "/"));
// 没有文件,不需要文件的copy
zos.closeEntry();
}
}else {
for (File file : listFiles) {
// 判断是否需要保留原来的文件结构
if (KeepDirStructure) {
// 注意:file.getName()前面需要带上父文件夹的名字加一斜杠,
// 不然最后压缩包中就不能保留原来的文件结构,即:所有文件都跑到压缩包根目录下了
compress(file, zos, name + "/" + file.getName(),KeepDirStructure);
} else {
compress(file, zos, file.getName(),KeepDirStructure);
}
}
}
}
}
//清空文件夹方法
public static boolean deleteDir(String path){
File file = new File(path);
if(!file.exists()){//判断是否待删除目录是否存在
System.err.println("The dir are not exists!");
return false;
}
String[] content = file.list();//取得当前目录下所有文件和文件夹
for(String name : content){
File temp = new File(path, name);
if(temp.isDirectory()){//判断是否是目录
deleteDir(temp.getAbsolutePath());//递归调用,删除目录里的内容
temp.delete();//删除空目录
}else{
if(!temp.delete()){//直接删除文件
System.err.println("Failed to delete " + name);
}
}
}
return true;
}