HibernateTemplate

Hibernate 对Dao层的处理实例
   有模糊查询和 分页

package infoweb.dao;   
  
import java.util.List;   
import java.util.Iterator;   
  
import infoweb.pojo.Info;   
  
import net.sf.hibernate.HibernateException;   
import net.sf.hibernate.Query;   
import net.sf.hibernate.Session;   
  
import org.springframework.orm.hibernate.HibernateCallback;   
import org.springframework.orm.hibernate.support.HibernateDaoSupport;   
  
   
pTitle p  
pDescription p  
pCopyright Copyright (c) 2004p  
pCompany p  
@author Mr.xp 
@version 1.0   
    
  
public class InfoDAOImpl extends HibernateDaoSupport implements IInfoDAO {   
     
    构造函数   
      
public InfoDAOImpl() {   
    super();   
}   
  
     
    增加记录   
    @param info Info   
      
public void setInfo(Info info) throws Exception {   
    getHibernateTemplate().save(info);   
}   
  
     
    通过ID取得记录   
    @param id String   
    @return Info   
      
public Info getInfoById(String id) throws Exception {   
    Info info = (Info) getHibernateTemplate().load(Info.class, id);   
    return info;   
}   
  
     
    修改记录   
    @param Info info   
      
public void modifyInfo(Info info) throws Exception {   
    getHibernateTemplate().update(info);   
}   
  
     
    删除记录   
    @param Info info   
      
public void removeInfo(Info info) throws Exception {   
    getHibernateTemplate().delete(info);   
}   
  
     
                                                     
以下部份不带审核功能                                 
                                                     
     
  
     
    取记录总数   
    @return int   
      
public int getInfosCount() throws Exception {   
    int count = 0;   
    String queryString = select count() from Info;   
    count = ((Integer) getHibernateTemplate().iterate(queryString).next()).   
            intValue();   
    return count;   
}   
  
     
    取所有记录集合   
    @return Iterator   
      
public Iterator getAllInfos() throws Exception {   
    Iterator iterator = null;   
    String queryString = select info from Info as info order by info.id desc;   
    List list = getHibernateTemplate().find(queryString);   
    iterator = list.iterator();   
    return iterator;   
}   
  
     
    取记录集合   
    @return Iterator   
    @param int position, int length   
      
public Iterator getInfos(int position, int length) throws Exception {   
    Iterator iterator = null;   
    String queryString = select info from Info as info order by info.id desc;   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    设置游标的起始点   
    query.setFirstResult(position);   
    设置游标的长度   
    query.setMaxResults(length);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    return iterator;   
}   
  
     
    取第一条记录   
    @throws Exception   
    @return Station   
      
public Info getFirstInfo() throws Exception {   
    Iterator iterator = null;   
    Info info = null;   
    String queryString = select info from Info as info order by info.id desc;   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    if (iterator.hasNext()) {   
      info = (Info) iterator.next();   
    }   
    return info;   
}   
  
     
    取最后一条记录   
    @throws Exception   
    @return Station   
      
public Info getLastInfo() throws Exception {   
    Iterator iterator = null;   
    Info info = null;   
    String queryString = select info from Info as info order by info.id asc;   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    if (iterator.hasNext()) {   
      info = (Info) iterator.next();   
    }   
    return info;   
  
}   
  
     
                                                     
   以下部份表中要有特定字段才能正确运行   个人和企业        
                                                     
     
  
     
    取符合条件记录总数, [表中要有 isperson 字段]   
    @return int   
    @param int isPerson   
      
  
public int getInfosCountByIsperson(int isPerson) throws Exception {   
    int count = 0;   
    String queryString =   
        select count() from Info as info where info.isperson = + isPerson;   
    count = ((Integer) getHibernateTemplate().iterate(queryString).next()).   
            intValue();   
    return count;   
}   
  
     
    取所有符合条件记录集合, 模糊查询条件.[表中要有 isperson 字段]   
    @return Iterator   
    @param int isPerson   
      
  
public Iterator getAllInfosByIsperson(int isPerson) throws Exception {   
    Iterator iterator = null;   
    String queryString = select info from Info as info where info.isperson = +   
                         isPerson + order by info.id desc;   
    List list = getHibernateTemplate().find(queryString);   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    return iterator;   
}   
  
     
    取符合条件记录集合, 模糊查询条件.[表中要有 isperson 字段]   
    @return Iterator   
    @param int isPerson,int position, int length   
      
  
public Iterator getInfosByIsperson(int isPerson, int position, int length) throws   
      Exception {   
    Iterator iterator = null;   
    String queryString = select info from Info as info where info.isperson = +   
                         isPerson + order by info.id desc;   
    创建查询   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    设置游标的起始点   
    query.setFirstResult(position);   
    设置游标的长度   
    query.setMaxResults(length);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    return iterator;   
}   
  
     
                                                     
   以下部份表中要有特定字段才能正确运行   查询部份         
                                                     
     
     
