userdao.java

当下流行的struts2的一个简单应用

package com.jack.user.dao.impl;

import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.jack.user.dao.IUserDAO;
import com.jack.user.pojo.User;

public class UserDAO extends HibernateDaoSupport implements IUserDAO {
	private static final Log log = LogFactory.getLog(UserDAO.class);
	// property constants
	public static final String USER_NAME = "userName";
	public static final String PASSWORD = "password";

	public void saveUser(User user) throws RuntimeException {
		log.debug("saving User instance");
		getHibernateTemplate().save(user);
		log.debug("save successful");
	}

	public void deleteUser(User user) throws RuntimeException {
		log.debug("deleting User instance");
		getHibernateTemplate().delete(user);
		log.debug("delete successful");

	}

	public boolean deleteUserById(String id) throws RuntimeException {
		Session session = this.getSession();
		getHibernateTemplate().delete(session.get(User.class, id));
		return true;
	}

	public User findUserById(String id) throws RuntimeException {
		log.debug("getting User instance with id: " + id);
		User instance = (User) getHibernateTemplate().get(
				"com.jack.user.pojo.User", id);
		return instance;
	}

	public boolean findUserByUNameAndPwd(String userName,String password) throws RuntimeException{
		boolean flag = false;
		String hql = "select user from User as user where user.userName=? and user.password=?";
		Query query = this.getSession().createQuery(hql);
		query.setString(0, userName);
		query.setString(1, password);
		List list = query.list();
		if(list.size()>0){
			flag = true;
		}
		return flag;
	}
	
	public boolean findUserByUserName(String userName) throws RuntimeException {
		boolean flag = false;
		String hql = "from User as user where user.userName=?";
		List list = this.getHibernateTemplate().find(hql, userName);
		if (list.size() > 0) {
			flag = true;
		}
		return flag;
	}

	public List findAll() throws RuntimeException {
		log.debug("finding all User instances");
		String queryString = "from User";
		return getHibernateTemplate().find(queryString);
	}
	public static UserDAO getFromApplicationContext(ApplicationContext ctx) {
		return (UserDAO) ctx.getBean("UserDAO");
	}

}