public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
try {
List<KL> list = (List<KL>) request.getSession().getAttribute("list");
List<String> listName = new ArrayList<String>();
List<String> thead = new ArrayList<String>();
listName.add("klnumber");
listName.add("name");
listName.add("contractname");
listName.add("tel");
listName.add("cardnumber");
listName.add("saler");
listName.add("sex");
listName.add("total_cost");
listName.add("front_cost");
listName.add("res_cost");
listName.add("bath_cost");
listName.add("others_cost");
listName.add("days");
listName.add("total_cost_time");
listName.add("remark");
thead.add("客历编号");
thead.add("客人姓名");
thead.add("合约名称");
thead.add("手机/联系电话");
thead.add("贵宾卡号");
thead.add("销售员");
thead.add("性别");
thead.add("消费合计");
thead.add("前天消费");
thead.add("餐饮消费");
thead.add("洗浴消费");
thead.add("其他类消费");
thead.add("住店天数");
thead.add("进场次数");
thead.add("备注");
Employee emp = (Employee) request.getSession().getAttribute("employee");
String name = emp.getName();
String date = DateUntil.getLocationTime1();
String title = "客历查询";
String fileTitle = "KL";
try {
ExcelUtil.getExcel(list, listName, thead, date, name, title, fileTitle);
File file = new File("D:/" + fileTitle + ".xls");
Desktop.getDesktop().open(file);
} catch (Exception e) {
// TODO: handle exception
JSONObject json = new JSONObject();
response.setContentType("application/json");
json.put("message", "error");
response.getWriter().write(json.toString());
}
} catch (Exception e) {
// TODO: handle exception
String message = "服务器出现错误！！ 3秒后跳转到登录界面！！";
String meta = "<meta http-equiv='refresh' content='3;url=" + request.getContextPath() + "'>";
request.getSession().removeAttribute("employee");
request.setAttribute("message", message + meta);
request.getRequestDispatcher("/messge.jsp").forward(request, response);
}
}
/**
* @param args
* @throws ParseException
*/
public static void main(String[] args) throws ParseException {
// TODO Auto-generated method stub
String b = DateUntil.longToDate(1445270400);
System.out.println(b);
}