第十二周作业
添加查询改变内容是否已经阅读功能
@Override public void updatemesById(Integer updateid) { // 通过id更新数据 try { String sql = "UPDATE t_email SET model='已读' where id=?"; conn = utils.getConnection(); ps = conn.prepareStatement(sql); ps.setInt(1, updateid); ps.executeUpdate(); }catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { try { utils.Close(conn, ps, rs); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix= "c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>我的邮箱</title>
</head>
<body>
<%@ include file="/C.jsp"%>
<div align="center"><h4>--->增加信件<---</h4>
<form action="${pageContext.request.contextPath}/myemail" method = "post">
<table>
<tr>
<td>
寄件人:
<input type = "text" name = "sendname">
</td>
</tr>
<tr>
<td>
收件人:
<input type = "text" name = "receivename">
</td>
</tr>
<tr>
<td>
内   容:
<input type = "text" name = "emailcontent">
</td>
</tr>
<tr>
<td>
已   读:
<input type = "text" name = "model">
</td>
</tr>
<tr>
<td>
日   期:
<input type = "text" name = "email">
</td>
</tr>
<tr>
<td>
<input type = "submit" value="录入" >
</td>
</tr>
</table>
</form>
</div>
<br>
<div align="center"><b1 >-------------------------------------------------------------------</b1></div>
<br>
<div align="center"><h4>--->查询信件<---</h4>
<h4>--->"2"代表没有查阅，"1"代表已经查阅<---</h4>
<div align="center" id = "mydiv">登录信息通知处==</div>
<table border="1">
<th>Id</th>
<th>寄件人 </th>
<th>收件人 </th>
<th>邮寄内容</th>
<th>是否查阅</th>
<th>日期</th>
<c:forEach items = "${emails}" var = "em" >
<tr>
<td>
${em.id}
</td>
<td>
${em.sendname}
</td>
<td>
${em.receivename}
</td>
<td>
${em.emailcontent}
</td>
<td>
${em.model}
</td>
<td>
${em.email}
</td>
<td>
<input type="button" value="删除" id = "${em.id}" onclick="dodelete(id)" />
<input type="button" value="查阅" id = "${em.id}" onclick="doupdate(id)" />
</tr>
</c:forEach>
</table>
<form action = "${pageContext.request.contextPath}/selectemail" method = "post">
<input type = "submit" value = "查询信件"/>
</form>
</div>
<script type="text/javascript">
function dodelete(id){
var xhr = new XMLHttpRequest();
//请求连接(绑定事件)
xhr.onreadystatechange=function(){
if(xhr.readyState==4){
var json = xhr.responseText;
eval("var jsonS="+json);//json = "jsonStr"
if(jsonS.success){
document.getElementById("mydiv").innerHTML="删除成功";
}else{
document.getElementById("mydiv").innerHTML="删除失败";
}
}
}
//请求处理(准备好需要验证的信息)
//获取参数
//var Ajaxurl = "login?studentsum"+sum+"&studentpassword"+password;
xhr.open("POST","/EmailHomework/deleate",true);
//请求完成,且响应就绪
//如果是发送post请求必须加上以下代码：application/x-www-form-urlencoded为为了防止乱码出现
xhr.setRequestHeader("Content-type","application/x-www-form-urlencoded;charset=utf-8");
xhr.send("id="+id);
}
function doupdate(id){
var xhr = new XMLHttpRequest();
xhr.onreadystatechange=function(){
if(xhr.readyState==4){
var json = xhr.responseText;
eval("var jsonS="+json);
if(jsonS.success){
document.getElementById("mydiv").innerHTML="修改成功";
}else{
document.getElementById("mydiv").innerHTML="修改失败";
}
}
}
xhr.open("POST","/EmailHomework/update",true);
xhr.setRequestHeader("Content-type","application/x-www-form-urlencoded;charset=utf-8");
xhr.send("id="+id);
}
