MYSQL_ssh.rar_mysql s_mysql增_ssh java mys_ssh mysql

package com.dao; import java.util.List; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.hibernate.LockMode; import org.springframework.context.ApplicationContext; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.dto.Yuangong; import com.idao.YuangongIDAO; /** * A data access object (DAO) providing persistence and search support for * Yuangong entities. Transaction control of the save(), update() and delete() * operations can directly support Spring container-managed transactions or they * can be augmented to handle user-managed Spring transactions. Each of these * methods provides additional information for how to configure it for the * desired type of transaction control. * * @see com.dto.Yuangong * @author MyEclipse Persistence Tools */ public class YuangongDAO extends HibernateDaoSupport implements YuangongIDAO { private static final Log log = LogFactory.getLog(YuangongDAO.class); protected void initDao() { // do nothing } /* (non-Javadoc) * @see com.dao.YuangongIDAO#save(com.dto.Yuangong) */ //查询 public List selectYuangongByTowParameter(String yuangongAgeFrist,String yuangongAgeTwo) { String hql="from Yuangong where yuangongAge>:yuangongAgeFrist and yuangongAge<:yuangongAgeTwo"; return this.getHibernateTemplate().findByNamedParam(hql, new String[]{"yuangongAgeFrist","yuangongAgeTwo"}, new Object[]{yuangongAgeFrist,yuangongAgeTwo}); } public int updateYuangong(Yuangong transientInstance) { log.debug("saving Yuangong instance"); try { this.getHibernateTemplate().saveOrUpdate(transientInstance); log.debug("save successful"); return 1; } catch (RuntimeException re) { log.error("save failed", re); throw re; } } public void save(Yuangong transientInstance) { log.debug("saving Yuangong instance"); try { getHibernateTemplate().save(transientInstance); log.debug("save successful"); } catch (RuntimeException re) { log.error("save failed", re); throw re; } } /* (non-Javadoc) * @see com.dao.YuangongIDAO#delete(com.dto.Yuangong) */ public void delete(Yuangong persistentInstance) { log.debug("deleting Yuangong instance"); try { getHibernateTemplate().delete(persistentInstance); log.debug("delete successful"); } catch (RuntimeException re) { log.error("delete failed", re); throw re; } } /* (non-Javadoc) * @see com.dao.YuangongIDAO#findById(java.lang.String) */ public Yuangong findById(java.lang.String id) { log.debug("getting Yuangong instance with id: " + id); try { Yuangong instance = (Yuangong) getHibernateTemplate().get( "com.dto.Yuangong", id); return instance; } catch (RuntimeException re) { log.error("get failed", re); throw re; } } /* (non-Javadoc) * @see com.dao.YuangongIDAO#findByExample(com.dto.Yuangong) */ public List findByExample(Yuangong instance) { log.debug("finding Yuangong 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; } } /* (non-Javadoc) * @see com.dao.YuangongIDAO#findByProperty(java.lang.String, java.lang.Object) */ public List findByProperty(String propertyName, Object value) { log.debug("finding Yuangong instance with property: " + propertyName + ", value: " + value); try { String queryString = "from Yuangong as model where model." + propertyName + "= ?"; return getHibernateTemplate().find(queryString, value); } catch (RuntimeException re) { log.error("find by property name failed", re); throw re; } } /* (non-Javadoc) * @see com.dao.YuangongIDAO#findByYuangongName(java.lang.Object) */ public List findByYuangongName(Object yuangongName) { return findByProperty(YUANGONG_NAME, yuangongName); } /* (non-Javadoc) * @see com.dao.YuangongIDAO#findByYuangongSex(java.lang.Object) */ public List findByYuangongSex(Object yuangongSex) { return findByProperty(YUANGONG_SEX, yuangongSex); } /* (non-Javadoc) * @see com.dao.YuangongIDAO#findByYuangongAge(java.lang.Object) */ public List findByYuangongAge(Object yuangongAge) { return findByProperty(YUANGONG_AGE, yuangongAge); } /* (non-Javadoc) * @see com.dao.YuangongIDAO#findByYuangongBu(java.lang.Object) */ public List findByYuangongBu(Object yuangongBu) { return findByProperty(YUANGONG_BU, yuangongBu); } /* (non-Javadoc) * @see com.dao.YuangongIDAO#findByYuangongZhiCheng(java.lang.Object) */ public List findByYuangongZhiCheng(Object yuangongZhiCheng) { return findByProperty(YUANGONG_ZHI_CHENG, yuangongZhiCheng); } /* (non-Javadoc) * @see com.dao.YuangongIDAO#findAll() */ public List findAll() { log.debug("finding all Yuangong instances"); try { String queryString = "from Yuangong"; return getHibernateTemplate().find(queryString); } catch (RuntimeException re) { log.error("find all failed", re); throw re; } } /* (non-Javadoc) * @see com.dao.YuangongIDAO#merge(com.dto.Yuangong) */ public Yuangong merge(Yuangong detachedInstance) { log.debug("merging Yuangong instance"); try { Yuangong result = (Yuangong) getHibernateTemplate().merge( detachedInstance); log.debug("merge successful"); return result; } catch (RuntimeException re) { log.error("merge failed", re); throw re; } } /* (non-Javadoc) * @see com.dao.YuangongIDAO#attachDirty(com.dto.Yuangong) */ public void attachDirty(Yuangong instance) { log.debug("attaching dirty Yuangong instance"); try { getHibernateTemplate().saveOrUpdate(instance); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } /* (non-Javadoc) * @see com.dao.YuangongIDAO#attachClean(com.dto.Yuangong) */ public void attachClean(Yuangong instance) { log.debug("attaching clean Yuangong instance"); try { getHibernateTemplate().lock(instance, LockMode.NONE); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } public static YuangongIDAO getFromApplicationContext(ApplicationContext ctx) { return (YuangongIDAO) ctx.getBean("YuangongDAO"); } }