?? exportexcel.jsp
字號(hào):
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ page import="java.util.ArrayList" %>
<%@ page import="com.glf.reportIE.commons.XmlUtils" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>導(dǎo)出報(bào)表</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('請(qǐng)您選擇報(bào)表!');
return false;
}
if(confirm('您確定要導(dǎo)出的excel文件和您選擇的報(bào)表相符合嗎?')){
return true;
}else{
return false;
}
}
</script>
</head>
<body>
<h1>導(dǎo)出報(bào)表</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">請(qǐng)選擇報(bào)表</td>
<td class="fm-field">
<select name="formName" id="formName" style="width:15em">
<option value="" selected>請(qǐng)選擇報(bào)表</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="導(dǎo)出excel報(bào)表" 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>請(qǐng)注意</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>請(qǐng)注意</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" >
暫時(shí)沒有報(bào)表可選,請(qǐng)執(zhí)行【后臺(tái)參數(shù)設(shè)置】-【添加報(bào)表的名字】這一步操作!
</span>
</label>
</td>
</tr>
</table>
</div>
</fieldset>
<div id="warningbt"></div>
</form>
</div>
</div>
<%
}
}
%>
</form>
</body>
</html>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -