: QBE (Query By Example)
Criteria cri = session.createCriteria(Student.class);
cri.add(Example.create(s)); //s是一个Student对象
list cri.list();
实质:创建一个模版,比如我有一个表serial有一个 giftortoy字段,我设置serial.setgifttoy("2"),
则这个表中的所有的giftortoy为2的数据都会出来
2: QBC (Query By Criteria) 主要有Criteria,Criterion,Oder,Restrictions类组成
session = this.getSession();
Criteria cri = session.createCriteria(JdItemSerialnumber.class);
Criterion cron = Restrictions.like("customer",name);
cri.add(cron);
list = cri.list();
==============================
比较运算符
HQL运算符 QBC运算符 含义
= Restrictions.eq() 等于
<> Restrictions.not(Exprission.eq()) 不等于
> Restrictions.gt() 大于
>= Restrictions.ge() 大于等于
< restrictions.lt()="" 小于=""><= restrictions.le()="" 小于等于="" is="" null="" restrictions.isnull()="" 等于空值="" is="" not="" null="" restrictions.isnotnull()="" 非空值="" like="" restrictions.like()="" 字符串模式匹配="" and="" restrictions.and()="" 逻辑与="" and="" restrictions.conjunction()="" 逻辑与="" or="" restrictions.or()="" 逻辑或="" or="" restrictions.disjunction()="" 逻辑或="" not="" restrictions.not()="" 逻辑非="" in(列表)="" restrictions.in()="" 等于列表中的某一个值="" ont="" in(列表)="" restrictions.not(restrictions.in())不等于列表中任意一个值="" between="" x="" and="" y="" restrictions.between()="" 闭区间xy中的任意值="" not="" between="" x="" and="" y="" restrictions.not(restrictions..between())="" 小于值x或者大于值y="" 3:="" hql="" string="" hql="select s.name ,avg(s.age) from Student s group by s.name" ;="" query="" query="session.createQuery(hql);" list="query.list();" ....="" 4:="" 本地sql查询="" session="sessionFactory.openSession();" tran="session.beginTransaction();" sqlquery="" sq="session.createSQLQuery(sql);" sq.addentity(student.class);="" list="sq.list();" tran.commit();="" 5:="" qid="">=>
可以私聊我~
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....