JSP第九次作业

1.建库,建表2个
用户表(id,用户名,密码)
邮件表(id,发件人,收件人,标题,内容,发送时间,状态)

2.建model层
entity,dao包

3.登陆,注册,登陆后显示全部邮件
11.png

 

 

 dao

 1 package com.gd.dao;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.PreparedStatement;
 6 import java.sql.ResultSet;
 7 import java.sql.SQLException;
 8 
 9 public class BaseDao {
10     // 获取连接
11     protected Connection getConnection() {
12         Connection conn = null;
13         try {
14             Class.forName("com.mysql.jdbc.Driver");
15             // 2.建立连接
16             conn = DriverManager.getConnection(
17                     "jdbc:mysql://localhost:3306/test", "root", "123456");
18         } catch (Exception e) {
19             e.printStackTrace();
20         }
21         return conn;
22     }
23 
24     // 关闭连接
25     protected void closeAll(Connection con, PreparedStatement ps, ResultSet rs) {
26         try {
27             if (rs != null)
28                 rs.close();
29             if (ps != null)
30                 ps.close();
31             if (con != null)
32                 con.close();
33 
34         } catch (SQLException e) {
35             e.printStackTrace();
36         }
37     }
38 }
 1 package com.gd.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.List;
 9 
10 import com.gd.entity.Msg;
11 
12 public class MsgDao extends BaseDao {
13     public List<Msg> listAll(String username) throws SQLException{
14         List<Msg> list =new ArrayList<Msg>();
15         Connection conn =getConnection();
16         String sql="select * from msg where username=?";
17         PreparedStatement pred =null;
18         
19         ResultSet rest=null;
20         try {
21             pred=conn.prepareStatement(sql);
22             pred.setString(1, username);
23             rest=pred.executeQuery();
24             while (rest.next()) {
25                 Msg msg=new Msg();
26                 msg.setMsgid(rest.getInt("msgid"));
27                 msg.setUsername(rest.getString("username"));
28                 msg.setTitle(rest.getString("title"));
29                 msg.setMsgcontent(rest.getString("msgcontent"));
30                 msg.setState(rest.getInt("state"));
31                 msg.setSendto(rest.getString("sendto"));
32                 msg.setMsg_create_date(rest.getDate("msg_create_date"));
33                 list.add(msg);
34             }
35         } catch (Exception e) {
36             // TODO: handle exception
37         }
38         finally{
39             closeAll(conn, pred, rest);
40         }
41         return list;
42     }
43 
44 }
 1 package com.gd.dao;
 2 
 3 import java.sql.Connection;
 4 import java.sql.PreparedStatement;
 5 import java.sql.ResultSet;
 6 import java.sql.SQLException;
 7 
 8 public class UsersDao extends BaseDao {
 9     public boolean login(String uname, String upwd) throws SQLException {
10         boolean f = false;
11         Connection conn = getConnection();
12         PreparedStatement pred = null;
13         ResultSet rest = null;
14         String sql = "select * from users where uname=? and upwd=?";
15         try {
16             pred = conn.prepareStatement(sql);
17             pred.setString(1, uname);
18             pred.setString(2, upwd);
19             rest = pred.executeQuery();
20             while (rest.next()) {
21                 f = true;
22             }
23         } catch (Exception e) {
24             // TODO: handle exception
25         } finally {
26             closeAll(conn, pred, rest);
27         }
28         return f;
29     }
30 
31     public boolean id(Integer id) throws SQLException {
32         boolean f = false;
33         Connection conn = getConnection();
34         PreparedStatement pred = null;
35         ResultSet rest = null;
36         String sql = "select * from users where id=?";
37         try {
38             pred = conn.prepareStatement(sql);
39             pred.setInt(1, id);
40             rest = pred.executeQuery();
41             while (rest.next()) {
42                 f = true;
43             }
44         } catch (Exception e) {
45             // TODO: handle exception
46         } finally {
47             closeAll(conn, pred, rest);
48         }
49         return f;
50     }
51 
52     public void zhuce(Integer id, String uname, String upwd) {
53         Connection conn = getConnection();
54         PreparedStatement pred = null;
55         try {
56             String sql = "insert into users(id,uname,upwd) values(?,?,?)";
57             pred = conn.prepareStatement(sql);
58             pred.setInt(1, id);
59             pred.setString(2, uname);
60             pred.setString(3, upwd);
61             pred.executeUpdate();
62 
63         } catch (Exception e) {
64             // TODO: handle exception
65         } finally {
66             closeAll(conn, pred, null);
67         }
68     }
69 
70 }

