// Source File Name:   bbsboard.java
package test;
import java.io.PrintStream;
import java.sql.ResultSet;
import java.sql.SQLException;
// Referenced classes of package test:
//            bbsreg

public class bbsboard
{

    public bbsboard()
    {
        dbconn = new bbsreg();
        rs = null;
        boardname = "";
        boardmaster = "";
        masterpwd = "";
        masterword = "";
        masteremail = "";
        boardid = 0;
        boardhits = 0;
        boardtopics = 0;
    }

    public boolean checkBoardMaster(int j, String s, String s1)
    {//檢查是否為該版的管理員
        rs = null;
        strSQL = "select * from board where boardmaster='" + s + "' and masterpwd='" + s1 + "' and boardid=" + j;
        try
        {
            rs = dbconn.executeQuery(strSQL);
            if(rs.next())
            {
                yesorno = true;
                getBoardInfo(j);
            } else
            {
                yesorno = false;
            }
            rs.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
            System.err.println("checkuserpassword.STRSQL:: " + strSQL);
        }
        return yesorno;
    }

    public boolean checkBoardName(String s)
    {//檢查版名
        rs = null;
        yesorno = true;
        strSQL = "select * from board where boardname='" + s + "'";
        try
        {
            rs = dbconn.executeQuery(strSQL);
            if(rs.next())
                yesorno = false;
            rs.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
            System.err.println("countUser.STRSQL:: " + strSQL);
        }
        return yesorno;
    }

    public int countBoard()
    {//統計版的數量
        strSQL = "SELECT COUNT(*) AS aa FROM board";
        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 delBoard(int j)
    {//刪除某一個版面
        strSQL = "delete from board where boardid=" + j;
        dbconn.executeUpdate(strSQL);
        strSQL = "delete from bbs where boardid=" + boardid;
        dbconn.executeUpdate(strSQL);
    }

    public int getBoardHits()
    {//返回版面的點擊量
        return boardhits;
    }

    public int getBoardId()
    {//返回版的ID號
        return boardid;
    }
    public boolean getBoardInfo(int j)
    {//返回版面的設置信息
        rs = null;
        strSQL = "select * from board where boardid=" + j;
        try
        {
            rs = dbconn.executeQuery(strSQL);
            if(rs.next())
            {
                yesorno = true;
                boardid = rs.getInt("boardid");
                boardname = rs.getString("boardname");
                boardmaster = rs.getString("boardmaster");
                masterpwd = rs.getString("masterpwd");
                masterword = rs.getString("masterword");
                masteremail = rs.getString("masteremail");
                boardhits = rs.getInt("boardhits");
                boardtopics = rs.getInt("boardtopics");
            } else
            {
                yesorno = false;
            }
            rs.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
            System.err.println("aq.STRSQL:: " + strSQL);
        }
        return yesorno;
    }

    public String getBoardMaster()
    {//返回版面的管理員
        return boardmaster;
    }

    public String getBoardMasteremail()
    {//返回版面管理員的郵箱地址
        return masteremail;
    }

    public String getBoardMasterpwd()
    {//返回版面管理員的密碼
        return masterpwd;
    }

    public String getBoardMasterword()
    {
        return masterword;
    }

    public String getBoardName()
    {//返回版面名稱
        return boardname;
    }

    public int getBoardTopics()
    {//返回版面的主題
        return boardtopics;
    }

    public ResultSet listBoard(int j)
    {//列出所有版面
        rs = null;
        switch(j)
        {
        case 1: // '\001'
            strSQL = "select * from board order by boardid desc";
            break;

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

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

        default:
            strSQL = "select * from board";
            break;
        }
        rs = dbconn.executeQuery(strSQL);
        return rs;
    }

    public void newBoard()
    {//建立一個新的版面
        strSQL = "insert into board(boardname,boardmaster,masterpwd,masteremail,masterword, boardhits, boardtopics) values('" + boardname + "','" + boardmaster + "','" + masterpwd + "','" + masteremail + "','" + masterword + "'," + boardhits + "," + boardtopics + ")";
        dbconn.executeUpdate(strSQL);
    }

    public void setBoardHits(int j)
    {//設置版面的點擊量
        boardhits = j;
    }
    public void setBoardMaster(String s)
    {//設置版面的管理員
        boardmaster = s;
    }

    public void setBoardMasteremail(String s)
    {//設置版面管理員的郵箱地址
        masteremail = s;
    }

    public void setBoardMasterpwd(String s)
    {//設置版面管理員的密碼
        masterpwd = s;
    }

    public void setBoardMasterword(String s)
    {
        masterword = s;
    }

    public void setBoardName(String s)
    {//設置版面的名稱
        boardname = s;
    }

    public void setBoardTopics(int j)
    {//設置版面的主題
        boardtopics = j;
    }

    public void updateBoard(int j)
    {//更新設置好的版面
        strSQL = "update board set boardmaster='" + boardmaster + "',masterpwd='" + masterpwd + "',masteremail='" + masteremail + "',masterword='" + masterword + "' where boardid=" + j;
        dbconn.executeUpdate(strSQL);
    }

    public void updateBoardHits(int j, int k)
    {//更新版面的點擊量
        strSQL = "update board set boardhits=boardhits+" + k + " where boardid=" + j;
        dbconn.executeUpdate(strSQL);
    }

    public void updateBoardTopics(int j, int k)
    {//更新版面的主題
        strSQL = "update board set boardtopics=boardtopics+" + k + " where boardid=" + j;
        dbconn.executeUpdate(strSQL);
    }

    bbsreg dbconn;
    ResultSet rs;
    String strSQL;
    int i;
    boolean yesorno;
    String boardname;
    String boardmaster;
    String masterpwd;
    String masterword;
    String masteremail;
    int boardid;
    int boardhits;
    int boardtopics;
}