📄 email.jsp
字号:
<%@page language="java" import="oa.bean.*,java.sql.*,java.util.*" contentType="text/html;charset=GBK"%>
<HTML>
<HEAD>
<TITLE> 邮件初始化 </TITLE>
<link href="../css/person.css" type=text/css rel=stylesheet>
</HEAD>
<BODY>
<table width="90%" align=center><tr width='100%'><td style="font:13pt Verdana,Arial,宋体;" align=center>邮箱垃圾清理</td></tr>
<tr width='100%'><td style="font:8pt Verdana,Arial,宋体;">
<%
String psw = request.getParameter("psw");
oa.bean.PersonBean myBean =null;
myBean = new oa.bean.PersonBean();
myBean.setPersonNO("1");
boolean b = myBean.verifyPwd(psw);
myBean.closeConn();
if(!b)
{
%>
<script>
alert("管理员密码错误！");
window.location.replace('index.jsp');
</script>
<%
}
else
{
oa.main.DealString ds = new oa.main.DealString();
String person = ((String)request.getParameter("txt_receiver"));
String pers[] = ds.splitStr(person,',');
oa.main.ParentBean pb = new oa.main.ParentBean();
String sql = "" ;
for(int i=0;i<pers.length;)
{
String zgbh = pers[i++] ;
String name = pers[i++] ;
String gh = pers[i++] ;
out.println("<br><br><br> <font color=red>姓名："+name+" 工号："+gh+"开始执行清理...</font><hr size=1 width='100%'>");
%>
<%
//==========================================================收件箱
out.println("<br> <font color=red>检查收件箱...</font>");
//查询收件箱
sql = "select zz_syjb.*,zz_zgb.xm,zz_zgb.zgbh from zz_syjb,zz_zgb where zz_zgb.zgbh=zz_syjb.fjrzgbh and success='0' and sjrzgbh='"+zgbh +"' and yjzt='0' order by fssj desc";
Vector vect1 = pb.getDataBySql(sql);
%>
<div align=right>
<table width=100% border=0 align=center cellspacing=0 cellpadding=0>
<tr><td width=50></td><td width=60 style="border-bottom:1px #777777 solid;">发件人</td><td style="border-bottom:1px #777777 solid;">邮件主题</td><td width=150 style="border-bottom:1px #777777 solid;">发送日期</td><td style="border-bottom:1px #777777 solid;" width=60>附件大小</td><td width=100 style="border-bottom:1px #777777 solid;">附件</td></tr>
<%
int j = 0 ;
int j_fj = 0 ;
for(;j<vect1.size();j++)
{
Hashtable hash = (Hashtable)vect1.get(j);
//查询附件
sql = "select y.yjfjid as yjfjid,y.fjwz as fjwz,y.fjxmc as fjxmc,y.fjmc as fjmc,y.fjdx as fjdx from zz_sjfjgxb z ,zz_yjfjb y where y.yjfjid=z.yjfjid and z.SJID='"+(String)hash.get("SJID")+"'";
Vector vect_fj = pb.getDataBySql(sql);
String fj = "";
for(int k=0;k<vect_fj.size();k++)
{
j_fj ++ ;
Hashtable hash_fj = (Hashtable)vect_fj.get(k);
if(!fj.equals(""))fj+="<br>";
fj += (String)hash_fj.get("FJMC") ;
}
%>
<tr>
<td></td>
<td><%=(String)hash.get("XM")%></td>
<td><%=(String)hash.get("ZT")%></td>
<td><%=(String)hash.get("FSSJ")%></td>
<td><%=(String)hash.get("FJDX")%></td>
<td><%=fj%></td></tr>
<%
}
%>
<tr><td></td><td colspan=5 style="border-top:1px #777777 solid;"> 总计邮件数：<%=j%> 总计附件数：<%=j_fj%></td></tr>
</table>
</div>
<%
//==========================================================发件箱
out.println("<br> <font color=red>检查发件箱...</font>");
//查询发件箱
sql = "select zz_fyjb.*,zz_sjrb.*,zz_zgb.xm from zz_fyjb,zz_zgb,zz_sjrb where zz_fyjb.fjid=zz_sjrb.fjid and zz_sjrb.sjrzgbh=zz_zgb.zgbh and success='0' and fjrzgbh="+zgbh +" and yjzt='0' order by fssj desc";
Vector vect2 = pb.getDataBySql(sql);
%>
<div align=right>
<table width=100% border=0 align=center cellspacing=0 cellpadding=0>
<tr><td width=50></td><td width=60 style="border-bottom:1px #777777 solid;">收件人</td><td style="border-bottom:1px #777777 solid;">邮件主题</td><td width=150 style="border-bottom:1px #777777 solid;">发送日期</td><td style="border-bottom:1px #777777 solid;" width=60>附件大小</td><td width=100 style="border-bottom:1px #777777 solid;">附件</td></tr>
<%
j = 0 ;
j_fj = 0 ;
for(;j<vect2.size();j++)
{
Hashtable hash = (Hashtable)vect2.get(j);
//查询附件
sql = "select * from zz_yjfjb where fjid='"+(String)hash.get("FJID")+"'";
Vector vect_fj = pb.getDataBySql(sql);
String fj = "";
for(int k=0;k<vect_fj.size();k++)
{
j_fj ++ ;
Hashtable hash_fj = (Hashtable)vect_fj.get(k);
if(!fj.equals(""))fj+="<br>";
fj += (String)hash_fj.get("FJMC") ;
}
%>
<tr>
<td></td>
<td><%=(String)hash.get("XM")%></td>
<td><%=(String)hash.get("ZT")%></td>
<td><%=(String)hash.get("FSSJ")%></td>
<td><%=(String)hash.get("FJDX")%></td>
<td><%=fj%></td></tr>
<%
}
%>
<tr><td></td><td colspan=5 style="border-top:1px #777777 solid;"> 总计邮件数：<%=j%> 总计附件数：<%=j_fj%></td></tr>
</table>
</div>
<%
//==========================================================草稿箱
out.println("<br> <font color=red>检查草稿箱...</font>");
//查询草稿箱
sql = "select zz_fyjb.*,zz_sjrb.*,zz_zgb.xm from zz_fyjb,zz_zgb,zz_sjrb where zz_fyjb.fjid=zz_sjrb.fjid and zz_sjrb.sjrzgbh=zz_zgb.zgbh and success='0' and fjrzgbh="+zgbh +" and yjzt='3' order by fssj desc";
Vector vect3 = pb.getDataBySql(sql);
%>
<div align=right>
<table width=100% border=0 align=center cellspacing=0 cellpadding=0>
<tr><td width=50></td><td width=60 style="border-bottom:1px #777777 solid;">收件人</td><td style="border-bottom:1px #777777 solid;">邮件主题</td><td width=150 style="border-bottom:1px #777777 solid;">发送日期</td><td style="border-bottom:1px #777777 solid;" width=60>附件大小</td><td width=100 style="border-bottom:1px #777777 solid;">附件</td></tr>
<%
j = 0 ;
j_fj = 0 ;
for(;j<vect3.size();j++)
{
Hashtable hash = (Hashtable)vect3.get(j);
//查询附件
sql = "select * from zz_yjfjb where fujianzt='0' and fjid='"+(String)hash.get("FJID")+"'";
Vector vect_fj = pb.getDataBySql(sql);
String fj = "";
for(int k=0;k<vect_fj.size();k++)
{
j_fj ++ ;
Hashtable hash_fj = (Hashtable)vect_fj.get(k);
if(!fj.equals(""))fj+="<br>";
fj += (String)hash_fj.get("FJMC") ;
}
%>
<tr>
<td></td>
<td><%=(String)hash.get("XM")%></td>
<td><%=(String)hash.get("ZT")%></td>
<td><%=(String)hash.get("FSSJ")%></td>
<td><%=(String)hash.get("FJDX")%></td>
<td><%=fj%></td></tr>
<%
}
%>
<tr><td></td><td colspan=5 style="border-top:1px #777777 solid;"> 总计邮件数：<%=j%> 总计附件数：<%=j_fj%></td></tr>
</table>
</div>
<%
//==========================================================垃圾箱
out.println("<br> <font color=red>检查垃圾箱...</font>");
//查询垃圾箱
sql = "select zz_zgb.xm,zz_syjb.sjid,zz_syjb.zt,zz_syjb.fssj,zz_syjb.fjdx,zz_syjb.read,zz_syjb.yjzt,zz_syjb.nr"
+ " from zz_zgb,zz_syjb"
+ " where zz_syjb.yjzt='1' and zz_syjb.success='0'"
+ " and zz_zgb.zgbh=zz_syjb.fjrzgbh"
+ " and zz_syjb.sjrzgbh='"+zgbh+"'"
+ " union"
+ " select zz_zgb.xm,zz_fyjb.fjid,zz_fyjb.zt,zz_fyjb.fssj,zz_fyjb.fjdx,zz_fyjb.read,zz_fyjb.yjzt,zz_fyjb.nr"
+ " from zz_fyjb,zz_sjrb,zz_zgb"
+ " where zz_zgb.zgbh=zz_sjrb.sjrzgbh"
+ " and zz_sjrb.fjid=zz_fyjb.fjid"
+ " and zz_fyjb.yjzt in ('1','4')"
+ " and zz_fyjb.fjrzgbh='"+zgbh+"'";
Vector vect4 = pb.getDataBySql(sql);
%>
<div align=right>
<table width=100% border=0 align=center cellspacing=0 cellpadding=0>
<tr><td width=50></td><td width=60 style="border-bottom:1px #777777 solid;">收件人</td><td style="border-bottom:1px #777777 solid;">邮件主题</td><td width=150 style="border-bottom:1px #777777 solid;">发送日期</td><td style="border-bottom:1px #777777 solid;" width=60>附件大小</td></tr>
<%
j = 0 ;
for(;j<vect4.size();j++)
{
Hashtable hash = (Hashtable)vect4.get(j);
%>
<tr>
<td></td>
<td><%=(String)hash.get("XM")%></td>
<td><%=(String)hash.get("ZT")%></td>
<td><%=(String)hash.get("FSSJ")%></td>
<td><%=(String)hash.get("FJDX")%></td></tr>
<%
}
%>
<tr><td></td><td colspan=4 style="border-top:1px #777777 solid;"> 总计邮件数：<%=j%> </td></tr>
</table>
</div>
<%
out.println("<br> <font color=red>执行清理中...</font>");
/*
//删除收件箱附件关系表
out.println("<br> <font color=red>删除收件箱附件关系表...</font>");
sql = "select * from zz_sjfjgxb where sjid in (select to_char(sjid) from zz_syjb where sjrzgbh='"+zgbh+"') " ;
out.println("<br> "+sql+"<br> "+pb.getDataBySql(sql));
//删除收件箱
out.println("<br> <font color=red>删除收件箱...</font>");
sql = "select * from zz_syjb where sjrzgbh='"+zgbh+"'" ;
out.println("<br> "+sql+"<br> "+pb.getDataBySql(sql));
//删除发件箱收件人
out.println("<br> <font color=red>删除发件箱收件人...</font>");
sql = "select * from zz_sjrb where sjrzgbh='"+zgbh+"' and fjid in (select fjid from zz_fyjb where fjrzgbh='"+zgbh+"') " ;
out.println("<br> "+sql+"<br> "+pb.getDataBySql(sql));
//删除发件箱
out.println("<br> <font color=red>删除发件箱...</font>");
sql = "select * from zz_fyjb where fjrzgbh='"+zgbh+"'" ;
out.println("<br> "+sql+"<br> "+pb.getDataBySql(sql));
*/
out.println("<br> <font color=red>删除附件表...</font>");
sql = " select yjfjid,fjid from zz_yjfjb "//收件箱里的附件
+" where yjfjid in "
+" (select yjfjid from zz_sjfjgxb "
+" where sjid in "
+" (select to_char(sjid) from zz_syjb where sjrzgbh='"+zgbh+"') "
+" ) "
+" union "
+" select yjfjid,fjid from zz_yjfjb "//加上发件箱里的附件
+" where fjid in "
+" (select fjid from zz_fyjb where fjrzgbh='"+zgbh+"') ";
Vector v5 = pb.getDataBySql(sql) ;
for ( int m=0 ; m < v5.size() ; m++ )
{
Hashtable hash = (Hashtable)v5.get(m);
String yjfjid = (String)hash.get("YJFJID");
String fjid = (String)hash.get("FJID");
//在别人的发件箱中使用
sql = "select * from zz_fyjb where fjid="+fjid+" and fjrzgbh!='"+zgbh+"' and yjzt='0'" ;
Vector vt1 = pb.getDataBySql(sql);
if(vt1.size()>0)continue;
//在别人的收件箱中使用
sql = "select * from zz_syjb "
+ "where sjrzgbh!='"+zgbh+"' "
+ " and sjid in (select to_number(sjid) from zz_sjfjgxb where yjfjid='"+yjfjid+"') ";
Vector vt2 = pb.getDataBySql(sql);
if(vt2.size()>0)continue;
sql = "delete from zz_yjfjb where yjfjid="+yjfjid+" and fjid='"+fjid+"' ";
out.println(sql);
pb.prepareStatement(sql);
pb.executeUpdate();
pb.closePstm();
}
//删除收件箱附件关系表
out.println("<br> <font color=red>删除收件箱附件关系表...</font>");
sql = "delete from zz_sjfjgxb where sjid in (select to_char(sjid) from zz_syjb where sjrzgbh='"+zgbh+"') " ;
pb.prepareStatement(sql);
pb.executeUpdate();
pb.closePstm();
//删除收件箱
out.println("<br> <font color=red>删除收件箱...</font>");
sql = "delete from zz_syjb where sjrzgbh='"+zgbh+"'" ;
pb.prepareStatement(sql);
pb.executeUpdate();
pb.closePstm();
//删除发件箱收件人
out.println("<br> <font color=red>删除发件箱收件人...</font>");
sql = "delete from zz_sjrb where sjrzgbh='"+zgbh+"' and fjid in (select fjid from zz_fyjb where fjrzgbh='"+zgbh+"') " ;
pb.prepareStatement(sql);
pb.executeUpdate();
pb.closePstm();
//删除发件箱
out.println("<br> <font color=red>删除发件箱...</font>");
sql = "delete from zz_fyjb where fjrzgbh='"+zgbh+"'" ;
pb.prepareStatement(sql);
pb.executeUpdate();
pb.closePstm();
out.println("<br> <font color=red>该人清理完成!</font>");
}
pb.closeConn();
}
%>
</td></tr></table>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -