clubuserimpl.java

特色： 1.今晚在线社区独有的双风格分桢形式 2.社区最多可进行3级分类

/*
 * Created on 2005-10-24
 * Last modified on 2006-1-24
 * Powered by GamVan.com
 */
package com.gamvan.club.dao.impl;

import java.util.Iterator;
import java.util.List;

import org.hibernate.CacheMode;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.gamvan.club.dao.ClubUserDAO;
import com.gamvan.club.item.ClubUserItem;
import com.gamvan.conn.ConnClub;


/**
 * 
 * @author GamVan by 我容易么我
 * Powered by GamVan.com
 */
public class ClubUserImpl extends ClubUserItem implements ClubUserDAO{

    private static final long serialVersionUID = 1L;

    
    /**
     * 根据用户ID返回用户信息
     * @param id
     * @return
     * 2005-11-5 17:37:06 Made In GamVan
     * @see com.gamvan.club.dao.ClubUserDAO#userInfo(int)
     */
    public ClubUserItem userInfo(int id) {
    	ClubUserItem cui = null;
        Session session = ConnClub.getSession();
        String hql = new String();
        try{
            hql = "from ClubUserItem where userID=?";
            Query query = session.createQuery(hql)
            .setInteger(0, id);
            /* 启用查询缓存 */
            query.setCacheable(true); 
            /* 为查询指定其命名的缓存区域 */
            query.setCacheRegion("userCache");
            /*  从二级缓存读写数据 */
            query.setCacheMode(CacheMode.NORMAL);
            cui = (ClubUserItem)query.uniqueResult();
        }catch(Exception e){

        }
        return cui;
    }
    
    
    /**
     * 根据用户名返回用户信息
     * @param name
     * @return
     * 2005-11-5 17:34:34 Made In GamVan
     * @see com.gamvan.club.dao.ClubUserDAO#userInfo(java.lang.String)
     */
    public ClubUserItem userInfo(String name) {
        ClubUserItem cui = null;
        Session session = ConnClub.getSession();
        String hql = new String();
        try{
            hql = "from ClubUserItem where userName=?";
            Query query = session.createQuery(hql)
            .setString(0, name);
            /* 启用查询缓存 */
            query.setCacheable(true); 
            /* 为查询指定其命名的缓存区域 */
            query.setCacheRegion("userCache");
            /*  从二级缓存读写数据 */
            query.setCacheMode(CacheMode.NORMAL);
            cui = (ClubUserItem)query.uniqueResult();
        }catch(Exception e){

        }
       return cui;
    }

    
    /**
     * 根据用户名、密码登录系统
     * @param uName
     * @param uPass
     * @return
     * 2005-11-5 17:34:56 Made In GamVan
     * @see com.gamvan.club.dao.ClubUserDAO#userLogin(java.lang.String, java.lang.String)
     */
    public ClubUserItem userLogin(String uName, String uPass) {
        Session session = ConnClub.getSession();
        String hql = new String();
        ClubUserItem cui = null;
        try{
            hql = "from ClubUserItem where userName=? and userPass=?";
            Query query = session.createQuery(hql)
            .setString(0, uName)
            .setString(1, uPass);
            /* 启用查询缓存 */
            query.setCacheable(true); 
            /* 为查询指定其命名的缓存区域 */
            query.setCacheRegion("userCache");
            /* 从二级缓存读写数据 */
            query.setCacheMode(CacheMode.NORMAL);
            cui = (ClubUserItem)query.uniqueResult();
        }catch(HibernateException e){

        }
        return cui;
    }
    
    
    /**
     * 根据用户ID验证用户登录，一般用作系统登录后进行重要操作的最终确认
     * @param uID
     * @param uPass
     * @return
     * 2005-11-5 17:35:22 Made In GamVan
     * @see com.gamvan.club.dao.ClubUserDAO#userLogin(int, java.lang.String)
     */
    public ClubUserItem userLogin(int uID, String uPass) {
        Session session = ConnClub.getSession();
        String hql = new String();
        ClubUserItem cui = null;
        try{
            hql = "from ClubUserItem where userID=? and userPass=?";
            Query query = session.createQuery(hql)
            .setInteger(0, uID)
            .setString(1, uPass)
            ;
            /* 启用查询缓存 */
            query.setCacheable(true); 
            /* 为查询指定其命名的缓存区域 */
            query.setCacheRegion("userCache");
            /* 从二级缓存读写数据 */
            query.setCacheMode(CacheMode.NORMAL);
            cui = (ClubUserItem)query.uniqueResult();
        }catch(HibernateException e){
            e.printStackTrace();
        }
        return cui;
    }
    
