如何使用JPA 2.0的CriteriaBuilder构建多对一关系的动态查询
我坚持使用JPA 2.0中的CriteriaBuilder构建动态查询。我的应用程序是Spring 3.0，基于Hibernate 3.6.0 + JPA 2.0。实际上我有两个实体，一个是
taUser
taContact
taUser
taContact
public class TaUser implements java.io.Serializable {
private int userId;
private TaContact taContact;
public int getUserId() {
return this.userId;
}
public void setUserId(int userId) {
this.userId = userId;
}
public TaContact getTaContact() {
return taContact;
}
public void setTaContact(TaContact taContact) {
this.taContact = taContact;
}
}
public class TaContact implements java.io.Serializable {
private int contactId;
public int getContactId() {
return this.contactId;
}
public void setContactId(int contactId) {
this.contactId = contactId;
}
private int contactNumber;
public int getContactNumber() {
return contactNumber;
}
public void setContactNumber(int contactNumber) {
this.contactNumber = contactNumber;
}
}
<entity class="com.common.model.TaUser" name="TaUser">
<table name="ta_user" />
<attributes>
<id name="userId">
<column name="USER_ID" />
<generated-value strategy="AUTO" />
</id>
<many-to-one name="taContact"
target-entity="TaContact">
<join-column name="Contact_id" />
</many-to-one>
</attributes>
</entity>
String jpql =
"select * from Tauser user where user.userId = "1" and user.taContact.contactNumber="8971329902";
Root<T> rootEntity;
TypedQuery<T> typedQuery = null;
EntityManagerFactory entityManagerFactory = this.getJpaTemplate()
.getEntityManagerFactory();
CriteriaBuilder criteriaBuilder = entityManagerFactory
.getCriteriaBuilder();
CriteriaQuery<T> criteriaQuery = criteriaBuilder.createQuery(TaUser.class);
rootEntity = criteriaQuery.from(TaUser.class);
criteriaQuery.where(criteriaBuilder.equal(rootEntity.get("userId"),
"1"));
criteriaQuery.where(criteriaBuilder.equal(rootEntity.get("taContact.contactNumber"),
"8971329902")); --- here i m getting error
at
org.hibernate.ejb.criteria.path.AbstractPathImpl.unknownAttribute(AbstractPathImpl.java:110)
at org.hibernate.ejb.criteria.path.AbstractPathImpl.locateAttribute(AbstractPathImpl.java:218)
at org.hibernate.ejb.criteria.path.AbstractPathImpl.get(AbstractPathImpl.java:189)
at com.evolvus.core.common.dao.CommonDao.findByCriteria(CommonDao.java:155)
没有找到相关结果
已邀请:
2 个回复
祁澈盘哼颗
Annotation定义查询。 您可以使用创建动态查询。Query q1=em.createQuery("SELECT TaUser AS tu WHERE tu.userId = :USERID"); //em is entityManager object q1.setInteger("USERID",34); //here 34 is the dynamic value or if there is any relationship with // another entity then set the object reference of the other entity. q1.getResultList(); //return list of data.席酱
public TaUser getUserByIdAndContactNumber( final long userId, final long contactNumber){ final CriteriaBuilder cb = entityManager.getCriteriaBuilder(); final CriteriaQuery<TaUser> query = cb.createQuery(TaUser.class); final Root<TaUser> root = query.from(TaUser.class); query .where(cb.and( cb.equal(root.get("userId"), userId), cb.equal(root.get("taContact").get("contactNumber"), contactNumber) )); return entityManager.createQuery(query).getSingleResult(); }领域的大型公路。将字段类型设置为。