这是一个导出为EXCEL的代码,你自己研究了!
<%-- mssql2excel.jsp --%>
<%@ page contentType="application/vnd.ms-excel; charset=gb2312"%>
<%@ page import="java.sql.*" %>
<%
String name=""+session.getAttribute("UserName");
String sql = "select * from bookdindan where 订阅者='"+name+"'";
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=F:\\forum.mdb"; //这里如何改为相对路径??
Connection conn = null;
ResultSet rs = null;
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
String s = "";
for (int i = 0; i < numberOfColumns; i++)
{
s = s + rsmd.getColumnName(i + 1) + "\t";
}
out.println(s);
while (rs.next())
{
String body= "";
for (int i = 0; i < numberOfColumns; i++)
{
body = body + rs.getString(i + 1) + "\t";
}
out.println(body);
}
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("errot " + e.getMessage());
}
rs.close();
conn.close();
%>
<%-- mssql2excel.jsp --%>
<%@ page contentType="application/vnd.ms-excel; charset=gb2312"%>
<%@ page import="java.sql.*" %>
<%
String name=""+session.getAttribute("UserName");
String sql = "select * from bookdindan where 订阅者='"+name+"'";
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=F:\\forum.mdb"; //这里如何改为相对路径??
Connection conn = null;
ResultSet rs = null;
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
String s = "";
for (int i = 0; i < numberOfColumns; i++)
{
s = s + rsmd.getColumnName(i + 1) + "\t";
}
out.println(s);
while (rs.next())
{
String body= "";
for (int i = 0; i < numberOfColumns; i++)
{
body = body + rs.getString(i + 1) + "\t";
}
out.println(body);
}
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("errot " + e.getMessage());
}
rs.close();
conn.close();
%>
关注……
<%@page contentType="text/html;charset=GBK"%> //html页头
改为:
<%@page contentType="application/msword;charset=GBK"%>
这样在IE中打开时就会提示以word文档保存,且从数据库中读入数据填写
不知是不是你想要的?
如果用excel可将application/msword 改为 application/excel 就可以了
看一下
还有,怎样使生成文件的文件名在程序中指定?