📄 failure.jsp

📁 电信的网厅的整站代码
💻 JSP
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<!--系统访问量导出excel功能-->
<%@ page language="java" contentType="text/html; charset=GBK" %>
<%@ page import="com.doone.data.*"%>
<%@ page import="com.doone.util.*"%>
<%@ page import="com.doone.uurm.*"%>
<%@ page import="com.doone.fj1w.fjmgr.statana.*"%>
<%!
	   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;
	}
	
	
	DataTable dt=new DataTable();
    clientcount clientcount=new clientcount();
    String  _year="";
    String  _popedom="";
    String  _transact="";
    String  _month="";
    String  _start="";
    String  _end="";
    String  _quarter="";
    String  _xun="";
    String  _week="";
    String  _rq="";
    String  mode="";
    
	DataRow dr = null;
	
	
%>

<%
	WebAuth auth = WebAuth.getInstance(request);
	
    if ( ! auth.IsAuthed() ) {
	    out.write("<script language=\"javascript\">self.parent.location.replace(\"" + request.getContextPath() + "/view/login/login.jsp" + "\");</script>");
	    return;
    }
    
  %>
<%  

    String falg="1";   
    String year=request.getParameter("year");
    String citycode=request.getParameter("citycode");
    String fwlx=request.getParameter("fwlx");
    String gzlx=request.getParameter("gzlx");
    String slzt=request.getParameter("slzt");
    String month=request.getParameter("month");
    String start=request.getParameter("starttime");
	String end=request.getParameter("endtime");
    String quarter=request.getParameter("quarter");
    String xun=request.getParameter("xun");
    String week=request.getParameter("week");
    String rq=request.getParameter("rq");
    String time_style=request.getParameter("time_style");
    String pageNo=request.getParameter("PageNo");
    if(start==null||start.equals("null")||start.equals("")){start="";}
    if(citycode==null||citycode.equals("null")||citycode.equals("")){citycode="";}
    if(slzt==null||slzt.equals("null")||slzt.equals("")){slzt="";}
    if(fwlx==null||fwlx.equals("null")||fwlx.equals("")){fwlx="";}
    if(gzlx==null||gzlx.equals("null")||gzlx.equals("")){gzlx="";}
    if(year==null||year.equals("null")||year.equals("")){year="";}
    if(month==null||month.equals("null")||month.equals("")){month="";}
	if(end==null||end.equals("null")||end.equals("")){end="";}
    if(time_style==null||time_style.equals("")||time_style.equals("null")){time_style="";}
    if(quarter==null||quarter.equals("")||quarter.equals("null")){quarter="";}
    if(xun==null||xun.equals("")||xun.equals("null")){xun="";}
    if(week==null||week.equals("")||week.equals("null")){week="";}
    if(rq==null||rq.equals("")||rq.equals("null")){rq="";}
    if(pageNo==null||pageNo.equals("")||pageNo.equals("null")){pageNo="1";}
    
 %>
