使用java技术将Excel表格内容导入mysql数据库

1、添加POI jar包到项目的lib目录下­
2、Excel文件目录:d://excel.xls­
3、数据库字段为:num1 num2 num3 num4 num5 num6­
4、数据库名：blog­
5、表名:test­
6、编写类：连接mysql的字符串方法、插入的方法、实体类­­


1 import java.io.FileInputStream;­
2 import java.io.FileNotFoundException;­
3 import java.io.IOException;­
4 import org.apache.commons.logging.Log;­
5 import org.apache.commons.logging.LogFactory;­
6 import org.apache.poi.hssf.usermodel.HSSFCell;­
7 import org.apache.poi.hssf.usermodel.HSSFRow;­
8 import org.apache.poi.hssf.usermodel.HSSFSheet;­
9 import org.apache.poi.hssf.usermodel.HSSFWorkbook;­
10
11 public class TestExcel {­
12 //记录类的输出信息­
13 static Log log = LogFactory.getLog(TestExcel.class); ­
14 //获取Excel文档的路径­
15 public static String filePath = "D://excel.xls";­
16 public static void main(String[] args) {­
17 try {­
18 // 创建对Excel工作簿文件的引用­
19 HSSFWorkbook wookbook = new HSSFWorkbook(new FileInputStream(filePath));­
21 // 在Excel文档中，第一张工作表的缺省索引是0
22 // 其语句为：HSSFSheet sheet = workbook.getSheetAt(0);­
23 HSSFSheet sheet = wookbook.getSheet("Sheet1");­
25 //获取到Excel文件中的所有行数­
26 int rows = sheet.getPhysicalNumberOfRows();
28 //遍历行­
29 for (int i = 0; i < rows; i++) {­
30 // 读取左上端单元格­
31 HSSFRow row = sheet.getRow(i);­
32 // 行不为空­
33 if (row != null) {­
34 //获取到Excel文件中的所有的列­
35 int cells = row.getPhysicalNumberOfCells();­
36 String value = ""; ­
37 //遍历列­
38 for (int j = 0; j < cells; j++) {­
39 //获取到列的值­
40 HSSFCell cell = row.getCell(j);­
41 if (cell != null) {­
42 switch (cell.getCellType()) {­
43 case HSSFCell.CELL_TYPE_FORMULA:­
44 break;­
45 case HSSFCell.CELL_TYPE_NUMERIC:­
46 value += cell.getNumericCellValue() + ","; ­
47 break; ­
48 case HSSFCell.CELL_TYPE_STRING:­
49 value += cell.getStringCellValue() + ",";­
50 break;­
51 default:­
52 value += "0";­
53 break;­
54 }­
55 }
56 }­
57 // 将数据插入到mysql数据库中­
58 String[] val = value.split(",");­
59 TestEntity entity = new TestEntity();­
60 entity.setNum1(val[0]);­
61 entity.setNum2(val[1]);­
62 entity.setNum3(val[2]);­
63 entity.setNum4(val[3]);­
64 entity.setNum5(val[4]);­
65 entity.setNum6(val[5]);­
66 TestMethod method = new TestMethod();­
67 method.Add(entity);­
68 }­
69 }­
70 } catch (FileNotFoundException e) {­
71 e.printStackTrace();­
72 } catch (IOException e) {­
73 e.printStackTrace();­
74 }­
75 }­
76 }­