userdaoimpl.java

用java三大框架和mysql开发的网上购物系统

package com.bookshop.dao;

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

import com.bookshop.entity.User;
import com.bookshop.util.HibernateUtils;

/**
 * 通过Hibernate实现DAO ，与数据库进行交互
 * @author Administrator
 *
 */
public class UserDAOImpl  implements UserDAO{
	
	/**
	 * 根据登录ID，查找User对象
	 */
	public User getUserByloginId(String loginId) {
		User user = null;
		Session session = HibernateUtils.getHibernateSession();
		//定义HQL
		String hql = "from User as u where u.loginId = :loginId";
		//创建Query对象
		Query query = session.createQuery(hql);
		//绑定参数
		query.setString("loginId", loginId);
		
		//得到结果集
	// List result = query.list();
// System.out.println("result is:" + result);if(result.size()==1){
	//		user = (User)result.get(0);
	//}
		
		//结果集只有一条记录，用下面的方法
		user = (User)query.uniqueResult();
		return user;
	}
	
	//用户的 注册
	public void addUser(User user) {
		Session session = null; 
		Transaction tx = null;
		try{
			session = HibernateUtils.getHibernateSession();
			tx = session.getTransaction();
			tx.begin();
			session.save(user); 
			tx.commit();
		}catch(Exception e){
			e.printStackTrace();
			tx.rollback();
		}finally{
			HibernateUtils.closeHibernateSession(session);}
		}
	}