Java method to export TXT file
- 2020-04-01 03:53:15
- OfStack
This article illustrates a Java method for exporting TXT files. Share with you for your reference. The details are as follows:
Example a
@RequestMapping(value="/grab/export/csv",method={RequestMethod.GET})
public void exportCsv(HttpServletRequest request,HttpServletResponse response){
String userId = ServletRequestUtils.getStringParameter(request, "userId", "test");
ModelAndView mav=new ModelAndView();
SqlVideoList sqlVideoList =new SqlVideoList();
List<VideoListModel> list = new ArrayList<VideoListModel>();
try {
list = sqlVideoList.selectSuccessDate(userId);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//Export the TXT file
response.setContentType("text/plain");
String fileName="videolist";
try {
fileName = URLEncoder.encode("videolist", "UTF-8");
} catch (UnsupportedEncodingException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
response.setHeader("Content-Disposition","attachment; filename=" + fileName + ".txt");
BufferedOutputStream buff = null;
StringBuffer write = new StringBuffer();
String enter = "rn";
ServletOutputStream outSTr = null;
try {
outSTr = response.getOutputStream(); //To establish
buff = new BufferedOutputStream(outSTr);
//Write to a file
if(list.size()>0){
for (int i = 0; i < list.size(); i++) {
write.append(list.get(i).getUrl()+",");
write.append(list.get(i).getTitle());
write.append(enter);
}
}
buff.write(write.toString().getBytes("UTF-8"));
buff.flush();
buff.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
buff.close();
outSTr.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
Example 2:
@RequestMapping(value = "/{exchangeId}/{packageId}/export", method = RequestMethod.GET)
public void writeToTxt(@PathVariable String exchangeId,@PathVariable String packageId, HttpServletRequest request,HttpServletResponse response) throws UnsupportedEncodingException {
String schoolId = this.getSchoolId(request); //Net school ID
//Get the corresponding exchange code of the VIP package of the online school
VipCodeExample example=new VipCodeExample();
example.createCriteria().andSchoolIdEqualTo(schoolId).andPackageIdEqualTo(packageId).andExchangeIdEqualTo(exchangeId);
List<VipCode> vipCodes = vipExchangeManager.getVipCode(example);
if(vipCodes.size()>0){
response.setContentType("text/plain");//Here are two key Settings
response.addHeader("Content-Disposition",
"attachment;filename="+java.net.URLEncoder.encode(vipCodes.get(0).getName(),"UTF-8")+".txt");
//Filename specifies the default name
VipCode vipcode=new VipCode();
BufferedOutputStream buff = null;
StringBuffer write = new StringBuffer();
String tab = " ";
String enter = "rn";
ServletOutputStream outSTr = null;
try {
outSTr = response.getOutputStream();//To establish
buff = new BufferedOutputStream(outSTr);
for (int i = 0; i < vipCodes.size(); i++) {
vipcode = vipCodes.get(i);
write.append(i+1); //The serial number
write.append(tab);
write.append(vipcode.getExchangeCode());
write.append(tab);
if("normal".equals(vipcode.getStatus())){
write.append(" normal ");
}else{
write.append(" Has change ");
}
write.append(enter);
}
buff.write(write.toString().getBytes("UTF-8"));
buff.flush();
buff.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
buff.close();
outSTr.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
I hope this article has been helpful to your Java programming.