/**
* Servlet implementation class ExportEnrollExamine
*/
@WebServlet("/ExportEnrollExamine")
public class DocFileExportLicenseServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public DocFileExportLicenseServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
JSONObject jsonData = JSONObject.fromObject(request.getParameter("jsonData"));
String sqlString =BaseLicenseBaseInfo.queryCheckInfoBycheckId(jsonData.getString("checkId"));
LinkedList<HashMap<String,Object>> list = AccessDataBaseUtil.getDataTableListKeyValue(sqlString,"LIC_USER;LIC_USER_IDCARD;LIC_USER_DOCUMENT_TYPE;LIC_CALLSIGN;LIC_CODE;CHECK_STATUS");
String sqlStringLastTime =BasicLicenseCheckInfo.selectCheckInfoById(jsonData.getString("checkId"));
LinkedList<HashMap<String,Object>> lastTimeList = AccessDataBaseUtil.getDataTableListKeyValue(sqlStringLastTime,"check_end_time;check_title");
JSONObject jsonobj =new JSONObject();
JSONArray jsonarray = JSONArray.fromObject(lastTimeList);
JSONObject licenseTime = jsonarray.getJSONObject(0);
jsonobj.put("licenseData", JSONArray.fromObject(list));
jsonobj.put("licenseTime", licenseTime.get("check_end_time"));
StringBuffer write = new StringBuffer();
try {
response.setHeader("Content-Disposition", "attachment;filename="+ new String((licenseTime.get("check_title").toString()+".txt").getBytes("utf-8"), "iso8859-1"));// 设置头信息
response.setContentType("application/ynd.ms-excel;charset=UTF-8");
OutputStream out = response.getOutputStream();
write.append(jsonobj);
out.write(write.toString().getBytes("UTF-8"));
out.flush();
out.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
* Servlet implementation class ExportEnrollExamine
*/
@WebServlet("/ExportEnrollExamine")
public class DocFileExportLicenseServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public DocFileExportLicenseServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
JSONObject jsonData = JSONObject.fromObject(request.getParameter("jsonData"));
String sqlString =BaseLicenseBaseInfo.queryCheckInfoBycheckId(jsonData.getString("checkId"));
LinkedList<HashMap<String,Object>> list = AccessDataBaseUtil.getDataTableListKeyValue(sqlString,"LIC_USER;LIC_USER_IDCARD;LIC_USER_DOCUMENT_TYPE;LIC_CALLSIGN;LIC_CODE;CHECK_STATUS");
String sqlStringLastTime =BasicLicenseCheckInfo.selectCheckInfoById(jsonData.getString("checkId"));
LinkedList<HashMap<String,Object>> lastTimeList = AccessDataBaseUtil.getDataTableListKeyValue(sqlStringLastTime,"check_end_time;check_title");
JSONObject jsonobj =new JSONObject();
JSONArray jsonarray = JSONArray.fromObject(lastTimeList);
JSONObject licenseTime = jsonarray.getJSONObject(0);
jsonobj.put("licenseData", JSONArray.fromObject(list));
jsonobj.put("licenseTime", licenseTime.get("check_end_time"));
StringBuffer write = new StringBuffer();
try {
response.setHeader("Content-Disposition", "attachment;filename="+ new String((licenseTime.get("check_title").toString()+".txt").getBytes("utf-8"), "iso8859-1"));// 设置头信息
response.setContentType("application/ynd.ms-excel;charset=UTF-8");
OutputStream out = response.getOutputStream();
write.append(jsonobj);
out.write(write.toString().getBytes("UTF-8"));
out.flush();
out.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}