useriddictdaoimpl.java

spring struts hibernate 集成开发的web应用

package com.sc.dao.hibernate;

import java.util.List;

import org.hibernate.*;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.sc.dao.UseridDictDAO;
import com.sc.model.UseridDict;

import com.sc.util.CommUtil;
/**
 * 
 * @author cnsdl
 * @since jdk1.5 spring 1.2.6 hibernate 3
 *
 */

public class UseridDictDAOImpl extends HibernateDaoSupport implements UseridDictDAO {
	

	
	private SessionFactory sessionFactory;

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根

	}

	public void addObject(UseridDict userid) {
		getHibernateTemplate().saveOrUpdate(userid);
		
	}

	public UseridDict getUserid() throws Exception{
		//记录数
		int count =this.getRecordCount();
		//随机取出第num行纪录
		int num = CommUtil.randomInt(count);
		
		String hql = "from UseridDict";
		List lst = getHibernateTemplate().find(hql);
		getHibernateTemplate().setFetchSize(num);
		getHibernateTemplate().setMaxResults(1);
		
		if (lst.size()!=0){
			return (UseridDict)lst.get(0);
		}else
			return null;
	}

	public void deleteObject(UseridDict userid) {
		getHibernateTemplate().delete(userid);
		
	}

	public int getRecordCount() throws Exception{
		String hql = "select count(userid) from UseridDict";
		System.out.println("here");
		

		List lst = getHibernateTemplate().find(hql);
		//System.out.println(lst.size());
		 
		return lst.get(0).hashCode();
	}
	

}