tsuserdatadao.java

struts hibernet spring

package com.ts.dao;

import java.util.Date;
import java.util.List;
import com.ts.orm.TsUserdata;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.springframework.context.ApplicationContext;
import org.springframework.jdbc.support.SQLExceptionTranslator;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class TsUserdataDAO extends HibernateDaoSupport implements iUserdataDAO{
	private static final Log log = LogFactory.getLog(TsUserdataDAO.class);
	// property constants
	public static final String TS_USERNAME = "tsUsername";
	public static final String TS_PASSWORD = "tsPassword";
	public static final String TS_TELEPHONE = "tsTelephone";
	public static final String TS_SEX = "tsSex";
	public static final String TS_EMAIL = "tsEmail";

	protected void initDao() {
		// do nothing
	}
	
	public void save(TsUserdata transientInstance) {
		log.debug("saving TsUserdata instance");
		try {
			
			getHibernateTemplate().save(transientInstance);
			log.debug("save successful");
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}
	}
	public void saveOrUpdate(TsUserdata transientInstance) {
		log.debug("saving TsUserdata instance");
		try {
			
			getHibernateTemplate().saveOrUpdate(transientInstance);
			log.debug("save successful");
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}
	}
	
	public void delete(TsUserdata persistentInstance) {
		log.debug("deleting TsUserdata instance");
		try {
			getHibernateTemplate().delete(persistentInstance);
			log.debug("delete successful");
		} catch (RuntimeException re) {
			log.error("delete failed", re);
			throw re;
		}
	}

	public TsUserdata findById(java.lang.Integer id) {
		log.debug("getting TsUserdata instance with id: " + id);
		try {
			TsUserdata instance = (TsUserdata) getHibernateTemplate().get(
					"com.ts.orm.TsUserdata", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}

	public List findByExample(TsUserdata instance) {
		log.debug("finding TsUserdata instance by example");
		try {
			List results = getHibernateTemplate().findByExample(instance);
			log.debug("find by example successful, result size: "
					+ results.size());
			return results;
		} catch (RuntimeException re) {
			log.error("find by example failed", re);
			throw re;
		}
	}

	public List findByProperty(String propertyName, Object value) {
		log.debug("finding TsUserdata instance with property: " + propertyName
				+ ", value: " + value);
		try {
			String queryString = "from TsUserdata as model where model."
					+ propertyName + "= ?";
			return getHibernateTemplate().find(queryString, value);
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		} 
	}

	public List findByTsUsername(Object tsUsername) {
		return findByProperty(TS_USERNAME, tsUsername);
	}

	public List findByTsPassword(Object tsPassword) {
		return findByProperty(TS_PASSWORD, tsPassword);
	}

	public List findByTsTelephone(Object tsTelephone) {
		return findByProperty(TS_TELEPHONE, tsTelephone);
	}

	public List findByTsSex(Object tsSex) {
		return findByProperty(TS_SEX, tsSex);
	}

	public List findByTsEmail(Object tsEmail) {
		return findByProperty(TS_EMAIL, tsEmail);
	}

	public List findAll(int offset) {
		log.debug("finding all TsUserdata instances");
		try {
			String queryString = "from TsUserdata limit "+offset+",10";
			return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

	public TsUserdata merge(TsUserdata detachedInstance) {
		log.debug("merging TsUserdata instance");
		try {
			TsUserdata result = (TsUserdata) getHibernateTemplate().merge(
					detachedInstance);
			log.debug("merge successful");
			return result;
		} catch (RuntimeException re) {
			log.error("merge failed", re);
			throw re;
		}
	}

	public void attachDirty(TsUserdata instance) {
		log.debug("attaching dirty TsUserdata instance");
		try {
			getHibernateTemplate().saveOrUpdate(instance);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public void attachClean(TsUserdata instance) {
		log.debug("attaching clean TsUserdata instance");
		try {
			getHibernateTemplate().lock(instance, LockMode.NONE);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public static TsUserdataDAO getFromApplicationContext(ApplicationContext ctx) {
		return (TsUserdataDAO) ctx.getBean("TsUserdataDAO");
	}

}