forum.java

BBS论坛系统由JAVA和JSP实现

			}

			rs=dbc.executeQuery(sql);
			int t = 1 ;
			if(t<start)
			{
				while(rs.next())
				{
					if(t==start)break;
					t++;
				}
			}

			//rs.absolute(start);

			int i=0;
			Vector forumMSGs=new Vector();
			while(rs.next())
				{

					ForumMSG theMSG=new ForumMSG();
					theMSG.setAnnounceID(rs.getInt(1));
					theMSG.setForumID(rs.getInt(2));
					theMSG.setUserName(rs.getString(3));
					theMSG.setTopic(rs.getString(4));
					theMSG.setDateAndTime(rs.getString(5));
					theMSG.setBody(rs.getString(6));
					theMSG.setExpression(rs.getString(7));
					theMSG.setUserIP(rs.getString(8));
					theMSG.setRootID(rs.getInt(9));
					theMSG.setSignFlag(rs.getInt(10));
					theMSG.setIsBest(rs.getInt(11));
					theMSG.setIsVote(rs.getInt(12));
					theMSG.setIsTop(rs.getInt(29));
					theMSG.setLockTopic(rs.getInt(30));
					theMSG.setHits(rs.getInt(28)+1);
					User msgUser=new User();
					msgUser.setUserName(rs.getString(13));
					msgUser.setUserEmail(rs.getString(14));
					msgUser.setHomePage(rs.getString(15));
					msgUser.setOicq(rs.getString(16));
					msgUser.setSign(rs.getString(17));
					msgUser.setUserClass(rs.getInt(18));
					msgUser.setTitle(rs.getString(19));
					msgUser.setWidth(rs.getInt(20));
					msgUser.setHeight(rs.getInt(21));
					msgUser.setArticle(rs.getInt(22));
					msgUser.setFace(rs.getString(23));
					msgUser.setAddDate(rs.getString(24));
					msgUser.setUserWealth(rs.getInt(25));
					msgUser.setUserEP(rs.getInt(26));
					msgUser.setUserCP(rs.getInt(27));
					theMSG.setUser(msgUser);
					forumMSGs.add(theMSG);
					i++;
					if(i==perPage)
					break;
				}
			sql="update bbs.bbs1 set hits=hits+1 where announceID="+announceID;
			dbc.executeUpdate(sql);
			dbc.close();
			return forumMSGs;
		}
		catch(SQLException se)
		{
			se.printStackTrace();
			throw new ForumMSGNotFoundException();
		}
		catch(Exception e)
		{
			e.printStackTrace();
			throw new ForumMSGNotFoundException();
		}
	}
	public static Vector getForumTextMSGs  (HttpServletRequest request) throws ForumMSGNotFoundException{
		try{
			int forumID,rootID;
			try{
				forumID=ParamUtil.getInt(request,"forumID");
				rootID=ParamUtil.getInt(request,"rootID");

			}
			catch(Exception e){
				throw new Exception("对不起，没有发现帖子！");
			}


			//DBConnect dbc=new DBConnect(2,0);
			DBConnect dbc=new DBConnect();
			String sql="Select UserName,Topic,dateandtime,body from bbs.bbs1 where boardid="+forumID+" and rootid="+rootID+" order by announceid";

			ResultSet rs=dbc.executeQuery(sql);

			/*if(!rs.next())
				throw new Exception("对不起没有发现帖子!");*/

			Vector forumMSGs=new Vector();
			while(rs.next())
				{

					ForumMSG theMSG=new ForumMSG();
					//theMSG.setAnnounceID(rs.getInt(1));
					//theMSG.setForumID(rs.getInt(2));
					theMSG.setUserName(rs.getString(1));
					theMSG.setTopic(rs.getString(2));
					theMSG.setDateAndTime(rs.getString(3));
					theMSG.setBody(rs.getString(4));
					/*theMSG.setExpression(rs.getString(7));
					theMSG.setUserIP(rs.getString(8));
					theMSG.setRootID(rs.getInt(9));
					theMSG.setSignFlag(rs.getInt(10));
					theMSG.setIsBest(rs.getInt(11));
					theMSG.setIsVote(rs.getInt(12));
					theMSG.setIsTop(rs.getInt(29));
					theMSG.setLockTopic(rs.getInt(30));
					theMSG.setHits(rs.getInt(28)+1);
					User msgUser=new User();
					msgUser.setUserName(rs.getString(13));
					msgUser.setUserEmail(rs.getString(14));
					msgUser.setHomePage(rs.getString(15));
					msgUser.setOicq(rs.getString(16));
					msgUser.setSign(rs.getString(17));
					msgUser.setUserClass(rs.getInt(18));
					msgUser.setTitle(rs.getString(19));
					msgUser.setWidth(rs.getInt(20));
					msgUser.setHeight(rs.getInt(21));
					msgUser.setArticle(rs.getInt(22));
					msgUser.setFace(rs.getString(23));
					msgUser.setAddDate(rs.getString(24));
					msgUser.setUserWealth(rs.getInt(25));
					msgUser.setUserEP(rs.getInt(26));
					msgUser.setUserCP(rs.getInt(27));
					theMSG.setUser(msgUser);*/
					forumMSGs.add(theMSG);

				}

			dbc.close();
			return forumMSGs;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			throw new ForumMSGNotFoundException(e.getMessage());
		}
	}
	public int getForumMSGsNum(){
		return this.forumMSGsNum;
	}
	public int getForumTopicNum(){
		return forumTopicNum;
	}

	public int getForumID(){
		return forumID;
	}
	public String getForumType(){
		return forumType;
	}
	public int getForumClass(){
		return forumClass;
	}
	public String getReadMe(){
		return readMe;
	}
	public String getForumMaster(){
		return forumMaster;
	}
	public int getLockForum(){
		return lockForum;
	}
	public int getForumSkin(){
		return forumSkin;
	}
	public String getTableBack(){
		return tableBack;
	}
	public String getTableTitle(){
		return tableTitle;
	}
	public String getTableBody(){
		return tableBody;
	}
	public String getATableBody(){
		return aTableBody;
	}
	public String getTableFont(){
		return tableFont;
	}
	public String getTableContent(){
		return tableContent;
	}
	public String getAlertFont(){
		return alertFont;
	}
	public String getLastPostUser(){
		return lastPostUser;
	}
	public String getLastPostTime(){
		return lastPostTime;
	}
	public int getLastBbsNum(){
		return lastBbsNum;
	}
	public int getLastTopicNum(){
		return lastTopicNum;
	}
	public boolean getStrAllowForumCode(){
		if(strAllowForumCode==1)
			return true;
		else
			return false;
	}
	public boolean getStrAllowHTML(){
		if(strAllowHTML==1)
			return true;
		else
			return false;
	}
	public boolean getStrIMGInPosts(){
		if(strIMGInPosts==1)
			return true;
		else
			return false;
	}
	public boolean getStrIcons(){
		if(strIcons==1)
			return true;
		else
			return false;
	}
	public boolean getStrFlash(){
		if(strFlash==1)
			return true;
		else
			return false;
	}
	public String getForumLogo(){
		return forumLogo;
	}
	public String getIndexIMG(){
		return indexIMG;
	}
	public int getLastRootID(){
		return lastRootID;
	}
	public String getLastTopic(){
		return StringUtils.escapeHTMLTags(this.lastTopic);
	}
	public int getTodayNum(){
		return todayNum;
	}
	public String getForumUser(){
		return forumUser;
	}
	public Vector getForumOLUsers(){
		return forumOLUsers;
	}
	public int getForumOLGuestUsersNum(){
		return this.forumOLGuestUsersNum;
	}
	public int getForumOLMemberUsersNum(){
		return this.forumOLMemberUsersNum;
	}

	public int getForumsOLUsersNum(){
		return this.forumsOLUsersNum;
	}

	public String getForumIMG(String lastlogin){
		String strIMG="";
		switch(this.getForumSkin())
		{
			case 1:
			if(Format.compareTo(lastlogin,this.lastPostTime))
				strIMG="<img src=pic/foldernew.gif width=13 height=16 alt=常规论坛，有新帖子>";
			else
				strIMG="<img src=pic/ifolder.gif width=13 height=16 alt=常规论坛，无新帖子>";
			break;
			case 2:
			if(Format.compareTo(lastlogin,this.lastPostTime))
				strIMG="<img src=pic/folderallnew.gif width=13 height=16 alt=开放论坛，有新帖子>";
			else
				strIMG="<img src=pic/folderall.gif width=13 height=16 alt=开放论坛，无新帖子>";
			break;
			case 3:
			if(Format.compareTo(lastlogin,this.lastPostTime))
				strIMG="<img src=pic/follownew.gif width=13 height=16 alt=评论论坛，有新帖子>";
			else
				strIMG="<img src=pic/follow.gif width=13 height=16 alt=评论论坛，无新帖子>";
			break;
			case 4:
			if(Format.compareTo(lastlogin,this.lastPostTime))
				strIMG="<img src=pic/jinghua.gif width=13 height=16 alt=精华区，有新帖子>";
			else
				strIMG="<img src=pic/jinghua.gif width=13 height=16 alt=精华区，无新帖子>";
			break;
			case 5:
			if(Format.compareTo(lastlogin,this.lastPostTime))
				strIMG="<img src=pic/lock_l.gif width=13 height=16 alt=认证论坛，有新帖子>";
			else
				strIMG="<img src=pic/lock_b.gif width=13 height=16 alt=认证论坛，无新帖子>";
			break;
			case 6:
			if(Format.compareTo(lastlogin,this.lastPostTime))
				strIMG="<img src=pic/foldernew.gif width=13 height=16 alt=正规论坛，有新帖子>";
			else
				strIMG="<img src=pic/ifolder.gif width=13 height=16 alt=正规论坛，无新帖子>";
			break;
			default:
		}

	return strIMG;
	}

	public String authorSaveMSG(HttpServletRequest request,HttpServletResponse response) throws Exception{

		String userName=ParamUtil.getString(request,"userName","");
		String userPassword=ParamUtil.getString(request,"userPassword","");
		String sql="";
		String char_changed = "[align=right][此贴子已经被作者于"+Format.getDateTime()+"编辑过][/align]";
        	try{

        		User tempUser=new User(userName,userPassword,4);
				DBConnect dbc=new DBConnect();
				ResultSet rs;
        		int forumID=ParamUtil.getInt(request,"forumID");
				int announceID=ParamUtil.getInt(request,"announceID");
				int rootID=ParamUtil.getInt(request,"rootID");
				dbc.prepareStatement("select * from bbs.bbs1 where announceID=? and rootID=? and userName=?");
				dbc.setInt(1,announceID);
				dbc.setInt(2,rootID);
				dbc.setBytes(3,(new String(userName.getBytes("ISO-8859-1"),"GBK")).getBytes());
				rs=dbc.executeQuery();
				if(!rs.next())
					throw new Exception("<li>对不起，您没有权利编辑此帖子！</li>");
        		String subject=ParamUtil.getString(request,"subject","");
        		String content=ParamUtil.getString(request,"content","")+"\n\n\n\n"+char_changed;
        		String expression=ParamUtil.getString(request,"expression","");
        		int signFlag=ParamUtil.getInt(request,"signFlag",1);
        		int emailFlag=ParamUtil.getInt(request,"emailFlag",0);
        		if(subject.equals("")) throw new Exception("没有主体文字");

			sql="update bbs.bbs1 set Topic=?,Body=?,DateAndTime=getdate(),length=?,ip=?,expression=?,signflag=?,emailflag=? where announceID=?";
			dbc.prepareStatement(sql);
			dbc.setBytes(1,(new String(subject.getBytes("ISO-8859-1"),"GBK")).getBytes());
			dbc.setBytes(2,(new String(content.getBytes("ISO-8859-1"),"GBK")).getBytes());
			dbc.setInt(3,content.length());
			dbc.setString(4,request.getRemoteAddr());
			dbc.setString(5,expression);
			dbc.setInt(6,signFlag);
			dbc.setInt(7,emailFlag);
			dbc.setInt(8,announceID);