java怎么将excel表格数据导入数据库

下载 poi 包

public class TestPoiExcel {
static Log log = LogFactory.getLog(TestPoiExcel.class);

public static String fileToBeRead="e://test.xls";
public static void main(String argv[]) {
try {
// 创建对Excel工作簿文件的引用
HSSFWorkbook workbook= new HSSFWorkbook(new FileInputStream(fileToBeRead));
// 创建对工作表的引用。
// 　　本例是按名引用（让我们假定那张表有着缺省名"Sheet1"）
// 也可用getSheetAt(int index)按索引引用，
// 　　在Excel文档中，第一张工作表的缺省索引是0，
// 　　其语句为：HSSFSheet sheet = workbook.getSheetAt(0);
HSSFSheet sheet= workbook.getSheet("Sheet1");
int rows = sheet.getPhysicalNumberOfRows();
for (int r = 0; r < rows; r++) {
// 　　读取左上端单元
HSSFRow row = sheet.getRow(r);
if (row != null) {
int cells = row.getPhysicalNumberOfCells();
String value = "";
// log.info(cells);
for (short c = 0; c < cells; c++) {
HSSFCell cell = row.getCell(c);
if (cell != null){
switch (cell.getCellType()) {

case HSSFCell.CELL_TYPE_FORMULA :
//
break;

case HSSFCell.CELL_TYPE_NUMERIC:
value += (long)cell.getNumericCellValue()+",";
break;

case HSSFCell.CELL_TYPE_STRING:
value += cell.getStringCellValue()+",";
break;

default:
value +="0,";
}
}
}
//下面可以将查找到的行内容用SQL语句INSERT到oracle
log.info(value);
}
}
}catch(Exception e){
System.out.println(e);
}
}

}