实验五

最新推荐文章于 2024-05-08 18:50:24 发布

箴孞

最新推荐文章于 2024-05-08 18:50:24 发布

阅读量99

点赞数

本文链接：https://blog.csdn.net/M201819101016/article/details/109747980

版权

CharsetFilter

package com.media.filter;

import javax.servlet.*;
import javax.servlet.annotation.WebFilter;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

@WebFilter(filterName = "CharsetFilter")
public class CharsetFilter implements Filter {
    public void destroy() {
    }

    public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws ServletException, IOException {
        HttpServletRequest request = (HttpServletRequest) req;
        HttpServletResponse response = (HttpServletResponse)resp;

        request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=utf-8");

        chain.doFilter(req, resp);
    }

    public void init(FilterConfig config) throws ServletException {

    }

}

LoginFilter

package com.media.filter;

import javax.servlet.*;
import javax.servlet.annotation.WebFilter;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;

@WebFilter(filterName = "LoginFilter")
public class LoginFilter implements Filter {

    String[] ignores;

    public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws ServletException, IOException {

        HttpServletRequest request = (HttpServletRequest) req;
        HttpServletResponse response = (HttpServletResponse)resp;
        HttpSession session = request.getSession();

        String uri = request.getRequestURI();
        if(session.getAttribute("username") !=null || isIgnore(uri)){
            chain.doFilter(request,response);
        }else{
            response.sendRedirect("login.jsp");
        }
    }
    private boolean isIgnore(String uri){
        for (String str:ignores){
            if (uri.indexOf(str) != -1){
                return true;
            }
        }
        return false;
    }

    public void init(FilterConfig config) throws ServletException {
        String ignore = config.getInitParameter("ignore");
        ignores = ignore.split(",");

    }

}

UserCountListener

package com.media.listener;

import javax.servlet.ServletContext;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;
import javax.servlet.annotation.WebListener;
import javax.servlet.http.HttpSessionAttributeListener;
import javax.servlet.http.HttpSessionEvent;
import javax.servlet.http.HttpSessionListener;
import javax.servlet.http.HttpSessionBindingEvent;

@WebListener()
public class UserCountListener implements ServletContextListener,
        HttpSessionListener, HttpSessionAttributeListener {
    @Override
    public void sessionCreated(HttpSessionEvent se) {
        ServletContext application = se.getSession().getServletContext();
        int userCount = (int)application.getAttribute("userCount");
        userCount++;
        application.setAttribute("userCount",userCount);
        System.out.println("用户登录，系统当前在线人数:"+userCount);

    }

    @Override
    public void sessionDestroyed(HttpSessionEvent se){
        ServletContext application = se.getSession().getServletContext();
        int userCount = (int)application.getAttribute("userCount");
        if(userCount != 0){
            userCount--;
        }else{
            userCount = 0;
        }
        application.setAttribute("userCount",userCount);
        System.out.println("用户注销，系统当前在线人数:"+userCount);
    }
    @Override
    public void contextInitialized(ServletContextEvent sce){
        ServletContext application = sce.getServletContext();
        application.setAttribute("userCount",0);
    }
    @Override
    public void contextDestroyed(ServletContextEvent sce){

    }
    @Override
    public void attributeAdded(HttpSessionBindingEvent se){
        System.out.println("session添加属性");
    }
    @Override
    public void attributeRemoved(HttpSessionBindingEvent se){

    }
    @Override
    public void attributeReplaced(HttpSessionBindingEvent se){

    }

}

LoginServlet

package com.media.servlet;

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 javax.servlet.http.HttpSession;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

@WebServlet(name = "LoginServlet")
public class LoginServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request,response);
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");

        String username = request.getParameter("username");
        String password = request.getParameter("password");

        HttpSession session = request.getSession();
        if("1".equals(request.getParameter("invalidate"))&& session.getAttribute("username") !=null){
            session.invalidate();
            response.sendRedirect("login.jsp");
        }

        try {
            Class.forName("com.mysql.jdbc.Driver");

            String url = "jdbc:mysql://localhost:3306/book";
            Connection connection = DriverManager.getConnection(url,"root","root");

            //sql模板
            String sql = "select * from user where username = ? and password = ?";

            PreparedStatement ps = connection.prepareStatement(sql);

            ps.setString(1,username);
            ps.setString(2,password);

            ResultSet rs = ps.executeQuery();

            response.setContentType("text/html;charset=utf-8");

            PrintWriter out = response.getWriter();

            if (rs.next()){
                //表示登录成功
                session.setAttribute("username","username");
                response.sendRedirect("home.jsp");
            }else{
                //表示登录未成功
                out.print("登陆失败，3秒之后跳转登陆页面...");
                response.setHeader("refresh","3;url=login.jsp");
            }

        }catch (Exception e){
            e.printStackTrace();
        }

    }
}

UserServlet

package com.media.servlet;

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(name = "UserServlet")
public class UserServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }
}

