JPA_Criteria

CriteriaInfo

import com.creditcloud.model.criteria.CriteriaInfo;
XxxxxServiceBean.java 里的代码============================================
//只有一个参数的查询条件
ParamInfo paramInfo = new ParamInfo();
paramInfo.add("type", type, ParamOperator.AND,QueryOperator.EQ);
paramInfo.add("id", loanIdList, ParamOperator.AND,QueryOperator.IN);//List<String> loanIdList
CriteriaInfo criteriaInfo = new CriteriaInfo(paramInfo,PageInfo.ALL,null);

//没有参数只排序查询
SortInfo sortInfo = new SortInfo("createTime",true);//倒序  不加true的参数为正序
CriteriaInfo criteriaInfo = new CriteriaInfo(paramInfo,PageInfo.ALL,sortInfo);
PagedResult<xxx> pagedResult = xxxDao.list(criteriaInfo);

Count 及NativeQuery

StringBuffer sb = new StringBuffer();
sb.append("select count(*) from tb_user WHERE LOGINNAME = ?");
Query query =  getEntityManager().createNativeQuery(sb.toString())
                                 .setParameter(1, "maqingbin0017");
Object count = query.getSingleResult();//count(*)-->转成Long  int(11)-->转到Integer Amount-->转成BigDecimal
return (Long)count;
如果多个列的NativeQuery
List<Object[]> list = query.getResultList();
if(list!=null&&list.size()>0){
        for(int i=0;i<list.size();i++){
            Object[] obj = (Object[])list.get(i);
            obj[0] 转成对应的类型
        }
}

HQL

sb.append("select vi from VirtualProduct vi
                                        where vi.status=:status
                                        and :nowDate>=vi.startTime
                                        and :nowDate<=vi.endTime
                                        and mobile in :mobile");
Query query =  getEntityManager().createQuery(sb.toString(), VirtualProduct.class)
                    .setParameter("status", "1")//1上架中
                    .setParameter("nowDate", new Date())
                    .setParameter("mobile", List<String> mobile);
                    .setHint("eclipselink.refresh", "True");//每次从数据库里取不从缓存里取
PageInfo pageInfo = new PageInfo(0, DEFAULT_SIZE) ;//import com.creditcloud.model.criteria.PageInfo     
//分布             
query.setFirstResult(pageInfo.getOffset());
query.setMaxResults(pageInfo.getSize())
//import org.eclipse.persistence.config.HintValues;
//import org.eclipse.persistence.config.QueryHints;
query.setHint(QueryHints.REFRESH, HintValues.TRUE);
//<dependency>
    //<groupId>org.eclipse.persistence</groupId>
    //<artifactId>eclipselink</artifactId>
    //<version>2.5.0</version>
    //<type>jar</type>
//</dependency>
List<VirtualProduct> virtualProductList=query.getResultList();
//本地时间范围**************
lr.repayment.dueDate between :from and :to

@NamedQuery

import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;

在实体类的上方增加代码

@NamedQueries({
        @NamedQuery(name = "xxx实体类.listxxx方法名",
            query = "select v(或者count(v.id)) from Xxxx v where v.xxx=:channel in :mobile"),
    })

在Dao层增加的代码

//关于count(*)在Dao层的代码
Long result = getEntityManager().createNamedQuery("VirtualProduct.findInvestByVrPid", Long.class)
.setParameter("vrPid", id)
.setParameter("mobile", List<String> mobile)
.getSingleResult();
return result == null ? 0 : result.intValue();
//关于List在Dao层的代码
List<VirtualProduct> virtualProductList=getEntityManager()
.createNamedQuery("VirtualProduct.listByStatus", VirtualProduct.class)
.setParameter("status", status)
//PageInfo pageInfo = new PageInfo(0, DEFAULT_SIZE) ;//import com.creditcloud.model.criteria.PageInfo
.setFirstResult(pageInfo.getOffset());
.setMaxResults(pageInfo.getSize())
.getResultList();
return virtualProductList;