bbsboard.java

用JSP写的论坛源代码 走过路过的各位千万不要错过啊！！！！

package serv;
import java.sql.ResultSet;
import java.sql.SQLException;
public class bbsboard {
	
	 bbsdb dbconn;
	 ResultSet rs;
	 String strSQL;
	 int i;
	 boolean yesorno;
	 private String boardname;
	 private String boardmaster;
	 private String masterpwd;
	 private String masterword;
	 private String masteremail;
	 private int boardid;
	 private int boardhits;
	 private int boardtopics;

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

	    public int getBoardId()
	    {
	        return boardid;
	    }
	    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 void setBoardId(int j)
	    {
	        boardid = j;
	    }
	    
	    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 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 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 updateBoard(int j)
	    {
	        strSQL = "update board set boardmaster='" + boardmaster + "',masterpwd='" + masterpwd + "',masteremail='" + masteremail + "',masterword='" + masterword + "' where boardid=" + j;
	        dbconn.executeUpdate(strSQL);
	    }
	    //删除板块
	    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 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);
	    }
	    //返回结果集 板块清单
	    public ResultSet listBoard(int j)
	    {
	        rs = null;
	        switch(j)
	        {
	        case 1: 
	            strSQL = "select * from board order by boardid desc";
	            break;

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

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

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

	    //确认版主
	    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;
	    }
}