DBUtil

package com.media.util;

import java.sql.*;

public class DBUtil {
    public static Connection getConnection(){
        Connection connection = null;
        try {
            //加载数据库驱动
            Class.forName("com.mysql.jdbc.Driver");

            //建立数据库连接
            String url = "jdbc:mysql://localhost:3306/book";
            connection = DriverManager.getConnection(url,"root","root");
        }catch (Exception e){
            e.printStackTrace();
        }
        return connection;
    }

    public static void close(Connection connection, PreparedStatement ps, ResultSet rs){
        //关闭数据库连接

        if(rs != null){
            try{
                rs.close();
            }catch (SQLException e){
                e.printStackTrace();
            }
        }

        if(ps != null){
            try {
                ps.close();
            }catch (SQLException e){
                e.printStackTrace();
            }
        }

        if(connection != null){
            try {
                connection.close();
            }catch (SQLException e){
                e.printStackTrace();
            }
        }
    }

    /**
     * MVC Model 模型层  访问数据库  View 视图层 显示页面内容的  Controller 控制器 负责页面请求跳转的
     *
     * dao Data Access Object 数据访问对象
     *
     *
     */
}

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
    <filter>
        <filter-name>charsetFilter</filter-name>
        <filter-class>com.media.filter.CharsetFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>charsetFilter</filter-name>
        <url-pattern>*</url-pattern>
    </filter-mapping>
    <filter>
        <filter-name>loginFilter</filter-name>
        <filter-class>com.media.filter.LoginFilter</filter-class>
        <init-param>
            <param-name>ignore</param-name>
            <param-value>/css,/js,/login.jsp,/login</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>loginFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
</web-app>

UserController

package com.media.controller;

import com.media.bean.UserBean;
import com.media.service.UserService;
import com.media.servlet.UserServlet;

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;
import java.sql.SQLException;
import java.util.List;

@WebServlet("/user")
public class UserController extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request,response);
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String method = request.getParameter("method");

        UserBean userBean = new UserBean();

        userBean.setUsername(request.getParameter("username"));
        userBean.setPassword(request.getParameter("password"));

        UserService userService = new UserService() {
            @Override
            public UserBean getUserById(int id) {
                return null;
            }

            @Override
            public UserBean getUserByName(String username) {
                return null;
            }

            @Override
            public List<UserBean> getUserList() {
                return null;
            }

            @Override
            public int addUser(UserBean user) throws SQLException {
                return 0;
            }

            @Override
            public int editUser(UserBean user) {
                return 0;
            }

            @Override
            public int deleteUserById(int id) {
                return 0;
            }
        };
        if("addUser".equals(method)){
            try {
                int count = userService.addUser(userBean);
                if(count == 0){
                    response.sendRedirect("");
                }else{
                    response.sendRedirect("home.jsp");
                }
            }catch (SQLException e){
                e.printStackTrace();
            }
        }

        if("editUser".equals(method)){
            userBean.setId(Integer.parseInt(request.getParameter("id")));
            userService.editUser(userBean);
        }

        if("deleteUser".equals(method)){
            userService.deleteUserById(Integer.parseInt(request.getParameter("id")));
        }
    }
}

LoginController

package com.media.controller;

import com.media.util.DBUtil;

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 javax.servlet.http.HttpSession;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

@WebServlet(name = "LoginServlet",value = "/login")
public class LoginController extends HttpServlet {

