optrinfodao.java

有关医院方向的开发

package com.woyi.dao;
// default package

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.woyi.dto.Optrinfo;
import com.woyi.dto.Organization;
import com.woyi.page.PageInfo;
import com.woyi.page.Pagination;

/**
 * Data access object (DAO) for domain model class Optrinfo.
 * @see .Optrinfo
  * @author MyEclipse Persistence Tools 
 */

public class OptrinfoDAO extends HibernateDaoSupport  {
    private static final Log log = LogFactory.getLog(OptrinfoDAO.class);
	//property constants
	public static final String OPTRID = "optrid";
	public static final String STUFFID = "stuffid";
	public static final String OPTRNAME = "optrname";
	public static final String PASSWORD = "password";
	public static final String ROLEID = "roleid";
	public static final String VALIDFLAG = "validflag";
	public static final String CMDOPTRID = "cmdoptrid";
	public static final String OPTRDESC = "optrdesc";
	public static final String REMARK = "remark";
	public static final String ORGCODE = "orgcode";
	
	public Pagination pagination;	
	public Organization organization;	
	
	public Pagination getPagination() {
		return pagination;
	}

	public void setPagination(Pagination pagination) {
		this.pagination = pagination;
	}

	protected void initDao() {
		//do nothing
	}
    
    public void save(Optrinfo transientInstance) {
        log.debug("saving Optrinfo instance");
        try {
            getHibernateTemplate().save(transientInstance);
            log.debug("save successful");
        } catch (RuntimeException re) {
            log.error("save failed", re);
            throw re;
        }
    }
    
	public boolean delete(Optrinfo persistentInstance) {
		boolean isFlag=false;
        log.debug("deleting Optrinfo instance");
        try {
            getHibernateTemplate().delete(persistentInstance);
            log.debug("delete successful");
            isFlag = true;
            return isFlag;
        } catch (RuntimeException re) {
            log.error("delete failed", re);
           return isFlag;
        }
    }
    
    public Optrinfo findById( java.lang.Integer id) {
        log.debug("getting Optrinfo instance with id: " + id);
        try {
            Optrinfo instance = (Optrinfo) getHibernateTemplate()
                    .get("Optrinfo", id);
            return instance;
        } catch (RuntimeException re) {
            log.error("get failed", re);
            throw re;
        }
    }
    
    
    public List findByExample(Optrinfo instance) {
        log.debug("finding Optrinfo 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 Optrinfo instance with property: " + propertyName
            + ", value: " + value);
      try {
         String queryString = "from Optrinfo 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 findByOptrid(Object optrid) {
		return findByProperty(OPTRID, optrid);
	}
	
	public List findByStuffid(Object stuffid) {
		return findByProperty(STUFFID, stuffid);
	}
	
	public List findByOptrname(Object optrname) {
		return findByProperty(OPTRNAME, optrname);
	}
	
	public List findByPassword(Object password) {
		return findByProperty(PASSWORD, password);
	}
	
	public List findByRoleid(Object roleid) {
		return findByProperty(ROLEID, roleid);
	}
	
	public List findByValidflag(Object validflag) {
		return findByProperty(VALIDFLAG, validflag);
	}
	
	public List findByCmdoptrid(Object cmdoptrid) {
		return findByProperty(CMDOPTRID, cmdoptrid);
	}
	
	public List findByOptrdesc(Object optrdesc) {
		return findByProperty(OPTRDESC, optrdesc);
	}
	
	public List findByRemark(Object remark) {
		return findByProperty(REMARK, remark);
	}
	

	public List findAll() {
		log.debug("finding all Optrinfo instances");
		try {
			String queryString = "from Optrinfo";
		 	return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}
	
    public Optrinfo merge(Optrinfo detachedInstance) {
        log.debug("merging Optrinfo instance");
        try {
            Optrinfo result = (Optrinfo) getHibernateTemplate()
                    .merge(detachedInstance);
            log.debug("merge successful");
            return result;
        } catch (RuntimeException re) {
            log.error("merge failed", re);
            throw re;
        }
    }

    public boolean attachDirty(Optrinfo instance) {
        log.debug("attaching dirty Optrinfo instance");
        boolean isFlag=false;
        try {
            getHibernateTemplate().saveOrUpdate(instance);
            isFlag=true;
            log.debug("attach successful");
            return isFlag;
        } catch (RuntimeException re) {
            log.error("attach failed", re);
            return isFlag;
        }
    }
    
    public void attachClean(Optrinfo instance) {
        log.debug("attaching clean Optrinfo instance");
        try {
            getHibernateTemplate().lock(instance, LockMode.NONE);
            log.debug("attach successful");
        } catch (RuntimeException re) {
            log.error("attach failed", re);
            throw re;
        }
    }

	public static OptrinfoDAO getFromApplicationContext(ApplicationContext ctx) {
    	return (OptrinfoDAO) ctx.getBean("OptrinfoDAO");
	}
	
	/**
	 * 根据条件获得操作员信息
	 * @param value
	 * @return
	 */
        public PageInfo fechOptr(String optrid,String stuffid,String optrname,String validflag,int pageNo) {
            log.debug("finding Optrinfo instance with property: " + optrid
              );
            try {
               String queryString = "from Optrinfo as b where b.optrid like '%" 
               						+ optrid +"' and b.optrname like '%" +optrname+"%' and b.stuffid like '%"+stuffid+"%' and b.validflag='"+validflag+"'  order by b.optrid";
               String count = "select count(*) from Optrinfo as b where b.optrid like '%" 
               						+ optrid +"' and b.optrname like '%" +optrname+"%' and b.stuffid like '%"+stuffid+"%' and b.validflag='"+validflag+"'  order by b.optrid";
               PageInfo pageInfo = pagination.page(pageNo, 10, queryString, count);
      		 return pageInfo;
            } catch (RuntimeException re) {
               log.error("find by property name failed", re);
               throw re;
            }
      	}
        
      /* 
       *  public PageInfo findByOptrId(String optrid){
            log.debug("finding Optrinfo instance with property: " + optrid
            );
          try {
             String queryString = "from Optrinfo as b where b.optrid = '" 
             						+ optrid +"'";
             String count = "select count(*) from Optrinfo as b where b.optrid = '" 
             						+ optrid +"'";
             PageInfo pageInfo = pagination.page(pageNo, 10, queryString, count);
    		 return pageInfo;
          } catch (RuntimeException re) {
             log.error("find by property name failed", re);
             throw re;
          }
    	}
    	*/

	public Organization getOrganization() {
		return organization;
	}

	public void setOrganization(Organization organization) {
		this.organization = organization;
	}
   
}