jsp实现针对excel及word文档的打印方法

<%@ page cOntentType="application/msword;charset=GBK" %>
<%@ page import="java.sql.*" %>













<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:mydb";
//连接mydb数据库
Connection con=DriverManager.getConnection (url, "", "");
try{
 Statement stmt=con.createStatement();
 //查询employee表
 ResultSet rs=stmt.executeQuery("select user_name, real_name, gender from employee ");
 while(rs.next()){
%>
 
<%
 } // end while
 rs.close();
 stmt.close();
} finally {
 con.close();
}
%>

 

 

 
用户名
 
 

 
真实姓名
 
 

 
性别
 
 

 

 
<%=rs.getString("user_name")%>
 
 

 
<%=rs.getString("real_name")%>
 
 

 
<%=rs.getString("gender")%>