jsp第十二周作业
1.实现 删除 回复邮件
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 con = getConnection();
String sql = "select * from msg where sendto=?";
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = con.prepareStatement(sql);
ps.setString(1, name);
rs = ps.executeQuery();
while (rs.next()) {
Msg m = new Msg();
m.setMsgid(rs.getInt("msgid"));
m.setUsername(rs.getString("username"));
m.setTitle(rs.getString("title"));
m.setState(rs.getInt("state"));
m.setMsgcontent(rs.getString("msgcontent"));
m.setSendto(rs.getString("sendto"));
m.setMsg_create_date(rs.getDate("mgs_create_date"));
list.add(m);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
closeAll(con, ps, rs);
}
return list;
}
public void addMsg(Msg m) {
Connection conn = getConnection();
String sql = "insert into msg(username,title,msgcontent,state,sendto,msg_create_date) values(?,?,?,0,?,?)";
PreparedStatement ps = null;
try {
ps = conn.prepareStatement(sql);
ps.setString(1, m.getUsername());
ps.setString(2, m.getTitle());
ps.setString(3, m.getMsgcontent());
ps.setString(4, m.getSendto());
ps.setDate(5, new java.sql.Date(new Date().getTime()));
ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
closeAll(conn, ps, null);
}
}
// 根据id删除邮件
public void delMsg(int id) {
Connection con = getConnection();
String sql = "delete from msg where msgid=" + id;
PreparedStatement ps = null;
try {
ps = con.prepareStatement(sql);
ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
closeAll(con, ps, null);
}
}
// 查看信息之后状态变为已读
public void updateMsg(int id) {
Connection con = getConnection();
String sql = "update msg set state='1' where msgid=?";
PreparedStatement pred = null;
try {
pred = con.prepareStatement(sql);
pred.setInt(1, id);
pred.executeUpdate();
} catch (SQLException e1) {
e1.printStackTrace();
} finally {
closeAll(con, pred, null);
}
}
// 查看详细信息
public void updateMsg(int id) {
Connection con = getConnection();
String sql = "update msg set state='1' where msgid=?";
PreparedStatement pred = null;
try {
pred = con.prepareStatement(sql);
pred.setInt(1, id);
pred.executeUpdate();
} catch (SQLException e1) {
e1.printStackTrace();
} finally {
closeAll(con, pred, null);
}
}
// 查看详细信息
public Msg Cha(int msgid) {
Msg m = null;
Connection con = getConnection();
ResultSet rs = null;
PreparedStatement ps = null;
String sql = "select * from msg where msgid=?";
try {
ps = con.prepareStatement(sql);
ps.setInt(1, msgid);
rs = ps.executeQuery();
while (rs.next()) {
m = new Msg();
m.setMsgid(rs.getInt("msgid"));
m.setUsername(rs.getString("username"));
m.setTitle(rs.getString("title"));
m.setMsgcontent(rs.getString("msgcontent"));
m.setState(rs.getInt("state"));
m.setSendto(rs.getString("sendto"));
m.setMsg_create_date(rs.getDate("mgs_create_date"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
closeAll(con, ps, rs);
}
return null;
}
}
2.实现阅读邮件功能：在main.jsp中点击任意邮件的标题，进入到detail.jsp显示邮件详情，包括发件人，主题，内容，时间。同时需要把邮件状态修改为已读。
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%@ page import="com.wan.entity.Msg"%><%@ page import="com.wan.dao.MsgDao"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><title>My JSP 'main.jsp' starting page</title></head><body bgcolor=#ffccff> <% String uname = (String) session.getAttribute("uname"); %> 欢迎你<% out.print(uname); %>使用邮箱 <hr> <a href="write.jsp">写邮件</a> <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++) { %> <tr> <td><%=list.get(i).getUsername()%></td> <td><a href="detail.jsp?id=<%=list.get(i).getMsgid()%>"><%=list.get(i).getMsgcontent() %></a> </td> <td> <% if (list.get(i).getState() == 1) { %> <img src="image/unread.png"/> <% } else { %><img src="image/read.png"/> <% } %> </td> <td><%=list.get(i).getMsg_create_date()%></td> <td><a href="delete.jsp?id=<%=list.get(i).getMsgid()%>">删除</a> </td> <td><a href="write.jsp?reply=<%=list.get(i).getUsername()%>">回复</a> </td> </tr> <% } %> </table></body></html> |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><title>My JSP 'write.jsp' starting page</title></head><body> <form action="dowrite.jsp" method="post"> 收件人:<input type="text" name="receiver" value="<%=request.getParameter("reply")%>"><br> 主题: <input type="text" name="title"><br> 内容 <textarea rows="6" cols="20" name="content"></textarea> <br> <input type="submit" value="发送"> <br> <a href="main.jsp">返回</a> </form></body></html> |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%@ page import="com.wan.entity"%><%@ page import="com.wan.dao"%><%@ page import="com.wan.dao"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><title>My JSP 'dowrite.jsp' starting page</title></head><body> <% request.setCharacterEncoding("utf-8"); String uname = (String) session.getAttribute("uname"); String sendto = request.getParameter("receiver"); String title = request.getParameter("title"); String content = request.getParameter("content"); Msg m = new Msg(); m.setMsgcontent(content); m.setUsername(uname); m.setSendto(sendto); m.setTitle(title); MsgDao md = new MsgDao(); md.addMsg(m); out.print("发送成功....."); response.setHeader("refresh", "3;url=main.jsp"); %></body></html> |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%@ page import="com.wan.entity"%><%@ page import="com.wan.dao%><%@ page import="com.wan.dao"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <title>My JSP 'detail.jsp' starting page</title> </head> <body> <body> <% request.setCharacterEncoding("utf-8"); String msgid = request.getParameter("id"); int idd = Integer.parseInt(msgid); MsgDao md = new MsgDao(); md.update(idd); Msg m =md.read(idd); %> <table> <tr> <td>发件人:</td> <td><input type="text" name="username" style="border: none" value="<%=m.getUsername()%>"> </td> </tr> <tr> <td>主题:</td> <td><input type="text" name="title" style="border: none" value="<%=m.getTitle()%>"> </td> </tr> <tr> <td>时间:</td> <td><input type="text" name="msg_create_date" style="border: none" value="<%=m.getMsg_create_date()%>"> </td> </tr> <tr> <td>收件人:</td> <td><input type="text" name="sendto" style="border: none" value="<%=m.getSendto()%>"> </td> </tr> <tr> <td>内容:</td> <td><div style="border: none;outline: none;overflow: inherit;"> <%=m.getMsgcontent()%></div> </td> </tr> </table> <br> <a href="main.jsp">返回</a></body> </body></html> |
