【JSP开源代码栏目提醒】:网学会员鉴于大家对JSP开源代码十分关注,论文会员在此为大家搜集整理了“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
上一篇:
em.jsp
下一篇:
试题库管理系统毕业论文