msg_main.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="msg_mainmenu.jsp"%>







             </TD></TR>
             </TBODY></TABLE>
</TD><TD id=right_pane>



<TABLE class=maintd id=Columns height="100%" cellSpacing=0  cellPadding=12 width="100%" border=0  background=../images/adminbodybg4.gif>
 <TBODY>
<TR height="100%"><td valign=top width=100%>


<form name="form1" method="post" action="delmsg.jsp">
<img src=../images/mymsg.jpg>我的收信箱

<TABLE class=tableborder1 cellSpacing=1 cellPadding=3 align=center>
<TBODY>
<TR>
<th valign=middle width=30>状态</th>
<th valign=middle width=300>主题</th><th valign=middle width=100>发件人</th><th valign=middle width=125>时间</th>
<th valign=middle width=50>字节</th><th valign=middle width=30>操作</th>
</tr>

</table>
<TABLE class=tableborder1 cellSpacing=1 cellPadding=1 align=center>

<%
rs=stmt.executeQuery("select * from message where recemem='"+(String) session.getAttribute("username")+"' and save=0 order by flag,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>
<td class=tablebody1 width=30><%if((rs.getString("flag")).compareTo("0")==0){%><img src=../images/m_news.gif title="未读"><%}else{%><img src=../images/m_news2.gif title="已读"><%}%></td>
<td  class=tablebody1 width=300><img src=../images/aer1.gif> <b><a href=readmsg.jsp?id=<%=rs.getString("id")%>&space=<%=request.getParameter("space")%>><%=rs.getString("topic")%></a></b></td><td  class=tablebody1 width=100><a href=user.jsp?username=<%=rs.getString("sendmem")%> title="查看<%=rs.getString("sendmem")%>的详细资料"><%=rs.getString("sendmem")%></a></td><td  class=tablebody1 width=125><%=rs.getString("sendtime")%></td>
<td class=tablebody1  width=50>

<%String v = rs.getString("content");
if (v==null){v="";}
	byte[] b = v.getBytes();
	out.println(b.length/2+" 个汉字"); 
%>

</td><td class=tablebody1  width=30><input name="id" type="checkbox" id="id" value="<%=rs.getString("id")%>"></td>
</tr>
<%}%>


</table>
<TABLE class=tableborder1 cellSpacing=1 cellPadding=1 align=center>
<tr>
<%
rs=stmt.executeQuery("SELECT count(*) from message where recemem='"+(String) session.getAttribute("username")+"'  and save=0  ");
while(rs.next()) i = rs.getInt(1) ;
%>
<td  class=tablebody2 width=99%><%@ include file="page.jsp"%></td>
<td align=right valign=middle colspan=6 class=tablebody2><input type=submit name=action class=buttonlinear disabled value="删除">
</td>
</tr>
</table>
</form>

</TBODY></TABLE>






</td></tr></table>


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






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