userimpl.java

来自「购物车系统」· Java 代码 · 共 98 行

package com.estore.dao.impl;


import java.util.List;

import org.hibernate.*;

import com.estore.dao.UserDao;
import com.estore.entity.Order;
import com.estore.entity.User;
import com.estore.util.*;

public class UserImpl implements UserDao {

	public void addUser(User user) {
		Session session = null;
		Transaction tran = null;
		
		try {
			session = HibernateUtil.getSession();
			tran = session.beginTransaction();
			session.save(user);
			tran.commit();
		} catch (Exception e) {
			e.printStackTrace();
			tran.rollback();
		}finally {
			 HibernateUtil.releaseSession(session);
		}
		

	}

	public User findUserByName(String name) {
		Session session = null;
		Transaction tran = null;
		User u = null;
		try {
			session = HibernateUtil.getSession();
			tran = session.beginTransaction();
			String hql = "from User u where name=?";
			Query q = session.createQuery(hql);
			q.setString(0, name);
			u = (User)q.uniqueResult();
			tran.commit();
		} catch (Exception e) {
			e.printStackTrace();
			tran.rollback();
		}finally {
			 HibernateUtil.releaseSession(session);
		}
		return u;
	}

	public List<Order> findOrderByUserId(Integer id) {
		Session s = null;
		Transaction tran = null;
		List<Order> orders = null;
		try{
			s = HibernateUtil.getSession();
			tran = s.beginTransaction();
			String hql = "from Order order where fid=?";
			Query q = s.createQuery(hql);
			q.setInteger(0, id);
			orders = q.list();
			tran.commit();
		}catch(Exception e){
			e.printStackTrace();
			tran.rollback();
		}finally {
			 HibernateUtil.releaseSession(s);
		}
		return orders;
	}

	public void deleteOrderById(Integer id) {
		Session s = null;
		Transaction tran = null;
		try{
			s = HibernateUtil.getSession();
			tran = s.beginTransaction();
			Order order = (Order)s.get(Order.class, id);
			s.delete(order);
			tran.commit();
		}catch(Exception e){
			e.printStackTrace();
			tran.rollback();
		}finally {
			 HibernateUtil.releaseSession(s);
		}
		
		
	}
	


}