bbs.java

有用的JSP程序设计教程(源代码)

// Source File Name:   bbs.java
package test;
import java.io.PrintStream;
import java.sql.ResultSet;
import java.sql.SQLException;

// Referenced classes of package test:
//            bbsreg, bbsuser

public class bbs
{

    public bbs()
    {
        dbconn = new bbsreg();
        bbsuser = new bbsuser();
        rs = null;
        bbsid = 0;
        parentid = 0;
        boardid = 0;
        child = 0;
        username = "";
        useremail = "";
        userip = "";
        expression = "";
        usersign = "";
        bbstopic = "";
        bbscontent = "";
        bbshits = 0;
        bbslength = 0;
        bbshot = "";
    }

    public void addNewBbs()

    {//增加版面
        strSQL = "INSERT INTO bbs(parentid,boardid,child,username,useremail,userip, expression,usersign, bbstopic,bbscontent,bbshits,length) VALUES(" + parentid + "," + boardid + "," + child + ",'" + username + "','" + useremail + "','" + userip + "','" + expression + "','" + usersign + "','" + bbstopic + "','" + bbscontent + "'," + bbshits + "," + bbslength + ")";
        dbconn.executeUpdate(strSQL);
    }

    public void changeBbsChild(int j, int k)
    {//改变BBS的子版面
        strSQL = "update bbs set child=child+" + k + " where bbsid=" + j;
        dbconn.executeUpdate(strSQL);
    }

    public void changeBbsHits(int j, int k)
    {//修改点击量
        strSQL = "update bbs set bbshits=bbshits+" + k + " where bbsid=" + j;
        dbconn.executeUpdate(strSQL);
    }

    public void delBbs(int j)
    {//删除BBS
        rs = null;
        if(getBbsInfo(j))
        {
            if(parentid == 0)
            {
                strSQL = "delete from bbs where parentid=" + bbsid;
                dbconn.executeUpdate(strSQL);
                strSQL = "update board set boardtopics=boardtopics-1 where boardid=" + boardid;
                dbconn.executeUpdate(strSQL);
            } else
            {
                strSQL = "update bbs set child=child-1 where bbsid=" + parentid;
                dbconn.executeUpdate(strSQL);
            }
            bbsuser.changeUserClass(username, -3);
            strSQL = "delete from bbs where bbsid=" + bbsid;
            dbconn.executeUpdate(strSQL);
        }
    }

    public int getBbsBoardid()
    {//返回BBS的ID号
        return boardid;
    }

    public int getBbsChild()
    {//返回子论坛
        return child;
    }

    public String getBbsContent()
    {//返回BBS的版首语
        return bbscontent;
    }

    public String getBbsExpression()
    {//返回BBS的状态
        return expression;
    }

    public int getBbsHits()
    {//返回BBS的点击量
        return bbshits;
    }

    public String getBbsHot()
    {//返回热点BBS
        return bbshot;
    }

    public boolean getBbsInfo(int j)
    {//返回BBS的信息
        rs = null;
        strSQL = "select * from bbs where bbsid=" + j;
        try
        {
            rs = dbconn.executeQuery(strSQL);
            if(rs.next())
            {
                yesorno = true;
                bbsid = rs.getInt("bbsid");
                parentid = rs.getInt("parentid");
                boardid = rs.getInt("boardid");
                child = rs.getInt("child");
                username = rs.getString("username");
                useremail = rs.getString("useremail");
                userip = rs.getString("userip");
                expression = rs.getString("expression");
                usersign = rs.getString("usersign");
                bbstopic = rs.getString("bbstopic");
                bbscontent = rs.getString("bbscontent");
                bbshits = rs.getInt("bbshits");
                bbslength = rs.getInt("length");
                bbshot = rs.getString("bbshot");
            } else
            {
                yesorno = false;
            }
            rs.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
            System.err.println("aq.STRSQL:: " + strSQL);
        }
        return yesorno;
    }

    public int getBbsLength()
    {//返回BBS的长度
        return bbslength;
    }

