jsp12

1.实现 删除 回复邮件
2.实现阅读邮件功能:在main.jsp中点击任意邮件的标题,进入到detail.jsp显示邮件详情,包括发件人,主题,内容,时间。同时需要把邮件状态修改为已读。

 1 <%@page import="dao.EmlDao"%>
 2 <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
 3 <html>
 4 <head>
 5 <title>删除邮件</title>
 6 </head>
 7 <body>
 8     <%
 9         request.setCharacterEncoding("utf-8");
10 
11         int eid = Integer.parseInt(request.getParameter("eid"));
12         EmlDao ed = new EmlDao();
13         ed.delEml(eid);
14     %>
15     <script type="text/javascript">
16         alert("删除成功!");
17     </script>
18     <%
19         response.sendRedirect("main.jsp");
20     %>
21 </body>
22 </html>
  1 package com.gxl.dao;
  2 
  3 import java.sql.Connection;
  4 import java.sql.PreparedStatement;
  5 import java.sql.ResultSet;
  6 import java.sql.SQLException;
  7 import java.util.ArrayList;
  8 import java.util.Date;
  9 import java.util.List;
 10 
 11 import com.gxl.entity.Msg;
 12 
 13 
 14 
 15 public class MsgDao extends BaseDao {
 16     // 1,插入邮件
 17     public void addMsg(Msg m) {
 18         Connection con = getConnection();
 19         String sql = "insert into msg(username,title,msgcontent,state,sendto,msg_create_date) values(?,?,?,?,?,?)";
 20         PreparedStatement ps = null;
 21         try {
 22             ps = con.prepareStatement(sql);
 23             ps.setString(1, m.getUsername());
 24             ps.setString(2, m.getTitle());
 25             ps.setString(3, m.getMsgcontent());
 26             ps.setInt(4, 1);
 27             ps.setString(5, m.getSendto());
 28             ps.setDate(6, new java.sql.Date(new Date().getTime()));// 系统当前时间
 29             ps.executeUpdate();
 30         } catch (SQLException e) {
 31             // TODO Auto-generated catch block
 32             e.printStackTrace();
 33         } finally {
 34             closeAll(con, ps, null);
 35         }
 36 
 37     }
 38 
 39     // 2.删除邮件
 40     public void delMail(int id) {
 41         Connection conn = getConnection();
 42         String sql = "delete from msg where msgid=?";
 43         PreparedStatement ps = null;
 44         try {
 45             ps = conn.prepareStatement(sql);
 46             ps.setInt(1, id);
 47             ps.executeUpdate();
 48         } catch (SQLException e) {
 49             // TODO Auto-generated catch block
 50             e.printStackTrace();
 51         }finally{
 52             closeAll(conn, ps, null);
 53         }
 54 
 55     }
 56      //(测试删除邮件的代码是否编写成功)
 57      //    public static void main(String[] args) {
 58      //    MsgDao md=new MsgDao();
 59     //    md.delMail(3);
 60     //}
 61 
 62 
 63     // 3.修改邮件状态
 64     public void update(int id) {
 65         Connection con = getConnection();
 66         String sql = "update  msg set state='1' where msgid=?";
 67         PreparedStatement ps = null;
 68         try {
 69             ps = con.prepareStatement(sql);
 70             ps.setInt(1, id);
 71             ps.executeUpdate();
 72         } catch (SQLException e) {
 73             e.printStackTrace();
 74         } finally {
 75             closeAll(con, ps, null);
 76         }
 77     }
 78 
 79     // 4.按照接收者查询全部邮件
 80     public List<Msg> getMailByReceiver(String name) {
 81         List<Msg> list = new ArrayList<Msg>();
 82         Connection con = getConnection();
 83         String sql = "select * from msg where sendto=?";
 84         PreparedStatement ps=null;
 85         ResultSet rs=null;
 86         try {
 87             ps = con.prepareStatement(sql);
 88             ps.setString(1, name);
 89             rs = ps.executeQuery();
 90             while (rs.next()) {
 91                 Msg m = new Msg();
 92                 m.setMsgid(rs.getInt("msgid"));
 93                 m.setUsername(rs.getString("username"));
 94                 m.setTitle(rs.getString("title"));
 95                 m.setMsgcontent(rs.getString("msgcontent"));
 96                 m.setState(rs.getInt("state"));
 97                 m.setSendto(rs.getString("sendto"));
 98                 m.setMsg_create_date(rs.getDate("msg_create_date"));
 99                 list.add(m);
100             }
101         } catch (SQLException e) {
102             e.printStackTrace();
103         }finally{
104             closeAll(con, ps, rs);
105         }
106         return list;
107 
108     }
109     //5.实现阅读邮件功能
110     public Msg read(int id) {
111         Connection con = getConnection();
112         String sql = "select msgid,username,sendto,title,msgcontent,msg_create_date from msg where msgid=?";
113         PreparedStatement ps = null;
114         ResultSet rs = null;
115         try {
116             ps = con.prepareStatement(sql);
117             ps.setInt(1, id);
118             rs = ps.executeQuery();
119             while (rs.next()) {
120                 Msg m = new Msg();
121                 m.setMsgid(rs.getInt("msgid"));
122                 m.setUsername(rs.getString("username"));
123                 m.setTitle(rs.getString("title"));
124                 m.setMsgcontent(rs.getString("msgcontent"));
125                 m.setSendto(rs.getString("sendto"));
126                 m.setMsg_create_date(rs.getDate("msg_create_date"));
127                 return m;
128             }
129 
130         } catch (SQLException e) {
131             e.printStackTrace();
132         } finally {
133             closeAll(con, ps, rs);
134         }
135         return null;
136     }
137 
138 
139 }
 1 <%@page import="entity.Msg"%>
 2 <%@page import="dao.MsgDao"%>
 3 <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
 4 
 5 <html>
 6 <head>
 7 <title>My JSP 'index.jsp' main page</title>
 8 </head>
 9 <body>
