思路：
1、JSP 页面 包括浏览文件和提交文件
2、服务器对excel文件进行读出
3、将excel文件内容解析保存至数据库中，然后显示到页面上

必要的包：commons-fileupload.jar 、 commons-io.jar、jxl.jar。

一：JSP 页面
<%
if (request.getParameter("flag") != null && request.getParameter("flag").equals("true")){%>
<script type="text/java script">
alert("中文电码表导入成功！");

self.location.replace("${ctx}/ABROAD/PAPER/telegraphcodelist.jsp");

<%}else if (request.getParameter("flag") != null && request.getParameter("flag").equals("false")){%>
<script type="text/java script">
alert("中文电码表导入失败！");

<%} %>

// --导入中文电码表
function newAttachment()
{
var filename = document.getElementById('importExcel').value;
if(filename=='')
{
alert('请选择要上传的文件');return false;
}
var fileextend = filename.substring(filename.lastIndexOf('.')+1).toLowerCase();
var moreTemple = "xls";

if(fileextend.indexOf(moreTemple)<0)
{
alert('请选择excel文件！');
return false;
}

document.attachmentForm.action="${ctx}/telegraphcodeImport";
document.attachmentForm.submit();

}

二：Servlet
package com.baosight.spes.abroad.base.commmon;

import java.io.File;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUpload;
import org.apache.commons.fileupload.FileUploadException;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.baosight.efmpx.system.util.SessionUtil;
import com.baosight.spes.abroad.base.domain.Telegraphcode;
import com.baosight.spes.abroad.group.agent.GROUPAgentFactory;
import com.baosight.spes.abroad.util.Constants;

public class FileImportForTelegraphcodeServlet extends HttpServlet{

/**
* serialVersionUID
*/
private static final long serialVersionUID = 1L;

private static Log logger = LogFactory
.getLog(FileImportForTelegraphcodeServlet.class);

protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
// TODO Auto-generated method stub
service(req, resp);
}

/**
* service
*
* @param req HttpServletRequest
* @param resp HttpServletResponse
* @throws ServletException
* @throws IOException
*/
protected void service(HttpServletRequest req,
HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
RequestDispatcher dispatcher = null;
boolean flag= false;