<%@ 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);
    }
   
    }
    
    %>