📄 madmin.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="con" scope="page" class="numb1.com.db"/>
<jsp:useBean id="ht" scope="page" class="numb1.com.Dohtml"/>
<%
String id=(String)session.getAttribute("id");id=ht.donull(id);
if(id.compareTo("")==0){
response.sendRedirect("login.jsp");
}else{
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>留言管理</title>
<style type="text/css">
<!--
td{font-size:13px}
th{font-size:14px}
.style1 {color: #FFFFFF}
a:link{text-decoration:none;color:#0000ff}
a:visited{text-decoration:none;color:#0000ff}
a:hover{text-decoration:underline;color:#96CCFE}
.link {color:#868686}
.link a:link{text-decoration:none;color:#868686}
.link a:visited{text-decoration:none;color:#868686}
.link a:hover{text-decoration:none;color:#96CCFE}
-->
</style>
</head>
<body>
<table width="720" border="0" align="center">
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> <strong> 收件箱</strong></td>
</tr>
<tr>
<td><form name="form1" method="post" action="">
<table width="98%" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC">
<tr bgcolor="#7188e0">
<td width="40" height="20"><div align="center"></div></td>
<td width="253"><div align="center" class="style1">留言主题</div></td>
<td width="114"><div align="center" class="style1">发信人</div></td>
<td width="124"><div align="center" class="style1">发信时间</div></td>
<td width="75"><div align="center" class="style1">阅读</div></td>
</tr>
<%
String infor="select id,title,time,isread from massage where toid='inform' and frid='inform'";
ResultSet frs=con.query(infor);
while(frs.next()){
%>
<tr bgcolor="#efefef">
<td><div align="center">
<input type="checkbox" name="checkbox" value="checkbox" disabled>
</div></td>
<td><div align="center"><a href="inform.jsp?mid=<%=frs.getString(1)%>"><%=con.getStr(frs.getString(2))%></a></div></td>
<td class="link"><div align="center"><font color="#FF0000">管理员</font></div></td>
<td><div align="center"><%=frs.getString(3).substring(5,16)%></div></td>
<td class="link"><div align="center"><%=frs.getString(4)%></div></td>
</tr>
<%}
String sql1="select id,frid,frname,title,time,isread from massage where toid='"+id+"'";
ResultSet rs1=con.query(sql1);
while(rs1.next()){
%>
<tr bgcolor="#efefef">
<td><div align="center">
<input type="checkbox" name="checkbox" value="checkbox">
</div></td>
<td><div align="center"><a href="mshow.jsp?mid=<%=rs1.getString(1)%>"><%=con.getStr(rs1.getString(4))%></a></div></td>
<td class="link"><div align="center"><a href="../aboutuser.jsp?id=<%=rs1.getString(2)%>"><%=con.getStr(rs1.getString(3))%></a></div></td>
<td><div align="center"><%=rs1.getString(5).substring(5,16)%></div></td>
<td><div align="center"><% if("0".equals(rs1.getString(6))){out.print("<font color=#FF0000>未读</font>");}else{out.print("已读");}%></div></td>
</tr>
<%
}
con.close();
%>
<tr class="link">
<td height="2" colspan="5"></td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td> <strong>已发消息</strong></td>
</tr>
<tr>
<td><table width="98%" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC">
<tr bgcolor="#7188e0">
<td width="40" height="20"><div align="center" class="style1">删除</div></td>
<td width="253"><div align="center" class="style1">留言主题</div></td>
<td width="114"><div align="center" class="style1">收件信人</div></td>
<td width="124"><div align="center" class="style1">发信时间</div></td>
<td width="75"><div align="center" class="style1">阅读</div></td>
</tr>
<%
String sql2="select id,toid,toname,title,time from massage where frid='"+id+"' and isread='0'";
ResultSet rs2=con.query(sql2);
while(rs2.next()){
%>
<tr bgcolor="#efefef">
<td><div align="center">
</div></td>
<td><div align="center"><a href="medit.jsp?mid=<%=rs2.getString(1)%>"><%=con.getStr(rs2.getString(4))%></a></div></td>
<td class="link"><div align="center"><a href="../aboutuser.jsp?id=<%=rs2.getString(2)%>"><%=con.getStr(rs2.getString(3))%></a></div></td>
<td><div align="center"><%=rs2.getString(5).substring(5,16)%></div></td>
<td><div align="center"><font color=#FF0000>未读</font></div></td>
</tr>
<%
}
con.close();
%> <tr>
<td height="2" colspan="5"></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<% }%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -