You need to enable JavaScript to run this app. Spring Boot启动时如何自动填充数据库?遇Bean创建错误求解
优惠活动
大模型
产品
解决方案
定价
更多

Spring Boot启动时如何自动填充数据库?遇Bean创建错误求解

Spring Boot启动时自动读取CSV填充数据库实现问题及报错排查

需求说明

  • 开发的应用需要读取指定文件夹下的CSV文件,将解析后的数据存入数据库
  • 希望实现Spring Boot程序启动时自动完成数据库填充操作,无需手动触发接口或调用方法

现有实现代码

FlightService.java

package com.package.service;

@Service
public class FlightService{
    File dir = new File("C:\\Users\\Akhil\\Desktop\\assignmentFour\\CSV");
    static FlightDao flightDao = (FlightDao) AppContextUtil.context.getBean("flightDao");
    
    public void readCSV() {
        File files[] = dir.listFiles();
        ArrayList<String> listofFileNames = new ArrayList<String>();
        for (File file : files) {
            Airline airline = FlightController.readFile(file);
            flightDao.saveAirline(airline);
        }
    }
}

FlightController.java

package com.package.controller;

public class FlightController {

    public static final SimpleDateFormat dateformat = new SimpleDateFormat("dd-MM-yyyy");
    
    public static Airline readFile(File file) {
        BufferedReader reader = null;
        Airline aObj = new Airline();
        aObj.setName(file.getName());
        HashSet<Flight> flight_Set = new HashSet<Flight>();
        try {
            reader = new BufferedReader(new FileReader(file));
            String line = reader.readLine();
            line = reader.readLine();
            
            while (line != null) {
                Flight f = manipulateLine(line,aObj);
                line = reader.readLine();
                flight_Set.add(f);
            }
        } catch (Exception e) {
            System.err.println("Could Not Read the File");
        } finally {
            if (reader != null) {
                try {
                    reader.close();
                } catch (Exception e) {
                    System.err.println("Could Not Close the File");
                }
            }
        }
        aObj.setFlights(flight_Set); 
        return aObj;
    }

    private static Flight manipulateLine(String line, Airline aObj) {

        StringTokenizer st = new StringTokenizer(line, "|");

        String flightNo = st.nextToken();
        String depLoc = st.nextToken();
        String arrLoc = st.nextToken();

        String validTillDate = st.nextToken();
        Date validTill = new Date();
        try {
            validTill = dateformat.parse(validTillDate);
        } catch (ParseException e) {
            System.err.print("Date not in appropriate(dd-MM-yyyy) format");
        }

        int flightTime = Integer.parseInt(st.nextToken());
        Double flightDuration = Double.parseDouble(st.nextToken());
        int fare = Integer.parseInt(st.nextToken());

        String avail = st.nextToken();
        Boolean seatAvailability;
        if (avail.charAt(0) == 'Y')
            seatAvailability = true;
        else
            seatAvailability = false;

        String flightClass = st.nextToken();

        return new Flight(flightNo, depLoc, arrLoc, fare, validTill,
                flightTime, flightDuration, seatAvailability, flightClass,aObj);
    }
}

URL处理控制器FlightCont.java

package com.package.controller;

@Controller
public class FlightCont {
    
    @RequestMapping(value ="/flightSearch" , method=RequestMethod.POST)
    public ModelAndView flightSearch(@Valid @ModelAttribute("flightDetails")FlightDetailsEntered flightDetails,BindingResult result){
        
        ModelAndView modelAndView =new ModelAndView("flightSearch");
        if(result.hasErrors())
        { 
            System.err.println(result);
            return modelAndView ;
        }
        List<Flight> listOfMatchingFlights= flightDetails.getListOfMatchingFlights();
        modelAndView = new ModelAndView("flightList");
        modelAndView.addObject("list", listOfMatchingFlights);
        return modelAndView ;
    }
}

运行报错信息

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flightService' defined in file [C:\Users\Akhil\Desktop\project\target\classes\com\package\service\FlightService.class]: Instantiation of bean failed; nested exception is java.lang.ExceptionInInitializerError

问题排查与解决方案

1. 报错根源

报错核心触发点在FlightService的静态变量初始化逻辑:

static FlightDao flightDao = (FlightDao) AppContextUtil.context.getBean("flightDao");
  • 静态变量初始化属于类加载阶段执行逻辑,此时Spring IoC容器尚未完成初始化,AppContextUtil.context大概率为null,直接调用getBean会抛出空指针异常,最终触发ExceptionInInitializerError,导致Spring无法实例化FlightService Bean。
  • 手动从上下文取Bean的写法不符合Spring依赖注入规范,冗余且易错。

2. 报错修复方案

  • 移除静态变量直接取Bean的逻辑,改用@Autowired注解注入FlightDao实例
  • 补充目录存在性判断,避免dir.listFiles()返回null导致的后续空指针
    改造后的基础FlightService代码:
package com.package.service;

@Service
public class FlightService{
    @Autowired
    private FlightDao flightDao;

    private final File dir = new File("C:\\Users\\Akhil\\Desktop\\assignmentFour\\CSV");
    
    public void readCSV() {
        // 校验目录有效性
        if(!dir.exists() || !dir.isDirectory()){
            System.err.println("指定CSV目录不存在:" + dir.getAbsolutePath());
            return;
        }
        // 仅读取CSV格式文件
        File files[] = dir.listFiles((d, name) -> name.endsWith(".csv"));
        if(files == null || files.length == 0){
            System.out.println("目录下无有效CSV文件,跳过数据填充");
            return;
        }
        for (File file : files) {
            Airline airline = FlightController.readFile(file);
            flightDao.saveAirline(airline);
        }
    }
}

3. 启动时自动执行填充逻辑实现

Spring Boot支持两种启动后自动执行任务的方案,优先选用CommandLineRunner(确保数据库连接等组件初始化完成后再执行逻辑):

方案:实现CommandLineRunner接口

让FlightService实现CommandLineRunner接口,容器启动完成后会自动执行run方法内的逻辑:

package com.package.service;

@Service
public class FlightService implements CommandLineRunner {
    @Autowired
    private FlightDao flightDao;

    private final File dir = new File("C:\\Users\\Akhil\\Desktop\\assignmentFour\\CSV");
    
    @Override
    public void run(String... args) throws Exception {
        // 启动后自动触发读CSV填充逻辑
        readCSV();
    }

    // 原有readCSV逻辑保持不变
    public void readCSV() {
        if(!dir.exists() || !dir.isDirectory()){
            System.err.println("指定CSV目录不存在:" + dir.getAbsolutePath());
            return;
        }
        File files[] = dir.listFiles((d, name) -> name.endsWith(".csv"));
        if(files == null || files.length == 0){
            System.out.println("目录下无有效CSV文件,跳过数据填充");
            return;
        }
        for (File file : files) {
            Airline airline = FlightController.readFile(file);
            flightDao.saveAirline(airline);
        }
    }
}

其他优化建议

  • 纯工具性质的CSV解析逻辑(原FlightController)建议移至util或service包下,避免web层分层混乱
  • CSV硬编码绝对路径可移植性差,建议将路径配置至application.properties,通过@Value注解注入:
    @Value("${csv.file.dir:C:\\Users\\Akhil\\Desktop\\assignmentFour\\CSV}")
    private String csvDirPath;
    
  • 原有读CSV逻辑中直接跳过前两行的写法可读性差,建议显式判断表头,避免空行导致的读取异常
    内容的提问来源于stack exchange,提问作者Akhil Garg
相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.11.13 08:54:05