package com.wsy.struts.bean;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.sql.DataSource;
import com.wsy.struts.datasource.DB;
import com.wsy.struts.util.Constants;
import com.wsy.struts.util.StringTrans;
public class TopicListBean {
private String id;
private String content;
private String author;
private String submittime;
private String forumid;
private String title;
private String xq;//主题表中的字段
private String rq;//人气
private int reCount;//每个主题回复的个数
private String lastTalk;//每个主题最新回复主题个数
private String forumname;//论坛名称
public String getForumname() {
return forumname;
}
public void setForumname(String forumname) {
this.forumname = forumname;
}
public int getReCount() {
return reCount;
}
public void setReCount(int reCount) {
this.reCount = reCount;
}
public String getLastTalk() {
return lastTalk;
}
public void setLastTalk(String lastTalk) {
this.lastTalk = lastTalk;
}
public String getXq() {
return xq;
}
public void setXq(String xq) {
this.xq = xq;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public String getForumid() {
return forumid;
}
public void setForumid(String forumid) {
this.forumid = forumid;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getSubmittime() {
return submittime;
}
public void setSubmittime(String submittime) {
this.submittime = submittime;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public List search(DataSource datasource,int pageid,String ForumId) throws Exception{
StringTrans s=new StringTrans();
List l=new ArrayList();
String sql="select * from tb_topic where forumid="+ForumId+" order by id desc limit "+pageid*Constants.TOPIC_PAGE_SIZE+","+Constants.TOPIC_PAGE_SIZE;
System.out.println(sql);
DB d=new DB(datasource);
ResultSet rs=d.OpenSql(sql);
ResultSet rscount=null;
ResultSet rscount2=null;
int count=0;
while(rs.next()){
TopicListBean t=new TopicListBean();
t.setId(rs.getString("id"));
t.setContent(rs.getString("content"));
t.setAuthor(rs.getString("author"));
t.setSubmittime(rs.getString("submittime"));
t.setForumid(rs.getString("forumid"));
t.setForumname(rs.getString("forumname"));
t.setTitle(rs.getString("title"));
t.setXq(rs.getString("xq"));
t.setRq(rs.getString("rq"));
String sqlcount="select count(*) from tb_response where topicid='"+t.getId()+"'";//取每个主题的回复总数
rscount=d.OpenSql(sqlcount);
while(rscount.next()){
t.setReCount(rscount.getInt(1));
System.out.println("recount"+t.getReCount());
}
rscount=null;
String sqlcount2="select * from tb_response where topicname='"+s.tranC(t.getTitle())+" order by id desc'";
rscount2=d.OpenSql(sqlcount2);
while(rscount2.next()){
t.setLastTalk(rs.getString("submittime"));
}
rscount2=null;
l.add(t);
}
rs=null;
d.close();
return l;
}
public int InsertData(String title,String content,String xq,String name,String forumid,String forumname,DataSource datasource){
int i=0;
DB d=new DB(datasource);
PreparedStatement pstmt=null;
String sql="insert into tb_topic(title,content,xq,author,forumid,forumname) values(?,?,?,?,?,?)";
pstmt=d.PrepareInsert(sql);
try{
pstmt.setString(1,title);
pstmt.setString(2,content);
pstmt.setString(3,xq);
pstmt.setString(4,name);
pstmt.setString(5,forumid);
pstmt.setString(6, forumname);
i=pstmt.executeUpdate();
}catch(SQLException e){
e.printStackTrace();
}
d.close();
return i;
}
/*插入tb_response表数据*/
public int InsertDataResponse(String title,String content,String xq,String name,String topicid,String topicname,DataSource datasource){
int i=0;
DB d=new DB(datasource);
String sql="insert into tb_response(title,content,author,topicid,topicname,xq)values ('"+title+"','"+content+"','"+name+"','"+topicid+"','"+topicname+"','"+xq+"')";
System.out.println(sql);
try{
i=d.ExecSql(sql);
}catch(Exception e){
e.printStackTrace();
}
d.close();
return i;
}
/*根据主题号在回复表中取信息*/
public List getRecordResponse(String topicid,DataSource datasource){
List list=new ArrayList();
DB d=new DB(datasource);
ResultSet rs=null;
String sql="select * from tb_response where topicid='"+topicid+"'";
try{
rs=d.OpenSql(sql);
while(rs.next()){
TopicListBean t=new TopicListBean();
t.setId(rs.getString("id"));
t.setTitle(rs.getString("title"));
t.setContent(rs.getString("content"));
t.setAuthor(rs.getString("author"));
t.setSubmittime(rs.getString("submittime"));
t.setXq(rs.getString("xq"));
list.add(t);
}
}catch(Exception e){
e.printStackTrace();
}
d.close();
return list;
}
public List getTotalRecordTopic(DataSource datasource){
List list=new ArrayList();
DB d=new DB(datasource);
ResultSet rs=null;
ResultSet rs2=null;
String sql="select * from tb_topic";
try{
rs=d.OpenSql(sql);
while(rs.next()){
TopicListBean t=new TopicListBean();
t.setId(rs.getString("id"));
t.setTitle(rs.getString("title"));
t.setForumid(rs.getString("forumid"));
t.setForumname(rs.getString("forumname"));
t.setContent(rs.getString("content"));
t.setAuthor(rs.getString("author"));
t.setSubmittime(rs.getString("submittime"));
t.setXq(rs.getString("xq"));
list.add(t);
}
}catch(Exception e){
e.printStackTrace();
}
d.close();
return list;
}
public int DelRecord(String id,DataSource datasource){
int i=0;
DB d=new DB(datasource);
String sql="delete from tb_topic where id='"+id+"'";
i=d.ExecSql(sql);
d.close();
return i;
}
public int DelRecordforForumn(String forumid,DataSource datasource){//由于删除某个论坛,所以相应这个论坛的主题也需要被删除
int i=0;
String id=null;
DB d=new DB(datasource);
String sql2="select id from tb_topic where forumid='"+forumid+"'";
String sql="delete from tb_topic where forumid='"+forumid+"'";
ResultSet rs=d.OpenSql(sql2);
try{
while(rs.next()){
id=rs.getString(1);
String sql3="delete from tb_response where topicid='"+id+"'";//将回复表中相关论坛回复删除
System.out.println(sql3);
System.out.println("topiclistBean"+d.ExecSql(sql3));
}
}catch(Exception e){
e.printStackTrace();
}
i=d.ExecSql(sql);
d.close();
return i;
}
public String getRq() {
return rq;
}
public void setRq(String rq) {
this.rq = rq;
}
public int UpdateRq(String id,DataSource datasource){
int i=0;
DB d=new DB(datasource);
String sql="update tb_topic set rq=rq+1 where id='"+id+"'";
i=d.ExecSql(sql);
d.close();
return i;
}
public int delRecordforUser(String name,DataSource datasource){
int i=0;
DB d=new DB(datasource);
String sql="delete from tb_topic where author='"+name+"'";
i=d.ExecSql(sql);
d.close();
return i;
}
public List getTotalRecordTopic(String id,DataSource datasource){
List list=new ArrayList();
DB d=new DB(datasource);
ResultSet rs=null;
ResultSet rs2=null;
String sql="select * from tb_topic where id='"+id+"'";
try{
rs=d.OpenSql(sql);
while(rs.next()){
TopicListBean t=new TopicListBean();
t.setId(rs.getString("id"));
t.setTitle(rs.getString("title"));
t.setForumid(
没有合适的资源?快使用搜索试试~ 我知道了~
BBS论坛 JAVA代码
共261个文件
gif:85个
class:59个
java:59个
4星 · 超过85%的资源 需积分: 15 25 下载量 125 浏览量
2013-03-11
10:01:04
上传
评论 1
收藏 714KB ZIP 举报
温馨提示
毕业论文设计之BBS论坛,JAVA开发ORACLE数据库TOMCAT服务器,BS模式
资源推荐
资源详情
资源评论
收起资源包目录
BBS论坛 JAVA代码 (261个子文件)
TopicListBean.class 9KB
ForumBean.class 7KB
LoginBean.class 6KB
DisplayResponseTag.class 5KB
LoginAction.class 5KB
DBnew.class 4KB
NewAticleAction.class 4KB
RegisterBean.class 4KB
RegisterAction.class 4KB
ResponseBean.class 4KB
ResponselistAction.class 4KB
DisplayUsermanagerTag.class 4KB
DisplayTag.class 3KB
TopicListAction.class 3KB
NewtopicAction.class 3KB
UserDelAction.class 3KB
ForumeditAction.class 3KB
DisplayTopicTag.class 3KB
ForumDelAction.class 3KB
DisplaySearchUserTag.class 3KB
TopicDelAction.class 3KB
RegisterForm.class 3KB
UeditAction.class 3KB
CheckUserAction.class 3KB
DB.class 3KB
DisplayUserMessageTag.class 3KB
ResponseDelAction.class 3KB
UserManagerAction.class 2KB
ForumAddAction.class 2KB
ConnDB.class 2KB
IndexAction.class 2KB
ResponselistForm.class 2KB
TopicmanagerForm.class 2KB
NewtopicForm.class 2KB
UsereditAction.class 2KB
UsersearchAction.class 2KB
mainAction.class 2KB
TopicmanagerAction.class 2KB
UeditForm.class 2KB
pageBean.class 2KB
DownTable.class 2KB
ResponseTopicAction.class 2KB
ForumForm.class 2KB
ForumeditForm.class 1KB
UserManagerForm.class 1KB
UsereditForm.class 1KB
StringTrans.class 1KB
LoginForm.class 1KB
UserdeleteForm.class 1KB
LogoffAction.class 1KB
ForumAddForm.class 1KB
UsersearchForm.class 1KB
ResponseDelForm.class 1KB
CheckForm.class 1KB
UserdeleteAction.class 963B
umlChange.class 889B
ForumDelForm.class 807B
TopicDelForm.class 807B
Constants.class 351B
.classpath 1KB
style.css 963B
Thumbs.db 155KB
Thumbs.db 140KB
Thumbs.db 60KB
~$readme.doc 162B
gl01.gif 29KB
010.gif 27KB
18.gif 19KB
17.gif 18KB
fb01.gif 14KB
lb.gif 14KB
r1.gif 14KB
05.gif 14KB
ht03.gif 10KB
zt_01.gif 10KB
zc_01.gif 9KB
02.gif 9KB
ht01.gif 8KB
gl_3.gif 8KB
zc06.gif 8KB
bj.gif 8KB
bj2.gif 7KB
ht02.gif 5KB
08.gif 4KB
gl_3_1.gif 4KB
gl_3_2.gif 4KB
2.gif 3KB
r2.gif 3KB
16.gif 3KB
4.gif 3KB
zt_02.gif 3KB
um_03.gif 3KB
um_01.gif 3KB
zc_02.gif 3KB
fb05.gif 3KB
5.gif 3KB
1.gif 3KB
9.gif 3KB
14.gif 3KB
r3.gif 3KB
共 261 条
- 1
- 2
- 3
资源评论
- water_hate22014-05-28不错的系统,可以学习
- zhouliju2014-01-01一般,有点小帮助
- captain-na2014-12-26东西很好,但自己是初学者,有点看不懂。
- jianyuwutong111112013-05-06没看懂,但还是赞一个,上传辛苦了
jiangshuang22
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功