    public int getBbsParentid()
    {//返回BBS的父论坛
        return parentid;
    }

    public String getBbsTopic()
    {//返回BBS的主题
        return bbstopic;
    }

    public String getBbsUseremail()
    {返回BBS中的用户邮箱
        return useremail;
    }

    public String getBbsUserip()
    {//返回BBS中用户的IP地址
        return userip;
    }
    public String getBbsUsername()
    {//返回BBS的用户名称
        return username;
    }

    public String getBbsUsersign()
    {
        return usersign;
    }

    public int getRecordsCount(int j, int k, String s)
    {//统计记录数
        rs = null;
        i = 0;
        switch(j)
        {
        case 0: // '\0'
            strSQL = "SELECT COUNT(*) AS aa FROM bbs WHERE parentid=0 and boardid=" + k;
            break;

        case 8: // '\b'
            strSQL = "SELECT COUNT(*) AS aa FROM bbs WHERE parentid=0 and boardid=" + k;
            break;

        case 1: // '\001'
            strSQL = "SELECT COUNT(*) AS aa FROM bbs where parentid=0 and boardid=" + k + " and (bbstopic like '%" + s + "%')";
            break;

        case 2: // '\002'
            strSQL = "SELECT COUNT(*) AS aa FROM bbs where boardid=" + k + " and (username like '%" + s + "%')";
            break;

        case 3: // '\003'
            strSQL = "SELECT COUNT(*) AS aa FROM bbs where boardid=" + k + " and (dateandtime >=#" + s + "#)";
            break;

        case 4: // '\004'
            strSQL = "SELECT COUNT(*) AS aa FROM bbs where bbshot='ok' and boardid=" + k;
            break;

        case 5: // '\005'
        case 6: // '\006'
        case 7: // '\007'
        default:
            strSQL = "SELECT COUNT(*) AS aa FROM bbs WHERE parentid=0 and boardid=" + k;
            break;
        }
        try
        {
            rs = dbconn.executeQuery(strSQL);
            if(rs.next())
                i = rs.getInt("aa");
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
            System.err.println("aq.STRSQL:!#: " + strSQL);
        }
        return i;
    }

    public int getRecordsStart(int j, int k, int l, int i1, String s)
    {//返回记录的首记录
        rs = null;
        i = 0;
        int j1 = 0;
        if(l == 0)
            j1 = 0;
        else
            j1 = (l - 1) * k + 1;
        switch(j)
        {
        case 8: // '\b'
            strSQL = "SELECT TOP " + j1 + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + " ORDER BY dateandtime DESC";
            break;

        case 0: // '\0'
            strSQL = "SELECT TOP " + j1 + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + " ORDER BY dateandtime DESC";
            break;

        case 1: // '\001'
            strSQL = "SELECT TOP " + j1 + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + " and (bbstopic like '%" + s + "%') ORDER BY dateandtime DESC";
            break;

        case 2: // '\002'
            strSQL = "SELECT TOP " + j1 + " * FROM bbs where boardid=" + i1 + " and (username like '%" + s + "%') order by dateandtime desc";
            break;

        case 3: // '\003'

            strSQL = "SELECT TOP " + j1 + " * FROM bbs where boardid=" + i1 + " and (dateandtime >=#" + s + "#) order by dateandtime desc";
            break;
        case 4: // '\004'
            strSQL = "SELECT TOP " + j1 + " * FROM bbs where bbshot='ok' and boardid=" + i1 + " order by dateandtime desc";
            break;

        case 5: // '\005'
        case 6: // '\006'
        case 7: // '\007'
        default:
            strSQL = "SELECT TOP " + j1 + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + " ORDER BY dateandtime DESC";
            break;
        }
        try
        {
            for(rs = dbconn.executeQuery(strSQL); rs.next();)
                i = rs.getInt("bbsid");

            rs.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
            System.err.println("aq.STRSQL:!#$$: " + strSQL);
        }
        return i;
    }

