用hutool将数据库中记录和字段导出为excel(springboot+jpa)
最近在做一个接口,将数据库导出为excel,一开始想了很多方法。先展示下一开始用的方法,不是自动的,每个不同的数据库都需要再实现类重写,字段一多就很麻烦,但是逻辑比较简单:
dao层:
public interface BusCarAccidentDao extends JpaSpecificationExecutor<BusCarAccidentModel>, JpaRepository<BusCarAccidentModel, String> {
List<BusCarAccidentVo> findByPZaglqydmAndPZagljgdm(String qydm, String jgdm);
}
service:
@Override
public BaseResponse export(DataScopCtrolNoPage dataScopCtrolNoPage, HttpServletResponse httpServerResponse) throws ClassNotFoundException, NoSuchMethodException, IllegalAccessException, InvocationTargetException, IOException {
List<BusCarAccidentVo> list = busCarAccidentDao.findByPZaglqydmAndPZagljgdm(dataScopCtrolNoPage.getCountyPid(), dataScopCtrolNoPage.getStationPid());
System.out.println(JSON.toJSONString(list));
System.out.println("++++");
for(int i =0; i<list.size(); i++)
System.out.println(list.