今天遇到一个需求，需要将一个大文本字段内的数据导出，以供别人进行相关中问的翻译，现在记录一下导出成word的jsp，以备后用
导出名称为：product.doc
content字段类型为：longtext
|
1 2 |
<%@page contentType="text/html;charset=utf-8" import="java.sql.*,java.util.*,abc.jsp.database.*,abc.jsp.util.*,java.text.SimpleDateFormat,java.net.*"%> |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
<% PoolManager pool = new PoolManager(); if (pool == null) { pool = new PoolManager(); } Connection conn = null; try { conn = pool.getConnection(); String query = "select name,content from information"; ResultSet rs = DataManager.executeQuery(conn,query); response.setContentType("application/vnd.ms-word;charset=UTF-8"); response.setHeader("Content-disposition","attachment; filename=product.doc"); %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> </head> <body> <% int m=1; while(rs!=null&&rs.next()){ %> <strong><%=m%>栏目名称:</strong><%=Common.getFormatStr(rs.getString("name"))%><br/> <strong>栏目内容:</strong><%=Common.getFormatStr(rs.getString("content"))%><br/> <hr/> <br/> <br/> <%m++;}%> </body> </html> <% } catch (Exception e) { e.printStackTrace(); } finally { pool.freeConnection(conn); } %> |
时间：2013-04-23 20:09:24
Latest posts by Zhiming Zhang (see all)
- aws eks node 自动化扩展工具 Karpenter - 8月 10, 2022
- ReplicationController and ReplicaSet in Kubernetes - 12月 20, 2021
- public key fingerprint - 5月 27, 2021