Spring Boot整合Spring JDBC时NamedParameterJdbcTemplate抛出NullPointerException问题排查

Let's walk through the possible issues causing this NPE and fix them one by one:

1. The Most Likely Culprit: Injection Method Naming #

Look at your autowired setter method:

@Autowired
private void setjdbcTemplate(NamedParameterJdbcTemplate jdbcTemplate) {
    this.jdbcTemplate = jdbcTemplate;
}

The method name setjdbcTemplate doesn't follow standard JavaBean camelCase conventions—it should be setJdbcTemplate (capital J). While @Autowired typically injects by type, non-standard method names can sometimes confuse Spring's dependency injection mechanism, leading to failed injection.

A simpler approach is to use field injection directly (no need for a setter):

@Repository
@Transactional
public class UserDaoImpl implements UserDao {
    @Autowired
    private NamedParameterJdbcTemplate jdbcTemplate;
    private static final String TABLE_NAME = "users"; // Don't forget the String type here!

    // Rest of your code...
}

2. Syntax Error in Constant Declaration #

Your TABLE_NAME definition is missing the type:

// Wrong: missing String type
private static final TABLE_NAME = "users";

// Correct:
private static final String TABLE_NAME = "users";

This is a basic syntax error that would prevent your class from compiling. If your app is running, you probably just missed the type when pasting code, but fixing this is mandatory to avoid other issues down the line.

3. Component Scanning Scope #

Make sure your UserDaoImpl is within Spring Boot's component scanning range. The @SpringBootApplication annotation automatically scans the package containing your main application class and all its sub-packages.

For example:

• If your main class is in com.myapp, and UserDaoImpl is in com.myapp.dao, you're good.
• If UserDaoImpl is in a sibling package like com.myappdata.dao, you'll need to explicitly expand the scan range in your main class:

@SpringBootApplication
@ComponentScan(basePackages = {"com.myapp", "com.myappdata"})
public class YourApplication {
    public static void main(String[] args) {
        SpringApplication.run(YourApplication.class, args);
    }
}

4. Verify Dependencies Are Correct #

Spring Boot auto-creates NamedParameterJdbcTemplate only if you have the right dependencies. Check your build file:

Maven (pom.xml) #

<dependencies>
    <!-- Required for JDBC auto-configuration -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <!-- MySQL driver -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>
</dependencies>

Gradle (build.gradle) #

dependencies {
    implementation 'org.springframework.boot:spring-boot-starter-jdbc'
    runtimeOnly 'mysql:mysql-connector-java'
}

Without spring-boot-starter-jdbc, Spring won't create the NamedParameterJdbcTemplate bean at all—so injection will fail every time.

5. Quick Check on Transaction Configuration #

While this isn't the root cause of your NPE, just to confirm: @SpringBootApplication already includes @EnableTransactionManagement, so your @Transactional annotations should work fine once the bean is properly injected.

Start with fixing the setter method naming/switching to field injection and the constant type issue—those are the most probable fixes. Then double-check dependencies and component scanning if the problem persists.

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