elanadmindaoimpl.java

struts+hibernate BBS mysql数据库 功能基本齐全

package com.elan.forum.impl;

import java.util.List;

import org.apache.commons.logging.Log;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.elan.db.ElHbnDB;
import com.elan.forum.dao.AdminDAO;
import com.elan.forum.model.ForumAdmin;
import com.elan.forum.model.ForumUser;
import com.elan.forum.model.Forumlevel;
import com.elan.forum.util.Constents;
import com.elan.forum.util.LogMgr;

public class ElanAdminDAOImpl implements AdminDAO {

	private static ElanAdminDAOImpl elanAdminDAOImpl = null;
	private Log log = null;

	private ElanAdminDAOImpl() {
		init();
	}

	private void init() {
		log = LogMgr.getLog(ElanAdminDAOImpl.class);
	}

	static {
		elanAdminDAOImpl = new ElanAdminDAOImpl();
	}

	public static ElanAdminDAOImpl newInstance() {
		if (elanAdminDAOImpl == null) {
			elanAdminDAOImpl = new ElanAdminDAOImpl();
		}
		return elanAdminDAOImpl;
	}

	public ForumAdmin checkAdminAndCreateAdmin(String username, String password) {
		ForumAdmin forumAdmin = null;
		String hql = "from ForumAdmin as model where model.username = ? and model.password = ?";
		Query query = ElHbnDB.getSession().createQuery(hql);
		query.setParameter(0, username);
		query.setParameter(1, password);
		List<ForumAdmin> adminList = query.list();
		if (adminList.size() == 1) {
			forumAdmin = adminList.get(0);
		}
		return forumAdmin;
	}

	/**
	 * 1:成功的琐定用户 (non-Javadoc)
	 * 
	 * @see com.elan.forum.dao.AdminDAO#lockUserById(int)
	 * @return int
	 */
	public int lockUserById(int id) {
		byte lock = 1;
		Session session = ElHbnDB.getSession();
		ForumUser forumUser = (ForumUser) session.get(ForumUser.class,
				new Long(id));
		forumUser.setLocked(Byte.valueOf(lock));
		session.update(forumUser);
		return Constents.CURRENT_OPERATION_SUCCESS;
	}

	public int lockUserByListById(int id, List<ForumUser> userList) {
		System.out.println("为什么啊");
		byte lock = 0;
		Session session = null;
		session = ElHbnDB.getSession();
		ForumUser forumUser = userList.get(id);
		System.out.println(forumUser.getLocked());
		forumUser.setLocked(Byte.valueOf(lock));
		session.update(forumUser);
		return Constents.CURRENT_OPERATION_SUCCESS;
	}

	public int modefyUserByListById(int listId, List<ForumUser> userList) {
		Session session = null;
		ForumUser forumUser = null;
		session = ElHbnDB.getSession();
		forumUser = userList.get(listId);
		session.update(forumUser);
		userList.set(listId, forumUser);
		return Constents.CURRENT_OPERATION_SUCCESS;
	}

	public int modefyUser(ForumUser forumUser) {
		ElHbnDB.getSession().update(forumUser);
		return Constents.CURRENT_OPERATION_SUCCESS;
	}

	public List<ForumUser> findAllUserInCache() {
		return null;
	}

	public int deleteUserById(Integer id) {
		Query query = ElHbnDB.getSession().createQuery(
				"delete from ForumUser where id = ?");
		query.setParameter(0, id.intValue());
		query.executeUpdate();
		return Constents.CURRENT_OPERATION_SUCCESS;
	}

	public int lockUserById(Integer id) {
		Session session = ElHbnDB.getSession();
		ForumUser fu = (ForumUser) session.get(ForumUser.class, id);
		if(null != fu) {
			fu.setLocked(Byte.valueOf("1"));
			session.update(fu);
			System.out.println("已经执行锁定");
		}
		return Constents.CURRENT_OPERATION_SUCCESS;
	}
	public int unLockUserById(Integer id) {
		Session session = ElHbnDB.getSession();
		ForumUser fu = (ForumUser) session.get(ForumUser.class, id);
		if (null != fu) {
			fu.setLocked(Byte.valueOf("0"));
			session.update(fu);
			//System.out.println("已经执行解锁");
		}
		return Constents.CURRENT_OPERATION_SUCCESS;
	}
	public List<Forumlevel> getForumLevel() {
		Session session = ElHbnDB.getSession();
		Query query = session.createQuery("from Forumlevel");
		List<Forumlevel> list = query.list();
		if (!isEmptyList(list)) {
			return list;
		}
		return null;
	}

	private boolean isEmptyList(List list) {
		return list.size() > 0 ? false : true;
	}

}