在JAVA web开发中怎么把Excel中的数据导入到oracle数据库中

[cjl881225]

在JAVA web开发中怎么把Excel中的数据导入到oracle数据库中，请各位朋友指点，最好能给出例子并带上注释，谢谢！

[hzz104551041]

需要使用jxl.jar

	/**
	 * 传入excel文件路径　获取一个列表
	 * @param filePath Excel 文件路径
	 * @param isDelete 是否在读取完删除该文件
	 * @return
	 */
	public static List readExcel(String filePath) {
		jxl.Workbook rwb = null;
		InputStream is = null;
		List<List<String>> biglist = new ArrayList<List<String>>();
		try {
			// 构建Workbook对象, 只读Workbook对象
			// 直接从本地文件创建Workbook
			// 从输入流创建Workbook
			is = new FileInputStream(filePath);
			rwb = Workbook.getWorkbook(is);
			// Sheet(术语：工作表)就是Excel表格左下角的Sheet1,Sheet2,Sheet3但在程序中
			// Sheet的下标是从0开始
			// 获取第一张Sheet表
			Sheet rs = rwb.getSheet(0);
			// 获取Sheet表中所包含的总列数
			int rsColumns = rs.getColumns();
			// 获取Sheet表中所包含的总行数
			int rsRows = rs.getRows();
			// 获取指定单元格的对象引用
			
			List<String> colnames = new ArrayList<String>();
			for (int j = 0; j < rsColumns; j++) {
				Cell cell = rs.getCell(j, 0);
				colnames.add(cell.getContents());	
			}
			biglist.add(colnames);
			//**从第二行开始读取数据  这里默认从第2行开始读取
			for (int i = 1; i < rsRows; i++) {
				List<String> smalllist = new ArrayList<String>();
				boolean flag = false;
				for (int j = 0; j < rsColumns; j++) {
					Cell cell = rs.getCell(j, i);
					smalllist.add(cell.getContents());
					if(cell.getContents() != null && !"".equals(cell.getContents())){
						flag = true;
					}
				}
				if(flag){
					biglist.add(smalllist);
				}
			}
			return biglist;
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if(rwb!=null) {
				rwb.close();
			}
			try {
				is.close();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		return biglist;
	}

[yangxuan18]

/**
* 导入学院
*/
@SuppressWarnings("unchecked")
public void importAcademy(ActionForm form, HttpServletRequest request,
HttpServletResponse response) throws BizException {
try
{
DynaValidatorForm daf = (DynaValidatorForm)form;
FormFile importFile = (FormFile) daf.get("importFile");
String type = getUserType(request);
if(!"administrator".equals(type))
throw new BizException(Logic.class, "messages.noAuthority");
else
{
Workbook wordBook = Workbook.getWorkbook(importFile.getInputStream());
Sheet[] sheets = wordBook.getSheets();
for (int i = 0; i < sheets.length; i++)
{
int academyColumnIndex = getSheetColumnIndex("学院",sheets[i]);
if(-1 == academyColumnIndex)
throw new BizException(Logic.class, "messages.academyColumnNotFound");
else
{
for (int j = 1; j < sheets[i].getRows(); j++)
{
String academyName = sheets[i].getCell(academyColumnIndex, j).getContents().trim();
if(null != academyName && !"".equals(academyName))
{
List <Academy> academyList = academyDAO.find("from Academy where academyName = ?",academyName);
if(null == academyList || academyList.size() == 0)
{
Academy academy = new Academy();
academy.setAcademyName(academyName);
academyDAO.save(academy);
}
}
}
}
}
}
}
catch (DaoException e)
{
throw new DaoException(AcademyDAO.class, e.getMessage());
} catch (BiffException e) {
e.printStackTrace();
throw new BizException(Logic.class, "messages.importFailed");
} catch (FileNotFoundException e) {
e.printStackTrace();
throw new BizException(Logic.class, "messages.importFailed");
} catch (IOException e) {
e.printStackTrace();
throw new BizException(Logic.class, "messages.importFailed");
}
}

/**
* 查找工作薄中指定列名的列索引
*/
private int getSheetColumnIndex(String cloumnName,Sheet sheet)
{
Cell[] headers = sheet.getRow(0);
for (int i = 0; i < headers.length; i++)
{
if(cloumnName.equals(headers[i].getContents()))
return headers[i].getColumn();
}
return -1;
}
这是我以前写的导入学院名称的一个例子，仅供参考。

[「已注销」]

up 不错 学习

[redstarofsleep]

JXL是Java处理Excel的包

[cjl881225]

谢谢hzz104551041和yangxuan0418