    public ResultSet listBbs(int j, int k, int l, int i1, String s)
    {//列出所有论坛
        rs = null;
        i = getRecordsStart(j, k, l, i1, s);
        switch(j)
        {
        case 0: // '\0'
            strSQL = "SELECT TOP " + k + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + " and bbsid<=" + i + " ORDER BY dateandtime DESC";
            break;

        case 1: // '\001'
            strSQL = "SELECT TOP " + k + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + " and (bbstopic like '%" + s + "%') and bbsid<=" + i + " ORDER BY dateandtime DESC";
            break;

        case 8: // '\b'
            strSQL = "SELECT TOP " + k + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + " and bbsid<=" + i + " ORDER BY dateandtime DESC";
            break;

        case 2: // '\002'
            strSQL = "SELECT TOP " + k + " * FROM bbs where boardid=" + i1 + " and (username like '%" + s + "%') and bbsid<=" + i + " order by dateandtime desc";
            break;

        case 3: // '\003'
            strSQL = "SELECT * FROM bbs where boardid=" + i1 + " and (dateandtime >=#" + s + "#) and bbsid<=" + i + " order by dateandtime desc";
            break;

        case 4: // '\004'
            strSQL = "SELECT * FROM bbs where bbshot='ok' and boardid=" + i1 + " and bbsid<=" + i + " order by dateandtime desc";
            break;

        case 5: // '\005'
        case 6: // '\006'
        case 7: // '\007'
        default:
            strSQL = "SELECT TOP " + k + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + " and bbsid<=" + i + " ORDER BY dateandtime DESC";
            break;
        }
        rs = dbconn.executeQuery(strSQL);
        return rs;
    }

    public ResultSet listBbsRe(int j)
    {
        rs = null;
        strSQL = "select * from bbs where parentid=" + j;
        rs = dbconn.executeQuery(strSQL);
        return rs;
    }

    public void setBbsBoardid(int j)
    {//设置论坛的ID号
        boardid = j;
    }

    public void setBbsChild(int j)
    {//设置子论坛
        child = j;
    }

    public void setBbsContent(String s)
    {//设置论坛的版首语
        bbscontent = s;
    }

    public void setBbsExpression(String s)
    {//设置论坛的状态
        expression = s;
    }

    public void setBbsHits(int j)
    {//设置论坛的点击量
        bbshits = j;
    }

    public void setBbsHot(int j)
    {//以ID号为序设置论坛为热点论坛
        strSQL = "update bbs set bbshot='ok' where bbsid=" + j;
        dbconn.executeUpdate(strSQL);
    }

    public void setBbsHot(String s)
    {//以名称设置论坛为热点论坛
        bbshot = s;
    }

    public void setBbsLength(int j)
    {//设置论坛的长度
        bbslength = j;
    }

    public void setBbsNohot(int j)
    {//设置论坛为一般论坛
        strSQL = "update bbs set bbshot='no' where bbsid=" + j;
        dbconn.executeUpdate(strSQL);
    }

    public void setBbsParentid(int j)
    {//设置论坛的父论坛
        parentid = j;
    }

    public void setBbsTopic(String s)
    {//设置论坛的主题
        bbstopic = s;
    }

    public void setBbsUseremail(String s)
    {//设置论坛用户的邮箱
        useremail = s;
    }

    public void setBbsUserip(String s)
    {//设置用户登录的IP地址
        userip = s;
    }
    public void setBbsUsername(String s)
    {//设置用户名称
        username = s;
    }
    public void setBbsUsersign(String s)
    {
        usersign = s;
    }
    bbsreg dbconn;
    bbsuser bbsuser;
    ResultSet rs;
    String strSQL;
    boolean yesorno;
    int i;
    int bbsid;
    int parentid;
    int boardid;
    int child;
    int bbshits;
    int bbslength;
    String username;
    String useremail;
    String userip;
    String expression;
    String usersign;
    String bbstopic;
    String bbscontent;
    String bbshot;
}