<%
     try{
       dt=clientcount.getcount(citycode,fwlx,gzlx,slzt,year,quarter,month,xun,week,rq,start,end,pageNo,falg);
	   }catch(Exception ex){ex.printStackTrace();}%> 
 <%
	   
	StringBuffer buffer = new StringBuffer();
	try {
	
	if(!year.equals("")){_year=year+"年";}
    if(!quarter.equals("")){_quarter="第"+quarter+"季度";}
    if(!month.equals("")){_month="第"+month+"月";}
    if(!xun.equals("")){
    if(xun.equals("1")){_xun="上旬";}
    if(xun.equals("2")){_xun="中旬";}
    if(xun.equals("3")){_xun="下旬";}
    }
    if(!week.equals("")){
    if(week.equals("1")){_week="第一周";}
    if(week.equals("2")){_week="第二周";}
    if(week.equals("3")){_week="第三周";}
    if(week.equals("4")){_week="第四周";}
    }
    if(!rq.equals("")){_rq=rq.substring(0,4)+"年"+rq.substring(5,7)+"月"+rq.substring(8,10)+"日";}
    if(!start.equals("")){_start=start+"--";}
    if(!end.equals("")){_end=end;}
    mode=_year+_quarter+_month+_xun+_week+_rq+_start+_end;
    
   StringBuffer content = new StringBuffer();
			
			content.append("<ss:Row>\n");
			content.append("<ss:Cell ss:StyleID=\"wc0CEFE34C\"><ss:Data ss:Type=\"String\">地市</ss:Data>\n</ss:Cell>\n");
			content.append("<ss:Cell ss:StyleID=\"wc0CEFE34C\"><ss:Data ss:Type=\"String\">服务类型</ss:Data>\n</ss:Cell>\n");
			content.append("<ss:Cell ss:StyleID=\"wc0CEFE34C\"><ss:Data ss:Type=\"String\">受理状态</ss:Data>\n</ss:Cell>\n");
			content.append("<ss:Cell ss:StyleID=\"wc0CEFE34C\"><ss:Data ss:Type=\"String\">数量</ss:Data>\n</ss:Cell>\n");
			content.append("</ss:Row>\n");
			
	
		int   index = 0;
		while ( index < dt.getRows().getCount() ) {
			content.append("<ss:Row>\n");
				
			// 
			content.append("<ss:Cell><ss:Data ss:Type=\"String\">");
			content.append(dt.getRow(index).getString("cityname"));
			content.append("</ss:Data></ss:Cell>\n");
				
			//
			content.append("<ss:Cell><ss:Data ss:Type=\"String\">");
			if(dt.getRow(index).getString("APPEALMODE").equals("故障")){
			content.append(getHTMLString(dt.getRow(index).getString("APPEALMODE")));
			content.append("(");
			content.append(dt.getRow(index).getString("FAULTTYPE"));
			content.append(")");
			}
			else{
			content.append(getHTMLString(dt.getRow(index).getString("APPEALMODE")));
			}
			content.append("</ss:Data></ss:Cell>\n");
			
			//
			content.append("<ss:Cell><ss:Data ss:Type=\"String\">");
			content.append(dt.getRow(index).getString("state"));
			content.append("</ss:Data></ss:Cell>\n");
			
			
			//
			content.append("<ss:Cell><ss:Data ss:Type=\"String\">");
			content.append(dt.getRow(index).getString("cnt"));
			content.append("</ss:Data></ss:Cell>\n");
			
		    content.append("<ss:Cell><ss:Data ss:Type=\"String\">");
			content.append(mode);
			content.append("</ss:Data></ss:Cell>\n");
			
			content.append("</ss:Row>\n");
			
			index++;
		}
		buffer.append("<?xml version=\"1.0\"?>\n");
		buffer.append("<ss:Workbook xmlns:x=\"urn:schemas-microsoft-com:office:excel\"\n xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\"\n xmlns:c=\"urn:schemas-microsoft-com:office:component:spreadsheet\">\n ");
		buffer.append("<x:ExcelWorkbook>\n");
		buffer.append("<x:ProtectStructure>False</x:ProtectStructure>\n");
		buffer.append("<x:ActiveSheet>0</x:ActiveSheet>\n");
		buffer.append("</x:ExcelWorkbook>\n");

		buffer.append("<ss:Styles>\n");
		buffer.append("<ss:Style ss:ID=\"Default\">\n ");
		buffer.append("<ss:Alignment ss:Horizontal=\"Automatic\" ss:Rotate=\"0.0\" ss:Vertical=\"Bottom\"\n ss:ReadingOrder=\"Context\"/>\n");
		buffer.append("<ss:Borders>\n</ss:Borders>\n");
		buffer.append("<ss:Font ss:FontName=\"宋体\" ss:Size=\"10\" ss:Color=\"Automatic\" ss:Bold=\"0\"\n    ss:Italic=\"0\" ss:Underline=\"None\"/>\n");
		buffer.append("<ss:Interior ss:Color=\"Automatic\" ss:Pattern=\"None\"/>\n");
		buffer.append("<ss:NumberFormat ss:Format=\"General\"/>\n");
		buffer.append("<ss:Protection ss:Protected=\"1\"/>\n");
		buffer.append("</ss:Style>\n");
		
		buffer.append("<ss:Style ss:ID=\"wc0CEFE34C\">\n");
		buffer.append("<ss:Alignment ss:Horizontal=\"Center\"/>\n");
		buffer.append("<ss:Font ss:FontName=\"宋体\" ss:Size=\"10\" ss:Bold=\"1\"/>\n");
		buffer.append("</ss:Style>\n");

		buffer.append("</ss:Styles>\n ");
		
		
		buffer.append("<c:ComponentOptions>\n");
		buffer.append("<c:Label>\n");
		buffer.append("<c:Caption>Microsoft Office Spreadsheet</c:Caption>\n");
		buffer.append("</c:Label>\n  ");
		buffer.append("<c:MaxHeight>80%</c:MaxHeight>\n  ");
		buffer.append("<c:MaxWidth>80%</c:MaxWidth>\n  ");
		buffer.append("<c:NextSheetNumber>4</c:NextSheetNumber>\n ");
		buffer.append("</c:ComponentOptions>\n ");
		buffer.append("<x:WorkbookOptions>\n  ");
		buffer.append("<c:OWCVersion>10.0.0.4109</c:OWCVersion>\n");
		buffer.append("<x:Height>7620</x:Height>\n");
		buffer.append("<x:Width>15240</x:Width>\n");
		buffer.append("</x:WorkbookOptions>\n");
		buffer.append("<ss:Worksheet ss:Name=\"工作表\">\n  ");
		buffer.append("<x:WorksheetOptions>\n   ");
		buffer.append("<x:Selected/>\n   ");
		buffer.append("<x:ViewableRange>R1:R262144</x:ViewableRange>\n   ");
		buffer.append("<x:Selection>R1C1</x:Selection>\n   ");
		buffer.append("<x:TopRowVisible>0</x:TopRowVisible>\n ");  
		buffer.append("<x:LeftColumnVisible>0</x:LeftColumnVisible>\n   ");
		buffer.append("<x:ProtectContents>False</x:ProtectContents>\n  ");
		buffer.append("</x:WorksheetOptions>\n  ");
		buffer.append("<c:WorksheetOptions>\n  </c:WorksheetOptions>\n  ");
		buffer.append("<ss:Table ss:DefaultColumnWidth=\"54.0\" ss:DefaultRowHeight=\"12.75\">");
		
		buffer.append("<ss:Column ss:Width=\"54.0\" ss:AutoFitWidth=\"0\"/>");
		buffer.append("<ss:Column ss:Width=\"120.0\" ss:AutoFitWidth=\"0\"/>");
		buffer.append("<ss:Column ss:Width=\"54.0\" ss:AutoFitWidth=\"0\"/>");
		buffer.append("<ss:Column ss:Width=\"100.0\" ss:AutoFitWidth=\"0\"/>");
		buffer.append("<ss:Column ss:Width=\"250.0\" ss:AutoFitWidth=\"0\"/>");
		
		buffer.append(content);
		
		buffer.append("</ss:Table>\n</ss:Worksheet>\n");
		buffer.append("</ss:Workbook>\n");

		ExtString.replace(buffer, "&", "&amp;");
		ExtString.replace(buffer, "<", "&lt;");
		ExtString.replace(buffer, ">", "&gt;");
		ExtString.replace(buffer, "\"", "&quot;");
		
		//response.reset();
		//response.setContentType("application/vnd.ms-excel; charset=gbk");

		//out.print(buffer);
		//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>系统访问量统计导出EXCEL</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 + -