java读取Excel数据存入缓存_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("\\."); //.是特殊字符，需要转义&#x