branchdaofromhbn.java

航空售票系统的代码

package com.tarena.abs.dao;

import com.tarena.abs.model.*;
import java.util.*;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
/**
 * 	int string string string number
 * id name passwd,email score
 * @author zhoukai
 *
 */
public class BranchDaoFromHbn implements BranchDAO {

	@Override
	public boolean addBranch(Branch user) {
		System.out.println(user.getName());
		Session s = null;
		Transaction t = null;
		boolean b = false;
		try {
			 s = HbnUtil.getSession();
			 t = s.beginTransaction();
			s.save(user);
			t.commit();
			b=true;
		} catch (HibernateException e) {
			e.printStackTrace();
			t.rollback();
		} finally{
			if(s!=null)try{s.close();}catch(Exception e){e.printStackTrace();}
		}
		return b;
	}

	@Override
	public Branch getBranch(String name, String passwd) {
		Session s = null;
		Transaction t = null;
		Branch a = null;
		try {
			 s = HbnUtil.getSession();
			 t = s.beginTransaction();
			 String hql="from Branch where name=? and passwd=?";
			 Object o = s.createQuery(hql)
			 			.setString(0, name)
			 			.setString(1, passwd)
			 			.uniqueResult();
			 a = (Branch)o;
			t.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			t.rollback();
		} finally{
			if(s!=null)try{s.close();}catch(Exception e){e.printStackTrace();}
		}
		return a;
	}

	@Override
	public Set getAllBranch() {
		Session s = null;
		Transaction t = null;
		HashSet hs = new HashSet();
		try {
			 s = HbnUtil.getSession();
			 t = s.beginTransaction();
			String hql="from Branch";
			Query q = s.createQuery(hql);
			List l = q.list();
			hs.addAll(l);
			t.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			t.rollback();
		} finally{
			if(s!=null)try{s.close();}catch(Exception e){e.printStackTrace();}
		}
		return hs;
	}

	@Override
	public boolean modifyPassword(String name, String oldPassword,
			String newPassword) {
		Session s = null;
		Transaction t = null;
		boolean b = false;
		try {
			 s = HbnUtil.getSession();
			 t = s.beginTransaction();
			 String hql="from Branch where name=? and passwd=?";
			 Branch a = (Branch)s.createQuery(hql)
			 			.setString(0, name)
			 			.setString(1, oldPassword)
			 			.uniqueResult();
			 a.setPasswd(newPassword);
			 s.update(a);
			t.commit();
			b = true;
		} catch (HibernateException e) {
			e.printStackTrace();
			t.rollback();
		} finally{
			if(s!=null)try{s.close();}catch(Exception e){e.printStackTrace();}
		}
		return b;
	}

	@Override
	public boolean removeBranch(String name) {
		Session s = null;
		Transaction t = null;
		boolean b = false;
		try {
			 s = HbnUtil.getSession();
			 t = s.beginTransaction();
			 String hql="from Branch where name=?";
			 Branch a = (Branch)s.createQuery(hql)
			 							.setString(0, name)
			 							.uniqueResult();
			s.delete(a);
			t.commit();
			b = true;
		} catch (HibernateException e) {
			e.printStackTrace();
			t.rollback();
		} finally{
			s.close();
		}
		return b;
	}

}