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无法实例化FlightServiceBean。 - 手动从上下文取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
相关产品推荐
相关产品推荐

