clubusers.java

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

/*
 * Made in GamVan
 * 注册用户相关信息
 * 登陆，查询，参数更新都在此类！
 */
package com.gamvan.club;
import com.gamvan.conn.*;
import com.gamvan.tools.*;
import com.gamvan.club.ClubCounter;
import java.sql.*;
import java.util.*;
import java.text.DecimalFormat;
public class ClubUsers{
    private String userName, userName2, userEmail, userQuestion, userAnswer;
    private String userBirthday, userWeb, userQQ, userArea, userCity, userWork, userPen, userIntro, userTxt;
    private int userID, userSex, userEmailOpen, userUpfile, userLoginTimes;
    private int userTopicCount, userReCount;
    private double userMoney, userMark, userDeposit, userCredit;
    private java.util.Date userRegDate, userLastDate;
    private Time userRegTime, userLastTime;
    private String userRegip, userLastip;
    private String message; //收集信息
    EncodeString ens = new EncodeString(); //字符串加密/转换
    Gb clubgb = new Gb(); //中文编码
    ArrayEdit ae = new ArrayEdit(); //字符串数组处理
    private String userPass = new String(""); //初始化复空值 
    //格式化当前时间
    java.text.SimpleDateFormat isNow = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    private String now = isNow.format(new java.util.Date());
    //控制小数点位数
    DecimalFormat df = new DecimalFormat(".##");
    //验证用户登录
    public boolean userLogin(String uName, String uPass, int es) throws Exception{
        //参数es判断密码是否加密
        boolean tempbea = false;
        uName = clubgb.Gb(uName);
        uPass = clubgb.Gb(uPass);
        if(es==0){
            uPass = ens.encodeString("md5of16",uPass);
        }
        String sql = new String();
        ConnClub bridge = new ConnClub();
        Connection con = bridge.getConnection();
       try{
        ResultSet rs;
        sql = "Select * From GVclubUsers ";
        sql += " where userName = ? and userPass=?" ;
        PreparedStatement pps = con.prepareStatement(sql);
        pps.setString(1, uName);
        pps.setString(2, uPass);
        rs = pps.executeQuery();
        if(rs.next()){
            userTxt = rs.getString(19);
            message = "登陆成功!";
            tempbea = userLoginUpdate(uName, this.userLastip);
            //更新用户登录信息，取得返回值；
            
        }else{
            message = "登陆失败，用户名或密码错误!!!" + uPass;
        }
        rs.close();
        pps.close();
       }catch(Exception e){
           message = "系统出现意外错误，登陆失败!";
       }finally{
           con.close();
       }
        
        //message = userLastip;
        return tempbea;
    }
    //更新用户相关指数
    public boolean userLoginUpdate(String uName, String userLastip) throws Exception{
       boolean tempbea = false;
       String txts = new String("");
       String sql = new String();
       ConnClub bridge = new ConnClub();
       Connection con = bridge.getConnection(); 
       try{
            ClubRule cr = new ClubRule(); //社区制度
            cr.getClubRule();
            txts = cr.getCrMark();
            userMark = ae.txtsList(txts,14,"|");
            txts = "";
            txts = cr.getCrMoney();
            userMoney = ae.txtsList(txts,14,"|");
            txts = "";
            txts = cr.getCrCredit();
            userCredit = ae.txtsList(txts,14,"|");    
            sql = "UPDATE GVclubUsers set userLastTime='" + now + "'";
            sql += ", userLoginTimes=userLoginTimes+1, userLastip='" + userLastip + "'";
            sql += ", userMoney=userMoney+"+ userMoney +", userMark=userMark+"+ userMark+"";
            sql += ", userCredit=userCredit+"+ userCredit +" ";
            sql += " where userName = '"+ uName +"'" ;
            //message = sql;
            PreparedStatement pps1 = con.prepareStatement(sql);
            pps1.executeUpdate();
            tempbea = true;
            pps1.close();
       }catch(Exception e){
           tempbea = false;
           //message = e.toString();
           con.close();
       }finally{
           con.close();
       }
        return tempbea;
    }
    public boolean userSelect(String uName) throws Exception{
        //uName = clubgb.Gb(uName);
        boolean tempbea;
        tempbea = false;
        ConnClub bridge = new ConnClub();
        Connection con = bridge.getConnection();   
        try{
            String sqlCommand = new String();
            ResultSet rs;
            sqlCommand = "Select * From GVclubUsers where userName=?" ;
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setString(1,uName);
            rs = pps.executeQuery();
            if(rs.next()){
                tempbea = true;
                userID = rs.getInt("userID");
                userName = rs.getString("userName").trim();
                userPass = rs.getString("userPass").trim();
                userName2 = rs.getString("userName2");
                userSex = rs.getInt("userSex");
                userEmail = rs.getString("userEmail");
                userEmailOpen = rs.getInt("userEmailOpen");
                userQuestion = rs.getString("userQuestion");
                userAnswer = rs.getString("userAnswer");
                userBirthday = rs.getString("userBirthday");
                userWeb = rs.getString("userWeb");
                userQQ = rs.getString("userQQ");
                userArea = rs.getString("userArea");
                userCity = rs.getString("userCity");
                userWork = rs.getString("userWork");
                userPen = rs.getString("userPen");
                userIntro = rs.getString("userIntro");
                userUpfile = rs.getInt("userUpfile");
                userTxt = rs.getString("userTxt");
                userRegDate = rs.getDate("userRegTime");
                //userRegTime= rs.getTime(20);
                userLastDate = rs.getDate("userLastTime");
                //userLastTime = rs.getTime(21);
                userMoney = rs.getDouble("userMoney");
                userDeposit = rs.getDouble("userDeposit");
                userMark = rs.getDouble("userMark");
                userCredit = rs.getDouble("userCredit");
                userTopicCount = rs.getInt("userTopicCount");
                userReCount = rs.getInt("userReCount");
                }
            rs.close();
            pps.close();
            }catch(Exception e){
                con.close();
                tempbea = false;
                message = e.toString() + String.valueOf(tempbea);
            }finally{
                con.close();
            }
        
        return tempbea;
        
    }
   public boolean userSelect(int userid) throws Exception{
        //uName = clubgb.Gb(uName);
        boolean tempbea;
        tempbea = false;
        ConnClub bridge = new ConnClub();
        Connection con = bridge.getConnection();   
        try{
            String sqlCommand = new String();
            ResultSet rs;
            sqlCommand = "Select * From GVclubUsers where userID=?" ;
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setInt(1,userid);
            rs = pps.executeQuery();
            if(rs.next()){
                tempbea = true;
                userID = rs.getInt("userID");
                userName = rs.getString("userName").trim();
                userPass = rs.getString("userPass").trim();
                userName2 = rs.getString("userName2");
                userSex = rs.getInt("userSex");
                userEmail = rs.getString("userEmail");
                userEmailOpen = rs.getInt("userEmailOpen");
                userQuestion = rs.getString("userQuestion");
                userAnswer = rs.getString("userAnswer");
                userBirthday = rs.getString("userBirthday");
                userWeb = rs.getString("userWeb");
                userQQ = rs.getString("userQQ");
                userArea = rs.getString("userArea");
                userCity = rs.getString("userCity");
                userWork = rs.getString("userWork");
                userPen = rs.getString("userPen");
                userIntro = rs.getString("userIntro");
                userUpfile = rs.getInt("userUpfile");
                userTxt = rs.getString("userTxt");
                userRegDate = rs.getDate("userRegTime");
                //userRegTime= rs.getTime(20);
                userLastDate = rs.getDate("userLastTime");
                //userLastTime = rs.getTime(21);
                userMoney = rs.getDouble("userMoney");
                userDeposit = rs.getDouble("userDeposit");
                userMark = rs.getDouble("userMark");
                userCredit = rs.getDouble("userCredit");
                userTopicCount = rs.getInt("userTopicCount");
                userReCount = rs.getInt("userReCount");
                }
            rs.close();
            pps.close();
            }catch(Exception e){
                con.close();
                tempbea = false;
                message = e.toString() + String.valueOf(tempbea);
            }finally{
                con.close();
            }
        return tempbea;
    } 
    
