guide.jsp

云网oa办公自动化系统java源码。能够使用！有说明！

          <option style="BACKGROUND: #ccaa00" value="#ccaa00"></option>
          <option style="BACKGROUND: #ff0000" value="#ff0000"></option>
          <option style="BACKGROUND: #ff0088" value="#ff0088"></option>
          <option style="BACKGROUND: #ff00ff" value="#ff00ff"></option>
          <option style="BACKGROUND: #ff8800" value="#ff8800"></option>
          <option style="BACKGROUND: #ff0005" value="#ff0005"></option>
          <option style="BACKGROUND: #ff88ff" value="#ff88ff"></option>
          <option style="BACKGROUND: #ee0005" value="#ee0005"></option>
          <option style="BACKGROUND: #ee01ff" value="#ee01ff"></option>
          <option style="BACKGROUND: #3388aa" value="#3388aa"></option>
          <option style="BACKGROUND: #000000" value="#000000"></option>
        </SELECT> <script language="JavaScript">
		form<%=n%>.color.value="<%=color%>"
		</script> </td>
      <td width="5%" height="39"><input type="text" name="sort" size=3 value="<%=sort%>"> </td>
      <td width="11%" height="39"><input name="Submit3" type="submit" class="singleboarder" value="修改"> 
        <a href="guide.jsp?op=del&id=<%=id%>&boardcode=<%=boardcode%>&boardname=<%=StrUtil.UrlEncode(boardname,"utf-8")%>" class=mainA> 删除</a></td>
    </form>
  </tr>
  <%
		}%>
</table>
<table width="100%" border="0" align="center" bgcolor="#0078bf" class="p9">
  <form name="form_search" method="post" action="../manager/?">
    <tr> 
      <td width="9%" align="center"><span class="style1">贴子标题 </span></td>
      <td width="21%" align="left"> <input name="what" type="text" class="singleboarder" > 
      </td>
      <td width="70%" align="left"><input name="Submit" type="submit" class="singleboarder" value="搜索贴子">
        &nbsp;<a href="guide.jsp?op=sort&boardcode=<%=boardcode%>&boardname=<%=StrUtil.UrlEncode(boardname,"utf-8")%>"><font color=white>重新排序</font></a> <input type=hidden name="boardcode" value="<%=boardcode%>">
        <input type=hidden name="boardname" value="<%=boardname%>">
        <a href="guide.jsp?op=generateguide&boardcode=<%=boardcode%>&boardname=<%=StrUtil.UrlEncode(boardname,"utf-8")%>"><font color=white>重新生成<%=boardname%>导读</font></a></td>
    </tr>
  </form>
</table>
<%
		if (boardcode==null)
		{
			out.println(StrUtil.makeErrMsg("请选择版面！"));
			return;
		}
		String sql;
		if (what.equals(""))
			sql = "select f.id,topic,f.name,lydate,recount,hit,expression,f.type,iselite,islocked,level,boardcode,b.name as boardname,f.isguide from sq_message as f,sq_forumboard as b where f.boardcode="+StrUtil.sqlstr(boardcode)+" and f.boardcode=b.code and f.rootid=-1 ORDER BY f.isguide desc,f.hit desc,f.level desc,f.lydate desc";
		else
			sql = "select f.id,topic,f.name,lydate,recount,hit,expression,f.type,iselite,islocked,level,boardcode,b.name as boardname,f.isguide from sq_message as f,sq_forumboard as b where f.boardcode="+StrUtil.sqlstr(boardcode)+" and f.topic like "+StrUtil.sqlstr("%"+what+"%")+" and f.boardcode=b.code and f.rootid=-1 ORDER BY f.isguide desc,f.hit desc,f.level desc,f.lydate desc";
		
		int pagesize = 10;
		ResultRecord rr = null;
		Paginator paginator = new Paginator(request);
		int curpage = paginator.getCurPage();
		PageConn pageconn = new PageConn("forum", curpage, pagesize);
		ResultIterator ri = pageconn.getResultIterator(sql);
		paginator.init(pageconn.getTotal(), pagesize);
		//设置当前页数和总页数
		int totalpages = paginator.getTotalPages();
		if (totalpages==0)
		{
			curpage = 1;
			totalpages = 1;
		}
