userdaoimpl.java

spring struts hibernate 集成开发的web应用

package com.sc.dao.hibernate;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.*;
//import org.hibernate.type.Type;


import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import java.util.*;

import com.sc.dao.UserDAO;
import com.sc.model.Userinfo;
/**
 * 
 * @author cnsdl
 * @since jdk1.5, spring 1.2, hibernate 3
 *
 */
public class UserDAOImpl extends HibernateDaoSupport implements UserDAO{
	private SessionFactory sessionFactory;
	
	private Log log = LogFactory.getLog(UserDAOImpl.class);
	
	public boolean isValidUser(String username, String password) {

		String hql = "from Userinfo u where u.username=:username and u.password=:password";
		String[] args = new String[]{"username","password"};
		String[] values = new String[] {username,password};

		List userList = getHibernateTemplate().findByNamedParam(hql,args,values);
		System.out.print(userList);
		if (userList.size() > 0) {
			return true;
		}
		return false;
	}
	/**
	 * @return boolean
	 * 返回值为false代表没有被使用
	 */

	public boolean isUsedUsername(String username) {
		
		String hql = "from Userinfo u where u.username=?";
		Object args = new String(username);
		
		List userList = getHibernateTemplate().find(hql,args);
		
		if (userList.size() > 0){
			return true;		
		}
		return false;
	}
	/* (non-Javadoc)
	 * @see com.sc.dao.UserDAO#addUser(com.sc.model.Userinfo)
	 */
	public void addUser(Userinfo user) {
		getHibernateTemplate().saveOrUpdate(user);
		
		if (log.isDebugEnabled()) {
			log.debug( "userId set to:" + user.getUserid());
			}
		
	}
	public List getUsers() {
		
		return getHibernateTemplate().find("from Userinfo");
	}
	public void deleteUser(Integer userid) {
		Object user = getHibernateTemplate().load(Userinfo.class,userid);
		getHibernateTemplate().delete(user);
		
	}
	public void deleteUser(Userinfo user) {
		getHibernateTemplate().delete(user);
		
	}
	public Userinfo getUser(Integer userid) {
		
		return (Userinfo) getHibernateTemplate().get(Userinfo.class,userid);
	}

}