Wyciąganie rekordów z bazy danych JPA

Question

Mój problem polega na tym, że chciałbym wyciągnąć z bazy role dla użytkownika o konkretnym id przy pomocy JPA. W jaki sposób powinienem sformułować zapytanie?

@Entity
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private long id;

    private String username;

    private String password;

    private String firstname;

    private String lastname;

    private String email;

    @ManyToMany
    private Set<Role> roles;

    public User() {
    }

    public long getId() {
        return 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 String getFirstname() {
        return firstname;
    }

    public void setFirstname(String firstname) {
        this.firstname = firstname;
    }

    public String getLastname() {
        return lastname;
    }

    public void setLastname(String lastname) {
        this.lastname = lastname;
    }

    public String getEmail() {
        return email;
    }

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

    public Set<Role> getRoles() {
        return roles;
    }

    public void setRoles(Set<Role> roles) {
        this.roles = roles;
    }
}

@Entity
@Table(name = "role")
public class Role {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String name;

    @ManyToMany(mappedBy = "roles")
    private Set<User> users;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

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

    public Set<User> getUsers() {
        return users;
    }

    public void setUsers(Set<User> users) {
        this.users = users;
    }
}

@Override
    public List<String> getUserRole(User user) {
        return entityManager.createQuery(??????????);
    }

 

Comments

Korzystasz z JpaRepository?

Answer 1

W jpa nie jestem pewien, ale w Hibernate jest w sesji metoda:

session.get(User.class, IdNumber);

 

A w Twoim przypadku może: "from User s Where s.id = '1'";

Przynajmniej tak sobie myślę