📄 loginacclog_execl.jsp

📁 电信的网厅的整站代码
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.util.*"%>
<%@ page import="com.doone.uurm.*, com.doone.data.*, com.doone.fj1w.common.*, com.doone.util.*"%>
<%@ page import="com.doone.fj1w.fjmgr.statana.Simpreportqry" %>
<%@ page import="com.doone.fj1w.fjmgr.rpt.*"%>

<%!
	String getHTMLString(String tmp) {
		tmp = tmp.replaceAll("\'","&#39;");
		tmp = tmp.replaceAll("\"", "&#34;");
		tmp = tmp.replaceAll("<", "&lt;");
		tmp = tmp.replaceAll(">", "&gt;");
		tmp = tmp.replaceAll("&", "&amp;");

		return tmp;
	}
%>
<%
	try {
	    String statisticType = request.getParameter("st");
	    String cityCode = request.getParameter("CITYCODE");
	    String startTime = request.getParameter("STARTTIME");
	    String endTime = request.getParameter("ENDTIME");
	    	    
	    Map map = new HashMap();
	    map.put("STATISTICTYPE",statisticType);
	    map.put("CITYCODE",cityCode);
	    map.put("STARTTIME",startTime);
	    map.put("ENDTIME",endTime);
	    
	    LoginAcclogImpl loginAcclogImpl = new LoginAcclogImpl();
	    DataTable dt = loginAcclogImpl.getAllList(map);
	    StringBuffer _sb = new StringBuffer();
		if(dt!=null){
			_sb.append("<meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">\n");
			_sb.append("<DIV Align=Center>注册帐号统计报表</DIV>\n");	
			_sb.append("<table width=\"720\">");	
			//_sb.append("<table cellspacing=\"0\" rules=\"all\" bordercolor=\"Black\" border=\"1\" id=\"DGrid_BugShow\" style=\"border-color:Black;width:100%;border-collapse:collapse;\">\n");                	
			try {
				com.doone.data.DataColumnCollection dcs = dt.getColumns();
				int colcount = dcs.getCount();
				_sb.append("<tr>");
				for (int icol = 0;icol<colcount;icol++){
					com.doone.data.DataColumn dc = dcs.getDataColumn(icol);
					_sb.append("<td class=\"body_td\" align=\"left\" nowrap><b>");
					_sb.append(dc.getColumnName());
					_sb.append("</b></TD>");
				}
				_sb.append("</tr>");
				
				for(int iresult=0;iresult<dt.getRows().getCount(); iresult++){	
					_sb.append("<tr height=\"20\">");			
					DataRow drresult = dt.getRow(iresult);
					for (int icol=0; icol<colcount;icol++){
						_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
						_sb.append(drresult.getString(icol).trim().equals("")?"&nbsp;":drresult.getString(icol).trim());
						_sb.append("</TD>");
					}
					_sb.append("</tr>");
				}
			} catch (Exception e) {
				FileLogger.getLogger().info(e.getMessage(),e);
			}
			_sb.append("</table>");
		}
		response.reset();
		response.setContentType("application/vnd.ms-excel; charset=gbk");
		//response.setContentType("application/x-msdownload");
		response.setHeader ("Content-Disposition", "attachment; filename=\"affairaccept.xls\"");	
		out.print(_sb);
		out.close();
		return ;
    }catch(Exception ex){
		FileLogger.getLogger().warn(ex.getMessage(),ex);
    }

%>
<html>
<head>
    <meta content="text/html; charset=GB18030" http-equiv="content-type"/>
    <title><%--= (sFaqCoteID!=null&&sFaqCoteID.equals("2"))?"咨询列表": "新闻列表"--%>业务受理量统计报表</title>
</head>

<body style="margin: 0px">
	<object width="100%" height="100%" classid="CLSID:0002E551-0000-0000-C000-000000000046" codebase="/manager/owc11.exe">
		<param name="DataType" value="XMLDATA">
		<param name="XMLData" value="<%--= buffer--%>">
		<table width='100%' cellpadding='0' cellspacing='0' border='0' height='8'>
			<tr>
				<td bgColor='#336699' height='25' width='10%'>&nbsp;</td>
				<td bgColor='#666666'width='85%'>
					<font face='宋体' color='white' size='4'>
						<b>&nbsp; 缺少 Microsoft Office Web Components</b>
					</font>
				</td>
			</tr>
			<tr>
				<td bgColor='#cccccc' width='15'>&nbsp;</td>
				<td bgColor='#cccccc' width='500px'><br> 
					<font face='宋体' size='2'>此网页要求 Microsoft Office Web Components。
					<p align='center'> 一般装完Office后会自动安装该组件.</p></font><p><font face='宋体' size='2'>此网页同时要求 Microsoft Internet Explorer 5.01 或更高版本。</p><p align='center'><a href='http://www.microsoft.com/windows/ie/default.htm'> 单击此处安装最新的 Internet Explorer</a>.</font><br>&nbsp;</td></tr></table>
	</object>

</body>

</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -