本文主要介绍第十二周 ■作业参考答案第六章频率特性分析法(第十二周 ■作业科永明)，下面一起看看第十二周 ■作业参考答案第六章频率特性分析法(第十二周 ■作业科永明)相关资讯。
1.删除回复邮件。2.阅读邮件:在main.jsp点击任意邮件标题进入details，显示邮件详细信息，包括发件人、主题、内容和时间。同时，您需要将邮件状态更改为已读。包com . nn . dao；导入java . sql . connection；导入java . sql . prepared statement；导入java . sql . resultset；导入java . sql . sql exception；导入java . util . arraylist；导入java . util . date；导入java . util . list；导入javax . annotation . predestroy；导入com . nn . entity . msg；导入com . sun . org . apache . regexp . internal . recompile；公共类msgdao扩展basedao { public listmsg listall(string send to)抛出sqlexception { listmsg list = new arraylistmsg；connection conn = getconnection；字符串sql = select * from msg where sendto=？ preparedstatement pred = nullresultset rest = nulltry { pred = conn . prepare statement(sql)；pred.setstring(1，send to)；rest = pred . execute query；while(rest . next){ msg msg = new msg；msg . setmsgid(rest . getint( msgid ));msg . set username(rest . getstring( 用户名和密码));msg . settitle(rest . getstring( 标题和标题));msg.setmsgcontent(rest.getst戒指( msgcontent ));msg . setstate(rest . getint( 国家与社会));msg . setsendto(rest . getstring( sendto ));msg . setmsg _ create _ date(rest . getdate( 消息创建日期 ));list . add(msg)；} } catch(exc:处理异常} finally{ closeall(conn，pred，rest)；}返回列表；} public void changestate(integer msgid){ connection conn = getconnection；字符串sql = 更新msg set state=1，其中msgid=？ preparedstatement pred = nulltry { pred = conn . prepare statement(sql)；pred.setint(1，msgid)；pred . execute update；} catch (sqlexception e) { // todo自动生成的catch块e . printstacktrace；} finally{ closeall(conn，pred，null)；} } public listmsg show content(integer msgid){ listmsg list = new arraylistmsg；connection conn = getconnection；字符串sql = select * from msg其中msgid=？ preparedstatement pred = nullresultset rest = nulltry { pred = conn . prepare statement(sql)；pred.setint(1，msgid)；rest = pred . execute query；while(rest . next){ msg msg = new msg；msg.setusername(rest . getstring( 用户名和密码));msg . settitle(rest . getstring( 标题和标题));msg . setmsgcontent(rest . getstring( msgcontent ));msg . setmsg _ create _ date(rest . getdate( 消息创建日期 ));list . add(msg)；} } catch (sqlexception e) { // todo自动生成的catch块e . printstacktrace；}最后{ closeall(conn，pred，rest)；}返回列表；} public void delmsg(integer msgid){ connection conn = getconnection；字符串sql = 从msg中删除，其中msgid=？ preparedstatement pred = nulltry { pred = conn . prepare statement(sql)；pred.setint(1，msgid)；pred . execute update；} catch (sqlexception e) { // todo自动生成的catch块e . printstacktrace；} finally{ closeall(conn，pred，null)；} } public void send(msg msg){ connection conn = getconnection；字符串sql = 插入到消息(用户名，标题，消息内容，状态，发送到，消息创建日期)值(？,?,?,0,?,?) preparedstatement ps = null请尝试{ ps = conn . prepare statement(sql)；ps.setstring(1，msg . get username)；ps.setstring(2，msg . gettitle)；ps.setstring(3，msg . getmsgcontent)；ps.setstring(4，msg . getsendto)；ps.setdate(5，new java.sql.date(new date。gettime))；ps . execute update；} catch (sqlexception e) { // todo自动生成的catch块e . printstacktrace；}最后{ closeall(conn，ps，null)；} } } % @页导入= com . nn . entity . msg % % @页导入= com . nn . dao . msgdao % % @ page language = java和进口= java.util. * pageencoding = utf8 % % request . setcharacterencoding( utf8和);response . setcharacterencoding( utf8和);% !doctype html public //w3c//dtd html 4.01过渡版//en html body % string magid = request . getparameter( msgid );integer msgid = integer . parse int(magid)；msgdao msg dao = new msg dao；msg dao . changestate(msgid)；msg msg = new msg；listmsg list = new arraylistmsg；list = msg dao . show content(msgid)；% tablewidth = 600像素border = 2px固体和(msgms g1 :列表){ % trtd % out . print(msg 1 . get username)的第个发件人/第个标题/第个内容/第个发送时间/第/tr %；%/td td % out . print(msg 1 . gettitle)；%/td td%out.print(msg1.getmsgcontent)；%/td td % out . print(msg 1 . getmsg _ create _ date)；%/td/tr % } %/tablea href = zhuye.jsp 继续浏览/a/body/html % @页面导入= com . nn . entity . msg % % @页导入= com . nn . dao . msgdao % % @页导入= sun . security . jgss . loginconfigmpl % % @页导入= com . nn . dao . use rs dao % % @ page language = java和进口= java.util. * pageencoding = utf8 % % request . setcharacterencoding( utf8和);response . setcharacterencoding( utf8和);% !doctype html public //w3c//dtd html 4.01过渡版//en html body % string msgid 1 = request . getparameter( msgid );integer msgid = integer . parse int(msgid 1)；msgdao msg dao = new msg dao；msg dao . delmsg(msgid)；send redirect( zhuye.jsp );%/body/html % @页面导入= % % @页导入= com . nn . dao . msgdao % % @页导入= com . nn . entity . msg % % @页导入= sun . security . jgss . loginconfigmpl % % @页导入= com . nn . dao . users dao % % @ page language = java和进口= java.util. * pageencoding = utf8 % % request . setcharacterencoding( utf8和);response . setcharacterencoding( utf8和);% !doctype html public //w3c//dtd html 4.01过渡版//en html body % string uname =(string)session . get attribute( uname );if(uname = = null){ out . print( 您尚未登录，您将跳回登录页面... );response . set header( 刷新 ， 5;url = log in . jsp );} else { % welcom:表格宽度= 600像素border = 2px固体和% if(列表。size = = 0) {out。打印( 你没有邮件 );}否则{ % tr thid/th sender/th title/th已读和未读状态/th recipient/th发送时间thth colspan = 2 operation/th/tr % for(msg msg 1 : list){ % trtd % out . print(msg 1 . get msgid %/td td % out . print(msg 1 . get username)；%/td tda href = domsgcontent.jsp？msgid = % = msg 1 . getmsgid% % out . print(msg 1 . gettitle)；%/a/td td % out . print(msg 1 . getstate)；%/td td % out . print(msg 1 . getsendto)；%/td td % out . print(msg 1 . getmsg _ create _ date)；%/td tda href = delmsg.jsp？msgid = % = msg 1 . getmsgid% delete/a/td tda href = send.jsp？username=%=msg1.getusername% reply/a/td/tr % } } %/table/body/html % @ page language = java和进口= java.util. * 页面编码= utf8 % % request . setcharacterencoding( utf8 ).response . setcharacterencoding( utf8和);% !doctype html public /w3c//dtdthtml4.01过渡版//en html正文脚本类型= 文本/javascript function dologin{ if(log in . send to . value = ){ alert( 没有输入收件人);返回；} if(log in . title . value = = ){ alert( 没有标题输入 );返回；} if(log in . content . value = = ){ alert( 没有输入 );返回；} loginform . submit；} / script表单名称= 登录表单 动作= 方法= 邮政和邮政收件人:输入类型= 文本 nam:输入类型= 文本 name = 标题和标题br content :bintextarearows = 6 cols = 50 name = 内容 /textareabrinputtype = 提交 价值= 发送 onclick = 多洛金 /.
标签:
邮件发送者
了解更多第十二周 ■作业参考答案第六章频率特性分析法(第十二周 ■作业科永明)相关内容请关注本站点。