<%
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);
}
%>