导入excle数据到数据库

1.需要导入的数据excle

2.导入的是csv文件，后端代码

public class CsvUtilTwo {
    /*
     * author:命运的信徒 date:2019-1-15 arm:java读取.csv文件里面的所有内容
     */
    public static List<MemberCommunicationRecord> memberPhoneRecord() {
        // 1. .csv文件的路径。注意只有一个\的要改成\\
        File csv = new File(
                "D:\\4006180571来电记录20210401.csv"); // CSV文件路径
        BufferedReader br = null;
        try {
            br = new BufferedReader(new FileReader(csv, Charset.forName("GBK")));
        } catch (IOException e) {
            e.printStackTrace();
        }
        String line = "";
        String everyLine = "";
        List<MemberCommunicationRecord> allMemberCommunicationRecord = new ArrayList<>();
        try {
            System.out.println("==================start======================");
            int count = 0;
            while ((line = br.readLine()) != null) // 读取到的内容给line变量
            {
                if (count != 0) {
                    everyLine = line;
                    String[] str = everyLine.split(",");
                    MemberCommunicationRecord memberRecord = new MemberCommunicationRecord();
                    memberRecord.setMajorPhone(str[0]);
                    memberRecord.setMajorProvince(str[1]);
                    memberRecord.setMajorCity(str[2]);
                    memberRecord.setCalledNumber(str[3]);
                    memberRecord.setCallStatus(str[4]);
                    memberRecord.setCallTime(str[5]);
                    System.out.println(everyLine);
                    allMemberCommunicationRecord.add(memberRecord);
                }
                count++;
            }
            System.out.println("csv表格中所有行数：" + allMemberCommunicationRecord.size());
            System.out.println("==================end======================");
        } catch (IOException e) {
            e.printStackTrace();
        }
        return allMemberCommunicationRecord;

    }

3.返回的是需要导入的实体对象List,最后存一下就好了。（过于简单，不多解释了）