java – EclipseLink(非OSGi)与EclipseLink JPA之间的区别

EclipseLink的主要优点之一是您可以直接在JPQL查询中调用本机SQL函数.在Hibernate中,这不是直接可能的.

具有命名查询的示例实体类 –

@Entity
@Table(name = "authorizedUsers",schema = "public")

@NamedQuery(name = "AuthorizedUsers.findByAll",query = "SELECT a FROM AuthorizedUsers a where a.username = :username and a.password = :password")
public class AuthorizedUsers implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @Column(name = "id")
    private Integer id;

    @Column(name = "username")
    private String username;

    @Column(name = "password")
    private String password;

    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 List<AuthorizedUsers> findFragmentByAll(String username,String password)
            throws PersistenceException,IllegalStateException {

        if (em != null) {
            final Query query = em.createNamedQuery("AuthorizedUsers.findByAll");
            query.setParameter("username",username);
            query.setParameter("password",password);
            return query.getResultList();
        }

而em是实体管理器的一个实例.