userdaoimpl.java

来自「struts2+spring2.0+hibernate3.2与acegi 1.0」· Java 代码 · 共 138 行

package com.test.dao.impl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.test.bean.UserBean;
import com.test.dao.UserDAO;
import com.test.page.PageTool;

public class UserDAOImpl extends HibernateDaoSupport implements UserDAO {

	private UserBean userBean;

	@SuppressWarnings("unchecked")
	public List<UserBean> findAllUsers(PageTool pageInfo) {
		// TODO Auto-generated method stub
		//String hql = "from UserBean userBean order by userBean.userId desc";

		//List<UserBean> userList = this.getHibernateTemplate().find(hql);
		
		final int size = pageInfo.getSize();
		
		final int startRow = (pageInfo.getCur()-1)*pageInfo.getSize();
		
		Session session = this.getSession();
		
		Query query = session.createQuery("from UserBean userBean order by userBean.userId desc");

		query.setFirstResult(startRow);
		
		query.setMaxResults(size);
		
		return (List<UserBean>)query.list();
	}

	
	public List<UserBean> findAllUsers() {
		// TODO Auto-generated method stub
		String hql = "from UserBean userBean order by userBean.userId desc";

		List<UserBean> userList = (List<UserBean>)this.getHibernateTemplate().find(hql);
		return userList;
	}


	public UserBean findUserById(String userId) {
		// TODO Auto-generated method stub
		return (UserBean)this.getHibernateTemplate().get(UserBean.class,userId);
	}

	public void removeUser(UserBean userBean) {
		// TODO Auto-generated method stub
		this.getHibernateTemplate().delete(userBean);
		
		Session session = this.getSession();
		
		session.beginTransaction().commit();
		
		session.close();
	}

	public void saveUser(UserBean userBean) {
		// TODO Auto-generated method stub

		try {
			
			//System.out.println("userid_dao="+userBean.getUserId());

			this.getHibernateTemplate().save(userBean);

			Session session = this.getSession();

			session.beginTransaction().commit();

			session.close();

		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	public void updateUser(UserBean userBean) {
		// TODO Auto-generated method stub
		this.getHibernateTemplate().update(userBean);
		
		Session session = this.getSession();
		
		session.beginTransaction().commit();
		
		session.close();
	}

	public UserBean getUserBean() {
		return userBean;
	}

	public void setUserBean(UserBean userBean) {
		this.userBean = userBean;
	}

	public List<UserBean> findUserByFirstNameAndLastName(String firstName,
			String lastName) {
		// TODO Auto-generated method stub
		
		String hql = "from UserBean userBean where userBean.firstName=? and userBean.lastName=?";

		List<UserBean> userBeanList = (List<UserBean>)this.getHibernateTemplate().find(hql,new String[]{firstName,lastName});

		return userBeanList;
	}

	public List<UserBean> findUserByFirstName(String firstName) {
		// TODO Auto-generated method stub
		String hql = "from UserBean userBean where userBean.firstName=?";

		List<UserBean> userBeanList = (List<UserBean>)this.getHibernateTemplate().find(hql,firstName);

		return userBeanList;
	}

	public List<UserBean> findUserByLastName(String lastName) {
		// TODO Auto-generated method stub
		String hql = "from UserBean userBean where userBean.lastName=?";

		List<UserBean> userBeanList = (List<UserBean>)this.getHibernateTemplate().find(hql,lastName);

		return userBeanList;
	}
	
	
	

}