📄 mysms.jsp
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/conn.jsp"%>
<%@ include file="checkbbsuser.jsp"%>
<%@ include file="../inc/ftbbstohtml.jsp"%>
<%!String searchstr,smtype;%>
<%
String str,img,touxian,jibie,sqlsms,chstr,ku,ka;
int tili,jingyuan;
ResultSet rs1,rs2,rs3;
bbsadmin=username;
String act=request.getParameter("act");
if(act!=null){
searchstr=new String(request.getParameter("searchstr").getBytes("iso-8859-1"));
smtype=request.getParameter("smtype");
}
String t=request.getParameter("t");
String sql="select * from sms where bbssystem=1 order by indate desc";
ResultSet rs=stmt.executeQuery(sql);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language=javascript src="../inc/cookies.js"></script>
<script>
var stylecook = getCookie("STYLESHOW");
var style;
var strstyle;
if(stylecook=="")
{
stylecook=1;
}
else
{
stylecook++;
}
style="main0"+stylecook+".css";
strstyle="<link href=\"../css/"+style+"\" rel=\"stylesheet\" type=\"text/css\"> ";
document.write(strstyle);
</script>
<title><%=username%>的收件箱</title>
</head>
<body topmargin="5">
<div align="center">
<TABLE align=center class="maintbbg" border=0 cellPadding=0 cellSpacing=0 width="99%">
<TR>
<TD height=25> <div align="center"><font color="#FFFFFF"><strong>欢迎<font color="#CC3300"><%=username%></font>网友来管理你的论坛短信</strong></font></div></TD>
</TR>
</TABLE>
<TABLE align=center class="td004" border=0 cellPadding=0 cellSpacing=0 width="99%">
<TR>
<TD height=28 class="maintbtr2">
<div align="center">
<form name="form1" method="post" action="" style="MARGIN-BOTTOM: 0px">
短信搜索:
<input name="searchstr" type="text" id="searchstr" size="25">
<select name="smtype" id="smtype">
<option value="title" selected>短信标题</option>
<option value="content">短信内容</option>
</select>
<input name="act" type="hidden" id="act" value="y">
<input type="submit" name="Submit" value="查找短信">
<input name="button" type="button" id="button" value="发送短信" onClick="javascript:window.location.href='postsms.jsp'">
<input name="send" type="button" id="send" value="收件箱" onClick="javascript:window.location.href='mysms.jsp'">
<input name="re" type="button" id="re" value="发件箱" onClick="javascript:window.location.href='mysms.jsp?t=my'">
</form>
</div></TD>
</TR>
</TABLE>
<%
if(t==null&&rs.next()){
%>
<table border="0" width="99%" cellspacing="0" cellpadding="0" class="table001" align="center">
<tr class="td004">
<td height="23" valign="middle" class="maintbtr1">
<div align="center"><b>系统信息</b></div></td>
<td class="maintbtr1"><b>标 题：<%=rs.getString("title")%></b></td>
</tr>
<tr>
<td valign="top" width="20%" class="maintbtr3"><div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center"> <IMG height=84 src=../bbs/userheadimg/cache5.gif width=84></div></td>
</tr>
<tr>
<td height="20" class="f12"><div align="center">系统管理员</div></td>
</tr>
<tr>
<td height="12"> </td>
</tr>
</table>
</div></td>
<td valign="top" class="td004"><table width="100%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td height="80" valign="top" class="f14"> <%=htmln(rs.getString("content"))%></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td height="1" background="../bbs/userheadimg/bg_text1.gif"></td>
</tr>
<tr>
<td height="18">
<table width="100%" border=0 cellspacing=0 cellpadding=0>
<tr>
<td width="55%" class=f14><font color="#000000">
<%if(bbsadmin.equals("1")){%>
操作选项：[<a class=a03 href=delsms.jsp?id=<%=rs.getString("id")%>>删除</a>][<a class=a03 href=editsms.jsp?id=<%=rs.getString("id")%>>编辑</a>]
<%}%>
</font></td>
<td width="45%"><div align="right">发信时间:<%=rs.getString("indate").substring(0,10)%> </div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<%}%>
<%
str="select * from sms where bbssystem=2 and accepter='"+username+"' order by indate desc";
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs1=stmt1.executeQuery(str);
if(rs1.next()&&t==null){
%>
<table border="0" width="99%" cellspacing="0" cellpadding="0" class="td004" align="center">
<tr class="td004">
<td height="23" valign="middle" class="maintbtr1">
<div align="center"><b>系统信息</b></div></td>
<td class="maintbtr1"><b>标 题：<%=rs1.getString("title")%></b></td>
</tr>
<tr>
<td valign="top" width="20%" class="maintbtr3"><div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center"> <IMG height=84 src=../bbs/userheadimg/cache5.gif width=84></div></td>
</tr>
<tr>
<td height="20" class="f12"><div align="center">系统管理员</div></td>
</tr>
<tr>
<td height="12"> </td>
</tr>
</table>
</div></td>
<td valign="top" class="td004"><table width="100%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td height="80" valign="top" class="f14"> <%=htmln(rs1.getString("content"))%></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td height="1" background="../bbs/userheadimg/bg_text1.gif"></td>
</tr>
<tr>
<td><table width="100%" border=0 cellspacing=0 cellpadding=0>
<tr>
<td width="56%" class=f14><font color="#000000">
<%if(bbsadmin.equals("1")){%>
操作选项：[<a class=a03 href=delsms.jsp?id=<%=rs1.getString("id")%>>删除</a>][<a class=a03 href=editsms.jsp?id=<%=rs1.getString("id")%>>编辑</a>]
<%}%>
<%if(rs1.getString("sender")!=null){%>[<a class=a03 href="agree.jsp?id=<%=rs1.getString("id")%>&postuser=<%=rs1.getString("sender")%>&accepter=<%=rs1.getString("accepter")%>&agree=Y">同意</a>][<a class=a03 href="disagree.jsp?id=<%=rs1.getString("id")%>&postuser=<%=rs1.getString("sender")%>&accepter=<%=rs1.getString("accepter")%>&agree=N">不同意</a>]<%}%>
</font></td>
<td width="44%"><div align="right">发信时间:<%=rs1.getString("indate").substring(0,10)%> </div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<%
}
%>
<%
if(t!=null){
ku="sender='"+username+"'";
}
else{
ku="accepter='"+username+"'";
}
if(smtype!=null&&searchstr!=null){
sqlsms="select * from sms where "+ku+" and "+smtype+" like '%"+searchstr+"%' and bbssystem=0 order by indate desc";
}
else{
sqlsms="select * from sms where "+ku+" and bbssystem=0 order by indate desc";
}
//out.print(sqlsms);
//out.close();
ResultSet rs15=stmt1.executeQuery(sqlsms);
int i=1;
while(rs15.next()){
String replysign=rs15.getString("replysign");
if(t!=null){
str="select * from clubuser where clubuser_name='"+username+"'";
}
else{
str="select * from clubuser where clubuser_name='"+rs15.getString("sender")+"'";
}
//str="select * from clubuser where clubuser_name='"+rs15.getString("sender")+"'";
//out.print(str);
//out.close();
Statement stmt5=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs5=stmt5.executeQuery(str);
rs5.next();
String clubuser_nickname=rs5.getString("clubuser_name");
%>
<TABLE align="center" class="maintbbg" border=0 cellPadding=0 cellSpacing=0 width="99%">
<TBODY>
<TR>
<TD width="20%" height="23" vAlign=middle class="maintbtr1"><div align="center">第<%=i%>条</div></TD>
<TD class="maintbtr1"><B> 标 题：<%=rs15.getString("title")%></B> </TD>
</TR>
</TBODY>
</TABLE>
<TABLE width="99%" border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD class="maintbtr3" rowSpan=2 vAlign=top width="20%"><DIV align=center>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD><div align="center"><IMG height=84 src="../bbs/userheadimg/cache5.gif" width=84></div></TD>
</TR>
<TR>
<TD height=20 class="f12">·网名：<%=clubuser_nickname%></TD>
</TR>
<TR>
<TD height=20 class="f12">·注册：<%=rs5.getString("clubuser_reg_date").substring(0,10)%></TD>
</TR>
</TBODY>
</TABLE>
</DIV></TD>
</TR>
<TR>
<TD class="td004" vAlign=top><TABLE border=0 cellPadding=3 cellSpacing=3 width="100%">
<TBODY>
<TR>
<TD height="160" vAlign=top class=f14><%=htmln(rs15.getString("content"))%></TD>
</TR>
</TBODY>
</TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=5 width="100%">
<TBODY>
<TR>
<TD background="../bbs/images/bg_text1.gif" height="1"></TD>
</TR>
<TR>
<TD align=left class=f14><table width="100%" border=0 cellspacing=0 cellpadding=0>
<tr>
<td width="56%" class=f14> <font color="#000000">操作选项：[<a class=a03 href=delsms.jsp?id=<%=rs15.getString("id")%>>删除</a>][<a class=a03 href=editsms.jsp?id=<%=rs15.getString("id")%>>编辑</a>][<%if(replysign.equals("0")){%><a class=a03 href=replysms.jsp?id=<%=rs15.getString("id")%>&touser=<%=rs5.getString("clubuser_name")%>>回复</a><%}else{%><font color="#FF0000">已回复</font><%}%>]</font></td>
<td width="44%"><div align="right">发信时间: <%=rs15.getString("indate").substring(0,10)%> </div></td>
</tr>
</table></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE>
<%
i=i+1;
}
%>
<%@ include file="../inc/bbstail.jsp"%>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -