ScoreCardRepository Bean未实例化引发空指针异常问题排查

问题场景 #

调用/retrieve-stats接口时，GameServiceImpl.retrieveStatsForUser方法中执行scoreCardRepository.getTotalScoreForUser(userId)抛出空指针异常，但同方法内的badgeCardRepository能正常调用。

相关代码片段 #

ScoreCardRepository接口 #

public interface ScoreCardRepository extends CrudRepository<ScoreCard, Long> {

    @Query(value = "SELECT SUM(SCORE) FROM SCORE_CARD WHERE USER_ID = :userId", nativeQuery = true)
    Integer getTotalScoreForUser(Long userId);
}

GamificationController控制器 #

@RestController
@RequestMapping("/gamification")
public class GamificationController {

    private final LeaderBoardServiceImpl leaderBoardService;
    private final GameServiceImpl gameService;

    @Autowired
    public GamificationController(GameServiceImpl gameService, LeaderBoardServiceImpl leaderBoardService){
        this.gameService = gameService;
        this.leaderBoardService = leaderBoardService;
    }

    @GetMapping("/retrieve-stats")
    ResponseEntity<GameStats> getUserStats(@RequestParam("user") String userId){
        return ResponseEntity.ok(gameService.retrieveStatsForUser(Long.parseLong(userId)));
    }
}

GameServiceImpl实现类 #

@Service
public class GameServiceImpl implements GameService {

    private final ScoreCardRepository scoreCardRepository;
    private final BadgeCardRepository badgeCardRepository;

    @Autowired
    public GameServiceImpl(ScoreCardRepository scoreCardRepository, BadgeCardRepository badgeCardRepository) {
        this.scoreCardRepository = scoreCardRepository;
        this.badgeCardRepository = badgeCardRepository;
    }

    @Override
    public GameStats retrieveStatsForUser(Long userId) {
        List<BadgeCard> badgeCardList = badgeCardRepository.findByUserIdOrderByBadgeTimestampDesc(userId);
        int totalScore = scoreCardRepository.getTotalScoreForUser(userId); // 空指针异常触发点
        GameStats gameStats = new GameStats(userId, totalScore,
                badgeCardList.stream().map(BadgeCard::getBadge).collect(Collectors.toList()));
        return gameStats;
    }
}

原因分析 #

这个空指针大概率不是scoreCardRepository未实例化，优先排查以下两类情况：

1. 自动拆箱导致的空指针：getTotalScoreForUser返回Integer类型，当数据库中没有对应用户的分数记录时，SUM(SCORE)会返回null。此时用int类型去接收返回值，会触发自动拆箱的空指针异常——这是最常见的触发原因，和Repository实例是否存在无关。
2. Repository实例化异常：如果确实是scoreCardRepository本身为null，检查以下点：
   • 该接口是否在Spring组件扫描范围内（比如是否和启动类同包/子包，或通过@EnableJpaRepositories指定了扫描路径）
   • ScoreCard实体类是否正确添加@Entity注解，映射的表名SCORE_CARD是否和数据库实际表名一致
   • 项目是否引入了spring-boot-starter-data-jpa等必要依赖

解决方案 #

方案1：处理SQL返回null的情况 #

• 方式一：在代码中判断null，避免拆箱异常

  Integer totalScore = scoreCardRepository.getTotalScoreForUser(userId);
  int finalScore = totalScore != null ? totalScore : 0;
  

• 方式二：在SQL中用COALESCE函数直接返回默认值

  @Query(value = "SELECT COALESCE(SUM(SCORE), 0) FROM SCORE_CARD WHERE USER_ID = :userId", nativeQuery = true)
  Integer getTotalScoreForUser(Long userId);
  

方案2：排查Repository实例化问题 #

• 确认启动类添加了@EnableJpaRepositories（若Repository不在启动类所在包下，需指定basePackages参数）
• 检查ScoreCard实体的@Entity、@Table注解配置是否正确
• 核对项目依赖，确保spring-boot-starter-data-jpa已引入并正常加载

内容的提问来源于stack exchange，提问作者IDK