如何利用Spring Boot和Spring Data Jpa从数据库中获取用户进行登录

Question

我想用我自己的数据库中的数据制作登录表单。我创建了实体用户类：

@Entity
@Table(name = "Auth_data")
public class User {
    @Id
    @GeneratedValue
    @Getter @Setter
    private Long id;
    @Column(name= "username")
    @Getter @Setter
    private String username;
    @Column(name="password")
    @Getter @Setter
    private String password;

    @Enumerated(EnumType.ORDINAL)
    @Column(name="role")
    @Getter @Setter
    private Role role;
    @Column(name = "client_ID")
    @Getter @Setter
    private Long clientID;
    @Column(name = "instructor_ID")
    @Getter @Setter
    private Long instructorID;

    public User() {}

    public User(String username, String password, Role role, Long clientID, Long instructorID) {
        this.username = username;
        this.password = password;
        this.role = role;
        this.clientID = clientID;
        this.instructorID = instructorID;
    }

}

@Service
public class UserDetailsServiceIml implements UserDetailsService {
    @Autowired
    private UserRepository userRepository;

    @Override
    public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {
        final User user = userRepository.findByUsername(username);
        if(user == null) {
            throw new UsernameNotFoundException(username);
        }

        Set<GrantedAuthority> grantedAuthorities = new HashSet< >();
        grantedAuthorities.add(new SimpleGrantedAuthority(user.getRole().name()));
        return new org.springframework.security.core.userdetails.User(user.getUsername(), user.getPassword(),
                grantedAuthorities);
    }
}

@Repository
public interface UserRepository extends JpaRepository<User, Long> {
    User findByUsername(String username);
}

@Repository
public interface UserRepository extends JpaRepository<User, Long> {
    @Query("Select u from User u WHERE u.username=:username")
    User findByUsername(@Param("username") String username);
}

UPD：解决了！我不知道为什么和怎么做。我发现hibernate创建了新表“auth_data”，但没有使用我的表“auth_data”。因此，我将“auth_data”重命名为“auth_data”，现在开始工作了！我还在@data上更改了@getter@setter，在用户存储库中更改了“User findByUsername（String username）；”并将字段角色的类型从枚举更改为字符串。

Answer 1

您可能没有将试图登录的用户植入数据库。如果用户不存在于数据库中，则可以使用应用程序运行器类在每次启动时为其添加种子。此外，您还可以在类级别上应用Lombok的@data注释，为所有字段生成getter和setter。

package com.javahowtos.dataseeddemo.dataseed;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.CommandLineRunner;
import org.springframework.stereotype.Component;

import com.javahowtos.dataseeddemo.model.User;
import com.javahowtos.dataseeddemo.repository.UserRepository;

@Component
public class UserDataLoader implements CommandLineRunner {

    @Autowired
    UserRepository userRepository;

    @Override
    public void run(String... args) throws Exception {
        loadUserData();
    }

    private void loadUserData() {
        if (userRepository.count() == 0) {
            User user1 = new User("John", "Doe");
            User user2 = new User("John", "Cook");
            userRepository.save(user1);
            userRepository.save(user2);
        }
        System.out.println(userRepository.count());
    }
}

来源：https://javahowtos.com/guides/107-spring/376-how-to-seed-the-database-in-spring-boot-project.html