package j2eebbs;
import java.sql.ResultSet;
import java.util.Vector;
public class Forum {
private int id;
private String forumname;
private String manager;
private int topicNum;
private int lastTopicId;
private String lastTopicTitle = "";
private String lastTopicAuthor = "";
private String lastTopicTime = "";
public String getForumname() {
return forumname;
}
public void setForumname(String forumname) {
this.forumname = forumname;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getLastTopicAuthor() {
return lastTopicAuthor;
}
public void setLastTopicAuthor(String lastTopicAuthor) {
this.lastTopicAuthor = lastTopicAuthor;
}
public int getLastTopicId() {
return lastTopicId;
}
public void setLastTopicId(int lastTopicId) {
this.lastTopicId = lastTopicId;
}
public String getLastTopicTime() {
return lastTopicTime;
}
public void setLastTopicTime(String lastTopicTime) {
this.lastTopicTime = lastTopicTime;
}
public String getLastTopicTitle() {
return lastTopicTitle;
}
public void setLastTopicTitle(String lastTopicTitle) {
this.lastTopicTitle = lastTopicTitle;
}
public String getManager() {
return manager;
}
public void setManager(String manager) {
this.manager = manager;
}
public int getTopicNum() {
return topicNum;
}
public void setTopicNum(int topicNum) {
this.topicNum = topicNum;
}
public Forum(int id, String forumname, String manager, int topicNum,
int lastTopicId, String lastTopicTitle, String lastTopicAuthor,
String lastTopicTime) {
this.id = id;
this.forumname = forumname;
this.manager = manager;
this.topicNum = topicNum;
this.lastTopicId = lastTopicId;
this.lastTopicTitle = lastTopicTitle;
this.lastTopicAuthor = lastTopicAuthor;
this.lastTopicTime = lastTopicTime;
}
public Forum(int id, String forumname, String manager) {
this.id = id;
this.forumname = forumname;
this.manager = manager;
}
public static Vector search(DB db) throws Exception {
int topicNum = 0;
int lastTopicId;
String lastTopicTitle;
String lastTopicAuthor;
String lastTopicTime;
Vector forumVector = new Vector();
ResultSet rs, rsTopic;
String strSql;
int forumid;
strSql = "select * from forum";
rs = db.OpenSql(strSql);
while (rs.next()) {
lastTopicId = 0;
lastTopicTitle = null;
lastTopicAuthor = null;
lastTopicTime = null;
forumid = rs.getInt("id");
strSql = "select count(*) from topic where forumid=" + forumid;
rsTopic = db.OpenSql(strSql);
if (rsTopic.next()) {
topicNum = rsTopic.getInt(1);
}
strSql = "select * from topic where forumid=" + forumid
+ " order by forumid desc";
rsTopic = db.OpenSql(strSql);
if (rsTopic.next()) {
lastTopicId = rsTopic.getInt("id");
lastTopicTitle = rsTopic.getString("title");
lastTopicTime = rsTopic.getString("submittime");
lastTopicAuthor = rsTopic.getString("author");
}
forumVector.add(new Forum(forumid, rs.getString("forumname"), rs
.getString("manager"), topicNum, lastTopicId,
lastTopicTitle, lastTopicTime, lastTopicAuthor));
}
return forumVector;
}
public static Vector searchAllForums(DB db) throws Exception {
int forumid = 0;
String forumname = null;
String manager = null;
Vector forumVector = new Vector();
ResultSet rs;
String strSql;
strSql = "select * from forum";
rs = db.OpenSql(strSql);
while (rs.next()) {
forumid = rs.getInt("id");
forumname = rs.getString("forumname");
manager = rs.getString("manager");
forumVector.add(new Forum(forumid, forumname, manager));
}
return forumVector;
}
public static boolean insert(DB db, String forumname) throws Exception {
String strSql;
ResultSet rs;
int iMaxId;
strSql = "select max(id) from forum";
rs = db.OpenSql(strSql);
if (rs.next()) {
iMaxId = rs.getInt(1) + 1;
} else {
iMaxId = 1;
}
strSql = "insert into forum values('" + iMaxId + "','" + forumname
+ "','')";
if (db.ExecSql(strSql) == 0) {
return false;
} else {
return true;
}
}
public static boolean delete(DB db, String forumid) throws Exception {
String strSql;
strSql = "delete from forum where id=" + forumid;
if (db.ExecSql(strSql) == 0) {
return false;
} else {
return true;
}
}
public static boolean edit(DB db, String forumid, String forumname,
String manager) throws Exception {
String strSql;
strSql = "update forum set forumname='" + forumname + "',manager='"
+ manager + "'where id=" + forumid;
if (db.ExecSql(strSql) == 0) {
return false;
} else {
return true;
}
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
BBS论坛系统
共131个文件
java:39个
class:39个
jsp:21个
需积分: 0 19 下载量 172 浏览量
2008-05-11
14:38:03
上传
评论
收藏 1.32MB RAR 举报
温馨提示
基于Struts的BBS系统,值得一看哦
资源详情
资源评论
资源推荐
收起资源包目录
BBS论坛系统 (131个子文件)
Forum.class 5KB
User.class 4KB
SubmitArticleAction.class 4KB
Response.class 4KB
Topic.class 3KB
TopicListAction.class 3KB
UserEditAction.class 3KB
ForumCreateAction.class 3KB
RegistrationAction.class 3KB
ForumEditSubmitAction.class 3KB
UserLoginAction.class 3KB
TopicDeleteAction.class 3KB
UserManagerAction.class 3KB
AdminLoginAction.class 3KB
UserDeleteAction.class 3KB
ForumDeleteAction.class 3KB
ForumManagerAction.class 3KB
TopicDisp.class 3KB
ForumEditAction.class 2KB
ResponseListAction.class 2KB
TopicSearchAction.class 2KB
SearchUserAction.class 2KB
NewTopicAction.class 2KB
EncodingFilter.class 2KB
RegistrationForm.class 2KB
DB.class 2KB
AdminLogoffAction.class 1KB
LogoffAction.class 1KB
Constants.class 1KB
PrepareToCreateForumAction.class 1KB
ForumManagerForm.class 1KB
ForumForm.class 1KB
UserManagerForm.class 1KB
AdminLoginForm.class 866B
UserLoginForm.class 861B
TopicManagerForm.class 860B
NewArticleForm.class 830B
ForumidForm.class 651B
TopicOfResponseForm.class 622B
.classpath 949B
myStyleClass.css 35B
logo.gif 35KB
logo2.gif 35KB
struts.jar 474KB
antlr.jar 344KB
commons-beanutils.jar 160KB
commons-digester.jar 147KB
commons-validator.jar 74KB
jakarta-oro.jar 62KB
commons-logging.jar 33KB
commons-fileupload.jar 19KB
Forum.java 5KB
Response.java 4KB
User.java 4KB
EncodingFilter.java 4KB
SubmitArticleAction.java 3KB
TopicListAction.java 3KB
Topic.java 2KB
UserEditAction.java 2KB
TopicDisp.java 2KB
ForumCreateAction.java 2KB
RegistrationAction.java 2KB
ForumEditSubmitAction.java 2KB
UserLoginAction.java 2KB
AdminLoginAction.java 2KB
TopicDeleteAction.java 2KB
UserManagerAction.java 2KB
UserDeleteAction.java 2KB
ForumDeleteAction.java 2KB
ForumManagerAction.java 2KB
NewTopicAction.java 2KB
ForumEditAction.java 2KB
RegistrationForm.java 1KB
SearchUserAction.java 1KB
TopicSearchAction.java 1KB
ResponseListAction.java 1KB
Constants.java 1KB
DB.java 1KB
NewArticleForm.java 922B
ForumManagerForm.java 717B
AdminLogoffAction.java 716B
ForumForm.java 709B
UserManagerForm.java 684B
LogoffAction.java 664B
PrepareToCreateForumAction.java 618B
UserLoginForm.java 617B
AdminLoginForm.java 616B
TopicManagerForm.java 522B
TopicOfResponseForm.java 396B
ForumidForm.java 364B
topiclist.jsp 3KB
bbsindex.jsp 2KB
responselist.jsp 2KB
useredit.jsp 2KB
usermanager.jsp 2KB
registration.jsp 2KB
forumedit.jsp 2KB
topicmanager.jsp 2KB
forummanager.jsp 2KB
newarticle.jsp 1KB
共 131 条
- 1
- 2
qin85325407
- 粉丝: 4
- 资源: 5
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0