?? xls.jsp
字號:
<%@ include file="checksession.jsp" %>
<%@page contentType="text/html;charset=gbk"%>
<%@page import="org.apache.log4j.*,java.util.*,com.util.StringUtils,com.web.tools.NutchFromXLS" %>
<%!
static Logger logger = Logger.getLogger("xls.jsp");
%>
<script>
function startGetGjInfo(){
document.f1.btn.value=="開始從xls導入...";
document.f1.btn.disabled=true;
document.f1.submit();
}
</script>
<center>
<form name="f1" action="xls.jsp">
<input type="hidden" name="start" value="ok">
<input type="button" name="btn" value="開始從xls文件導入" onclick="startGetGjInfo()">
</form>
</center>
<p style="padding:20px;line-height:21px;">
默認就是從Excel文件: WEB-INF\classes\xmldb\gongjiao.xls 導入.
<br/>
所以在導入之前,你可以通過編輯該 gongjiao.xls (Excel電子表格)文件,等公交線路編輯完整后,
就可以通過這個功能來導入,避免一筆筆記錄用手工輸入.
</p>
<%
if(StringUtils.parseString(request.getParameter("start")).equals("ok")){
Date start = new Date();
String needTimeBySeconds;
try{
String filename = getServletContext().getRealPath("/")+"WEB-INF/classes/xmldb/gongjiao.xml";
String indexDir = getServletContext().getRealPath("/")+"WEB-INF/classes/index/";
String xlsFilePath = getServletContext().getRealPath("/")+"WEB-INF/classes/xmldb/gongjiao.xls";
NutchFromXLS xlsNutch = new NutchFromXLS(filename,indexDir);
xlsNutch.setEncoding("utf-8");
xlsNutch.doStart(xlsFilePath);
Date end = new Date();
needTimeBySeconds = String.valueOf((end.getTime() - start.getTime())/1000);
out.print("執行成功.花費時間:"+needTimeBySeconds+"秒");
}
catch(Exception e){
logger.info("e="+e);
}
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -