11周作业

1.users
package com.hm.entity;

/**
 * Users用户实体类
 */
public class Users {
    int id;
    String uname;
    String upwd;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUname() {
        return uname;
    }
    public void setUname(String uname) {
        this.uname = uname;
    }
    public String getUpwd() {
        return upwd;
    }
    public void setUpwd(String upwd) {
        this.upwd = upwd;
    }

}

2.msg
import java.util.Date;

/**
 * msg实体类
 */
public class Msg {
    private int msgid;
    private String username;
    private String title;
    private String msgcontent;
    private int state;
    private String sendto;
    Date msg_create_date;
    public int getMsgid() {
        return msgid;
    }
    public void setMsgid(int msgid) {
        this.msgid = msgid;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getTitle() {
        return title;
    }
    public void setTitle(String title) {
        this.title = title;
    }
    public String getMsgcontent() {
        return msgcontent;
    }
    public void setMsgcontent(String msgcontent) {
        this.msgcontent = msgcontent;
    }
    public int getState() {
        return state;
    }
    public void setState(int state) {
        this.state = state;
    }
    public String getSendto() {
        return sendto;
    }
    public void setSendto(String sendto) {
        this.sendto = sendto;
    }
    public Date getMsg_create_date() {
        return msg_create_date;
    }
    public void setMsg_create_date(Date msg_create_date) {
        this.msg_create_date = msg_create_date;
    }


}

3.userDao
package com.hm.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


public class UsersDao extends BaseDao{
    //关于用户的增删改查
    //登陆
    public boolean login(String name,String pwd){
        boolean f=false;
        Connection conn=getConnection();
        String sql="select * from email_02.users where uname=? and upwd=?";
        PreparedStatement ps;
        try {
            ps = conn.prepareStatement(sql);
            ps.setString(1, name);
            ps.setString(2, pwd);
            ResultSet rs=ps.executeQuery();
            if(rs.next())
                f=true;
            closeAll(conn, ps, rs);


        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return f;
    }

    private void closeAll(Connection conn, PreparedStatement ps, ResultSet rs) {
    }

4.msgDao
package com.hm.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.hm.entity.Msg;

public class MsgDao extends BaseDao{
    //插入邮件

    //删除邮件

    //修改邮件状态

    //按照接收者查询全部邮件
    public List<Msg> getMailByReceiver(String name){
        List<Msg> list=new ArrayList<Msg>();
        Connection conn=getConnection();
        String sql="select * from email_02.msg where sendto=?";
        PreparedStatement ps;
        ResultSet rs;
        try {
            ps = conn.prepareStatement(sql);
            ps.setString(1, name);
            rs=ps.executeQuery();
            while(rs.next()){
                Msg m=new Msg();
                m.setMsgid(rs.getInt(1));
                m.setUsername(rs.getString(2));
                m.setTitle(rs.getString(3));
                m.setMsgcontent(rs.getString(4));
                m.setState(rs.getInt(5));
                m.setSendto(rs.getString(6));
                m.setMsg_create_date(rs.getDate(7));
                list.add(m);
            }

            closeAll(conn, ps, rs);

        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return list;
    }

    private void closeAll(Connection conn, PreparedStatement ps, ResultSet rs) {
    }

}

5.baseDao
package com.hm.dao;

import java.sql.Connection;
import java.sql.DriverManager;

public class BaseDao {
    //获取连接
    protected Connection getConnection(){
        Connection conn=null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            // 2.建立连接
            conn = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/email_02", "root", "20000306");
        } catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
    }

}

loginServlet
package com.hm.controller;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

@WebServlet("/loginServlet")
public class LoginServlet extends HttpServlet {
    @Override
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //设置客户端的编码格式
        request.setCharacterEncoding("UTF-8");
        // 接收客户端传递的参数
        String uname=request.getParameter("uname");
        String upwd=request.getParameter("upwd");
        if(uname==null||"".equals(uname.trim())) {
//     提示用户信息
            request.setAttribute("msg", "用户姓名不可以是空");
//            请求转发到login.jsp
            request.getRequestDispatcher("login.jsp").forward(request, response);
            return;
        }
            if(upwd==null||"".equals(upwd.trim())){
//     提示用户信息
                request.setAttribute("msg","用户密码不可以是空");
//            请求转发到login.jsp
                request.getRequestDispatcher("login.jsp").forward(request,response);
                return;
        }
//            判断账号密码是否正确
if(!"admin".equals(uname)||!"admin".equals(upwd)){
    request.setAttribute("msg","登录失败");
//    请求转发跳到Login.jsp
    request.getRequestDispatcher("login.jsp").forward(request,response);
}
//登录成功
// 设置登录信息到session中
        request.getSession().setAttribute("uname",uname);

// 跳转到index.jsp
        response.sendRedirect("mail.jsp");
    }
}

jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<body>
<h2>欢迎<%=session.getAttribute("uname")%>登录！</h2>
</body>
</html>


<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>登录</title>
    <link href="mail.jsp" rel="script">
</head>
<body>
<div style="text-align: center">
<form action="loginServlet" method="post" id="loginForm">
  姓名: <input type="text" name="uname"><br>
  密码: <input type="password" name="upwd"><br>
  <button type="button">登录</button>
    <button type="button">注册</button>
<%--    <span style="color: brown;font-size: 12px"><%=request.getAttribute("msg")%></span>--%>
    <span style="color: brown;font-size: 12px">${msg}</span>
</form>
</div>
</body>
</html>


<%@page import="com.hm.entity.Msg"%>
<%@page import="com.hm.dao.MsgDao"%>
<%@ page import="java.util.List" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
  <title></title>
</head>
<body>
<%
  String uname=(String)session.getAttribute("uname");
%>

<table height="20px" width="100%" align="center" border="1">
  <tr>
    <td>发件人</td>
    <td>主题</td>
    <td>状态</td>
    <td>时间</td>
  </tr>
  <%
    MsgDao md=new MsgDao();
    List<Msg> list=md.getMailByReceiver(uname);
    for(Msg m:list)
    {%>
  <tr>
    <td><%=m.getUsername() %></td>
    <td><%=m.getTitle() %></td>
    <td><%
      int state=m.getState();
      if(state==1){ %>
      <img src ="image/1.jpg" />
      <%;
      }else{%>
      <img src ="image/2.jpg" />
      <%;
      }
      %></td>
    <td><%=m.getMsg_create_date() %></td>
  </tr>
  <%}
  %>
</table>
</body>
</html>