【Java开源代码栏目提醒】:网学会员为需要Java开源代码的朋友们搜集整理了BBSadmin.java相关资料,希望对各位网友有所帮助!
package my
bbs;
import java.sql.*;
public class BBSadmin {
public BBSadmin(){
}
public StringBuffer getBbs(){
StringBuffer buffer=new StringBuffer();
DBConn conn =new DBConn();
try{
String sql="SELECT * FROM forums WHERE isparent=1";
ResultSet rs=conn.query(sql);
while(rs.next()){
buffer.append("<TR bgcolor='#ADD0EC'><TD width=10%></TD><TD align=left>");
buffer.append("<FONT color=blue>"+rs.getString("forum_name")+"</FONT> ");
buffer.append("<a href='AddForum.do?action=5&forumid="+rs.getInt("sortid")+"'>");
buffer.append("<img src='images/del.gif'></a></TD></TR>");
buffer.append("<TR><TD width=10%></TD><TD align=left>");
buffer.append(getForum(rs.getInt("sortid")));
buffer.append("<FORM action='AddForum.do' method='post'>");
buffer.append("向分类中添加分论坛:<BR>");
buffer.append("论坛名:<INPUT size=12 type=text name='forumname' value=''>");
buffer.append("<INPUT type=hidden name='action' value='2'>");
buffer.append("<INPUT type=hidden name='forumid' value='"+rs.getInt("sortid")+"'>");
buffer.append("<INPUT type='submit' value='提交'><BR>");
buffer.append("<FONT color=red>================================</FONT>");
buffer.append("</FORM></TD></TR>");
}
}
catch(Exception e){
}
return buffer;
}
public StringBuffer getForum(int id){
StringBuffer buffer=new StringBuffer();
DBConn conn =new DBConn();
try{
String
sql="SELECT * FROM forums WHERE isparent=0 AND sortid="+id;
ResultSet rs=conn.query(sql);
while(rs.next()){
buffer.append("<LI><a href='forumdetail.do?forumid="+rs.getInt("id")+"'>");
buffer.append(rs.getString("forum_name")+"</a> ");
buffer.append("<a href='AddForum.do?action=4&forumid="+rs.getInt("id")+"'>");
buffer.append("<img src='images/del.gif'></a><BR>");
}
}
catch(Exception e){
buffer.append("目前无分论坛");
}
return buffer;
}
public StringBuffer getForumdetail(String id){
StringBuffer buffer=new StringBuffer();
DBConn conn =new DBConn();
try{
String sql="SELECT * FROM forums WHERE isparent=0 AND id="+id;
ResultSet rs=conn.query(sql);
if(rs.next()){
buffer.append("论坛名称:");
buffer.append("<INPUT type=text name='forumname' value='"+rs.getString("forum_name")+"'>");
buffer.append("<BR>论坛描述:");
buffer.append("<INPUT type=text name='description' value='"+rs.getString("description")+"'>");
buffer.append("<BR>论坛图标:");
buffer.append("<INPUT type=text name='logo' value='"+rs.getString("pic_logo")+"'>");
buffer.append("<BR>管理名单:");
buffer.append("<INPUT type=text name='admin' value='"+rs.getString("admin_author")+"'>");
}
}
catch(Exception e){
buffer.append("目前无分论坛");
}
return buffer;
}
}