java 读取excel存入数据库

package com.model;


import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;

import com.jfinal.plugin.activerecord.Db;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class PoiDemo {
    public String excelPath  = "D:\\Users\\user\\Desktop\\piodemo.xls";
    public void poimothed() throws FileNotFoundException{
        try {
            //String encoding = "GBK";
            File excel = new File(excelPath);
            if (excel.isFile() && excel.exists()) {   //判断文件是否存在

                String[] split = excel.getName().split("\\.");  //.是特殊字符，需要转义！！！！！
                Workbook wb=null;
                //根据文件后缀（xls/xlsx）进行判断
                if ( "xls".equals(split[1])){
                    FileInputStream fis = new FileInputStream(excel);   //文件流对象
                    wb = new HSSFWorkbook(fis);
                }else if ("xlsx".equals(split[1])){

                }else {
                    System.out.println("文件类型错误!");
                    return;
                }

                //开始解析
                Sheet sheet = wb.getSheetAt(0);     //读取sheet 0

                int firstRowIndex = sheet.getFirstRowNum()+2;   //第一行是列名，所以不读
                int lastRowIndex = sheet.getLastRowNum();
                System.out.println("firstRowIndex: "+firstRowIndex);
                System.out.println("lastRowIndex: "+lastRowIndex);
                String consolation_leader=null;
                String grouping_company=null;
                String accompany_leader=null;
                String liaison_man=null;
                String contacts_man=null;
                for(int rIndex = firstRowIndex; rIndex <= lastRowIndex; rIndex++) {   //遍历行
                    System.out.println("rIndex: " + rIndex);
                    Row row = sheet.getRow(rIndex);
                    if (row != null) {
                        int firstCellIndex = row.getFirstCellNum();
                        int lastCellIndex = row.getLastCellNum();
                        String consolation_level=null;
                        String name=null;
                        String sex=null;
                        String birthday=null;
                        String join_party_time=null;
                        String grouping_Basics=null;
                        String address=null;
                        String lntroduction=null;
                        for (int cIndex = firstCellIndex; cIndex < lastCellIndex; cIndex++) {   //遍历列
                            Cell cell = row.getCell(cIndex);
                            if (cell != null&&!"".equals(cell.toString().trim())) {
                                switch(cIndex)
                                {
                                    case 1:
                                        consolation_leader=cell.toString();
                                        System.out.println("1:"+consolation_leader);
                                        break;
                                    case 2:
                                        consolation_level=cell.toString();
                                        System.out.println("2:"+consolation_level);
                                        break;
                                    case 3:
                                        name=cell.toString();
                                        System.out.println("3:"+name);
                                        break;
                                    case 4:
                                        sex=cell.toString();
                                        System.out.println("4:"+sex);
                                        break;
                                    case 5:
                                        birthday=cell.toString();
                                        System.out.println("5:"+birthday);
                                        break;
                                    case 6:
                                        join_party_time=cell.toString();
                                        System.out.println("6:"+join_party_time);
                                        break;
                                    case 7:
                                        grouping_Basics=cell.toString();
                                        System.out.println("7:"+grouping_Basics);
                                        break;
                                    case 8:
                                        address=cell.toString();
                                        System.out.println("8:"+address);
                                        break;
                                    case 9:
                                        lntroduction=cell.toString();
                                        System.out.println("9:"+lntroduction);
                                        break;
                                    case 10:
                                        grouping_company=cell.toString();
                                        System.out.println("10:"+grouping_company);
                                        break;
                                    case 11:
                                        accompany_leader=cell.toString();
                                        System.out.println("11:"+accompany_leader);
                                        break;
                                    case 12:
                                        liaison_man=cell.toString();
                                        System.out.println("12:"+liaison_man);
                                        break;
                                    case 13:
                                        contacts_man=cell.toString();
                                        System.out.println("13:"+contacts_man);
                                        break;
                                    default:
                                        break;
                                }

                            }

                        }
                        insertMethod(consolation_leader,consolation_level,name,sex,birthday,join_party_time,grouping_Basics,address,lntroduction,grouping_company,accompany_leader,liaison_man,contacts_man);


                    }
                }
            } else {
                System.out.println("找不到指定的文件");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

    }
    public void insertMethod(String consolation_leader,String consolation_level,String name,String sex,String birthday,String join_party_time,String grouping_Basics,String address,String lntroduction,String grouping_company,String accompany_leader,String liaison_man,String contacts_man){
        String sql="insert into condolences(consolation_leader,consolation_level,name,sex,birthday,join_party_time,grouping_Basics,address,lntroduction,grouping_company,accompany_leader,liaison_man,contacts_man) values(?,?,?,?,?,?,?,?,?,?,?,?,?)";


        Db.update(sql,consolation_leader,consolation_level,name,sex,birthday,join_party_time,grouping_Basics,address,lntroduction,grouping_company,accompany_leader,liaison_man,contacts_man);
    }
}

<dependency>
  <groupId>org.apache.poi</groupId>
  <artifactId>poi</artifactId>
  <version>3.15</version>
</dependency>

<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
  <groupId>org.apache.poi</groupId>
  <artifactId>poi-ooxml</artifactId>
  <version>3.15</version>
</dependency>