receivemsg_forebin.jsp
来自「采用j2ee架构做的bbs」· JSP 代码 · 共 70 行
JSP
70 行
<%@page pageEncoding="gb2312"%>
<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<%@include file="conn.jsp" %>
<%
String msg_id=request.getParameter("msg_id");
String sql1="select * from icefish_msg where msg_id="+msg_id;
Statement stmt1=conn.createStatement();
ResultSet rs1=stmt1.executeQuery(sql1);
while(rs1.next()){
String sql2="update icefish_msg set msg_new='false' where msg_id="+msg_id;
Statement stmt2=conn.createStatement();
stmt2.executeUpdate(sql2);
stmt2.close();
%>
<SCRIPT LANGUAGE="JavaScript">
function closeWindow(){
Window.close()
}
</SCRIPT>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312" />
<title>查看短消息</title>
<style type="text/css">
<!--
.STYLE10 {font-family: "宋体"; font-weight: bold; font-size: 12px; }
.STYLE12 {font-family: "宋体"; font-weight: bold; font-size: 12px; color: #FFFFFF; }
.STYLE15 {font-size: 12px}
-->
</style>
</head>
<body>
<form>
<table width="666" border="1" align="center" bordercolorlight="#7777FF" bordercolordark="#7777FF" style="border-collapse:collapse">
<tr>
<td align="center" height="25" colspan="2" background="images/skin/1/bg_td.gif"><span class="STYLE12">查看短消息</span></td>
</tr>
<tr>
<td height="25" colspan="2" align="center">
<a class=zh href="del_choose_forebin.jsp?msg_id=<%=rs1.getString("msg_id")%>" onClick="return confirm(' 确定要删除该信息？')"><img src="images/button/del.gif" width="40" height="40"></a>
<a class=zh href="writemsg.jsp"><img src="images/button/write.gif" width="40" height="40"></a>
<a class=zh href="message.jsp"><img src="images/button/msg.gif" width="40" height="40"></a></td>
</tr>
<tr>
<td width="80" height="30" class="STYLE10"> 发件人:</td>
<td width="566"> <span class="STYLE15"><%=rs1.getString("msg_from")%></span></td>
<tr>
<td width="80" height="30" class="STYLE10"> 主 题 :</td>
<td> <span class="STYLE15"><%=rs1.getString("msg_topic")%></span></td>
</tr>
<tr valign="top">
<td width="80" height="125" valign="middle" class="STYLE10"> 内 容 :</td>
<td height="194"valign="top"><br> <span class="STYLE15"><%=rs1.getString("msg_words")%></span></td>
</tr>
<tr>
<td align="center" height="26" colspan="2" bgcolor="#CCCCCC">
<input type=button name="CloseButton" value="关闭" onClick=window.close()>
</td>
</tr>
<%}
rs1.close();
stmt1.close();
conn.close();
%>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?