📄 sendmessage.jsp
字号:
<html>
<head>
<meta http-equiv=Content-Type content="text/html;charset=gb2312">
<title>发送消息</title>
</head>
<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.util.Calendar"%>
<%@ page import="java.text.*"%>
<jsp:useBean id="bbsdb" scope="page" class="bbs.Bbsdb"/>
<%
ResultSet rs=null;
String sql=null;
String sn=null;
sn=request.getParameter("SerialNum");
if (sn==null)
sn="";
int rnum=bbsdb.getRowNum("ever_user WHERE UID IN (SELECT * FROM current_user WHERE SerialNum=\'"+sn+"\')");
if (rnum==0)
{
%>
您的帐号已经过期，请重新登录或者注册新的用户!<br>
<%
}
else
{
String target=null;
target=request.getParameter("Target");
if (target==null)
target="";
String message=null;
message=request.getParameter("message");
if (message==null)
message="";
if (target.equals("")||message.equals(""))
{
%>
无信息发送！
<%
}
else
{
sql="SELECT * FROM ever_user WHERE UID IN (SELECT UID FROM current_user WHERE SerialNum=\'"+sn+"\')";
rs=bbsdb.executeQuery(sql);
String uid=null;
while (rs.next())
uid=rs.getString("UID");
rs.close();
sql="SELECT Info FROM ever_user WHERE UID=\'"+target+"\'";
rs=bbsdb.executeQuery(sql);
String info=null;
while (rs.next())
info=rs.getString("Info");
if (info==null)
info="";
newinfo=info+"<hr>"+uid+":<br>"+message+"<br>";
sql="UPDATE ever_user SET Info=\'"+newinfo+"\' WHERE UID=\'"+target+"\'";
bbsdb.executeUpdate(sql);
}
%>
<body bgcolor="pink">
<p>
<font size="7" color="#FF0000" face="隶书">
<big><big><strong>
你已成功发送信息!
</strong></big></big>
</font></p>
<%
}
%>
</body>
</html>
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -