这是servlet端的代码
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String doid = request.getParameter("doid");
String dbname = request.getParameter("dbname");
//Tools dbnametool = new Tools();//有些数据库的显示值和参数值不匹配,调用这个方法更新这个问题。
//String mydbname = dbnametool.ChangeDbName(dbname);
DBDao dbdao = new DBDao();
List<List<String>> resultlist = dbdao.selectAllByIdDB(doid, dbname);//获得本页的所有数据
Do_aDao da_adao = new Do_aDao();//在do_a这个数据库里检索
int recordsnum = da_adao.selectNumByDoidDB(doid, dbname);
String doid_num = doid.substring(5);
String filename = "DOID_"+doid_num+"_"+dbname+"_"+recordsnum;
System.out.println(filename);
OutputStream out = null;
try {
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment; filename="+filename+".xls");
//File file = new File("H:\\MyEclipse 8.x\\mymydbcrid\\WebRoot\\excel\\data.xls");// 注意,里面的参数必须是这个文件全路径
String filePath=this.getServletConfig().getServletContext().getRealPath("/");
File file = new File(filePath+"data.xls");//得到一个绝对路径
Workbook srcBook = Workbook.getWorkbook(file);
WorkbookSettings settings = new WorkbookSettings ();
settings.setWriteAccess(null);
WritableWorkbook wb = Workbook.createWorkbook(response
.getOutputStream(), srcBook, settings);
WritableSheet s = wb.getSheet(0); // w.createSheet("Demo", 0);
int row = 0;
WritableSheet sheet = wb.getSheet(0);
for (int i = 0; i < resultlist.size(); i++) {
row++;
List<String> oneline = resultlist.get(i);
for (int j = 0; j < oneline.size(); j++) {
s.addCell(new Label(j, row - 1, oneline.get(j)));
}
}
wb.write();
wb.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (out != null)
out.close();
}
}
下面是jsp端的一个简单的form
<form id="form1" name="form1" method="post" action="EntityDownload">
<input name="doid" type="hidden" size="6" value=<%=doid%> />
<input name="dbname" type="hidden" size="6" value=<%=dbname%> />
<input name="itemnum" type="hidden" size="6" value=<%=itemnum%> />
<input name="curpage" type="hidden" size="6" value=<%=curpage%> />
This is the page <%=curpage %>, we have <%=pageCount %> pages records in total. <input type="submit" name="Submit" value="export all the data as xls file" />
</form><br/>