SSM框架poi实现excel数据导入到MySQL数据库

SSM框架poi实现excel数据导入到MySQL数据库

前端代码

<td style="vertical-align:top;padding-left:2px;">
	<a class="btn btn-light btn-xs" onclick="fromExcel();" title="从EXCEL导入">
		<i id="nav-search-icon"	class="ace-icon fa fa-download bigger-110 nav-search-icon blue"></i>
	</a>
</td>

//打开上传excel页面
	function fromExcel() {
		 top.jzts();
		 var diag = new top.Dialog();
		 diag.Drag=true;
		 diag.Title ="EXCEL 导入到数据库";
		 diag.URL = '<%=basePath%>village/goUploadExcel.do';
		 diag.Width = 300;
		 diag.Height = 150;
		 diag.CancelEvent = function() { //关闭事件
			 if(diag.innerFrame.contentWindow.document.getElementById('zhongxin').style.display == 'none') {
				 if('${page.currentPage}' == '0') {
					 top.jzts();
					 setTimeout("self.location.reload()", 100);
				 } else {
					 nextPage(${page.currentPage});
				 }
			}
			diag.close();
		 };
		 diag.show();
	}	

后台代码

/**打开上传EXCEL页面
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value="/goUploadExcel")
	public ModelAndView goUploadExcel()throws Exception{
		ModelAndView mv = this.getModelAndView();
		mv.setViewName("system/village/uploadexcel");
		return mv;
	}

excel上传页面

<form action="village/readExcel.do" name="Form" id="Form" method="post" enctype="multipart/form-data">
								<div id="zhongxin">
								<table style="width:95%;" >
									<tr>
										<td style="padding-top: 20px;"><input type="file" id="excel" name="excel" style="width:50px;" onchange="fileType(this)" /></td>
									</tr>
									<tr>
										<td style="text-align: center;padding-top: 10px;">
											<a class="btn btn-mini btn-primary" onclick="save();">导入</a>
											<a class="btn btn-mini btn-danger" onclick="top.Dialog.clo