searchdao.java

来自「仿照google电子地图制作.基本实现电子地图功能,放大缩小及拖拉功能.」· Java 代码 · 共 47 行

package com.dao.impl;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;

import com.dao.ISearchDAO;
import com.util.HibernateSessionFactory;
import com.vo.Search;

public class SearchDAO implements ISearchDAO
{

	private Session session = null;
	
	public SearchDAO()
	{
		session = HibernateSessionFactory.getSession();
	}
	
	public static SearchDAO getinstance()
	{
		return new SearchDAO();
	}
	//按关键字搜索
	public List queryByKey(String key)
	{
		Criteria criteria = session.createCriteria(Search.class).add(Restrictions.like("keyword", key+"%"));
		List list = criteria.list();
		session.close();
		return list;
	}
	//测试
	public static void main(String args[])
	{
		List<Search> list = SearchDAO.getinstance().queryByKey("张");
		for(int i = 0; i < list.size(); i ++)
		{
			Search s = list.get(i);
			System.out.println(s.getKeyword());
		}
	}

}