十二周作业
1.实现昨天讲过的 删除 回复邮件
2.实现阅读邮件功能:在main.jsp中点击任意邮件的标题,进入到detail.jsp显示邮件详情,
包括发件人,主题,内容,时间。同时需要把邮件状态修改为已读。
package
dao;
import
java.sql.Connection;
import
java.sql.PreparedStatement;
import
java.sql.ResultSet;
import
java.sql.SQLException;
import
java.util.ArrayList;
import
java.util.Date;
import
java.util.List;
import
entity.Msg;
public
class
MsgDao
extends
BaseDao {
public
List<Msg> getMailByReceiver(String name) {
List<Msg> list =
new
ArrayList<Msg>();
Connection conn = getConnection();
String sql =
"select * from mail where addressee=?"
;
PreparedStatement ps =
null
;
ResultSet rs =
null
;
try
{
ps = conn.prepareStatement(sql);
ps.setString(
1
, name);
rs = ps.executeQuery();
while
(rs.next()) {
Msg m =
new
Msg();
int
eid = rs.getInt(
"eid"
);
String sender = rs.getString(
"sender"
);
String addressee = rs.getString(
"addressee"
);
String title = rs.getString(
"title"
);
String content = rs.getString(
"content"
);
Date sending_time = rs.getDate(
"sending_time"
);
int
state = rs.getInt(
"state"
);
m.setEid(eid);
m.setSender(sender);
m.setAddressee(addressee);
m.setTitle(title);
m.setContent(content);
m.setSending_time(sending_time);
m.setState(state);
list.add(m);
}
}
catch
(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
closeAll(conn, ps, rs);
}
return
list;
}
public
void
addMsg(Msg m) {
Connection conn = getConnection();
String sql =
"insert into mail(sender,addressee,title,content,sending_time,state) values(?,?,?,?,?,?)"
;
PreparedStatement ps =
null
;
try
{
ps = conn.prepareStatement(sql);
ps.setString(
1
, m.getSender());
ps.setString(
2
, m.getAddressee());
ps.setString(
3
, m.getTitle());
ps.setString(
4
, m.getContent());
ps.setDate(
5
,
new
java.sql.Date(
new
Date().getTime()));
ps.setInt(
6
, m.getState());
ps.executeUpdate();
}
catch
(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
closeAll(conn, ps,
null
);
}
}
public
void
delMail(
int
id) {
Connection conn = getConnection();
String sql =
"delete from mail where eid=?"
;
PreparedStatement ps =
null
;
try
{
ps = conn.prepareStatement(sql);
ps.setInt(
1
, id);
ps.executeUpdate();
}
catch
(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
closeAll(conn, ps,
null
);
}
}
public
Msg getMailById(
int
id) {
Connection conn = getConnection();
String sql =
"select * from mail where eid=?"
;
PreparedStatement ps =
null
;
ResultSet rs =
null
;
Msg m =
null
;
try
{
ps = conn.prepareStatement(sql);
ps.setInt(
1
, id);
rs = ps.executeQuery();
while
(rs.next()) {
m =
new
Msg();
int
eid = rs.getInt(
"eid"
);
String sender = rs.getString(
"sender"
);
String addressee = rs.getString(
"addressee"
);
String title = rs.getString(
"title"
);
String content = rs.getString(
"content"
);
Date sending_time = rs.getDate(
"sending_time"
);
m.setEid(eid);
m.setSender(sender);
m.setAddressee(addressee);
m.setTitle(title);
m.setContent(content);
m.setSending_time(sending_time);
m.setState(readMail(id) ==
1
?
0
:
1
);
}
}
catch
(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
closeAll(conn, ps, rs);
}
return
m;
}
public
int
readMail(
int
id) {
int
n =
0
;
Connection conn = getConnection();
String sql =
"update mail set state='0' where eid=?"
;
PreparedStatement ps =
null
;
try
{
ps = conn.prepareStatement(sql);
ps.setInt(
1
, id);
n = ps.executeUpdate();
}
catch
(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
closeAll(conn, ps,
null
);
}
return
n;
}
}
package
dao;
import
java.sql.Connection;
import
java.sql.PreparedStatement;
import
java.sql.ResultSet;
import
java.sql.SQLException;
import
java.util.ArrayList;
import
java.util.Date;
import
java.util.List;
import
entity.Msg;
public
class
MsgDao
extends
BaseDao {
public
List<Msg> getMailByReceiver(String name) {
List<Msg> list =
new
ArrayList<Msg>();
Connection conn = getConnection();
String sql =
"select * from mail where addressee=?"
;
PreparedStatement ps =
null
;
ResultSet rs =
null
;
try
{
ps = conn.prepareStatement(sql);
ps.setString(
1
, name);
rs = ps.executeQuery();
while
(rs.next()) {
Msg m =
new
Msg();
int
eid = rs.getInt(
"eid"
);
String sender = rs.getString(
"sender"
);
String addressee = rs.getString(
"addressee"
);
String title = rs.getString(
"title"
);
String content = rs.getString(
"content"
);
Date sending_time = rs.getDate(
"sending_time"
);
int
state = rs.getInt(
"state"
);
m.setEid(eid);
m.setSender(sender);
m.setAddressee(addressee);
m.setTitle(title);
m.setContent(content);
m.setSending_time(sending_time);
m.setState(state);
list.add(m);
}
}
catch
(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
closeAll(conn, ps, rs);
}
return
list;
}
public
void
addMsg(Msg m) {
Connection conn = getConnection();
String sql =
"insert into mail(sender,addressee,title,content,sending_time,state) values(?,?,?,?,?,?)"
;
PreparedStatement ps =
null
;
try
{
ps = conn.prepareStatement(sql);
ps.setString(
1
, m.getSender());
ps.setString(
2
, m.getAddressee());
ps.setString(
3
, m.getTitle());
ps.setString(
4
, m.getContent());
ps.setDate(
5
,
new
java.sql.Date(
new
Date().getTime()));
ps.setInt(
6
, m.getState());
ps.executeUpdate();
}
catch
(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
closeAll(conn, ps,
null
);
}
}
public
void
delMail(
int
id) {
Connection conn = getConnection();
String sql =
"delete from mail where eid=?"
;
PreparedStatement ps =
null
;
try
{
ps = conn.prepareStatement(sql);
ps.setInt(
1
, id);
ps.executeUpdate();
}
catch
(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
closeAll(conn, ps,
null
);
}
}
public
Msg getMailById(
int
id) {
Connection conn = getConnection();
String sql =
"select * from mail where eid=?"
;
PreparedStatement ps =
null
;
ResultSet rs =
null
;
Msg m =
null
;
try
{
ps = conn.prepareStatement(sql);
ps.setInt(
1
, id);
rs = ps.executeQuery();
while
(rs.next()) {
m =
new
Msg();
int
eid = rs.getInt(
"eid"
);
String sender = rs.getString(
"sender"
);
String addressee = rs.getString(
"addressee"
);
String title = rs.getString(
"title"
);
String content = rs.getString(
"content"
);
Date sending_time = rs.getDate(
"sending_time"
);
m.setEid(eid);
m.setSender(sender);
m.setAddressee(addressee);
m.setTitle(title);
m.setContent(content);
m.setSending_time(sending_time);
m.setState(readMail(id) ==
1
?
0
:
1
);
}
}
catch
(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
closeAll(conn, ps, rs);
}
return
m;
}
public
int
readMail(
int
id) {
int
n =
0
;
Connection conn = getConnection();
String sql =
"update mail set state='0' where eid=?"
;
PreparedStatement ps =
null
;
try
{
ps = conn.prepareStatement(sql);
ps.setInt(
1
, id);
n = ps.executeUpdate();
}
catch
(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
closeAll(conn, ps,
null
);
}
return
n;
}
}
<%@ page language=
"java"
contentType=
"text/html; charset=utf-8"
pageEncoding=
"utf-8"
%>
<%@ page
import
=
"dao.MsgDao"
%>
<%@ page
import
=
"entity.Msg"
%>
<%@ page
import
=
"java.util.List"
%>
<%@ page
import
=
"java.util.ArrayList"
%>
<!DOCTYPE html PUBLIC
"-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd"
>
<html>
<head>
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=utf-8"
>
<title>Insert title here</title>
<style>
table {
border-collapse: collapse;
width:400px;
}
table, table tr th, table tr td {
border: 1px solid #
000000
;
}
table td{
text-align:center;
}
img{
width:30px;
}
a{
text-decoration: none;
}
a:link{
color:black;
}
</style>
</head>
<body>
<%String uname=(String)session.getAttribute(
"uname"
); %>
首页!!欢迎你<%=uname %>
<table border=
"1"
>
<tr>
<td>发件人</td><td>主题</td><td>状态</td><td>时间</td><td>操作</td><td>操作</td>
<%
MsgDao md =
new
MsgDao();
List<Msg> list = md.getMailByReceiver(uname);
for
(
int
i =
0
; i < list.size(); i++) {
out.print(
"<tr><td>"
+ list.get(i).getSender() +
"</td>"
);
out.print(
"<td><a href=\"detail.jsp?id="
+list.get(i).getEid() +
"\">"
+ list.get(i).getTitle() +
"</a></td>"
);
if
(list.get(i).getState() ==
1
) {
out.print(
"<td><img src=\"img/wd.png\"/></td>"
);
}
else
{
out.print(
"<td><img src=\"img/yd.png\"/></td>"
);
}
out.print(
"<td>"
+ list.get(i).getSending_time() +
"</td>"
);
out.print(
"<td><a href=\"delete.jsp?id="
+list.get(i).getEid()+
"\">删除</a></td>"
);
out.print(
"<td><a href=\"write.jsp?id="
+list.get(i).getEid()+
"&reply="
+list.get(i).getSender()+
"\">回复</a></td></tr>"
);
}
%>
</tr>
</table>
</body>
</html>
<%@ page language=
"java"
contentType=
"text/html; charset=utf-8"
pageEncoding=
"utf-8"
%>
<%@ page
import
=
"dao.MsgDao"
%>
<!DOCTYPE html PUBLIC
"-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd"
>
<html>
<head>
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=utf-8"
>
<title>Insert title here</title>
</head>
<body>
<%
int
id=Integer.parseInt(request.getParameter(
"id"
));
MsgDao md=
new
MsgDao();
md.delMail(id);
response.sendRedirect(
"main.jsp"
);
%>
</body>
</html>
<%@page import="entity.Msg"%>
<%@page import="dao.MsgDao"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<html>
<head>
<title>My JSP 'index.jsp' main page</title>
</head>
<body>
<%
String uname=(String)session.getAttribute("uname");
%>
欢迎你 <% out.print(uname); %> <a href="write.jsp">写邮件</a>
<table height="20px" width="100%" align="center" border="1">
<tr>
<td>发件人</td>
<td>主题</td>
<td>状态</td>
<td>时间</td>
<td>操作</td>
<td>操作</td>
</tr>
<%
MsgDao md=new MsgDao();
List<Msg> list=md.getMailByReceiver(uname);
for(Msg m:list)
{%>
<tr>
<td><%=m.getUsername() %></td>
<td><a href="detail.jsp?reply=<%=m.getMsgid()%>"><%=m.getTitle() %></a></td>
<td><%
int state=m.getState();
if(state==1){ %>
<img src ="image/已读消息.png" />
<%;
}else{%>
<img src ="image/未读.png" />
<%;
}
%></td>
<td><%=m.getMsg_create_date() %></td>
<td><a href="write.jsp?reply=<%=m.getUsername()%>">回复</a></td>
<td><a href="del.jsp?id=<%=m.getMsgid()%>">删除</a></td>
</tr>
<%}
%>
</table>
</body>
</html>
<%@page import="dao.MsgDao"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<html>
<head>
<title>My JSP 'index.jsp' main page</title>
</head>
<body>
<%
String uname=(String)session.getAttribute("uname");
%>
欢迎你 <% out.print(uname); %> <a href="write.jsp">写邮件</a>
<table height="20px" width="100%" align="center" border="1">
<tr>
<td>发件人</td>
<td>主题</td>
<td>状态</td>
<td>时间</td>
<td>操作</td>
<td>操作</td>
</tr>
<%
MsgDao md=new MsgDao();
List<Msg> list=md.getMailByReceiver(uname);
for(Msg m:list)
{%>
<tr>
<td><%=m.getUsername() %></td>
<td><a href="detail.jsp?reply=<%=m.getMsgid()%>"><%=m.getTitle() %></a></td>
<td><%
int state=m.getState();
if(state==1){ %>
<img src ="image/已读消息.png" />
<%;
}else{%>
<img src ="image/未读.png" />
<%;
}
%></td>
<td><%=m.getMsg_create_date() %></td>
<td><a href="write.jsp?reply=<%=m.getUsername()%>">回复</a></td>
<td><a href="del.jsp?id=<%=m.getMsgid()%>">删除</a></td>
</tr>
<%}
%>
</table>
</body>
</html>
<%@ page language=
"java"
contentType=
"text/html; charset=utf-8"
pageEncoding=
"utf-8"
%>
<%@ page
import
=
"entity.Msg"
%>
<%@ page
import
=
"dao.MsgDao"
%>
<!DOCTYPE html PUBLIC
"-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd"
>
<html>
<head>
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=utf-8"
>
<title>Insert title here</title>
</head>
<body>
<%
request.setCharacterEncoding(
"utf-8"
);
String uname=(String)session.getAttribute(
"uname"
);
String addressee=request.getParameter(
"addressee"
);
String title=request.getParameter(
"title"
);
String content=request.getParameter(
"content"
);
Msg m=
new
Msg();
m.setContent(content);
m.setSender(uname);
m.setAddressee(addressee);
m.setTitle(title);
MsgDao md=
new
MsgDao();
md.addMsg(m);
out.print(
"发送成功....."
);
response.setHeader(
"refresh"
,
"5;url=main.jsp"
);
%>
</body>
</html>
<%@ page language=
"java"
contentType=
"text/html; charset=utf-8"
pageEncoding=
"utf-8"
%>
<%@ page
import
=
"dao.MsgDao"
%>
<%@ page
import
=
"entity.Msg"
%>
<!DOCTYPE html PUBLIC
"-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd"
>
<html>
<head>
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=utf-8"
>
<title>Insert title here</title>
</head>
<body>
<%
int
id=Integer.parseInt(request.getParameter(
"id"
));
MsgDao md =
new
MsgDao();
md.readMail(id);
%>
<form action=
"dowrite.jsp"
method=
"post"
>
收件人:<input type=
"text"
name=
"addressee"
value=
"<%=request.getParameter("
reply
")%>"
><br>
主题: <input type=
"text"
name=
"title"
><br>
内容 <textarea rows=
"6"
cols=
"20"
name=
"content"
></textarea>
<br>
<input type=
"submit"
value=
"发送"
>
</form>
</body>
</html>