?? 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 + -