shbaogao.jsp

JSP+MYSQL能飞网络办公OA系统

<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="top.jsp"%>
<TABLE id=Table1 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR id=main_section vAlign=top>
<TD>

      <TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR >
          <TD   class=welcomeleft id=left_pane vAlign=top width=155 >
            <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0  background=../images/back.gif height=586>
              <TBODY>
               <TR>
                <TD   valign=top>


<%@ include file="personal_menu.jsp"%>



             </TD></TR>
             </TBODY></TABLE>




</TD><TD id=right_pane> 







<div class="maintd" style="height:100%;width:100%;">

<TABLE cellSpacing="0" cellPadding="0" width="98%" align="center" border="0" class="article-page" bordercolor=red>
	
<TR>
<TD valign="top">



<table cellspacing="1" cellpadding="1" border="0" align=center width=98% >
<tr class="Grid_Header" background=../images/welcomebodymenubg.gif>
<td width=50%>标题</td><td width=10%>来自</td><td width=20%>日期</td><td width=10%>状态</td>
</tr>

<%
rs=stmt.executeQuery("SELECT * from work where recemem='"+(String) session.getAttribute("username")+"' and flag=2 order by id desc");
String pages = request.getParameter("page") ;
int pageInt =  1 ,i=0 ;
if(pages==null){}else{pageInt = Integer.parseInt(pages);}
while(i<20*(pageInt-1)&&rs.next()){i++ ;}
i=0;
while(rs.next()&i<20){
i++ ;
%>

<tr class="datalist1" bgcolor=cccccc>
<td>

<a href="shreadwork.jsp?id=<%=rs.getString("id")%>&space=<%=request.getParameter("space")%>"><%=rs.getString("topic")%></a>
<%String tttt=rs.getString("content");%>
<%if(tttt.indexOf("gif")>=0){%><img src=../images/gif.gif><%}%>
<%if(tttt.indexOf("jpg")>=0){%><img src=../images/jpg.gif><%}%>
<%if(tttt.indexOf("bmp")>=0){%><img src=../images/bmp.gif><%}%>
<%if(tttt.indexOf("jpge")>=0){%><img src=../images/jpg.gif><%}%>
<%if(tttt.indexOf("png")>=0){%><img src=../images/png.gif><%}%>
<%if(tttt.indexOf("txt")>=0){%><img src=../images/txt.gif><%}%>
<%if(tttt.indexOf("doc")>=0){%><img src=../images/word.gif><%}%>
<%if(tttt.indexOf("rtf")>=0){%><img src=../images/word.gif><%}%>
<%if(tttt.indexOf("xls")>=0){%><img src=../images/excel.gif><%}%>
<%if(tttt.indexOf("rar")>=0){%><img src=../images/rar.gif><%}%>
<%if(tttt.indexOf("zip")>=0){%><img src=../images/zip.gif><%}%>
</td>
<td><a href=user.jsp?username=<%=rs.getString("fbmem")%>><%=rs.getString("fbmem")%></a></td>
<td><%=rs.getString("fbtime")%></td><td>
<%if(Integer.parseInt((String)rs.getString("readok"))==0){%><font color=red>未阅</font><%}%>
<%if(Integer.parseInt((String)rs.getString("readok"))==1){%>已阅<%}%>	
</td>
</tr>

<%
}%>

</table>
<table cellspacing="1" cellpadding="1" border="0" align=center width="98%">


<tr>
<td class="article-page-body" height="100%" colspan="2" width="100%">
<TABLE cellSpacing="0" cellPadding="0" width="100%" border="0" height="100%" bordercolor=blue>
<TR>
<TD height=2 valign="top">
		
<table   height="35" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<TD nowrap="nowrap" align="left" width="20%">
<input type="button" value="刷新"  class="pushbutton" onclick="javascript:location.reload()">
&nbsp;
</TD>


<td align=right width="75%">

<%
rs=stmt.executeQuery("SELECT count(*) from work where recemem='"+(String) session.getAttribute("username")+"' and flag=2 ");
while(rs.next()) i = rs.getInt(1) ;
%>

<%@ include file="page.jsp"%>

</td>

<td width=8%></td>

</tr>
</table>
		
</TD>
</TR>
</table>


</TD>
</TR>
</TABLE>

</td>
</tr>
</TABLE>

</div>





 </TD></TR></TBODY></TABLE></TD></TR>
</TBODY>
</table>


<%@ include file="end.jsp"%>
</BODY>
</HTML>