10 <%
11     String uname=(String)session.getAttribute("uname");
12  %>
13  欢迎你 <% out.print(uname); %> <a href="write.jsp">写邮件</a>
14  <table height="20px" width="100%" align="center" border="1">
15        <tr>
16            <td>发件人</td>
17            <td>主题</td>
18            <td>状态</td>
19            <td>时间</td>
20            <td>操作</td>
21            <td>操作</td>
22        </tr>
23          <%
24          MsgDao md=new MsgDao();
25          List<Msg> list=md.getMailByReceiver(uname);   
26             for(Msg m:list)
27             {%>
28            <tr>
29                <td><%=m.getUsername() %></td>
30                <td><a href="detail.jsp?reply=<%=m.getMsgid()%>"><%=m.getTitle() %></a></td>
31                <td><%
32                int state=m.getState();
33                if(state==1){ %>
34                    <img src ="image/已读消息.png" />
35                    <%;
36                }else{%>
37                    <img src ="image/未读.png" />
38                    <%;
39                } 
40                %></td>
41                <td><%=m.getMsg_create_date() %></td>
42                <td><a href="write.jsp?reply=<%=m.getUsername()%>">回复</a></td>
43                <td><a href="del.jsp?id=<%=m.getMsgid()%>">删除</a></td>
44            </tr>
45             <%}
46         %>
47    </table>
48 </body>
49 </html>
 1 package com.gxl.dao;
 2 
 3 import java.sql.Connection;
 4 
 5 import java.sql.PreparedStatement;
 6 import java.sql.ResultSet;
 7 import java.sql.SQLException;
 8 
 9 public class UsersDao extends BaseDao {
10 
11     // 关于用户的增删改查
12 
13     // 1.登录
14     public boolean login(String uname, String upwd) {
15         boolean f = false;
16         Connection con = getConnection();
17         String sql = "select * from users where uname=? and upwd=?";
18         PreparedStatement ps = null;
19         ResultSet rs = null;
20         try {
21             ps = con.prepareStatement(sql);
22             ps.setString(1, uname);
23             ps.setString(2, upwd);
24             rs = ps.executeQuery();
25             if (rs.next())
26                 f = true;
27         } catch (SQLException e) {
28             e.printStackTrace();
29         } finally {
30             closeAll(con, ps, rs);
31         }
32         return f;
33     }
34 
35     // 2.注册
36     public int register(String uname, String upwd) {
37         Connection con = getConnection();
38         PreparedStatement ps = null;
39         int x = 0;
40         try {
41             String sql = "insert into users(uname,upwd) values(?,?)";
42             ps = con.prepareStatement(sql);
43             ps.setString(1, uname);
44             ps.setString(2, upwd);
45             x = ps.executeUpdate();
46         } catch (SQLException e) {
47             e.printStackTrace();
48         } finally {
49             closeAll(con, ps, null);
50         }
51         return x;
52     }
53 }
 1 <%@page import="entity.email"%>
 2 <%@page import="dao.EmlDao"%>
 3 <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
 4 <html>
 5 <head>
 6 <title>主界面</title>
 7 </head>
 8 <body>
 9     <%
