Hibernate_Criteria QBC查询

package com.sun.test;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.junit.After;
import org.junit.Before;

import com.sun.dao.impl.HibernateSessionFactory;
import com.sun.entity.House;

public class QBCTest {
	private Session session;

	@Before
	public void before() {
		session = HibernateSessionFactory.getSession();
	}

	@After
	public void after() {
		session.close();
	}
    
	@org.junit.Test
	public void baseQuery(){
		Map map=new HashMap();
		map.put("title", "江荆路房屋出租");
		Criteria c=session.createCriteria(House.class);
		//c.add(Restrictions.like("title", "出租",MatchMode.ANYWHERE))
		//.add(Restrictions.between("price", 2000l, 12000l));
		c.add(Restrictions.allEq(map)).addOrder(Order.desc("price"));
		List<House> houseList=c.list();
		for(House h:houseList){
			System.out.println(h.getTitle());
		}
	}
	
	@org.junit.Test
	public void baseExample(){
		Criteria c=session.createCriteria(House.class);
		House house=new House();
		house.setTitle("江");
		//house.setPrice(3000l);
		house.setDescription("家电");
		List<House> houseList=c.add(Example.create(house).enableLike(MatchMode.ANYWHERE).excludeZeroes()).list();
		for(House h:houseList){
			System.out.println(h.getTitle());
		}
	}
	
}

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值