userdaoimp1.java

老师给的购物车

package com.tarena.shopcart.entity.daoImp1;

import java.util.List;

import org.hibernate.Session;
import org.hibernate.Transaction;

import com.tarena.shopcart.entity.Contactinfo;
import com.tarena.shopcart.entity.Country;
import com.tarena.shopcart.entity.OrderStatus;
import com.tarena.shopcart.entity.Province;
import com.tarena.shopcart.entity.Users;
import com.tarena.shopcart.entity.dao.IUserDAO;
import com.tarena.shopcart.util.HibernateSessionFactory;


public class UserDAOImp1 implements IUserDAO {
	/**
	 * 添加用户信息
	 */
	public boolean addUser(Users user) {
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			session.save(user);
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return false;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return true;
	}

	/**
	 * 获得所有的用户信息
	 * 
	 * @return
	 */
	public List getAllUser() {
		List list = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			list = session.createQuery("from Users").list();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return list;
	}

	/**
	 * 根据用户名查询用户的信息
	 * 
	 * @param 用户的名字
	 * @return 用户的实体
	 */
	public Users selectByUsername(String userId) {
		Users user = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			user = (Users) session.createQuery("from Users u where u.userId=?")
					.setString(0, userId).uniqueResult();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return user;
	}

	public List getAllCountry() {
		List list = null;
		Session session = null;
		Transaction tran = null;
		;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			list = session.createQuery("from Country").list();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return list;
	}

	public List getAllProvince() {
		List list = null;
		Session session = null;
		Transaction tran = null;
		;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			list = session.createQuery("from Province").list();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return list;

	}

	

	public boolean modifyUser(Users user) {
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			session.update(user);
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return false;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return true;
	}

	public Contactinfo selectByUid(String uid) {
		Contactinfo info = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			info = (Contactinfo) session.createQuery("from Contactinfo u where u.user=?")
					.setString(0, uid).uniqueResult();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return info;
	}
	
	

	public boolean modifyUserinfo(Contactinfo info) {
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			session.update(info);
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return false;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return true;
	}
	
	public Country getCountryBycid(int cid) {
		Country status = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			status = (Country) session.createQuery(
					"from Country c where c.Id=?").setInteger(0, cid)
					.uniqueResult();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return status;
	}

	public Province getProvinceBypid(int pid) {
		Province status = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			status = (Province) session.createQuery(
					"from Province p where p.Id=?").setInteger(0, pid)
					.uniqueResult();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return status;
	}

	public static void main(String[] args) {
		/*
		 * Country product=new Country(); product.setName("d");
		 * System.out.println(new UserDAOImp1().getAllCountry());
		 */
		Users user = new Users();
		user.setUserId("admin");

		System.out.println(new UserDAOImp1().selectByUid("admin"));

	}

	public boolean deleteUser(Users user) {
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			session.delete(user);
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return false;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return true;
	}

	
}