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.rar_Eclipse_bbs_bbs struts_struts eclipse_struts 系统 （123个子文件） 
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 TopicSearchAction.class 2KB ResponseListAction.class 2KB SearchUserAction.class 2KB NewTopicAction.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 1002B myStyleClass.css 35B
logo.gif 35KB logo2.gif 35KB
struts.jar 531KB mysql-connector-java-3.1.8-bin.jar 400KB antlr.jar 350KB commons-beanutils.jar 184KB commons-digester.jar 164KB commons-validator.jar 82KB jakarta-oro.jar 64KB commons-logging.jar 37KB commons-fileupload.jar 22KB Forum.java 5KB Response.java 4KB User.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 TopicDeleteAction.java 2KB AdminLoginAction.java 2KB UserManagerAction.java 2KB UserDeleteAction.java 2KB ForumDeleteAction.java 2KB ForumManagerAction.java 2KB ForumEditAction.java 2KB RegistrationForm.java 1KB NewTopicAction.java 1KB SearchUserAction.java 1KB TopicSearchAction.java 1KB ResponseListAction.java 1KB Constants.java 1KB DB.java 1KB NewArticleForm.java 922B ForumManagerForm.java 717B ForumForm.java 709B UserManagerForm.java 684B AdminLogoffAction.java 671B 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 userlogin.jsp 1KB共 123 条
- 1
- 2
资源评论
