使用HibernateTemplate进行模糊查询
其思路和直接使用hibernate有所区别
其思路和直接使用hibernate有所区别
- 模糊查询
分别使用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()); } } }