entity

 1 package com.gd.entity;
 2 
 3 import java.util.Date;
 4 
 5 public class Msg {
 6     private Integer msgid;
 7     private String username;
 8     private String title;
 9     private String msgcontent;
10     private Integer state;
11     private String sendto;
12     private Date msg_create_date;
13     
14     public Integer getMsgid() {
15         return msgid;
16     }
17     public void setMsgid(Integer msgid) {
18         this.msgid = msgid;
19     }
20     public String getUsername() {
21         return username;
22     }
23     public void setUsername(String username) {
24         this.username = username;
25     }
26     public String getTitle() {
27         return title;
28     }
29     public void setTitle(String title) {
30         this.title = title;
31     }
32     public String getMsgcontent() {
33         return msgcontent;
34     }
35     public void setMsgcontent(String msgcontent) {
36         this.msgcontent = msgcontent;
37     }
38     public Integer getState() {
39         return state;
40     }
41     public void setState(Integer state) {
42         this.state = state;
43     }
44     public String getSendto() {
45         return sendto;
46     }
47     public void setSendto(String sendto) {
48         this.sendto = sendto;
49     }
50     public Date getMsg_create_date() {
51         return msg_create_date;
52     }
53     public void setMsg_create_date(Date msg_create_date) {
54         this.msg_create_date = msg_create_date;
55     }
56 
57 }
 1 package com.gd.entity;
 2 
 3 public class Users {
 4     private Integer id;
 5     private String uname;
 6     private String upwd;
 7     public Integer getId() {
 8         return id;
 9     }
10     public void setId(Integer id) {
11         this.id = id;
12     }
13     public String getUname() {
14         return uname;
15     }
16     public void setUname(String uname) {
17         this.uname = uname;
18     }
19     public String getUpwd() {
20         return upwd;
21     }
22     public void setUpwd(String upwd) {
23         this.upwd = upwd;
24     }
25     
26 
27 }

jsp

 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
 2 <%
 3     request.setCharacterEncoding("utf-8");
 4     response.setCharacterEncoding("utf-8");
 5 %>
 6 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 7 <html>
 8 <head>
 9 <title>My JSP 'zhuce.jsp' starting page</title>
10 </head>
11 <body>
12     <script type="text/javascript">
13         function dozhuce() {
14             if (loginform2.id.value == "") {
15                 alert("没有输入id");
16                 return;
17             }
18             if (loginform2.uname.value == "") {
19                 alert("没有输入用户名");
20                 return;
21             }
22             if (loginform2.upwd.value == "") {
23                 alert("没有输入密码");
24                 return;
25             }
26             if (loginform2.upwd2.value == "") {
27                 alert("没有确认密码");
28                 return;
29             }
30             loginform2.submit();
31         }
32     </script>
33     <form action="dozhuce.jsp" name="loginform2" method="post">
34         id: <input type="number" name="id" /><br>
35          用户名:<input type="text" name="uname" /> <br>
36          密码:<input type="password" name="upwd" /> <br>
37          确认密码:<input type="password" name="upwd2" /><br>
38         <input type="button" value="注册" onclick="dozhuce()" />
39     </form>
40 </body>
41 </html>
 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
 2 <%@page import="com.gd.dao.UsersDao"%>
 3 <%
 4     request.setCharacterEncoding("utf-8");
 5     response.setCharacterEncoding("utf-8");
 6 %>
 7 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 8 <html>
 9 <head>
10 <title>My JSP 'dozhuce.jsp' starting page</title>
11 </head>
12 <body>
13     <%
14         String uid = request.getParameter("id");
15         Integer id = Integer.parseInt(uid);
16         String uname = request.getParameter("uname");
17         String upwd = request.getParameter("upwd");
18         String upwd2 = request.getParameter("upwd2");
19         UsersDao usersDao = new UsersDao();
20         if (upwd.equals(upwd2)) {
21             if (usersDao.id(id)) {
22                 out.print("已经有这个id了,即将跳回注册页.....");
23                 response.setHeader("refresh", "5;url=zhuce.jsp");
24             } else {
25                 usersDao.zhuce(id, uname, upwd);
26                 out.print("注册成功,即将跳回登录页.....");
27                 response.setHeader("refresh", "5;url=login.jsp");
28             }
29         } else {
30             out.print("两次密码不一致,即将跳回注册页.....");
31             response.setHeader("refresh", "5;url=zhuce.jsp");
32         }
33     %>
34 </body>
35 </html>
 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
 2 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 3 <html>
 4 <head>
 5 <title>My JSP 'login.jsp' starting page</title>
 6 </head>
 7 
 8 <body>
 9     <script type="text/javascript">
