Spring Boot无法创建userService Bean，JPA查询验证失败求助

我是Spring Boot新手，近期一直遇到无法创建名为userService的Bean的错误，即使在主类中添加了@ComponentScan和@EntityScan注解，问题仍未解决。堆栈跟踪显示，错误根源是UserRepository中的joinUserProductTable方法的JPA查询验证失败。

堆栈跟踪 #

Error creating bean with name 'userService': Unsatisfied dependency expressed through field 'userRepo' : nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userRepository' defined in org.simplilearn.repository.UserRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Invocation of init method failed; nested exception is org.springframework.data.repository.query.QueryCreationException: Could not create query for public abstract java.util.List org.simplilearn.repository.UserRepository.joinUserProductTable(); Reason: Validation failed for query for method public abstract java.util.List org.simplilearn.repository.UserRepository.joinUserProductTable()!; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.util.List org.simplilearn.repository.UserRepository.joinUserProductTable()!

相关代码 #

主类 #

@SpringBootApplication
//@ComponentScan(basePackages = {"org.simplilearn"})
//@EntityScan(basePackages = "org.simplilearn")
public class MedicareApplication {

    public static void main(String[] args) {
        SpringApplication.run(MedicareApplication.class, args);
    }

}

UserService类 #

@Service
public class UserService {
    @Autowired
    private UserRepository userRepo;
    
    // 保存用户到数据库(POST方法)
    public User saveUser(User user) {
        return userRepo.save(user);
    }
    
    // 从数据库查询所有用户(GET方法)
    public List<User> getUsers() {
        return userRepo.findAll();
    }
    
    // 根据ID查询用户
    public User getUserById(int id) {
        return userRepo.findById(id).orElse(null);
    }
    
    // 根据ID删除用户(DELETE方法)
    public String deleteUserById(int id) {
        userRepo.deleteById(id);
        return "ID为" + id + "的数据已成功删除!";
    }
    
    // 关联查询用户和产品表
    public List<OrderResponse> getUserProductJoinInfos() {
        return userRepo.joinUserProductTable();
    }   
}

UserRepository接口 #

@Repository
public interface UserRepository extends JpaRepository<User, Integer> {

    @Query("SELECT new org.simplilearn.entity.OrderResponse(u.UserId,u.name,u.email, u.mobile, u.address, p.medicinename, p.seller"+ ", p.price, p.description, p.quantity, p.orderDateTime) FROM User u JOIN u.products p")
    public List<OrderResponse> joinUserProductTable();
}

User实体类 #

@Entity
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int UserId;
    private int age;
    private String name;
    private String email;
    private String gender;
    private String address;
    private String mobile;

    @ManyToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    @JoinTable(name = "USER_PRODUCT_TABLE", 
               joinColumns = { @JoinColumn(name = "user_id", referencedColumnName = "UserId") }, 
               inverseJoinColumns = { @JoinColumn(name = "product_id", referencedColumnName = "pid") })
    private List<Product> products;

    public User() {
    }

    public User(int age, String name, String email, String gender, String address, String mobile, List<Product> products) {
        super();
        this.age = age;
        this.name = name;
        this.email = email;
        this.gender = gender;
        this.address = address;
        this.mobile = mobile;
        this.products = products;
    }

    public int getUserId() {
        return UserId;
    }

    public void setUserId(int userId) {
        UserId = userId;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getMobile() {
        return mobile;
    }

    public void setMobile(String mobile) {
        this.mobile = mobile;
    }

    public List<Product> getProducts() {
        return products;
    }

    public void setProducts(List<Product> products) {
        this.products = products;
    }

    @Override
    public String toString() {
        return "User [UserId=" + UserId + ", age=" + age + ", name=" + name + ", email=" + email + ", gender=" + gender
                + ", address=" + address + ", mobile=" + mobile + ", products=" + products + "]";
    }
}

问题核心在于JPA查询语句的语法或DTO构造不匹配，按以下步骤修复：

1. 修复JPA查询的字符串拼接问题 #

原查询通过字符串拼接生成，容易出现空格缺失或语法错误，改为完整字符串：

@Query("SELECT new org.simplilearn.entity.OrderResponse(u.UserId, u.name, u.email, u.mobile, u.address, p.medicinename, p.seller, p.price, p.description, p.quantity, p.orderDateTime) FROM User u JOIN u.products p")
public List<OrderResponse> joinUserProductTable();

2. 确保OrderResponse存在匹配的构造函数 #

必须保证org.simplilearn.entity.OrderResponse类有一个参数顺序、类型完全匹配的构造函数，参数依次为：
int（UserId）、String（name）、String（email）、String（mobile）、String（address）、String（medicinename）、String（seller）、对应Product的price类型、String（description）、Integer（quantity）、对应Product的orderDateTime类型

如果缺少该构造函数，JPA无法实例化DTO，会直接导致查询验证失败。

3. 校验Product实体的字段一致性 #

查询中用到的p.medicinename、p.seller、p.orderDateTime等字段，必须和Product实体类中的属性名完全一致（包括大小写），同时属性类型要和构造函数参数匹配。

4. 主类注解无需额外配置 #

@SpringBootApplication已经包含@ComponentScan、@EntityScan、@EnableJpaRepositories的功能，只要主类在org.simplilearn包或其子包下，注释掉的额外注解不需要开启。

5. 确认关联关系配置 #

检查@ManyToMany的@JoinTable配置：referencedColumnName必须和对应实体的主键名一致（User的主键是UserId，Product的主键是pid，当前配置是正确的）。

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