carsdao.java

车辆管理系统是OA系统中一部分。 单独使用。 提高车辆的有效管理

package org.langsin.car.dao.impl;

import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.langsin.car.dao.ICarDAO;
import org.langsin.car.vo.Cars;
import org.langsin.car.vo.User;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

/**
 * Data access object (DAO) for domain model class Cars.
 * @see org.langsin.car.vo.Cars
 * @author MyEclipse - Hibernate Tools
 */
public class CarsDAO extends HibernateDaoSupport implements ICarDAO{

    private static final Log log = LogFactory.getLog(CarsDAO.class);

	//property constants
	public static final String CARSNAME = "carsname";
	public static final String CARGRADE = "cargrade";
	public static final String INUSE = "inuse";
	public static final String MEMO = "memo";

	protected void initDao() {
		//do nothing
	}
    /**
     * 增加一个车辆信息
     */
    public void save(Cars transientInstance) {
        log.info("CarsDAO中save方法被执行！车辆管理模块，增加一个车辆信息");
        try {
            getHibernateTemplate().save(transientInstance);
            log.debug("save successful");
        } catch (RuntimeException re) {
            log.error("save failed", re);
            throw re;
        }
    }
    
	public void delete(Cars persistentInstance) {
        log.debug("deleting Cars instance");
        try {
            getHibernateTemplate().delete(persistentInstance);
            log.debug("delete successful");
        } catch (RuntimeException re) {
            log.error("delete failed", re);
            throw re;
        }
    }
	/**
	 * 根据Id查找一个车辆信息
	 * @param id
	 * @return
	 */
    

    
    
    public List findByExample(Cars instance) {
        log.debug("finding Cars 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 Cars instance with property: " + propertyName
            + ", value: " + value);
      try {
         String queryString = "from Cars 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 findByCarsname(Object carsname) {
		return findByProperty(CARSNAME, carsname);
	}
	
	public List findByCargrade(Object cargrade) {
		return findByProperty(CARGRADE, cargrade);
	}
	
	public List findByInuse(Object inuse) {
		return findByProperty(INUSE, inuse);
	}
	
	public List findByMemo(Object memo) {
		return findByProperty(MEMO, memo);
	}
	
    public Cars merge(Cars detachedInstance) {
        log.debug("merging Cars instance");
        try {
            Cars result = (Cars) getHibernateTemplate()
                    .merge(detachedInstance);
            log.debug("merge successful");
            return result;
        } catch (RuntimeException re) {
            log.error("merge failed", re);
            throw re;
        }
    }

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

	public static CarsDAO getFromApplicationContext(ApplicationContext ctx) {
    	return (CarsDAO) ctx.getBean("CarsDAO");
	}
/**
 * 查询出所有的车辆
 */
	public List findAllCar() {
		  log.info("carDAO中findAllCar方法被执行，车辆管理模块查询出所有的车辆");
		List cars=getHibernateTemplate().find("FROM Cars c");
		return cars;
	}
	/**
	 * 根据Id删除一个车辆的信息
	 */
public void deleteIdCar(Integer carsid) {
	log.info("CarsDAO中deleteIdCar方法被执行！车辆管理模块根据ID删除一个车辆的信息");
	Cars car=(Cars)getHibernateTemplate().get(Cars.class, carsid);
	getHibernateTemplate().delete(car);
	
	
}
	public Cars findByIdCar(Integer carsid) {
	       log.info("CarsDAO中findByIdCar方法被执行！车辆管理模块根据Id查找一个车辆信息");
	        try {
	            Cars instance = (Cars) getHibernateTemplate()
	                    .get("org.langsin.car.vo.Cars", carsid);
	            System.out.println(instance+"**********");
	            return instance;
	        } catch (RuntimeException re) {
	            log.error("get failed", re);
	            throw re;
	        }
	}
	public void updateCar(Cars car) {
	
			Cars instance = (Cars) getHibernateTemplate().get(
					"org.langsin.car.vo.Cars", car.getCarsid());
		instance.setCarsname(car.getCarsname());
		instance.setCargrade(car.getCargrade());
		instance.setInuse(car.getInuse());
		instance.setMemo(car.getMemo());
	
			getHibernateTemplate().update(instance);
			
		}
	public List findByInUser() {
	List carInUses=this.getHibernateTemplate().find("FROM Cars where inuse='N'");
		return carInUses;
	}
		
	
}