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