📄 simprpttoexcel.jsp

📁 电信的网厅的整站代码
💻 JSP
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ 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="java.util.HashMap"%>
<%@ page import="com.doone.fj1w.fjmgr.order.OrderService"%>
<%@ page import="com.doone.fj1w.fjmgr.statana.Simpreportqry"%>

<%!
	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;
	}
%>
<%
	String queryString = request.getQueryString();
	//System.out.println("queryString:"+queryString);	
	
	
	String sparamnum = request.getParameter("RECORDNUM");
	String ssql = request.getParameter("SQL");
	
	int place = 0;
	place = queryString.indexOf("SQL");
	queryString = queryString.substring(0,place);
	int placeone = 0;
	int placetwo = 0;
	String paramitem = "";
	int ilength = 0;
	HashMap hm = new HashMap();
	
	for(int t=0;t<Integer.parseInt(sparamnum);t++){
		placeone = queryString.indexOf("=");
		placetwo = queryString.indexOf("&");
		paramitem = queryString.substring(placeone+1,placetwo);
		ilength = queryString.length();
		queryString = queryString.substring((placetwo+1),ilength);
			if(place>0){
				hm.put(String.valueOf(t),paramitem);
			}
	}          
	
	StringBuffer buffer = new StringBuffer();
	try {
			DataTable dt_result = Simpreportqry.getsqlresult(ssql,hm);

			buffer.append("<meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">\n");
			buffer.append("<DIV Align=Center>简单报表查询</DIV>\n");
			buffer.append("<table cellspacing=\"0\" rules=\"all\" bordercolor=\"Black\" border=\"1\" id=\"DGrid_BugShow\" style=\"border-color:Black;width:100%;border-collapse:collapse;\">\n");                
	        if(dt_result!=null){
					buffer.append("<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" width=\"100%\" bordercolor=\"#FFFFFF\" bgcolor=\"#EEEEEE\" style=\"border-collapse:collapse;\">");
					com.doone.data.DataColumnCollection dcs = dt_result.getColumns();
					int colcount = dcs.getCount();
					buffer.append("<tr>");
					for (int icol = 0;icol<colcount;icol++){
						com.doone.data.DataColumn dc = dcs.getDataColumn(icol);
						buffer.append("<TD>");
						buffer.append(dc.getColumnName());
						buffer.append("</TD>");
					}
					buffer.append("</tr>");
					for(int iresult=0;iresult<dt_result.getRows().getCount(); iresult++){	
						buffer.append("<tr>");			
	                   			DataRow drresult = dt_result.getRow(iresult);
	                   			for (int icol=0; icol<colcount;icol++){							
							buffer.append("<TD>");							
							buffer.append(drresult.getString(icol).trim().equals("")?"&nbsp;":drresult.getString(icol).trim());
							buffer.append("</TD>");							
					}
					buffer.append("</tr>");
				}
				buffer.append("</table>");
			}

			response.reset();
			response.setContentType("application/vnd.ms-excel; charset=gbk");
			//response.setContentType("application/x-msdownload");
			response.setHeader ("Content-Disposition", "attachment; filename=\"simprptlist.xls\"");	
			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><%--= (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 + -