src/com/jiudai/dao/StockDAO.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.jiudai.dao;
 
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.jiudai.Utils.HibernateUtil;
import com.jiudai.domain.StockInfo;

public class StockDAO {
	
	/*保存汽车库存信息*/
	public void  AddStockInfo(StockInfo stockInfo) {
		Session s = null;
		Transaction tx = null;
		try {
			s = HibernateUtil.getSession();
			tx = s.beginTransaction();
			s.save(stockInfo);
			tx.commit(); 
		} catch (HibernateException e) {
			if(tx != null)
				tx.rollback();
			throw e;
		} finally {
			HibernateUtil.closeSession();
		} 
	}
	
	/*增加或减少汽车库存信息,此处session不用关闭，由调用者关闭*/
	public void UpdateStockCount(String carname,int count) {
		Session s = null; 
		try {
			s = HibernateUtil.getSession();
			String hql = "From StockInfo st where st.carname='" + carname + "'"; 
			Query q = s.createQuery(hql); 
			StockInfo stockInfo = (StockInfo)q.uniqueResult(); 
			stockInfo.setStockCount(stockInfo.getStockCount() + count);
			s.update(stockInfo); 
		} catch (HibernateException e) { 
			throw e;
		} 
	}
	
	/*查询汽车的库存*/
	public int GetStockCount(String carname) {
		Session s = null;
		try {
			s = HibernateUtil.getSession();
			String hql = "From StockInfo st where st.carname='" + carname + "'"; 
			Query q = s.createQuery(hql); 
			StockInfo stockInfo = (StockInfo)q.uniqueResult();
			return stockInfo.getStockCount();
		} catch (HibernateException e) {
			throw e;
		} finally {
			HibernateUtil.closeSession();