net oracle 写入word,将大文本字段导出到word中

今天遇到一个需求，需要将一个大文本字段内的数据导出，以供别人进行相关中问的翻译，现在记录一下导出成word的jsp，以备后用

导出名称为：product.doc

content字段类型为：longtext

import="java.sql.*,java.util.*,abc.jsp.database.*,abc.jsp.util.*,java.text.SimpleDateFormat,java.net.*"%>

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");

%>

int m=1;

while(rs!=null&&rs.next()){

%>

栏目名称:

栏目内容:

---

} catch (Exception e) {

e.printStackTrace();

} finally {

pool.freeConnection(conn);

}

%>