📄 mailedit.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="check.jsp" %>
<%@ page import="java.util.*" %>
<%
String mailbox = request.getParameter("mailbox");
String op = request.getParameter("op");
String sql = "";
String id = request.getParameter("id");
//======删除当前邮件======
if(op.compareTo("3")==0){ //
//如果是回收站,则删除文件
if (mailbox.compareTo("2")==0 ){ //如果是回收站,则删除文件
sql = "delete from allmail where ID="+id;
sqlbean.executeUpdate(sql);
}else{ //如果不是回收站,则添加到回收站
sql="update allmail set status=2 where ID="+id;
sqlbean.executeUpdate(sql);
}
sqlbean.close();
response.sendRedirect("mailbox.jsp?mailbox="+mailbox);
}else if(op.compareTo("4")==0){
sql = "update allmail set isread=1 where ID="+id;
sqlbean.executeUpdate(sql);
sql = "select * from allmail where ID="+id;
//out.println(sql);
sqlbean.executeQuery(sql);
if(sqlbean.next()){
%>
<HTML>
<HEAD>
<link href="new.css" rel="stylesheet">
<body >
<TABLE cellSpacing=0>
<TBODY>
<TR>
<TD class=dark><B>收件人:</B></TD>
<TD class=toBlock noWrap><INPUT name=towho value="<%=sqlbean.getString("stowho")%>" style='border:1pt solid #636563;font-size:9pt;width=100%' readonly>
</TD></TR>
<TR><TD class=dark><B>邮件主题:</B></TD>
<TD class=inputBlock noWrap><INPUT type=text name=subject value="<%=sqlbean.getString("title") %>" style='border:1pt solid #636563;font-size:9pt' size=50 readonly>
</TD></TR>
</TBODY></TABLE>
<TEXTAREA name=massage style="FONT-FAMILY: ms shell dlg; FONT-SIZE: 14px; HEIGHT: 250px; WIDTH: 400px" readonly>
<%=sqlbean.getString("message")%>
</TEXTAREA>
<br>
<table width="400" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#666666" bordercolordark="#FFFFFF" bgcolor="#d6d3ce" align=left>
<tr>
<td WIDTH="70" align="left"><FONT COLOR="#FF0000">附件:</FONT></td>
<td ><% String ff =sqlbean.getString("url");
if(ff.length()<2) out.println("查看");
else out.println("<a href='"+ff+"' target=_blank>查看</a>");
%>
</td>
</tr></table>
<%}else{
out.println("<br>数据已经不存在了!");
}
sqlbean.close();
}else if(op.compareTo("2")==0){
Calendar now = Calendar.getInstance();
String sj2 = now.get(Calendar.YEAR)+"-"+(now.get(Calendar.MONTH)+1)+"-"+now.get(Calendar.DAY_OF_MONTH)+" "+now.get(Calendar.HOUR_OF_DAY)+":"+now.get(Calendar.MINUTE)+":"+now.get(Calendar.SECOND);
sql = "insert into allmail (towho,stowho,userid,username,message,time,status,isread) values('"
+session.getAttribute("Uid")+"','"
+sqlbean.to_8859_1(session.getAttribute("Uname").toString())+"','"
+request.getParameter("towho")+"','"
+sqlbean.to_8859_1(request.getParameter("stowho"))+"','"
+sqlbean.to_8859_1(request.getParameter("message"))+"','"
+sj2+"',"
+"4,0)";//为收件箱做准备
sqlbean.executeUpdate(sql);
out.println(sqlbean.showMsg("javascript:window.close()","短信息已经成功发送,正在关闭窗口!","系统提示"));
}
%>
<br><br>
<a href="javaScript:window.close()"><img border="0" src="images/close_1.gif"></a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -