📄 exportexcel.jsp
字号:
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ page import="java.util.ArrayList" %>
<%@ page import="com.glf.reportIE.commons.XmlUtils" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>导出报表</title>
<link href="./css/reportIE_form.css" rel="stylesheet" type="text/css" media="all" />
<link href="./css/reportIE_main.css" rel="stylesheet" type="text/css" media="all" />
<script type="text/javascript">
function checkExportExcel(){
if(document.getElementById('formName').value == ''){
window.alert('请您选择报表！');
return false;
}
if(confirm('您确定要导出的excel文件和您选择的报表相符合吗？')){
return true;
}else{
return false;
}
}
</script>
</head>
<body>
<h1>导出报表</h1>
<form action="exportExcel" name="base" id="base" method="post" onsubmit="return checkExportExcel()">
<div id="bigform">
<table width="89%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="fm-label">请选择报表</td>
<td class="fm-field">
<select name="formName" id="formName" style="width:15em">
<option value="" selected>请选择报表</option>
<%
String xmlPath = request.getRealPath("")+"/pages/reportIE/model/excelFormName.xml";
boolean flag = XmlUtils.fileIsExits(xmlPath);
if(flag){
ArrayList fileArray = XmlUtils.getFormNameCellValue(xmlPath);
for(int i=0; i<fileArray.size(); i++){
%>
<option value="<%=fileArray.get(i+2)%>"><%=fileArray.get(i+1)%></option>
<%
i+=2;
}
}
%>
</select>
</td>
</tr>
<tr>
<td class="fm-label">查询条件</td>
<td class="fm-field">
<input name="searchCondition" id="searchCondition" type="text" value="" />
</td>
<td class="fm-label"> </td>
<td class="fm-field"> </td>
</tr>
</table>
</div>
<div id="bigformbt">
<input name="submit" class="fm-submit" value="导出excel报表" type="submit" onclick="document.getElementById('errormessage').style.display='none';" />
</div>
<br />
<%
String errorMessage = (String)request.getAttribute("errorMessage");
if(errorMessage != null && errorMessage.length() > 0)
{
%>
<div id="errormessage">
<h4>请注意</h4>
<div id="warning">
<form>
<fieldset>
<div>
<table border="0" width="100%">
<tr>
<td width="25"><img src="./images/icn_warning_m.gif" align="top" /></td>
<td>
<label >
<span class="tips" id="error" style="color:red" >
<%=errorMessage%>
</span>
</label>
</td>
</tr>
</table>
</div>
</fieldset>
<div id="warningbt"></div>
</form>
</div>
</div>
<%}%>
<%
if(flag){
ArrayList fileArray = XmlUtils.getFormNameCellValue(xmlPath);
if(fileArray.isEmpty()){
%>
<div id="errormessage">
<h4>请注意</h4>
<div id="warning">
<form>
<fieldset>
<div>
<table border="0" width="100%">
<tr>
<td width="25"><img src="./images/icn_warning_m.gif" align="top" /></td>
<td>
<label >
<span class="tips" id="error" style="color:red" >
暂时没有报表可选，请执行【后台参数设置】-【添加报表的名字】这一步操作！
</span>
</label>
</td>
</tr>
</table>
</div>
</fieldset>
<div id="warningbt"></div>
</form>
</div>
</div>
<%
}
}
%>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -