POI导入数据库
1.前台页面
<form action="<%=request.getContextPath()%>/doFile.action" method="post" enctype="multipart/form-data">
请选择文件:<input type="file" name="excelFile"><br/>
<input type="submit" value="提交">
</form>
excelFile封装 用 MultipartFile封装一个实体类
2.spring中进行上传配置
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="maxUploadSize"><value>100000</value></property>
<property name="defaultEncoding"><value>UTF-8</value>