dailysavedaoimpl.java

本系统实现了从五个网站上搜索的图书进行整合后

package com.booksearch.dao;



import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;


import com.booksearch.orm.Daily;
/**
 * Class:DailySaveDaoImpl
 * Description:  更新数据库中daily实体bean对应的dailyinfo表信息
 * extens:HibernateDaoSupport
 * implements:BookLoadDao
 * @author  feng guang
 * @since   11/28/08
 */
public class DailySaveDaoImpl extends HibernateDaoSupport implements DailySaveDao {

	/**
	* Function:  addDaily
	* Description: 添加日志信息到数据库表dailyinfo
	* Calls:  no
	* Called By:  SearchAction.execute(),AdvancedSearchAction.execute()
	* @param daily as Daily
	* @return void
	* @throws no
	*/
	public void addDaily(Daily daily) {
		this.getHibernateTemplate().save(daily);

	}
	/**
	* Function:  updateDaily
	* Description: 更新某关键字指定网站的下一页url
	* Calls:  no
	* Called By:  ThreadService.run()
	* @param keyword as String,webName as String,nextUrl as String
	* @return void
	* @throws no
	*/
	public  void updateDaily(String keyword,String webName,String nextUrl) {	
 		
        final String strHql = "update dailyinfo set "+webName+" = '"+nextUrl+"' where keyword = '"+keyword+"'";  
        
        this .getHibernateTemplate().execute( new  HibernateCallback()  {
            public  Object doInHibernate(Session session){
               SQLQuery query = session.createSQLQuery(strHql);
               query.executeUpdate();
               return null;
           }
       } );		
	}
	/**
	* Function:  updateDaily
	* Description: 从数据库中获得满足条件的所有book实体对象
	* Calls:  no
	* Called By:  SearchAction.execute(),AdvancedSearchAction.execute()
	* @param keyword as String,recordNum as long,falg as boolean
	* @return void
	* @throws no
	*/
	public synchronized void updateDaily(String keyword, long recordNum,boolean flag) {

		if(flag){
		  List list = this.getHibernateTemplate().find("from Daily as daily where daily.keyword = ?",keyword);
		  if(list.size()>0){
			  Daily temDaily = (Daily)list.get(0);
			  temDaily.setVisitNum(temDaily.getVisitNum() + 1);
			  temDaily.setRecordNum(recordNum);
			  this.getHibernateTemplate().update(temDaily);
		  }
		}else{
			  List list = this.getHibernateTemplate().find("from Daily as daily where daily.keyword = ?",keyword);
			  if(list.size()>0){
				  Daily temDaily = (Daily)list.get(0);
				  temDaily.setRecordNum(recordNum);
				  this.getHibernateTemplate().update(temDaily);
			  }
		}  
	}
}