我无法调用@NamedQueries [英] I can not call @NamedQueries

问题描述

我在JSP / EL / EJB WORLD中是新的，所以请记住... heheh

我的问题是 PREVIOUS Q？

so在上述问题的评论/答案中建议使用customerFacade.findByUserName（String userName），但问题是我无法使用这样的@NamedQuery。

我的代码如下：

CustomerFacade

package $; $ $ $ $ $ $ $ $

//导入**

@Stateless
public class CustomerFacade extends AbstractFacade< Customer> {

@PersistenceContext（unitName =OnlineStorePU）
private EntityManager em;

@Override
protected EntityManager getEntityManager（）{
return em;
}

public CustomerFacade（）{
super（Customer.class）;
}

}

 包实体; 
 
 //进口*** 
 
 @Entity 
 @Table（name =customer）
 @XmlRootElement 
 @NamedQueries（ {
 @NamedQuery（name =Customer.findAll，query =SELECT c FROM Customer c），
 @NamedQuery（name =Customer.findById，query =SELECT c FROM Customer c WHERE c.id =：id），
 @NamedQuery（name =Customer.findByName，query =SELECT c FROM Customer c WHERE c.name =：name），
 @NamedQuery name =Customer.findByMobile，query =SELECT c FROM Customer c WHERE c.mobile =：mobile），
 @NamedQuery（name =Customer.findByEmail，query =SELECT c FROM Customer c WHERE c.email =：email），
 @NamedQuery（name =Customer.findByAddress，query =SELECT c FROM Customer c WHERE c.address =：address），
 @NamedQuery（name =Customer.findByFax，query =SELECT c FROM Customer c WHERE c.fax =：fax），
 @NamedQuery（name =Customer.findByTelephone，query =SELECT c FROM Customer c WHERE c .telephone =：电话），
 @NamedQuery（name =Customer.findByUser name，query =SELECT c FROM Customer c WHERE c.username =：username）}）
 
 public class Customer implements Serializable {
 / ** 
 * all generated属性从DB导入向导
 *否findAll（）或findByXxxxx（）在这里声明
 *所以这是我假设所有@NamedQueries {} 
 *以某种方式创建名称的函数的原因作为@NameQuery 
 * 
 * / 
} 
  

我的问题是否需要实现@NamedQuery作为函数，如果是这样的话？

解决方案

你必须使用这样的东西

  em.createNamedQuery（Customer.findByUsername）
 .setParameter（username，Smith）
 .getResultList（）; 
  

I'm new in the JSP/EL/EJB WORLD so take it in count please... heheh

My question is a continuation of a PREVIOUS Q?

so in the comments/answers of the question above is recommended to use customerFacade.findByUserName(String userName), but the problem is that I can't do use of such @NamedQuery.

My code is as Follow:

CustomerFacade

package Session;

//imports **

@Stateless
public class CustomerFacade extends AbstractFacade<Customer> {

  @PersistenceContext(unitName = "OnlineStorePU")
  private EntityManager em;

  @Override
  protected EntityManager getEntityManager() {
    return em;
  }

  public CustomerFacade() {
    super(Customer.class);
  }

}

Customer

package Entity;

//imports***

@Entity
@Table(name = "customer")
@XmlRootElement
@NamedQueries({
@NamedQuery(name = "Customer.findAll", query = "SELECT c FROM Customer c"),
@NamedQuery(name = "Customer.findById", query = "SELECT c FROM Customer c WHERE c.id = :id"),
@NamedQuery(name = "Customer.findByName", query = "SELECT c FROM Customer c WHERE c.name = :name"),
@NamedQuery(name = "Customer.findByMobile", query = "SELECT c FROM Customer c WHERE c.mobile = :mobile"),
@NamedQuery(name = "Customer.findByEmail", query = "SELECT c FROM Customer c WHERE c.email = :email"),
@NamedQuery(name = "Customer.findByAddress", query = "SELECT c FROM Customer c WHERE c.address = :address"),
@NamedQuery(name = "Customer.findByFax", query = "SELECT c FROM Customer c WHERE c.fax = :fax"),
@NamedQuery(name = "Customer.findByTelephone", query = "SELECT c FROM Customer c WHERE c.telephone = :telephone"),
@NamedQuery(name = "Customer.findByUsername", query = "SELECT c FROM Customer c WHERE c.username = :username")})

public class Customer implements Serializable {
  /**
  *  all generated attributes from DB import Wizard
  *  no findAll() or findByXxxxx() is declared here
  *  So that is the reason I Assume that all @NamedQueries{}
  *  are somehow creating functions with Name as @NameQuery
  *
  */
}

My question is Do I need to implement the @NamedQuery as functions, if so HOW?

解决方案

You must use something like this

em.createNamedQuery("Customer.findByUsername")
.setParameter("username", "Smith")
.getResultList();

这篇关于我无法调用@NamedQueries的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！