使用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 }­