十.JPQL基础

一.
面向对象表达式语言表达式,可被编译为所有主流数据库SQL。
select u.name,u.income from user u;
name,income是属性名，下面代码执行后的list里面每个含有一个对象数组，每个数组里面有两值。

String queryString = "";        Query query = entityManager.createQuery(queryString);        List list = query.getResultList();

所有喜欢体育的：member of: select u from User u where :interest member of u.interests
interest设置一下参数
二.内置函数：
contact(u.name,’同学’)
substring(u.name,1,1)
trim(leading ‘小’ from u.name)
trim(trailing ‘小’ from u.name)
trim(both ‘小’ from u.name)
upper
lower
length
locate(‘小’,u.name,1)
CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP
ABS, SQRT, MOD, SIZE