导出csv格式打成zip包并下载代码,Java代码库,德仔网

代码语言

代码分类

【Java】导出csv格式打成zip包并下载

作者:小六大人 / 发布于2013/7/1/ 824

现在是超过6万条再生成一个csv文件，并起打在一个zip包里面


	public void exportAllCsv(HttpServletRequest request, HttpServletResponse response,int count,String querysql) throws Exception{
	 try{
	 SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
	 String reportTitle = "push_"+sdf.format(new Date());//导出文件的名字
	 CSVWriter writer = null;
	 String[] header ={"手机号码","内容","发送时间"};//表头
	 int pageSiz= 60000;//设置每一个excel文件导出的数量
	 int page;//页数
	 //计算分页
	 page = count/pageSiz+(count%pageSiz > 0 ? 1:0);
	 String auto_name = new SimpleDateFormat("yyyyMMddHHmmss").format(new Date());//当前时间//自动的生成一个文件码
	 String folder = request.getRealPath("upload") + File.separator +auto_name+"_myfolder";
	 //如果文件夹已存在就删除，可以根据需求安排是否进行删除，按照我的需求我不需要删除，因为我自动生成的文件码不会重复
	 //dropFolderOrFile(new File(folder));
	 File myfolder = new File(folder);
	 myfolder.mkdir();
	 //开始从第一页循环导出一个文件到那个文件夹
	 DAO dao=new DAO();
	 for(int i = 1; i <= page; i++){
	 PreparedStatement preparedStatement = null;
	 ResultSet result = null;
	 Connection conn =DAO.getConn();
	 String executeStr = "SELECT MOBILE_LIST,CONTENT,SUBMIT_TIME FROM (select rownum as myNum,TempAA.* FROM (" + querysql + ")TempAA ) where myNum>="
	 + (i-1)*pageSiz + " and myNum<=" + pageSiz*i;
	 preparedStatement = conn.prepareStatement(executeStr);
	 result = preparedStatement.executeQuery(executeStr);
	 int j=i;
	 File f = new File(myfolder+File.separator+reportTitle+"_"+j+".csv");
	 if(f.exists()){
	 f.delete();
	 }else{
	 f.createNewFile();
	 }
	 writer = new CSVWriter(new FileWriter(f));
	 writer.writeNext(header);
	 writer.writeAll(result,true);
	 result.close();
	 preparedStatement.close();
	 conn.close();
	 writer.close();
	 }
	 zipFile(folder);//folder是之前获取的文件夹路径
	 StringBuilder uri = new StringBuilder();
	 uri.append(folder);
	 uri.append(".zip");
	 downloadFile(request,response,uri);//去下载zip文件
	 }catch(Exception e){
	 e.printStackTrace();
	 }
	}

	

	

	将指定文件夹打包成zip

	/**
	 * 将指定文件夹打包成zip
	 * @param folder
	 * @throws IOException
	 */
	private void zipFile(String folder) throws IOException {
	 File zipFile = new File(folder + ".zip");
	 if (zipFile.exists()) {
	 zipFile.delete();
	 }
	 ZipOutputStream zipout = new ZipOutputStream(new FileOutputStream(zipFile));
	 File dir = new File(folder);
	 File[] fs = dir.listFiles();
	 byte[] buf = null;
	 if(fs!=null){
	 for (File f : fs) {
	 zipout.putNextEntry(new ZipEntry(f.getName()));
	 FileInputStream fileInputStream = new FileInputStream(f);
	 buf = new byte[2048];
	 BufferedInputStream origin = new BufferedInputStream(fileInputStream,2048);
	 int len;
	 while ((len = origin.read(buf,0,2048))!=-1) {
	 zipout.write(buf,0,len);
	 }
	 zipout.flush();
	 origin.close();
	 fileInputStream.close();
	 }
	 }
	 zipout.flush();
	 zipout.close();
	}

试试其它关键字

　打成zip包并下载　

同语言下

可能有用的

小六大人贡献的其它代码(1)

.导出csv格式打成zip包并下载