将excel转换为mysql_将Excel数据转换为MySql表

小编典典

这是您阅读Excel文件并将其存储在集合对象中的方式

import java.io.*;

import java.util.Iterator;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadExcelFile {

public static void main(String[] args)

{

try {

FileInputStream file = new FileInputStream(new File("C:/Users/hussain.a/Desktop/newExcelFile.xlsx"));

XSSFWorkbook workbook = new XSSFWorkbook(file);

XSSFSheet sheet = workbook.getSheetAt(0);

Iterator rowIterator = sheet.iterator();

rowIterator.next();

while(rowIterator.hasNext())

{

Row row = rowIterator.next();

//For each row, iterate through each columns

Iterator cellIterator = row.cellIterator();

while(cellIterator.hasNext())

{

Cell cell = cellIterator.next();

switch(cell.getCellType())

{

case Cell.CELL_TYPE_BOOLEAN:

System.out.println("boolean===>>>"+cell.getBooleanCellValue() + "\t");

// write hibernate lines here to store it in your domain

break;

case Cell.CELL_TYPE_NUMERIC:

System.out.println("numeric===>>>"+cell.getNumericCellValue() + "\t");

// write hibernate lines here to store it in your domain

break;

case Cell.CELL_TYPE_STRING:

System.out.println("String===>>>"+cell.getStringCellValue() + "\t");

// write hibernate lines here to store it in your domain

break;

}

}

System.out.println("");

}

file.close();

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

}

}

之后，您可以使用hibernate模式并存储在您的域类中

2020-06-01