package com.mvc.dao.impl;import java.util.List;import org.hibernate.Query;import org.hibernate.Session;import com.mvc.common.HibernateSessionFactory;import com.mvc.common.exception.PeopleServiceException;import com.mvc.dao.IMemberAdminDao;import com.mvc.dao.bean.JinfengAdmin;import com.mvc.dao.bean.JinfengMemberinfo;import com.mvc.dao.bean.JinfengStudents;public class MemberAdminDaoImpl implements IMemberAdminDao {//	根據本月招生人數查找管理員	public JinfengAdmin findAdmins(long num) throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengAdmin where num=?");		query.setLong(0, num);		return (JinfengAdmin) query.uniqueResult();	}//	管理員查找密碼	public String findNewPassword(String nickname, String question,			String answer) throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengAdmin where nickname=?,passwordquestion=?,passwordanswer=?");		query.setString(0, nickname);		query.setString(1, question);		query.setString(2, answer);				return (String) query.uniqueResult();	}	//根據姓名查找學員信息	public JinfengStudents findStudnetsByName(String name) throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengStudents where name=?");		query.setString(0, name);		return (JinfengStudents) query.uniqueResult();	}	public JinfengAdmin login(String nickname, String password)			throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengAdmin where nickname=? and password=?");		query.setString(0, nickname);		//System.out.println("nickname=="+nickname);				query.setString(1, password);		//System.out.println("password==="+password);		return (JinfengAdmin) query.uniqueResult();	}	public void saveOrUpdateAdmin(JinfengAdmin admin) throws Exception {		Session session=HibernateSessionFactory.currentSession();		//System.out.println("aaaaaaaaaaa");		session.saveOrUpdate(admin);	}	public void saveOrUpdateStudent(JinfengStudents student) throws Exception {		Session session=HibernateSessionFactory.currentSession();		session.saveOrUpdate(student);	}//	查詢當月招生人數前五名的管理員	public List findMemberAdminsByNum(int number) throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengAdmin order by num desc ");		query.setFirstResult(0);//設置第一行		query.setMaxResults(number);		List list=query.list();		return list;	}//	查找客戶的總數	public Integer findNumMemberinfo() throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("select count(*) from JinfengMemberinfo ");		return (Integer) query.uniqueResult();	}//	城市查找	public String getCity(String city) throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengStudents where city=?");		query.setString(0, city);		return (String) query.uniqueResult();	}	public JinfengStudents getRandomMember(int num) throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengStudents");		query.setFirstResult(num);		query.setMaxResults(0);				return (JinfengStudents) query.list().get(0);	}/*	//	查找指定數目學員	public List findStudentsBynum(int num) throws PeopleServiceException {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengStudents where ");		return null;	}*///	根據姓名查找客戶信息	public JinfengMemberinfo findMemberinfoByName(String name) throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengMemberinfo where name=?");		query.setString(0, name);		return (JinfengMemberinfo) query.uniqueResult();	}//	根據姓名查找管理員	public JinfengAdmin findAdminByName(String nickname) throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengAdmin where nickname=?");		query.setString(0, nickname);		return (JinfengAdmin) query.uniqueResult();	}//	根據管理員查詢他所招的學生	public List findStudentsByAdmin(JinfengAdmin admin) throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengStudents where jinfengAdmin=?");		query.setEntity(0, admin);		return query.list();	}//	 保存或者更新客戶信息	public void saveOrUpdateMemberinfo(JinfengMemberinfo memberinfo) throws Exception {		Session session=HibernateSessionFactory.currentSession();		session.saveOrUpdate(memberinfo);			}//	查詢所有客戶的信息	public List<JinfengMemberinfo> findMemberList() throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengMemberinfo");		List<JinfengMemberinfo> list=query.list();		return list;	}//	查詢所有學員的信息	public List<JinfengStudents> findStudentsList() throws Exception {		Session session=HibernateSessionFactory.currentSession();		Query query=session.createQuery("from JinfengStudents");		List<JinfengStudents> list=query.list();		return list;	}}