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