java - 按字段选择 hibernate

Question

我有这样的结构

package logic;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

import org.hibernate.annotations.GenericGenerator;

@Entity
@Table(name="users")
public class user {
    private Long id;
    private String name;
    private String pass;

    public user(){
        name = null;
    }

    public user(user u){
        name = u.getName();
    }

    @Id
    @GeneratedValue(generator = "increment")
    @GenericGenerator(name="increment", strategy = "increment")
    @Column(name="id")
    public Long getId(){
        return id;
    }

    @Column(name = "username", unique = true)
    public String getName() {
        return name;
    }

    @Column(name = "password")
    public String getPass(){
        return pass;
    }

    public void setId(Long i){
        id = i;
    }

    public void setName(String n){
        name = n;
    }

    public void setPass(String p){
        pass = p;
    }
}

我想通过用户名从这个表中进行选择，在 SQL 中像这样 select * from users where username = "abc";，但是我如何使用 hibernate 来做到这一点？

Answer 1

这样做

Query query = getSession().createQuery("from user where name =:name ")
            .setParameter("name ", "abc");

名称为 abc 的单个用户

 user u = (user) query.uniqueResult();

名为 abc 的所有用户

 List list = query.list();