把Execl中的数据导入mysql数据库当中

把Execl中的数据导入mysql数据库当中,一运行就空指针异常,错误提示应该找类中的 Statement,但是没太弄懂。

img

img

img

import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

public class PoiRead {
    public static void main(String[] args) throws Exception {
        ArrayList<String> cars = new ArrayList<String>();
        String PATH = "C:\\Users\\李晓彬\\Desktop\\汽车信息表.xlsx";
        FileInputStream inputStream = new FileInputStream(PATH);
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        XSSFSheet sheet = workbook.getSheetAt(0);



        for (int i = 0; i < 6; i++) {
            XSSFRow row = sheet.getRow(i);
            int cellCount = row.getPhysicalNumberOfCells();
            for (int cellNumber = 0; cellNumber < cellCount; cellNumber++) {
                XSSFCell cell = row.getCell(cellNumber);
                if (cell != null) {
                    CellType cellType = cell.getCellType();
                   // System.out.print(cell.getStringCellValue());
                    cars.add(cell.getStringCellValue());
                }

            }


       }

        Connection connection = null;
        Statement statement;
        ResultSet resultSet=null;

            statement=connection.createStatement();
            int n=0;
            String sql=null;
            //迭代List,批量入库。
            for (String car:cars
            ) {
                statement.executeBatch();
                sql = "insert into car_information (car_id,car_name,car_people,car_room,car_day) values ('"+car+"')";
                statement.executeUpdate(sql);

            }


            connection.commit();

    }

}

img

img

Connetion c = DriverManager.getConnection(url,user,password);