⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 mailedit.jsp

📁 GJMOA网络自动化办公系统是一套基于jsp的办公自动化系统在LINUX+ORACLE+TOMCAT环境下运行
💻 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 + -