Spring+Hibernate系列教材（四）- 条件查询

使用HibernateTemplate进行模糊查询
其思路和直接使用hibernate有所区别

步骤1:模糊查询

步骤 1 : 模糊查询

分别使用Hql和Criteria进行模糊查询

package com.how2java.test;

import java.util.List;

import org.hibernate.criterion.DetachedCriteria;

import org.hibernate.criterion.Restrictions;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.how2java.dao.CategoryDAO;

import com.how2java.pojo.Category;

public class TestSpring {

public static void main(String[] args) {

ApplicationContext context = new ClassPathXmlApplicationContext(

new String[] { "applicationContext.xml" });

CategoryDAO dao = (CategoryDAO) context.getBean("dao");

List<Category> cs =dao.find("from Category c where c.name like ?", "%c%");

for (Category c : cs) {

System.out.println(c.getName());

}

DetachedCriteria dc = DetachedCriteria.forClass(Category.class);

dc.add(Restrictions.like("name", "%分类%"));

cs =dao.findByCriteria(dc);

for (Category c : cs) {

System.out.println(c.getName());

}