userdaoimpl.java

在学习期间做的小型的图书选购项目 仅仅适合研究使用

package com.knt.dao;

import java.util.List;

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

import com.knt.factory.HibernateSessionFactory;
import com.knt.interfaces.UserDAO;
import com.knt.pojo.Customer;

public class UserDAOImpl implements UserDAO {

	public boolean isExist(Customer customer) {
		Session session = HibernateSessionFactory.getSession();
		StringBuffer sb = new StringBuffer();
		sb.append(" from Customer cr ");
		sb.append(" where cr.name = ? ");		
		Query query =session.createQuery(sb.toString());		
		query.setParameter(0,customer.getName());
		List list =query.list();
		System.out.println("++++++++"+list!=null);
		if(list.size()>0)return true;
		
		return false;
	}
	
	

	public List findAccount(Customer customer) {
		Session session = HibernateSessionFactory.getSession();
		StringBuffer sb = new StringBuffer();
		sb.append(" from Customer cr ");
		sb.append(" where cr.name = ? ");		
		Query query =session.createQuery(sb.toString());		
		query.setParameter(0,customer.getName());
		List list =query.list();
		return list;
	}
	
	
	public List loginaccountcheck(Customer customer) {
		Session session = HibernateSessionFactory.getSession();
		StringBuffer sb = new StringBuffer();
		sb.append(" from Customer cr ");
		sb.append(" where cr.name = ? ");
		sb.append(" and password =? ");
		Query query =session.createQuery(sb.toString());		
		query.setParameter(0,customer.getName());
		query.setParameter(1,customer.getPassword());
		List list =query.list();
		return list;
	}
	



	public void add(Customer customer) {
		Session session = HibernateSessionFactory.getSession();
		session.save(customer);		
	}


	

}