    /**
     * 向数据表添加用户信息
     * @return
     * 2005-11-5 17:36:24 Made In GamVan
     * @see com.gamvan.club.dao.ClubUserDAO#userAdd()
     */
    public ClubUserItem userAdd() {
        Session session = ConnClub.getSession();
        Transaction tran = session.beginTransaction();
        ClubUserItem cui = null;
        try{
            cui = new ClubUserItem();
            cui.setUserName(userName);
            cui.setUserPass(userPass);
            cui.setUserName2(userName2);
            cui.setUserSex(userSex);
            cui.setUserEmail(userEmail);
            cui.setUserEmailOpen(userEmailOpen);
            cui.setUserQuestion(userQuestion);
            cui.setUserAnswer(userAnswer);
            cui.setUserWeb(userWeb);
            cui.setUserQQ(userQQ);
            cui.setUserArea(userArea);
            cui.setUserCity(userCity);
            cui.setUserWork(userWork);
            cui.setUserPen(userPen);
            cui.setUserIntro(userIntro);
            cui.setUserUpfile(userUpfile);
            cui.setUserTxt(userTxt);
            cui.setUserRegTime(userRegTime);
            cui.setUserLastTime(userLastTime);
            cui.setUserLoginTimes(0);
            cui.setUserRegip(userRegip);
            cui.setUserLastip(userLastip);
            cui.setUserMoney(userMoney);
            cui.setUserMark(userMark);
            cui.setUserDeposit(0); //用户存款
            cui.setUserCredit(userCredit);         
            cui.setUserTopicCount(0);
            cui.setUserReCount(0);
            cui.setUserIsDel(userIsDel);
            cui.setUserUpfileOpen(userUpfileOpen);
            cui.setUserUpfileSize(userUpfileSize);
            cui.setUserPic(userPic);
            cui.setUserPicIs(userPicIs);
            cui.setUserAreaId(userAreaId);
            session.save(cui);
            session.flush();
            tran.commit(); 
        }catch(HibernateException e){
            cui = null;
            e.printStackTrace();
        }
        return cui;
    }
    
    
    /**
     * 更新用户注册资料
     * @param id
     * 2005-11-5 17:36:46 Made In GamVan
     * @see com.gamvan.club.dao.ClubUserDAO#userUpdate(int)
     */
    public void userUpdate(int id) {
        Session session = ConnClub.getSession();
        StringBuffer hql = new StringBuffer();
        Transaction tran = session.beginTransaction();
        try{
            hql.append("update ClubUserItem ");
            hql.append(" set userPass=?");
            hql.append(", userName2=?");
            hql.append(", userSex=?");
            hql.append(", userEmail=?");
            hql.append(", userEmailOpen=?");
            hql.append(", userBirthday=?");
            hql.append(", userWeb=?");
            hql.append(", userQQ=?");
            hql.append(", userArea=?");
            hql.append(", userCity=?");
            hql.append(", userWork=?");
            hql.append(", userPen=?");
            hql.append(", userIntro=?");
            hql.append(", userAreaId=?");
            hql.append(" where userID=?");
            session.createQuery(hql.toString())
            .setString(0, userPass)
            .setString(1, userName2)
            .setByte(2, userSex)
            .setString(3, userEmail)
            .setShort(4, userEmailOpen)
            .setString(5, userBirthday)
            .setString(6, userWeb)
            .setString(7, userQQ)
            .setString(8, userArea)
            .setString(9, userCity)
            .setString(10, userWork)
            .setString(11, userPen)
            .setString(12, userIntro)
            .setInteger(13, userAreaId)
            .setInteger(14, id)
            .executeUpdate();
            tran.commit();
        }catch(HibernateException e){
            e.printStackTrace();
            throw new HibernateException("资料更新失败：" + e.toString());
        }
    }

    
    
    /**
     * 用户登录时需要更新的信息
     * @param id 用户ID
     * @param lastip 最后登录IP	
     * @param lasttime 最后登录时间	
     * @param usermark 积分
     * @param usermoney 金币
     * @param usercredit 信誉
     * 2005-11-5 17:40:28 Made In GamVan
     * com.gamvan.club.dao