    取符合条件记录总数, 模糊查询条件.[表中要有 title 字段]   
    @return int   
    @param String text   
      
public int getInfosCount(String text) throws Exception {   
    int count = 0;   
    count = ((Integer) getHibernateTemplate().iterate(   
        select count() from Info as info where info.title like '% + text +   
        %').next()).intValue();   
    return count;   
}   
  
     
    取所有符合条件记录集合, 模糊查询条件.[表中要有 title 字段]   
    @return Iterator   
    @param String text   
      
  
public Iterator getAllInfos(String text) throws Exception {   
    Iterator iterator = null;   
    String queryString =   
         select info from Info as info where info.title like '% + text +   
        %' order by info.id desc;   
    创建查询   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    return iterator;   
}   
  
     
    取符合条件记录集合, 模糊查询条件.[表中要有 title 字段]   
    @return Iterator   
    @param String text,int position, int length   
      
public Iterator getInfos(String text, int position, int length) throws   
      Exception {   
    Iterator iterator = null;   
    String queryString =   
         select info from Info as info where info.title like '% + text +   
        %' order by info.id desc;   
  
    创建查询   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    设置游标的起始点   
    query.setFirstResult(position);   
    设置游标的长度   
    query.setMaxResults(length);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    return iterator;   
}   
  
     
                                                     
   以下部份表中要有特定字段才能正确运行   注册相关         
                                                     
     
  
     
    取符合条件记录总数.[ 表中要有 registername 字段]   
    @return int   
    @param String text   
      
public int getInfosCountByRegisterName(String registerName) throws Exception {   
    int count = 0;   
    count = ((Integer) getHibernateTemplate().iterate(   
        select count() from Info as info where info.registername = ' +   
        registerName + ').next()).intValue();   
    return count;   
}   
  
     
    通过注册名取得一条记录,如有多条,只取第一条.[表中要有 registername字段]   
    @param registername String   
    @return Info   
      
public Info getInfoByRegisterName(String registerName) throws Exception {   
    Iterator iterator = null;   
    Info info = null;   
    String queryString =   
         select info from Info as info where info.registername=' +   
        registerName + ' order by info.id desc;   
    创建查询   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    if (iterator.hasNext()) {   
      info = (Info) iterator.next();   
    }   
    return info;   
}   
  
     
    通过注册名取得所有记录集合.[表中要有 registername字段]   
    @param registername String   
    @return Iterator   
      
public Iterator getAllInfosByRegisterName(String registerName) throws   
      Exception {   
    Iterator iterator = null;   
    String queryString =   
         select info from Info as info where info.registername=' +   
        registerName + ' order by info.id desc;   
    创建查询   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    return iterator;   
}   
  
     
    通过注册名取得记录列表.[表中要有 registername字段]   
    @param registername String   
    @return Iterator   
      
public Iterator getInfosByRegisterName(String registerName, int position,   
                                         int length) throws Exception {   
    Iterator iterator = null;   
    String queryString =   
         select info from Info as info where info.registername=' +   
        registerName + ' order by info.id desc;   
    创建查询   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    设置游标的起始点   
    query.setFirstResult(position);   
    设置游标的长度   
    query.setMaxResults(length);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    return iterator;   
}   
  
     
                                                     
   以下部份表中要有特定字段才能正确运行     树型版块        
                                                     
     
  
     
    取记录总数.[ 表中要有 board_id 字段]   
    @return int   
    @param String boardId   
      
public int getInfosCountByBoard(String boardId) throws Exception {   
    int count = 0;   
  
    count = ((Integer) getHibernateTemplate().iterate(   
        select count() from Info as info where info.boardId = ' + boardId +   
        ').next()).intValue();   
  
    return count;   
}   
  
     
    通过版块名取得所有记录集合.[表中要有 board_id字段]   
    @param BoardId String   
    @return Iterator   
      
public Iterator getAllInfosByBoard(String boardId) throws Exception {   
    Iterator iterator = null;   
    String queryString = select info from Info as info where info.boardId=' +   
                         boardId + ' order by info.id desc;   
    创建查询   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    return iterator;   
}   
  
     
    通过版块名取得记录列表.[表中要有 board_id字段]   
    @param BoardId String   
    @return Iterator   
      
public Iterator getInfosByBoard(String boardId, int position, int length) throws   
      Exception {   
    Iterator iterator = null;   
    String queryString = select info from Info as info where info.boardId=' +   
                         boardId + ' order by info.id desc;   
  
    创建查询   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    设置游标的起始点   
    query.setFirstResult(position);   
    设置游标的长度   
    query.setMaxResults(length);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
  
    return iterator;   
  
}   
  
     
    取符合条件记录总数.[ 表中要有 board_id 字段,title] 模糊查询title   
    @return int   
    @param String boardId ,String text   
      
public int getInfosCountByBoard(String boardId, String text) throws Exception {   
    int count = 0;   
  
    count = ((Integer) getHibernateTemplate().iterate(   
        select count() from Info as info where info.boardId=' + boardId +   
        ' and info.title like '% + text + %').next()).intValue();   
  
    return count;   
  
}   
  
     
    通过版块名取得记录列表.[表中要有 board_id字段] 模糊查询title   
    @param String boardID,int position, int length   
    @return Iterator   
      
public Iterator getInfosByBoard(String boardId, int position, int length,   
                                  String text) throws Exception {   
    Iterator iterator = null;   
    String queryString = select info from Info as info where info.boardId=' +   
                         boardId + ' and info.title like '% + text +   
                         %' order by info.id desc;   
  
    创建查询   
    Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
    设置游标的起始点   
    query.setFirstResult(position);   
    设置游标的长度   
    query.setMaxResults(length);   
    记录生成   
    List list = query.list();   
    把查询到的结果放入迭代器   
    iterator = list.iterator();   
    return iterator;   
  
}