JSP第九次作业
2024-10-20 09:32:53
1.建库，建表2个
用户表（id,用户名，密码）
邮件表（id,发件人，收件人，标题，内容，发送时间，状态）
2.建model层
entity,dao包
3.登陆，注册，登陆后显示全部邮件
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="data:image/yidu.png" /> <%
77 ;
78 } else {
79 %> <img src="data: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>
搜索
复制
最新文章
- ssh远程执行命令
- iOS开发中一些常见的并行处理
- React中的PropTypes详解
- linux 的终端字体色和背景色的修改方法（一）
- win7：Remote Desktop Services 启动失败
- centos下安装nagios
- windows下将多个文件里面的内容合并成一个一个文件
- SecureCRT+WinSCP 共用 key pub 密钥 转换 ppk 登录ssh
- asp.net 使用 MongoDB 初体验
- Maven详解 之 聚合与继承
- 手动删除文件夹exe病毒并恢复原来文件夹
- Python成长之路第二篇（3）_字典的置函数用法
- Chapter 13 建造者模式
- HBase写的初步测试中的表现
- AngularJS学习篇（十二）
- 针对单个 js 文件禁用 ESLint 语法校验
- 竞价拍卖理论的介绍（RTB模型中使用第二竞价模型，为的是纳什平衡，保护所有多方利益）
- python学习第30天
- Entity Framework Core系列之DbContext（删除）
- C#+EntityFramework编程方式详细之Model First