团队作业 团队冲刺第四天
今天我们组实现公文传输功能，在大家的测试下能够进行收发文件的功能。
截图：
<%@ page language="java" pageEncoding="gb2312"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <%@ page language="java" import="java.sql.*" %> <jsp:useBean id="connDbBean" scope="page" class="db.db"/> <html> <head> <base href="<%=basePath%>"> <title>公文信息</title><LINK href="css.css" type=text/css rel=stylesheet> <script language="javascript" src="js/Calendar.js"></script> <script type="text/javascript" src="js/popup.js"></script> <script type="text/javascript"> function up(tt) { var pop=new Popup({ contentType:1,isReloadOnClose:false,width:300,height:50}); pop.setContent("contentUrl","upload.jsp?Result="+tt); pop.setContent("title","文件上传"); pop.build(); pop.show(); } </script> </head> <script language="javascript"> function check() { if(document.form1.shoujianren.value==""){alert("请输入收文人");document.form1.shoujianren.focus();return false;if(document.form1.fajianren.value==""){alert("请输入发文人");document.form1.fajianren.focus();return false;}if(document.form1.zhuti.value==""){alert("请输入主题");document.form1.zhuti.focus();return false;} } function gow() { document.location.href="youjianxinxi_add.jsp?jihuabifffanhao="+document.form1.jihuabifffanhao.value; } </script> <body > <% String sql; ResultSet RS_result; %> <form name="form1" id="form1" method="post" action="youjianxinxi_add_post.jsp"> 发送公文: <br> <br> <table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#00FFFF" style="border-collapse:collapse"> <tr><td>收文人：</td><td><input name='shoujianren' type='text' id='shoujianren' value='<% if (request.getParameter("shoujianren")==null) { } else { out.print(request.getParameter("shoujianren")); } %>' style='border:solid 1px #000000; color:#666666' /> *</td> </tr><tr><td>发文人：</td><td><input name='fajianren' type='text' id='fajianren' style='border:solid 1px #000000; color:#666666' value='<%=request.getSession().getAttribute("username")%>' /> *</td></tr><tr><td>主题：</td><td><input name='zhuti' type='text' id='zhuti' value='' size='50' style='border:solid 1px #000000; color:#666666' /> *</td></tr><tr><td>内容：</td><td><textarea name="neirong" style="display:none"></textarea><iframe ID="eWebEditor1" src="eWebEditor_V4.60/ewebeditor.htm?id=neirong&style=coolblue" frameborder="0" scrolling="no" width="600" HEIGHT="350"></iframe></td></tr><tr><td>附件：</td><td><input name='fujian' type='text' id='fujian' size='50' value='' style='border:solid 1px #000000; color:#666666' /> <input type='button' value='上传' onClick="up('fujian')" style='border:solid 1px #000000; color:#666666'/></td></tr> <tr> <td> </td> <td><input type="submit" name="Submit" value="提交" onClick="return check();" style='border:solid 1px #000000; color:#666666' /> <input type="reset" name="Submit2" value="重置" style='border:solid 1px #000000; color:#666666' /></td> </tr> </table> </form> </body> </html>
<%@ page language="java" pageEncoding="gb2312" import="java.sql.*" %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <% request.setCharacterEncoding("gb2312"); response.setCharacterEncoding("gb2312"); %> <jsp:useBean id="connDbBean" scope="page" class="db.db"/> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>My JSP 'adminyanzheng.jsp' starting page</title> </head> <body> <% String shoujianren=request.getParameter("shoujianren");String fajianren=request.getParameter("fajianren");String zhuti=request.getParameter("zhuti");String neirong=request.getParameter("neirong");String fujian=request.getParameter("fujian"); String sql="insert into youjianxinxi(shoujianren,fajianren,zhuti,neirong,fujian) values('"+shoujianren+"','"+fajianren+"','"+zhuti+"','"+neirong+"','"+fujian+"') "; connDbBean.executeUpdate(sql); out.print("<script>alert('添加成功!!');location.href='youjianxinxi_add.jsp';</script>"); %> </body> </html>
下面是123用户的发件记录：
<%@ page language="java" pageEncoding="gb2312"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <%@ page language="java" import="java.sql.*" %> <jsp:useBean id="connDbBean" scope="page" class="db.db"/> <html> <head> <base href="<%=basePath%>"> <title>公文信息</title><LINK href="css.css" type=text/css rel=stylesheet><script language="javascript" src="js/Calendar.js"></script> </head> <% String sql; ResultSet RS_result; %> <body > <p>我的发文列表：</p> <form name="form1" id="form1" method="post" action=""> 搜索: 收文人：<input name="shoujianren" type="text" id="shoujianren" style='border:solid 1px #000000; color:#666666' size="12" /> 主题：<input name="zhuti" type="text" id="zhuti" style='border:solid 1px #000000; color:#666666' size="12" /> <input type="submit" name="Submit" value="查找" style='border:solid 1px #000000; color:#666666' /> </form> <table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="00FFFF" style="border-collapse:collapse"> <tr> <td width="30" align="center" bgcolor="CCFFFF">序号</td> <td bgcolor='#CCFFFF'>收文人</td><td bgcolor='#CCFFFF'>发文人</td><td bgcolor='#CCFFFF'>主题</td><td bgcolor='#CCFFFF'>附件</td> <td width="138" align="center" bgcolor="CCFFFF">添加时间</td> <td width="60" align="center" bgcolor="CCFFFF">操作</td> </tr> <% int curpage=1;//当前页 int page_record=10;//每页显示的记录数 int zgs=0; int zys=0; //用下面的方法（sql查询完成，速度快） String hsgnpage=request.getParameter("page"); String fysql="select count(id) as ss from youjianxinxi where fajianren='"+request.getSession().getAttribute("username")+"'"; ResultSet RS_resultfy=connDbBean.executeQuery(fysql); while(RS_resultfy.next()){ zgs=Integer.parseInt(RS_resultfy.getString("ss")); zys=(zgs-1)/page_record+1; } if (hsgnpage!=null) { curpage=Integer.parseInt(request.getParameter("page"));//获取传递的值，需要显示的页 } else { curpage=1; } if (curpage==0) { curpage=1; } if(curpage>zys) { curpage=zys; } sql=""; sql="select top "+page_record+" * from youjianxinxi where fajianren='"+request.getSession().getAttribute("username")+"' and id not in (select top "+((curpage-1)*page_record)+" id from youjianxinxi where fajianren='"+request.getSession().getAttribute("username")+"' order by id desc) "; if(request.getParameter("shoujianren")=="" ||request.getParameter("shoujianren")==null ){}else{sql=sql+" and shoujianren like '%"+new String(request.getParameter("shoujianren").getBytes("8859_1"))+"%'";} if(request.getParameter("zhuti")=="" ||request.getParameter("zhuti")==null ){}else{sql=sql+" and zhuti like '%"+new String(request.getParameter("zhuti").getBytes("8859_1"))+"%'";} sql=sql+" order by id desc"; RS_result=connDbBean.executeQuery(sql); String id=""; String shoujianren="";String fajianren="";String zhuti="";String neirong="";String fujian=""; String addtime=""; int i=0; while(RS_result.next()){ i=i+1; id=RS_result.getString("id"); shoujianren=RS_result.getString("shoujianren");fajianren=RS_result.getString("fajianren");zhuti=RS_result.getString("zhuti");fujian=RS_result.getString("fujian"); addtime=RS_result.getString("addtime"); %> <tr> <td width="30" align="center"><%=i %></td> <td><%=shoujianren %></td><td><%=fajianren %></td><td><%=zhuti %></td><td><a href='<%=fujian %>' target='_blank'>下载</a></td> <td width="138" align="center"><%=addtime %></td> <td width="90" align="center"><a href="youjianxinxi_updt.jsp?id=<%=id%>">修改</a> <a href="del.jsp?id=<%=id %>&tablename=youjianxinxi" onClick="return confirm('真的要删除？')">删除</a> <a href="youjianxinxi_detail.jsp?id=<%=id%>">详细</a></td> </tr> <% } %> </table><br> 以上数据共<%=i %>条,<a style="cursor:hand" onClick="javascript:window.print();">打印本页</a> <p align="center"> 共<%=zgs%>条记录 <%=page_record %>条/页 <a href="youjianxinxi_list2.jsp?page=1">首页</a> <a href="youjianxinxi_list2.jsp?page=<%= curpage-1%>">上一页</a> <A href="youjianxinxi_list2.jsp?page=<%= curpage+1%>">下一页</A> <a href="youjianxinxi_list2.jsp?page=<%=zys %>">尾页</A> 当前第<FONT color=red><%=curpage %></FONT>页/共<FONT color=red><%=zys %></FONT>页</p> </body> </html>
下面是用户1424442424的收件记录：
<%@ page language="java" pageEncoding="gb2312"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <%@ page language="java" import="java.sql.*" %> <jsp:useBean id="connDbBean" scope="page" class="db.db"/> <html> <head> <base href="<%=basePath%>"> <title>公文信息</title><LINK href="css.css" type=text/css rel=stylesheet><script language="javascript" src="js/Calendar.js"></script> </head> <% String sql; ResultSet RS_result; %> <body > <p>我的收文列表：</p> <form name="form1" id="form1" method="post" action=""> 搜索: 收文人：<input name="shoujianren" type="text" id="shoujianren" style='border:solid 1px #000000; color:#666666' size="12" /> 主题：<input name="zhuti" type="text" id="zhuti" style='border:solid 1px #000000; color:#666666' size="12" /> <input type="submit" name="Submit" value="查找" style='border:solid 1px #000000; color:#666666' /> </form> <table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="00FFFF" style="border-collapse:collapse"> <tr> <td width="30" align="center" bgcolor="CCFFFF">序号</td> <td width="188" bgcolor='#CCFFFF'>收文人</td> <td width="188" bgcolor='#CCFFFF'>发文人</td> <td width="135" bgcolor='#CCFFFF'>主题</td> <td width="137" bgcolor='#CCFFFF'>附件</td> <td width="156" align="center" bgcolor="CCFFFF">收件时间</td> <td width="72" align="center" bgcolor="CCFFFF">操作</td> </tr> <% int curpage=1;//当前页 int page_record=10;//每页显示的记录数 int zgs=0; int zys=0; //用下面的方法（sql查询完成，速度快） String hsgnpage=request.getParameter("page"); String fysql="select count(id) as ss from youjianxinxi where shoujianren='"+request.getSession().getAttribute("username")+"'"; ResultSet RS_resultfy=connDbBean.executeQuery(fysql); while(RS_resultfy.next()){ zgs=Integer.parseInt(RS_resultfy.getString("ss")); zys=(zgs-1)/page_record+1; } if (hsgnpage!=null) { curpage=Integer.parseInt(request.getParameter("page"));//获取传递的值，需要显示的页 } else { curpage=1; } if (curpage==0) { curpage=1; } if(curpage>zys) { curpage=zys; } sql=""; sql="select top "+page_record+" * from youjianxinxi where shoujianren='"+request.getSession().getAttribute("username")+"' and id not in (select top "+((curpage-1)*page_record)+" id from youjianxinxi where shoujianren='"+request.getSession().getAttribute("username")+"' order by id desc) "; if(request.getParameter("shoujianren")=="" ||request.getParameter("shoujianren")==null ){}else{sql=sql+" and shoujianren like '%"+new String(request.getParameter("shoujianren").getBytes("8859_1"))+"%'";} if(request.getParameter("zhuti")=="" ||request.getParameter("zhuti")==null ){}else{sql=sql+" and zhuti like '%"+new String(request.getParameter("zhuti").getBytes("8859_1"))+"%'";} sql=sql+" order by id desc"; RS_result=connDbBean.executeQuery(sql); String id=""; String shoujianren="";String fajianren="";String zhuti="";String neirong="";String fujian=""; String addtime=""; int i=0; while(RS_result.next()){ i=i+1; id=RS_result.getString("id"); shoujianren=RS_result.getString("shoujianren");fajianren=RS_result.getString("fajianren");zhuti=RS_result.getString("zhuti");fujian=RS_result.getString("fujian"); addtime=RS_result.getString("addtime"); %> <tr> <td width="30" align="center"><%=i %></td> <td><%=shoujianren %></td><td><%=fajianren %></td><td><%=zhuti %></td><td><a href='<%=fujian %>' target='_blank'>下载</a></td> <td width="156" align="center"><%=addtime %></td> <td width="72" align="center"><a href="youjianxinxi_updt.jsp?id=<%=id%>"></a> <a href="del.jsp?id=<%=id %>&tablename=youjianxinxi" onClick="return confirm('真的要删除？')">删除</a> <a href="youjianxinxi_detail.jsp?id=<%=id%>">详细</a></td> </tr> <% } %> </table><br> 以上数据共<%=i %>条,<a style="cursor:hand" onClick="javascript:window.print();">打印本页</a> <p align="center"> 共<%=zgs%>条记录 <%=page_record %>条/页 <a href="youjianxinxi_list3.jsp?page=1">首页</a> <a href="youjianxinxi_list3.jsp?page=<%= curpage-1%>">上一页</a> <A href="youjianxinxi_list3.jsp?page=<%= curpage+1%>">下一页</A> <a href="youjianxinxi_list3.jsp?page=<%=zys %>">尾页</A> 当前第<FONT color=red><%=curpage %></FONT>页/共<FONT color=red><%=zys %></FONT>页</p> </body> </html>
王新凯、曾令杰完成对发送邮件、发送邮件记录部分的实现，都家林实现接收邮件记录部分
虽然实现了简单的发送接收功能，但对许多的条件设置还有缺陷，如给不存在用户发送邮件不会报错等情况，在大家的讨论后已有解决方法，在之后几天还会继续进行优化操作
