文章/答案/技术大牛

发布

社区首页 >问答首页 >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.

用户类

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;
    }
    
}

用户城市类

    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;
        }
    
    }

用户存储库

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);
}

用户城市存储库

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应用程序类

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);
        

    }

}

java

spring-boot

spring-data-jpa

one-to-many

Stack Overflow用户

回答已采纳

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

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

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

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

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

票数 0

查看全部 1 条回答

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

原文链接：

https://stackoverflow.com/questions/63640492

复制

相似问题

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

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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