bbs.java

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

		 catch (RuntimeException e) {e.printStackTrace();}	
		 return list;
	}
    
    
    //按照bbsid搜索parentid子帖
    public List bbsreview(int key) throws Exception

	{
	List list;
	list= new ArrayList();
	try {
		
		String sql="SELECT userName,bbscontent,dateandtime from bbs WHERE parentid="+key+" ORDER BY dateandtime DESC";
		rs=dbconn.executeQuery(sql);
		
		while(rs.next())
		{
			bbs rebbs=new bbs();
			
			rebbs.setBbsContent(rs.getString("bbscontent"));
			rebbs.setBbsUsername(rs.getString("userName"));
			rebbs.setBbsDateandtime(rs.getDate("dateandtime"));
			list.add(rebbs);
		}
		rs.close();
	} catch (RuntimeException e) {
		
		e.printStackTrace();
	}
	return list;
	}
   
    //更新跟帖数
    public void changeBbsChild(int j, int k)
    {
        String SQL = "update bbs set child=child+" + k + " where bbsid=" + j;
        dbconn.executeUpdate(SQL);
    }
    //更新点击率
    public void changeBbsHits(int j, int k)
    {
        strSQL = "update bbs set bbshits=bbshits+" + k + " where bbsid=" + j;
        dbconn.executeUpdate(strSQL);
    }
    //得到帖子的所有相关信息
    public boolean getBbsInfo(int j)
    {
        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");
                bbstopic = rs.getString("bbstopic");
                bbscontent = rs.getString("bbscontent");
                bbshits = rs.getInt("bbshits");
                bbslength = rs.getInt("length");
                bbshot = rs.getString("bbshot");
                bbspic=rs.getString("bbspic");
            } 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 delBbs(int j)
    {
        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);
            }
           
            strSQL = "delete from bbs where bbsid=" + bbsid;
            dbconn.executeUpdate(strSQL);
            }
        }
    //修剪帖子
	public String chStr(String str){
		if(str==null){
			str="";
		}
		else{
			try{
				str=(new String(str.getBytes("iso-8859-1"),"GB2312")).trim();
			}catch(Exception e){
				System.out.println("chStr");
				System.out.println(e.getMessage());
			}
		}
		return str;
	}


    //获取总帖子数量
    public int countBbs()
    {
        strSQL = "SELECT COUNT(*) AS aa FROM bbs";
        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("countBbs.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: 
        	
        	//j==8,j1==0,i1==板块号，K为一页显示多少数量(8,10,0,板块号,"")
            strSQL = "SELECT TOP " + j1 + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + " ORDER BY dateandtime DESC";
            break;

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

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

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

        case 3: 
            strSQL = "SELECT TOP " + j1 + " * FROM bbs where boardid=" + i1 + " and (dateandtime >=#" + s + "#) order by dateandtime desc";
            break;

        case 4: 
            strSQL = "SELECT TOP " + j1 + " * FROM bbs where bbshot='ok' and boardid=" + i1 + " order by dateandtime desc";
            break;

        case 5: 
        case 6: 
        case 7: 
        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 int getRecordsCount(int j, int k, String s)
    {
        rs = null;
        i = 0;
        switch(j)//j表示情况类别，k为板块名称，把帖子的数量给i
        {
        case 0:
            strSQL = "SELECT COUNT(*) AS aa FROM bbs WHERE parentid=0 and boardid=" + k;
            break;

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

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

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

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

        case 5: 
        case 6: 
        case 7: 
        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 ResultSet listBbs(int j, int k, int l, int i1, String s)
    {
        rs = null;
        i = getRecordsStart(j, k, l, i1, s);
        //i1是板块号，k为size,l为当前页面，i1为板块号，s查询关键字，i为查到多少号帖子
        switch(j)
        {
        case 0: 
            strSQL = "SELECT TOP " + k + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + " and bbsid<=" + i + " ORDER BY dateandtime DESC";
            break;

        case 1: 
            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: 
            strSQL = "SELECT TOP " + k + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + " and bbsid<=" + i + " ORDER BY dateandtime DESC";
            break;

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

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

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

        case 5: 
        	strSQL = "SELECT TOP " + k + " * FROM bbs WHERE parentid=0 and boardid=" + i1 + "ORDER BY dateandtime DESC";
            break;
        	
        case 6: 
        case 7: 
        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;
    }

    
    }