文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >Spring Boot“无法执行CommandLineRunner错误”

问Spring Boot“无法执行CommandLineRunner错误”
EN

Stack Overflow用户
提问于 2020-08-29 04:29:05
回答 1查看 146关注 0票数 2

我试图将一对多注释添加到我的spring boot项目中，但是当我运行我的项目时，我得到了"Failed to execute CommandLineRunner“错误。我希望用户表中的用户拥有多个城市。因此，我尝试添加OneToMany注释。

You can see the error at the attachment.

用户类

代码语言：javascript
复制
package io.javabrains.springsecurity.jpa.models;
import com.spring.weather.*;

import java.util.*;
import java.util.List;

import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.OneToMany;
import javax.persistence.Table;

@Entity
@Table(name="app_user")
public class User {
    @Id
    @GeneratedValue(strategy =GenerationType.AUTO)
    private int id;
    private String userName;
    private String password;
    private boolean active;
    private String role;
    private String city;
    
    @OneToMany(targetEntity = UserCity.class,cascade = CascadeType.ALL)
    @JoinTable(name="USER_CITY",joinColumns=@JoinColumn(name="m_user_id"),
    inverseJoinColumns=@JoinColumn(name="cityId"))
    private List<UserCity> usercity;
    public User() {
        super();
        // TODO Auto-generated constructor stub
    }
    public List<UserCity> getUsercity() {
        return usercity;
    }
    public void setUsercity(List<UserCity> usercity) {
        this.usercity = usercity;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUserName() {
        return userName;
    }
    public void setUserName(String userName) {
        this.userName = userName;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public boolean isActive() {
        return active;
    }
    public void setActive(boolean active) {
        this.active = active;
    }
    public String getRole() {
        return role;
    }
    public void setRole(String role) {
        this.role = role;
    }
    
    
    public String getCity() {
        return city;
    }
    public void setCity(String city) {
        this.city = city;
    }
    
}

用户城市类

代码语言：javascript
复制
    package io.javabrains.springsecurity.jpa.models;
    
    import javax.persistence.Entity;
    import javax.persistence.FetchType;
    import javax.persistence.GeneratedValue;
    import javax.persistence.GenerationType;
    import javax.persistence.Id;
    import javax.persistence.JoinColumn;
    import javax.persistence.ManyToOne;
    import javax.persistence.Table;
    
    
    @Entity
    @Table(name="user_city")
    public class UserCity {
        @Id
        @GeneratedValue(strategy =GenerationType.AUTO)  
        private int cityId;
        private String cityName;
    
        public UserCity() {
            super();
            // TODO Auto-generated constructor stub
        }
        
    
        public UserCity(int cityId, String cityName, User mUser) {
            super();
            this.cityId = cityId;
            this.cityName = cityName;
            this.mUser = mUser;
        }
    
    
        @ManyToOne
        private User mUser;
    
        public int getCityId() {
            return cityId;
        }
    
        public void setCityId(int cityId) {
            this.cityId = cityId;
        }
    
        public String getCityName() {
            return cityName;
        }
    
        public void setCityName(String cityName) {
            this.cityName = cityName;
        }
    
        
    
        public User getmUser() {
            return mUser;
        }
    
        public void setmUser(User mUser) {
            this.mUser = mUser;
        }
    
    }

用户存储库

代码语言：javascript
复制
package io.javabrains.springsecurity.jpa;

import java.util.Optional;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

import io.javabrains.springsecurity.jpa.models.User;

public interface UserRepository extends JpaRepository<User, Integer> {
    Optional<User> findByUserName(String userName);
}

用户城市存储库

代码语言：javascript
复制
package io.javabrains.springsecurity.jpa;

import org.springframework.data.jpa.repository.JpaRepository;

import io.javabrains.springsecurity.jpa.models.User;
import io.javabrains.springsecurity.jpa.models.UserCity;

public interface CityRepository extends JpaRepository<UserCity,id>{
}

Spring应用程序类

代码语言：javascript
复制
package io.javabrains.springsecurity.jpa;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.CommandLineRunner;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.Bean;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;

import com.spring.weather.WeatherService;

import io.javabrains.springsecurity.jpa.models.User;
import io.javabrains.springsecurity.jpa.models.UserCity;




@SpringBootApplication
@EnableJpaRepositories(basePackageClasses = UserRepository.class)

public class SpringsecurityApplication implements CommandLineRunner{
    @Bean
    public WeatherService ws() {
        return new WeatherService ();
    }
    
    
    @Autowired
     UserRepository userRepository;
     CityRepository cityRepository;
    public static void main(String[] args) {
        SpringApplication.run(SpringsecurityApplication.class, args);
    }

    @Override
    public void run(String... args) throws Exception {
        // TODO Auto-generated method stub
        System.out.println("Application Running.");
        User adminUser= new User();
        UserCity ucity=new UserCity();
        UserCity ucity2=new UserCity();
        ucity.setCityName("amsterdam");
    
       
        
        adminUser.setUserName("Admin");
        adminUser.setPassword(new BCryptPasswordEncoder().encode("pass"));
        adminUser.setRole("ROLE_ADMIN");
        adminUser.setActive(true);
        adminUser.setCity("bologna");
        ucity.setmUser(adminUser);
        userRepository.save(adminUser);
        cityRepository.save(ucity);
        
        
        
        User newUser= new User();
        newUser.setUserName("User");
        newUser.setPassword(new BCryptPasswordEncoder().encode("pass"));
        newUser.setRole("ROLE_USER");
        newUser.setActive(true);
        newUser.setCity("maribor");
        ucity2.setmUser(newUser);
        userRepository.save(newUser);
        cityRepository.save(ucity2);
        

    }

}
spring-data-jpa
one-to-many
java
spring-boot
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2020-08-29 05:06:48

您遇到的问题，更具体地说是主应用程序的第54行的NullPointerException，是由cityRepository未实例化的事实引起的。

查看您的配置，我发现您只注册了带有@EnableJpaRepositories注释的UserRepository。

尝试将CityRepository添加到@EnableJpaRepositories，并将此bean指定为自动装配的候选对象(还要将@Autowired添加到此bean，就像您对UserRepository所做的那样)

作为一个好的实践，遵循MVC结构，最好是将所有的spring存储库、负责数据库的所有CRUD操作的bean放在同一个包中

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/63640492

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档