    //act判断执行方式 0执行添加 1执行更新
    public boolean userRegPost(String act, String uName) throws Exception{
        uName = clubgb.Gb(uName);
        String txts = new String("");
        boolean tempbea = false;
        ClubUsers cu = new ClubUsers();
        String sql = new String();
        sql = cu.userReg(act, uName);
        ConnClub bridge = new ConnClub();
        Connection con = bridge.getConnection();
        try{
            ClubInfo ci = new ClubInfo();
            userUpfile = ci.getClubUpfileUser(); // 取出用户默认上传空间大小
            PreparedStatement pps = con.prepareStatement(sql);
            if(act.equals("add")){ //添加
                ClubCounter ccu = new ClubCounter();
                if(userSex==1){
                    ccu.counterUpdate(0, 0, 0, 0, 1, 0, 0, uName);
                }else{
                    ccu.counterUpdate(0, 0, 0, 0, 0, 1, 0, uName);
                }
                pps.setString(1, userName);
                pps.setString(2, userPass);
                pps.setString(3, userName2);
                pps.setInt(4, userSex);
                pps.setString(5, userEmail);
                pps.setInt(6, userEmailOpen);
                pps.setString(7, userQuestion);
                pps.setString(8, userAnswer);
                pps.setString(9, userBirthday);
                pps.setString(10, userWeb);
                pps.setString(11, userQQ);
                pps.setString(12, userArea);
                pps.setString(13, userCity);
                pps.setString(14, userWork);
                pps.setString(15, userPen);
                pps.setString(16, userIntro);   
                ClubRule cr = new ClubRule(); //社区制度
                cr.getClubRule();
                txts = cr.getCrMark();
                userMark = ae.txtsList(txts,15,"|");
                txts = "";
                txts = cr.getCrMoney();
                userMoney = ae.txtsList(txts,15,"|");
                txts = "";
                txts = cr.getCrCredit();
                userCredit = ae.txtsList(txts,15,"|");                    
                pps.setInt(17, userUpfile);     
                //pps.setString(16, "");
                pps.setString(18,now); //用户注册时间
                pps.setString(19,now); //最后登陆时间
                pps.setInt(20,0); //用户登录次数
                pps.setString(21,userRegip);
                pps.setString(22,userLastip);
                pps.setDouble(23,userMoney);
                pps.setDouble(24,0); //用户存款
                pps.setDouble(25,userMark);
                pps.setDouble(26,userCredit);
                pps.setInt(27,0);
                pps.setInt(28,0);     
            }else{
                    pps.setString(1, userPass);
                    pps.setString(2, userName2);
                    pps.setInt(3, userSex);
                    pps.setString(4, userEmail);
                    pps.setInt(5, userEmailOpen);
                    pps.setString(6, userBirthday);
                    pps.setString(7, userWeb);
                    pps.setString(8, userQQ);
                    pps.setString(9, userArea);
                    pps.setString(10, userCity);
                    pps.setString(11, userWork);
                    pps.setString(12, userPen);
                    pps.setString(13, userIntro);
                    pps.setString(14, uName);
            }
            tempbea = true;
            pps.executeUpdate();
            pps.close();
        }catch(Exception e){
            con.close();
        }finally{
            con.close();
        }
        //message = userWork+"11111111"+userPen;
        return tempbea;
    }
    //====================================
    public String userReg(String act, String uName){
        String sqlCommand = new String();
        sqlCommand = "";