10         String uname = (String) session.getAttribute("uname");
11     %>
12     <h2>首页!!欢迎你<%=uname%></h2>
13     <table border="1">
14         <tr>
15             <th>发件人</th>
16             <th>主题</th>
17             <th>状态</th>
18             <th>时间</th>
19             <th>操作</th>
20 
21             <%
22                 EmlDao md = new EmlDao();
23                 List<email> list = md.getEmailByAddressee(uname);
24                 
25                 for (int i = 0; i < list.size(); i++) {
26             %>
27             <tr>
28             <td><%=list.get(i).getSendername()%></td>
29             <td><a href="show.jsp?eid=<%=list.get(i).getEid() %>"><%=list.get(i).getTitle() %></a></td>
30             <td>
31                 <%
32                     if (list.get(i).getState() == 1) {
33                 %> <img src="images/sms_unReaded.png" /> <%
34                      } else {
35                 %> <img src="images/sms_readed.png" /> <%
36                      }
37                 %>
38             </td>
39             <td><%=list.get(i).getTotime()%></td>
40             <td><a href="delete.jsp?eid=<%=list.get(i).getEid()%>">删除</a></td>
41             <td><a href="write.jsp?reply=<%=list.get(i).getSendername()%>">回复</a></td>            
42             </tr>
43             <%
44                 }
45             %>                  
46     </table>
47     <br>
48     <a href="write.jsp">新建邮件</a>    
49 </body>
50 </html>
 1 <%@ page language="java" import="java.util.*" contentType="text/html; charset=utf-8"
 2     pageEncoding="utf-8"%>
 3 <%@page import="entity.Msg"%>
 4 <%@page import="dao.MsgDao"%>
 5 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 6 <html>
 7 <head>
 8 <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
 9 <title>Insert title here</title>
10 </head>
11 <body>
12 <%
13     String uname=(String)session.getAttribute("uname");
14  %>
15  <%
16  request.setCharacterEncoding("utf-8");
17  String msgid=request.getParameter("reply");
18  int id=Integer.parseInt(msgid);
19  %>
20  <table height="20px" width="100%" align="center" border="1">
21        <tr>
22            <td>发件人</td>
23            <td>主题</td>
24            <td>内容</td>
25            <td>时间</td>
26        </tr>
27          <%
28          MsgDao md=new MsgDao();
29          Msg m=md.Cha(id); 
30          md.updateMsg(id);
31           %>
32            <tr>
33                <td><%=m.getUsername() %></td>
34                <td><%=m.getTitle() %></td>
35                <td><%=m.getMsgcontent() %></td>
36                <td><%=m.getMsg_create_date() %></td>
37            </tr>
38    </table>
39 </body>
40 </html>
 1 <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
 2 <%@ page import="com.gxl.dao.UsersDao"%>
 3 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 4 <html>
 5 <head>
 6 <title>My JSP 'dologin.jsp' starting page</title>
 7 
 8 </head>
 9 
10 <body>
11     <%
12         request.setCharacterEncoding("utf-8");
13         String uname = request.getParameter("uname");
14         String upwd = request.getParameter("upwd");
15         UsersDao ud = new UsersDao();
16         if (ud.login(uname, upwd)) {
17             session.setAttribute("uname",uname);
18             request.getRequestDispatcher("main.jsp").forward(
19                     request,response);
20         } else {
21             out.print("登录失败,即将跳回登录页......");
22             response.setHeader("refresh", "3;url=login.jsp");
23         }
24     %>
25 </body>
26 </html>

 

 

 

 

 

 

posted @ 2022-05-22 13:15  计算机1905geng  阅读(11)  评论(0编辑  收藏  举报