从Excel里面读出数据，并将数据存入数据库

package com.hzm.sample; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.sql.Connection; import java.sql.SQLException; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.poifs.filesystem.POIFSFileSystem; import com.mocenter.db.ODBHandler; public class ReadExcel { private static String path = "c:/book1.xls"; double util[][] = new double[10][10]; // 表(sheet)－－－>行(row)－－>行里面的存储格(cell) public void readExcel(String excelPath) { excelPath = path; try { // 创建对Excel工作簿文件的引用 FileInputStream finput = new FileInputStream(excelPath); POIFSFileSystem fs = new POIFSFileSystem(finput); HSSFWorkbook wb = new HSSFWorkbook(fs);//HSSFWorkbook对象代表一个Excel文档 HSSFRow row = null;// 宣告一行 HSSFCell cell = null;// 宣告一个储存格 int num = wb.getNumberOfSheets();// 工作表sheet的数量 System.out.println("当前工作表数量是：" + num); int i = 0; short y = 0; for (int sheetNum = 0; sheetNum <num; sheetNum++) { if (wb.getSheetAt(sheetNum)!=null) {//如果工作表存在 HSSFSheet curSheet = wb.getSheetAt(sheetNum); // 获取工作表 System.out.println(wb.getSheetName(sheetNum));// 获取当前工作表名字 for (i = 1; i <= curSheet.getLastRowNum(); i++) { if (null != curSheet.getRow(i)) {//如果当前行存在 row = curSheet.getRow(i);// 获取工作行 System.out.println("当前工作行row=" + row); System.out.println("当前行中工作存储格的个数为" + row.getLastCellNum()); for (y = 0; y < row.getLastCellNum(); y++) {//获取工作存储格的个数 if(null!=row.getCell(y)){ cell = row.getCell(y);// 获取工作存储格 System.out.println("当前存储格为" + cell); int t = cell.getCellType(); switch (t) { case 0:// Numeric cell.getNumericCellValue(); // cell.setCellValue(); System.out.println(cell .getNumericCellValue()); // util[y][i]=cell.getNumericCellValue(); break; case 1:// String cell.getStringCellValue(); System.out.println(cell .getStringCellValue()); // util[y][i]=cell.getNumericCellValue(); break; case HSSFCell.CELL_TYPE_FORMULA: cell.getNumericCellValue(); System.out.println(cell .getNumericCellValue()); // util[y][i]=cell.getNumericCellValue(); break; default: System.out.println("�����ʽ其它类型" + " \t"); break; } } } } } } } } catch (Exception e) { e.printStackTrace(); } } public void insertDb(String id,String name,String number){ ODBHandler db1 = new ODBHandler();//默认数据库 String sql = "insert into test(id,name,number) values('"+id+"'"+name+"','"+number+"')"; try { db1.update(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) { ReadExcel demo = new ReadExcel(); demo.readExcel("s"); } }