<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="java.io.*,java.sql.*,jxl.*,jxl.write.*" %>
<%@ page
import="java.util.*,java.sql.*,com.abin.comm.util.Common"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title> </title>
</head>
<body>
<%
out.println(" ");
out.println("<br/>");
String username=request.getParameter("login");
out.println("<br/>");
if(null==username||"".equals(username)){
response.sendRedirect("login.jsp");
}
out.println(" :"+username);
out.println("<br/>");
%>
<a href="index.jsp?login=<%=username %>"> </a>
<%
out.println("<br/>");
out.println(" Execl( D ),Execl !");
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
int i = 0;
int j = 0;
String[] title = { "ID", " ", " ", " ", " "};
String sql = "select t.id,t.createtime,t.mobile,t.content,t.tuanname from hd_axiulog t where t.sign=4 order by t.createtime desc";
Calendar cal=Calendar.getInstance();
String path="d:\\ .xls";
try {
//
conn = DBClassLocal.getConnection();
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
//
ResultSetMetaData md = rs.getMetaData();
int columnCount = md.getColumnCount();
out.clear();
out=pageContext.pushBody();
response.reset();
//
response.setContentType("application/vnd.ms-excel");
// Workbook , Workbook
// : Excel
WritableWorkbook wwb = Workbook.createWorkbook(response.getOutputStream());
WritableSheet ws = wwb.createSheet("sheet1", 0);
for (i = 0; i < title.length; i++) {
WritableFont wf = new WritableFont(WritableFont.TIMES, 12,
WritableFont.BOLD, false);
WritableCellFormat wcfF = new WritableCellFormat(wf);
Label labelCF = new Label(i, 0, title[i], wcfF);
ws.addCell(labelCF);
}
i = 1;
while (rs.next()) {
for (j = 1; j <= title.length; j++) {
Label labelC = new Label(j - 1, i, rs.getString(j));
ws.addCell(labelC);
}
i++;
}
// Exel
wwb.write();
// Excel
wwb.close();
// rs.close();
// ps.close();
// conn.close();
} catch (Exception e) {
System.out.println(e.toString());
}finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
if(conn!=null){
conn.close();
}
}
%>
<br />
<br />
</body>
</html>