    /**
     * post请求 会执行doPost方法
     * @param request
     * @param response
     * @throws ServletException
     * @throws IOException
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request,response);
    }

    /**
     * get请求 会执行doGet方法
     * @param request
     * @param response
     * @throws ServletException
     * @throws IOException
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {


        System.out.println("servlet 请求");

        request.setCharacterEncoding("utf-8");

        String username = request.getParameter("username");
        String password = request.getParameter("password");

        HttpSession session = request.getSession();

        if("1".equals(request.getParameter("invalidate")) && session.getAttribute("username") != null){
            session.invalidate();
            //session.removeAttribute("username");
            response.sendRedirect("login.jsp");
        }

        try {

            Connection connection = DBUtil.getConnection();

            //sql 模板
            String sql = "select * from user where username = ? and password = ?";
            //使用PreparedStatement对象执行sql语句
            PreparedStatement ps = connection.prepareStatement(sql);

            ps.setString(1,username);
            ps.setString(2,password);

            ResultSet rs = ps.executeQuery();

            //response.setContentType("text/html;charset=UTF-8");

            PrintWriter out = response.getWriter();

            if(rs.next()){
                //表示登录成功
                session.setAttribute("username",username);
                response.sendRedirect("home.jsp");
            }else{
                //表示登录未成功
                out.print("登录失败,3秒之后跳转登录页面...");
                response.setHeader("refresh","3;url=login.jsp");
            }

            //服务端跳转
            //request.getRequestDispatcher("home.jsp").forward(request,response);

            DBUtil.close(connection,ps,rs);

        }catch (Exception e){
            e.printStackTrace();
        }
    }
}

UserDao

package com.media.dao;

import com.media.bean.UserBean;

import java.sql.SQLException;
import java.util.List;

public interface UserDao {
    UserBean getUserById(int id);
    UserBean getUserByName(String username);
    List<UserBean> getUserList(UserBean user);

    int addUser(UserBean user) throws SQLException;
    int editUser(UserBean user);
    int deleteUserById(int id);
}

UserDaoimpl

package com.media.dao.impl;

import com.media.bean.UserBean;
import com.media.dao.UserDao;
import com.media.util.DBUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class UserDaoimpl implements UserDao {
    @Override
    public UserBean getUserById(int id) {
        UserBean userBean = new UserBean();
        try{
            Connection connection = DBUtil.getConnection();
            String sql = "select * from user where id = ?";
            PreparedStatement ps = connection.prepareStatement(sql);
            ps.setInt(1,id);
            ResultSet rs = ps.executeQuery();

            if(rs.next()){
                userBean.setId(rs.getInt("id"));
                userBean.setUsername(rs.getString("username"));
                userBean.setPassword(rs.getString("password"));
                userBean.setGender(rs.getInt("gender"));
                userBean.setAge(rs.getInt("age"));
                userBean.setStatus(rs.getInt("status"));
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return userBean;
    }
    @Override
    public UserBean getUserByName(String username) {
        UserBean userBean = new UserBean();
        try{
            Connection connection = DBUtil.getConnection();
            String sql = "select * from user where username = ?";
            PreparedStatement ps = connection.prepareStatement(sql);
            ps.setString(1,username);
            ResultSet rs = ps.executeQuery();

            if(rs.next()){
                userBean.setUsername(rs.getString("username"));
                userBean.setPassword(rs.getString("password"));
                userBean.setGender(rs.getInt("gender"));
                userBean.setAge(rs.getInt("age"));
                userBean.setStatus(rs.getInt("status"));
                userBean.setId(rs.getInt("id"));
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return userBean;
    }
    @Override
    public List<UserBean> getUserList(UserBean user) {
        List<UserBean> userList = new ArrayList<>();
        UserBean userBean = null;
        try{
            Connection connection = DBUtil.getConnection();
            String sql = "select * from user where username like ?";
            PreparedStatement ps = connection.prepareStatement(sql);

            ps.setString(1,user.getUsername());
            ResultSet rs = ps.executeQuery();
            while (rs.next()){
                userBean = new UserBean();
                userBean.setUsername(rs.getString("username"));
                userBean.setPassword(rs.getString("password"));
                userBean.setGender(rs.getInt("gender"));
                userBean.setAge(rs.getInt("age"));
                userBean.setId(rs.getInt("id"));
                userBean.setStatus(rs.getInt("status"));
                userList.add(userBean);
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return userList;
    }
    @Override
    public int addUser(UserBean user) throws SQLException {
        Connection connection = DBUtil.getConnection();
        String sql = "inert into user (username,password,age,gender,status) values (?,?,?,?,?)";
        PreparedStatement ps = connection.prepareStatement(sql);
        ps.setString(1,user.getUsername());
        ps.setString(2,user.getPassword());
        ps.setInt(3,user.getAge());
        ps.setInt(4,user.getGender());
        ps.setInt(5,user.getStatus());
        int count = ps.executeUpdate();
        DBUtil.close(connection,ps,null);
        return count;
    }
    @Override
    public int editUser(UserBean user) {
        return 0;
    }
    @Override
    public int deleteUserById(int id) {
        return 0;
    }
}

UserService

package com.media.service;

import com.media.bean.UserBean;

import java.sql.SQLException;
import java.util.List;

public interface UserService {

    UserBean getUserById(int id);
    UserBean getUserByName(String username);
    List<UserBean> getUserList();

    int addUser(UserBean user) throws SQLException;
    int editUser(UserBean user);
    int deleteUserById(int id);
}

UserServiceimpl

package com.media.service.impl;

import com.media.bean.UserBean;
import com.media.dao.UserDao;
import com.media.dao.impl.UserDaoimpl;
import com.media.service.UserService;
import java.sql.SQLException;
import java.util.List;

public class UserServiceimpl implements UserService {
    @Override
    public UserBean getUserById(int id) {
        return null;
    }
    @Override
    public UserBean getUserByName(String username) {
        return null;
    }
    @Override
    public List<UserBean> getUserList() {
        return null;
    }
    @Override
    public int addUser(UserBean user) throws SQLException {
        //业务层 负责业务数据处理
        UserDao userDao = new UserDaoimpl();
        return userDao.addUser(user);
    }
    @Override
    public int editUser(UserBean user) {
        return 0;
    }
    @Override
    public int deleteUserById(int id) {
        return 0;
    }
}