10         function dologin() {
11             if (loginform.uname.value == "") {
12                 alert("没有输入用户名");
13                 return;
14             }
15             if (loginform.upwd.value == "") {
16                 alert("没有输入密码");
17                 return;
18             }
19             loginform.submit();
20         }
21     </script>
22     <form action="dologin.jsp" name="loginform" method="post">
23         用户名:<input type="text"  name="uname" /> <br>
24         密码:<input type="password"  name="upwd" /> <br>
25         <input type="button" value="登录" onclick="dologin()" /> 
26         <a href="zhuce.jsp">没有账号?立即注册</a>
27     </form>
28 </body>
29 </html>
 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
 2 <%@page import="sun.security.jgss.LoginConfigImpl"%>
 3 <%@page import="com.gd.dao.UsersDao"%>
 4 <%
 5     request.setCharacterEncoding("utf-8");
 6     response.setCharacterEncoding("utf-8");
 7 %>
 8 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 9 <html>
10 <head>
11 <title>My JSP 'dologin.jsp' starting page</title>
12 </head>
13 
14 <body>
15     <%
16         String uname = request.getParameter("uname");
17         String upwd = request.getParameter("upwd");
18         UsersDao ud = new UsersDao();
19         if (ud.login(uname, upwd)) {
20             session.setAttribute("uname", uname);
21             request.getRequestDispatcher("index.jsp").forward(request,
22                     response);
23         } else {
24             out.print("登录失败,5s后跳转登录页面");
25             response.setHeader("refresh", "5;url=login.jsp");
26         }
27     %>
28 </body>
29 </html>
  1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
  2 <%@page import="java.util.List"%>
  3 <%@page import="com.gd.dao.MsgDao"%>
  4 <%@page import="com.gd.entity.Msg"%>
  5 <%@page import="sun.security.jgss.LoginConfigImpl"%>
  6 <%@page import="com.gd.dao.UsersDao"%>
  7 <%
  8     request.setCharacterEncoding("utf-8");
  9     response.setCharacterEncoding("utf-8");
 10 %>
 11 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 12 <html>
 13 <head>
 14 <title>My JSP 'index.jsp' starting page</title>
 15 </head>
 16 <body>
 17     <%
 18         String uname = (String) session.getAttribute("uname");
 19         if (uname == null) {
 20             out.print("您未登录,即将跳回登陆页.....");
 21             response.setHeader("refresh", "5;url=login.jsp");
 22         } else {
 23     %>
 24     欢迎你<%=uname%>
 25 
 26 
 27 
 28     <%
 29         Msg msg = new Msg();
 30             MsgDao msgDao = new MsgDao();
 31             List<Msg> list = new ArrayList<Msg>();
 32             list = msgDao.listAll(uname);
 33     %>
 34     邮件列表:
 35     <table width="600px" border="2px solid blue">
 36         <tr>
 37             <th>id</th>
 38             <th>发件人</th>
 39             <th>标题</th>
 40             <th>内容</th>
 41             <th>已读未读状态</th>
 42             <th>收件人</th>
 43             <th>发送时间</th>
 44         </tr>
 45         <%
 46             if (list.size() == 0) {
 47                     out.print("你没有邮件");
 48                 } else {
 49                     for (Msg msg1 : list) {
 50         %>
 51         <tr>
 52             <td>
 53                 <%
 54                     out.print(msg1.getMsgid());
 55                 %>
 56             </td>
 57             <td>
 58                 <%
 59                     out.print(msg1.getUsername());
 60                 %>
 61             </td>
 62             <td>
 63                 <%
 64                     out.print(msg1.getTitle());
 65                 %>
 66             </td>
 67             <td>
 68                 <%
 69                     out.print(msg1.getMsgcontent());
 70                 %>
 71             </td>
 72             <td>
 73                 <%
 74                     int state = msg1.getState();
 75                                 if (state == 1) {
 76                 %> <img src="image/yidu.png" /> <%
 77      ;
 78                  } else {
 79  %> <img src="image/weidu.png" /> <%
 80      ;
 81                  }
 82  %>
 83             </td>
 84             <td>
 85                 <%
 86                     out.print(msg1.getSendto());
 87                 %>
 88             </td>
 89             <td>
 90                 <%
 91                     out.print(msg1.getMsg_create_date());
 92                 %>
 93             </td>
 94         </tr>
 95         <%
 96             }
 97                 }
 98             }
 99         %>
100     </table>
101 </body>
102 </html>

 

 

 

 

 

 

 

 

 

posted @ 2022-05-14 17:11  MXT16  阅读(8)  评论(0编辑  收藏  举报