【Java开源代码栏目提醒】:以下是网学会员为您推荐的Java开源代码-TopicListBean.java,希望本篇文章对您学习有所帮助。
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