%>
  <table width="100%" border="0" class="p9">
    <tr>
    <td align="right">找到符合条件的记录 <b><%=paginator.getTotal() %></b> 条　每页显示 <b><%=paginator.getPageSize() %></b> 
      条　页次 <b><%=curpage %>/<%=totalpages %></b></td>
    </tr>
  </table>
  <TABLE borderColor=#edeced cellSpacing=0 cellPadding=1 width="100%" align=center 
border=1>
    <TBODY>
      <TR bgColor=#0078bf height=25> 
        <TD colSpan=3 align=middle noWrap bgcolor="#0078bf"><FONT color=#ffffff>主题列表 <B>(点 <IMG 
      src="../images/plus.gif"> 即可展开贴子列表)</B></FONT></TD>
        <TD noWrap align=middle width=91><FONT color=#ffffff>作者</FONT></TD>
        <TD noWrap align=middle width=55><FONT color=#ffffff>字[回]</FONT></TD>
        <TD noWrap align=middle width=55><FONT color=#ffffff>操作/点击</FONT></TD>
        <TD noWrap align=middle width=80><FONT color=#ffffff>日期</FONT></TD>
      </TR>
    </TBODY>
  </TABLE>
  <%		
String topic = "",name="",lydate="",expression="";
int level=0,iselite=0,islocked=0;
int i = 0,recount=0,hit=0,type=0,isguide=0;
while (ri.hasNext()) {
 	      rr = (ResultRecord)ri.next(); 
		  i++;
		  id = rr.getString("id");
		  topic = rr.getString("topic");
		  name = rr.getString("name");
		  lydate = rr.getString("lydate");
		  recount = rr.getInt("recount");
		  hit = rr.getInt("hit");
		  expression = rr.getString("expression");
		  type = rr.getInt("type");
		  iselite = rr.getInt("iselite");
		  islocked = rr.getInt("islocked");
		  level = rr.getInt("level");
		  boardcode = rr.getString("boardcode");
		  boardname = rr.getString("boardname");
		  isguide = rr.getInt("isguide");
	  %>
  <table bordercolor=#edeced cellspacing=0 cellpadding=1 width="100%" align=center border=1>
    <tbody>
      <tr> 
        <td noWrap align=middle width=30 bgcolor=#f8f8f8> <% if (level==100) { %> <IMG height=15 alt="" src="../images/f_top.gif" width=15 border=0> 
          <% } 
		else {
			if (iselite==1) { %> <IMG src="../images/topicgood.gif"> <% }
			else {
		%> <%if (recount>20){ %> <img alt="打开主题 (热门主题)" src="../images/f_hot.gif"> <%}
	  else if (recount>0) {%> <img alt="打开主题 (有回复的主题)" src="../images/f_new.gif"> <%}
	  else {%> <img alt="打开主题 (没有回复的主题)" src="../images/f_norm.gif"> <%}
	 	}
	 }%> </td>
        <td align=middle width=17 bgcolor=#ffffff> <% String urlboardname = StrUtil.UrlEncode(boardname,"utf-8"); %> <a href="../manager/showtopictree.jsp?boardcode=<%=boardcode%>&hit=<%=(hit+1)%>&boardname=<%=urlboardname%>&rootid=<%=id%>" target=_blank> 
          <% 
		  if (islocked==1) { %>
          <IMG height=15 alt="" src="../images/f_locked.gif" width=17 border=0> 
          <% }
		  else {
			  if (type==1) { %>
          <IMG height=15 alt="" src="../images/f_poll.gif" width=17 border=0> 
          <%}else { %>
          <img src="../images/brow/<%=expression%>.gif" border=0> 
          <%}
		  } %>
          </a></td>
        <td onMouseOver="this.style.backgroundColor='#ffffff'" 
    onMouseOut="this.style.backgroundColor=''" align=left bgcolor=#f8f8f8> <%
		if (recount==0) {
		%> <img id=followImg<%=id%> title=展开回复" src="../images/minus.gif" loaded="no"> 
          <% }else { %> <img id=followImg<%=id%> title=展开回复 style="CURSOR: hand" 
      onClick=loadThreadFollow(<%=id%>,<%=id%>,"&boardcode=<%=boardcode%>&hit=<%=hit+1%>&boardname=<%=urlboardname%>") src="../images/plus.gif" loaded="no"> 
          <% } %> <!--<a href="showtopictree.jsp?boardcode=<%=boardcode%>&hit=<%=(hit+1)%>&boardname=<%=urlboardname%>&rootid=<%=id%>">（树形）<%=topic%></a>--> 
		  <a href="../showtopic.jsp?boardcode=<%=boardcode%>&hit=<%=hit%>&boardname=<%=urlboardname%>&rootid=<%=id%>"><%=topic%></a> 
		  <%
		//计算共有多少页回贴
		int allpages = (int)Math.ceil((double)recount/pagesize);
		if (allpages>1)
		{
		 	out.print("[");
			for (int m=1; m<=allpages; m++)
			{ %> <a href="../showtopic.jsp?boardcode=<%=boardcode%>&hit=<%=(hit+1)%>&boardname=<%=urlboardname%>&rootid=<%=id%>&CPages=<%=m%>"><%=m%></a> <% }
		  	out.print("]");
		 }%> </td>
        <td align=middle width=91 bgcolor=#ffffff> <% if (privilege.getUser(request).equals(name)) { %> <IMG height=14 src="../images/my.gif" 
            width=14> <% } %> <a href="../userinfo.jsp?username=<%=name%>"><%=name%></a> </td>
        <td align=middle width=55 bgcolor=#f8f8f8><font color=red>[<%=recount%>]</font></td>
        <td align=middle width=55 bgcolor=#ffffff>
		<%if (isguide==0) {%>
		<a href="guide.jsp?op=add&title=<%=StrUtil.UrlEncode(topic,"utf-8")%>&id=<%=id%>&boardcode=<%=boardcode%>&boardname=<%=StrUtil.UrlEncode(boardname,"utf-8")%>&hit=<%=hit%>">置为导读[<%=hit%>]</a>
		<%}else if (isguide==2){%>
		社区导读
		<%}else{%>
		<a href="guide.jsp?op=del&id=<%=id%>&boardcode=<%=boardcode%>&boardname=<%=StrUtil.UrlEncode(boardname,"utf-8")%>" class=mainA>删除导读</a>[<%=hit%>]
		<%}%>
		</td>
        <td align=left width=80 bgcolor=#f8f8f8> <table cellspacing=0 cellpadding=2 width="100%" align=center border=0>
            <tbody>
              <tr> 
                <td width="10%">&nbsp;</td>
                <td><%=lydate.substring(0,19)%></td>
              </tr>
            </tbody>
          </table></td>
      </tr>
      <tr id=follow<%=id%> style="DISPLAY: none"> 
        <td noWrap align=middle width=30 bgcolor=#f8f8f8>&nbsp;</td>
        <td align=middle width=17 bgcolor=#ffffff>&nbsp;</td>
        <td onMouseOver="this.style.backgroundColor='#ffffff'" 
    onMouseOut="this.style.backgroundColor=''" align=left bgcolor=#f8f8f8 colspan="5"> 
          <div id=followDIV<%=id%> 
      style="WIDTH: 100%;BACKGROUND-COLOR: lightyellow" 
      onClick=loadThreadFollow(<%=id%>,<%=id%>,"&hit=<%=hit+1%>&boardname=<%=urlboardname%>")>正在读取关于本主题的跟贴，请稍侯……</div></td>
      </tr>
      <tr> 
        <td 
    style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px" 
    colspan=5> </td>
      </tr>
    </tbody>
  </table>
<%}%>
  <table width="100%" border="0" cellspacing="1" cellpadding="3" align="center" class="9black">
    <tr> 
      <td width="2%" height="23">&nbsp;</td>
      <td width="76%" valign="baseline" height="23"> 
        <div align="right"> 
          <%
			String querystr = "what="+StrUtil.UrlEncode(what,"utf-8");
			out.print(paginator.getCurPageBlock("guide.jsp?"+querystr));
			%>
          &nbsp;</div>
    </td>
      
    <td width="22%" height="23">&nbsp; </td>
  </tr>
</table>            
</BODY></HTML>