memberadmindaoimpl.java

通过网站展示学校风采、文化、优点与特色

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;
	}

}