bbs.java

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

package serv;

import java.sql.*;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.io.*;




public class bbs {
	private int bbsid;
	private int parentid;
	private int boardid;
	private int child;
    private int bbshits;
    private int bbslength;
    private String userName;
    private String userEmail;
    private String userip;
    private String expression;
    private String userSign;
    private String bbstopic;
    private String bbscontent;
    private String bbshot;
    Date dateAndtime;
    String bbspic;
    bbsdb dbconn= new bbsdb();
    ResultSet rs;
    String strSQL;
    boolean yesorno;
    int i;
    public bbs()
    {
		dbconn = new bbsdb();
        //bbsuser bbsuser = new bbsuser();
        rs = null;
        bbsid = 0;
        parentid = 0;
        boardid = 0;
        child = 0;
        userName = "";
        userEmail = "";
        userip = "";
        userSign = "";
        bbstopic = "";
        bbscontent = "sdfasdf";
        bbshits = 0;
        bbslength = 0;
        bbshot = "";
        bbspic="";
        dateAndtime =new Date();
        
    }
	public void setBbsid(int j)
    {
        bbsid = j;
    }
	public void setBbsBoardid(int j)
    {
        boardid = j;
    }

    public void setBbsChild(int j)
    {
        child = j;
    }

    public void setBbsContent(String s)
    {
        bbscontent = s;
    }
    public void setBbsHits(int j)
    {
        bbshits = j;
    }

    public void setBbsHot(int j)
    {
        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)
    {
        userip = s;
    }

    public void setBbsUsername(String s)
    {
        userName = s;
    }

    public void setBbsUsersign(String s)
    {
        userSign = s;
    }
    public void setBbsPic(String s)
    {
    	bbspic=s;
    }
    public void setBbsDateandtime(Date date)
    {
        dateAndtime = date;
    	 }
    
    //get
    public int getBbsid()
    {
    	return bbsid;
    }
    public int getBbsBoardid()
    {
        return boardid;
    }
    public Date getBbsDateandtime()
    {
        return dateAndtime;
    	}

    public int getBbsChild()
    {
        return child;
    }

    public String getBbsContent()
    {
        return bbscontent;
    }
    public int getBbsHits()
    {
        return bbshits;
    }
    public String getBbsHot()
    {
        return bbshot;
    }

    

    public int getBbsLength()
    {
        return bbslength;
    }

    public int getBbsParentid()
    {
        return parentid;
    }

    public String getBbsTopic()
    {
        return bbstopic;
    }

    public String getBbsUseremail()
    {
        return userEmail;
    }

    public String getBbsUserip()
    {
        return userip;
    }

    public String getBbsUsername()
    {
        return userName;
    }

    public String getBbsUsersign()
    {
        return userSign;
    }
    public String getBbspic()
    {
    	return bbspic;
    }
    //按照题目搜索父贴
    public List bbslistTitle(String key) throws Exception
	{
		 List list= new ArrayList();
		 try {
				String sql="SELECT bbsid,child,userName,bbstopic,bbscontent,bbshits,dateandtime from bbs WHERE parentid=0 and bbstopic='"+key+"'";
				rs=dbconn.executeQuery(sql);
				String SQL = "update bbs set bbshits=bbshits+1 where bbstopic='"+key+"'";
		        dbconn.executeUpdate(SQL);
				while(rs.next())
				{
					bbs bbs=new bbs();
					bbs.setBbsid(Integer.parseInt(rs.getString("bbsid")));
					bbs.setBbsChild(Integer.parseInt(rs.getString("child")));
					bbs.setBbsUsername(rs.getString("userName"));
					bbs.setBbsTopic(rs.getString("bbstopic"));
					bbs.setBbsContent(rs.getString("bbscontent"));
					bbs.setBbsHits(Integer.parseInt(rs.getString("bbshits")));
					bbs.setBbsDateandtime(rs.getDate("dateandtime"));
					list.add(bbs);
				}
				rs.close();
				} 
		 catch (RuntimeException e) {e.printStackTrace();}	
		 return list;
	}
    //按照题目关键字查询父贴
    public List bbslistkeyTopic(String key) throws Exception
	{
		 List list= new ArrayList();
		 try {
				String sql="SELECT bbsid,child,userName,bbstopic,bbscontent,bbshits,dateandtime from bbs WHERE parentid=0 and bbstopic like'%"+key+"%'";
				rs=dbconn.executeQuery(sql);
				while(rs.next())
				{
					bbs bbs=new bbs();
					bbs.setBbsid(Integer.parseInt(rs.getString("bbsid")));
					bbs.setBbsChild(Integer.parseInt(rs.getString("child")));
					bbs.setBbsUsername(rs.getString("userName"));
					bbs.setBbsTopic(rs.getString("bbstopic"));
					bbs.setBbsContent(rs.getString("bbscontent"));
					bbs.setBbsHits(Integer.parseInt(rs.getString("bbshits")));
					bbs.setBbsDateandtime(rs.getDate("dateandtime"));
					list.add(bbs);
				}
				rs.close();
				} 
		 catch (RuntimeException e) {e.printStackTrace();}	
		 return list;
	}
    //按照作者关键字查询父贴
    public List bbslistkeyWriter(String key) throws Exception
	{
		 List list= new ArrayList();
		 try {
				String sql="SELECT bbsid,child,userName,bbstopic,bbscontent,bbshits,dateandtime from bbs WHERE parentid=0 and userName like'%"+key+"%'";
				rs=dbconn.executeQuery(sql);
				while(rs.next())
				{
					bbs bbs=new bbs();
					bbs.setBbsid(Integer.parseInt(rs.getString("bbsid")));
					bbs.setBbsChild(Integer.parseInt(rs.getString("child")));
					bbs.setBbsUsername(rs.getString("userName"));
					bbs.setBbsTopic(rs.getString("bbstopic"));
					bbs.setBbsContent(rs.getString("bbscontent"));
					bbs.setBbsHits(Integer.parseInt(rs.getString("bbshits")));
					bbs.setBbsDateandtime(rs.getDate("dateandtime"));
					list.add(bbs);
				}
				rs.close();
				} 
		 catch (RuntimeException e) {e.printStackTrace();}	
		 return list;
	}
    //按照内容关键字查询父贴
    public List bbslistkeyContent(String key) throws Exception
	{
		 List list= new ArrayList();
		 try {
				String sql="SELECT bbsid,child,userName,bbstopic,bbscontent,bbshits,dateandtime from bbs WHERE parentid=0 and bbscontent like'%"+key+"%'";
				rs=dbconn.executeQuery(sql);
				while(rs.next())
				{
					bbs bbs=new bbs();
					bbs.setBbsid(Integer.parseInt(rs.getString("bbsid")));
					bbs.setBbsChild(Integer.parseInt(rs.getString("child")));
					bbs.setBbsUsername(rs.getString("userName"));
					bbs.setBbsTopic(rs.getString("bbstopic"));
					bbs.setBbsContent(rs.getString("bbscontent"));
					bbs.setBbsHits(Integer.parseInt(rs.getString("bbshits")));
					bbs.setBbsDateandtime(rs.getDate("dateandtime"));
					list.add(bbs);
				}
				rs.close();
				}