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 > |