最近公司要求做一个导入excel文件到数据库的功能,就参照网上的博客做了一个小例子.
首先准备poi-3.17.jar,poi-ooxml-3.17.jar,poi-ooxml-schemas-3.17.jar
前端代码modal.jsp:
我是用的bootstrap插件(modal对话框)
<div class="modal" id="import">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">
<span aria-hidden="true">×</span><span class="sr-only">Close</span>
</button>
<h4 class="modal-title">导入</h4>
</div>
<div class="modal-body">
<form class="form-horizontal" role="form" id="import">
<div class="form-group">
<label class="col-sm-2 control-label">文件:</label>
<div class="col-sm-5">
<input type="file" name="uploadFile" id="file"/>
</div>
<div class="col-sm-3">
<button type="button" class="btn btn-primary" id="importBtn" >导入</button>
</div>
</div>
<div class="form-group text-center tips">