【Java开源代码栏目提醒】:本文主要为网学会员提供bbs.java,希望对需要bbs.java网友有所帮助,学习一下!
package twm;
import java.io.PrintStream;//锟斤拷锟斤拷锟矫的o拷锟斤拷锟斤拷锟斤拷锟缴撅拷锟?
import java.sql.ResultSet;
import java.sql.SQLException;
import twm.bbsreg;
import twm.bbsuser;
public class bbs
{
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;
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)
{
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)
{
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 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 getBbsBoardid()
{
return boardid;
}
public int getBbsChild()
{
return child;
}
public String getBbsContent()
{
return bbscontent;
}
public String getBbsExpression()
{
return expression;
}
public int getBbsHits()
{
return bbshits;
}
public String getBbsHot()
{
return bbshot;
}
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");
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()
{
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 int getRecordsCount(int j, int k, String s)
{
rs = null;
i = 0;
switch(j)
{
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=