java入门019～springboot批量导入excel数据到mysql

<name>demo</name>

<description>Demo project for Spring Boot</description>



<properties>

    <java.version>1.8</java.version>

</properties>



<dependencies>

    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-web</artifactId>

    </dependency>



    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-test</artifactId>

        <scope>test</scope>

    </dependency>



    <!--  操作excel      -->

    <dependency>

        <groupId>org.apache.poi</groupId>

        <artifactId>poi</artifactId>

        <version>3.16</version>

    </dependency>



    <dependency>

        <groupId>org.apache.poi</groupId>

        <artifactId>poi-ooxml</artifactId>

        <version>3.16</version>

    </dependency>

</dependencies>



<build>

    <plugins>

        <plugin>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-maven-plugin</artifactId>

        </plugin>

    </plugins>

</build>

记得重新Reimport  

![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy82MjczNzEzLTEzMTE0MzgwMGZiYWZmNDYucG5n?x-oss-process=image/format,png)



[]( )三，创建一个controller用于接收上传的excel文件

=============================================================