// Source File Name:   bbsuser.java
package test;
import java.io.PrintStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
// Referenced classes of package test:
//            bbsreg
public class bbsuser
{
    public bbsuser()
    {
        dbconn = new bbsreg();
        rs = null;
        userid = 0;
        username = null;
        userpassword = null;
        useremail = null;
        userhomepage = null;
        hpname = null;
        usersex = null;
        comefrom = null;
        usersign = null;
        userclass = 0;
        userbirthday = new Date();
        dateandtime = new Date();
    }
    public void changeUserClass(String s, int j)
    {//用戶修改組別
        strSQL = "update user set userclass=userclass+" + j + " where username='" + s + "'";
        dbconn.executeUpdate(strSQL);
    }
    public void changeUserPassword(String s, String s1)
    {//用戶修改密碼
        strSQL = "update user set userpassword='" + s1 + "' where username='" + s + "'";
        dbconn.executeUpdate(strSQL);
    }
    public boolean checkUserPassword(String s, String s1)
    {//檢查用戶密碼
        rs = null;
        strSQL = "select * from user where username='" + s + "' and userpassword='" + s1 + "'";
        try
        {
            rs = dbconn.executeQuery(strSQL);
            if(rs.next())
            {
                isUser = true;
                getUserInfo(s);
            } else
            {
                isUser = false;
            }
            rs.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
            System.err.println("checkuserpassword.STRSQL:: " + strSQL);
        }
        return isUser;
    }

    public int countUser()
    {//統計用戶總數
        strSQL = "SELECT COUNT(*) AS aa FROM user";
        i = 0;
        try
        {
            rs = dbconn.executeQuery(strSQL);
            if(rs.next())
                i = rs.getInt("aa");
            rs.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
            System.err.println("countUser.STRSQL:: " + strSQL);
        }
        return i;
    }

    public void delUser(String s)
    {//刪除用戶名
        strSQL = "delete from user where username='" + s + "'";
        dbconn.executeUpdate(strSQL);
    }

    public Date getUserBirthday()
    {//取得用戶生日日期
        return userbirthday;
    }
    public int getUserClass()
    {//返回用戶組別
        return userclass;
    }

    public String getUserComefrom()
    {//返回用戶屬地
        return comefrom;
    }

    public Date getUserDateandtime()
    {
        return dateandtime;
    }

    public String getUserEmail()
    {//返回用戶Email
        return useremail;
    }

    public String getUserHomepage()
    {//返回用戶主頁
        return userhomepage;
    }

    public String getUserHomepagename()
    {//返回用戶主頁名稱
        return hpname;
    }

    public int getUserId()
    {//返回用戶ID號
        return userid;
    }

    public boolean getUserInfo(String s)
    {//讀取用戶注冊信息
        rs = null;
        strSQL = "select * from user where username='" + s + "'";
        try
        {
            rs = dbconn.executeQuery(strSQL);
            if(rs.next())
            {
                isUser = true;
                userid = rs.getInt("userid");
                username = rs.getString("username");
                userpassword = rs.getString("userpassword");
                useremail = rs.getString("useremail");
                userhomepage = rs.getString("userhomepage");
                hpname = rs.getString("hpname");
                userbirthday = rs.getDate("userbirthday");
                usersex = rs.getString("usersex");
                comefrom = rs.getString("comefrom");
                userclass = rs.getInt("userclass");
                usersign = rs.getString("usersign");
                dateandtime = rs.getDate("dateandtime");
            } else
            {
                isUser = false;
            }
            rs.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
            System.err.println("aq.STRSQL:: " + strSQL);
        }
        return isUser;
    }

    public String getUserName()
    {//返回用戶名稱
        return username;
    }

    public String getUserPassword()
    {//返回用戶密碼
        return userpassword;
    }

    public String getUserSex()
    {//返回用戶性別
        return usersex;
    }

    public String getUserSign()
    {
        return usersign;
    }

    public ResultSet listUser(int j)
    {//顯示用戶列表
        rs = null;
        switch(j)
        {
        case 1: // '\001'
            strSQL = "select * from user order by userid desc";
            break;

        case 2: // '\002'
            strSQL = "select * from user order by username desc";
            break;

        case 3: // '\003'
            strSQL = "select * from user order by userclass desc";
            break;

        default:
            strSQL = "select * from user order by userid desc";
            break;
        }
        rs = dbconn.executeQuery(strSQL);
        return rs;
    }

    public void registryNewUser()
    {//注冊新用戶
        strSQL = "INSERT INTO USER(username,userpassword,useremail,userhomepage,hpname,usersex,comefrom,userclass,usersign) values('" + username + "','" + userpassword + "','" + useremail + "','" + userhomepage + "','" + hpname + "','" + usersex + "','" + comefrom + "','" + userclass + "','" + usersign + "')";
        dbconn.executeUpdate(strSQL);
    }

    public void setUserBirthday(Date date)
    {//設置用戶生日日期
        userbirthday = date;
    }

    public void setUserClass(int j)
    {//設置用戶組別
        userclass = j;
    }

    public void setUserComefrom(String s)
    {//設置用戶屬地
        comefrom = s;
    }

    public void setUserDateandtime(Date date)
    {
        dateandtime = date;
    }

    public void setUserEmail(String s)
    {//設置用戶Email地址
        useremail = s;
    }

    public void setUserHomepage(String s)
    {//設置用戶主頁
        userhomepage = s;
    }

    public void setUserHomepagename(String s)
    {//設置用戶主頁名稱
        hpname = s;
    }

    public void setUserName(String s)
    {//設置用戶名稱
        username = s;
    }
    public void setUserPassword(String s)
    {//設置用戶密碼
        userpassword = s;
    }
    public void setUserSex(String s)
    {//設置用戶性別
        usersex = s;
    }
    public void setUserSign(String s)
    {
        usersign = s;
    }
    public void updateUserInfo(String s)
    {//更新用戶的資料
        strSQL = "update user set useremail='" + useremail + "',userhomepage='" + userhomepage + "',hpname='" + hpname + "',usersex='" + usersex + "',comefrom='" + comefrom + "',usersign='" + usersign + "' where username='" + s + "'";
        dbconn.executeUpdate(strSQL);
    }

    bbsreg dbconn;
    ResultSet rs;
    String strSQL;
    int i;
    boolean isUser;
    int userid;
    int userclass;
    String username;
    String userpassword;
    String useremail;
    String userhomepage;
    String hpname;
    String usersex;
    String comefrom;
    String usersign;
    Date userbirthday;
    Date dateandtime;
}