ssm实现登录功能及拦截器配置

矫情吗；* 2023-02-12 11:21 1阅读 0赞

关于Spring SpringMVC MyBatis的一个综合案例

#### 要用到的jar包 ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTg4NzI3NQ_size_16_color_FFFFFF_t_70]

#### web.xml配置 ####

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
    	
    	
    	
    	
    	
    	<filter>
    		<filter-name>CharacterEncodingFilter</filter-name>
    		<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    		<init-param>
    			<param-name>encoding</param-name>
    			<param-value>UTF-8</param-value>
    		</init-param>
    	</filter>	
    	
    	<filter-mapping>
    		<filter-name>CharacterEncodingFilter</filter-name>
    		<url-pattern>\/*</url-pattern>
    	</filter-mapping>
    
    	
    	
    	
    	<servlet>
    		<servlet-name>springDispatcherServlet</servlet-name>
    		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    		<init-param>
    			<param-name>contextConfigLocation</param-name>
    			<param-value>classpath:spring*.xml</param-value>
    		</init-param>
    		<load-on-startup>1</load-on-startup>
    	</servlet>
    
    	
    	<servlet-mapping>
    		<servlet-name>springDispatcherServlet</servlet-name>
    		<url-pattern>*.do</url-pattern>
    	</servlet-mapping>
    	
    </web-app>

##### db.properties文件 #####

jdbc.driverClassName=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8
    jdbc.username=root
    jdbc.password=root
    jdbc.maxActive=20

##### log4j.properties文件 #####

# Global logging configuration
    log4j.rootLogger=ERROR, stdout
    # MyBatis logging configuration...
    # 配置日志
    # 规则 log4j.logger.映射接口的包=日志级别
    # 总共五个级别（error:错误,info：普通信息,debug：调试信息,warn：警告,trae/all：所有情况）
    # 当前开发阶段配置debug/ (all/trace),项目上线以后配置error
    log4j.logger.com.ywq.ssm.mapper=TRACE
    # Console output...
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

#### springdao.xml配置 ####

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xmlns:aop="http://www.springframework.org/schema/aop"
    	xmlns:context="http://www.springframework.org/schema/context"
    	xmlns:tx="http://www.springframework.org/schema/tx"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
    		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
    		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
    		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
    
    	
    	<context:component-scan base-package="com.ywq.ssm"/>
    	
    	
    	<context:property-placeholder location="classpath:db.properties"/>
    	
    	
    	
    	
    	<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
    		init-method="init" destroy-method="close">
    		<property name="driverClassName" value="${jdbc.driverClassName}"/>
    		<property name="url" value="${jdbc.url}"/>
    		<property name="username" value="${jdbc.username}"/>
    		<property name="password" value="${jdbc.password}"/>
    		<property name="maxActive" value="${jdbc.maxActive}"/>
    	</bean>
    
    	
    	
    	<bean id="sqlSessionFacoyry" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="dataSource" ref="dataSource"></property>
    	</bean>
    	
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		
    		<property name="basePackage" value="com.ywq.ssm.mapper"/>	
    	</bean>
    	
    	
    	
    	
    	<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		<property name="dataSource" ref="dataSource"/>
    	</bean>
    	
    	
    	<tx:advice id="txAdvice" transaction-manager="txManager">
    		<tx:attributes>
    			
    			<tx:method name="select*" read-only="true"/>
    			
    			<tx:method name="*"/>
    		</tx:attributes>
    	</tx:advice>
    	
    		<aop:config>
    			<aop:advisor advice-ref="txAdvice" pointcut="execution(* com.ywq.ssm.service..*.*(..))"/>
    		</aop:config>
    	
    </beans>

#### springmvc.xml配置 ####

#### 登录页面 ####

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    
    
    <h3>登录页面</h3>
    <span style="color: red;" >${
        msg}</span>
    <form action="${pageContext.request.contextPath}/user/login.do" method="post">
    	账号：<input type="text" name="name"><br>
    	密码：<input type="password" name="password"><br>
    	<button type="submit">登录</button>
    </form>

#### 数据列表页面 ####

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
        
       <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    
    <table border="1" style="width: 500px;border-collapse: collapse;">
      <tr>
        <th>id</th>
        <th>name</th>
        <th>password</th>
        <th>age</th>
        <th>操作</th>
      </tr>
      <c:forEach items="${users}" var="user">
      	<tr>
      		<td>${
        user.id}</td>
      		<td>${
        user.name}</td>
      		<td>${
        user.password}</td>
      		<td>${
        user.age}</td>
      		<td>
      			
      			<a href="javascript:void(0);" onclick="deleteUser(${user.id})">删除</a>  <a href=""> 修改</a>
      		</td>
      	</tr>
      </c:forEach>
    </table>
    
    <script type="text/javascript">
    	function deleteUser(userId){
        
    		if(confirm("您确定要删除此条数据吗？")){
        
    			location.href="${pageContext.request.contextPath}/user/delete.do?userId="+userId
    			
    		}
    		
    	}
    </script>

#### pojoUser代码 ####

package com.ywq.ssm.pojo;
    
    public class User {
        
    	private Integer id ;
    	private String name;
    	private String password;
    	private Integer age;
    	public Integer getId() {
        
    		return id;
    	}
    	public void setId(Integer id) {
        
    		this.id = id;
    	}
    	public String getName() {
        
    		return name;
    	}
    	public void setName(String name) {
        
    		this.name = name;
    	}
    	public String getPassword() {
        
    		return password;
    	}
    	public void setPassword(String password) {
        
    		this.password = password;
    	}
    	public Integer getAge() {
        
    		return age;
    	}
    	public void setAge(Integer age) {
        
    		this.age = age;
    	}
    	public User(Integer id, String name, String password, Integer age) {
        
    		super();
    		this.id = id;
    		this.name = name;
    		this.password = password;
    		this.age = age;
    	}
    	public User() {
        
    		super();
    	}
    	@Override
    	public String toString() {
        
    		return "User [id=" + id + ", name=" + name + ", password=" + password + ", age=" + age + "]";
    	}
    	
    	
    }

##### UserMapper代码 #####

package com.ywq.ssm.mapper;
    
    import java.util.List;
    
    import org.apache.ibatis.annotations.Delete;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    import org.springframework.stereotype.Repository;
    
    import com.ywq.ssm.pojo.User;
    
    public interface UserMapper {
        
    	
    	@Insert("insert into user (name,password,age) values(#{name},#{password},#{age})")
    	int insert(User user);
    	
    	@Select("select * from user where id = #{id}")
    	User selectByPrimaryKey(Integer id);
    	
    	@Select("select * from user")
    	List<User> selectList();
    	
    	@Delete("delete from user where id = #{id}")
    	int deleteByPrimaryKey(Integer id);
    
    	@Select("select * from user where name = #{name} and password = #{password} ")
    	User selectNameAndPassword(@Param("name") String name, @Param("password")  String password);
    	
    }

#### UserService接口 ####

package com.ywq.ssm.service;
    
    import java.util.List;
    
    import org.apache.ibatis.annotations.Delete;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Select;
    
    import com.ywq.ssm.pojo.User;
    
    public interface UserService {
        
    	int insert(User user);
    	
    	User selectByPrimaryKey(Integer id);
    	
    	List<User> selectList();
    	
    	int deleteByPrimaryKey(Integer id);
    
    	User selectNameAndPassword(String name, String password);
    	
    }

#### UserService实现类 ####

package com.ywq.ssm.service.impl;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import com.ywq.ssm.mapper.UserMapper;
    import com.ywq.ssm.pojo.User;
    import com.ywq.ssm.service.UserService;
    
    @Service
    public class UserServiceImpl  implements UserService{
        
    	
    	
    	/*
    	 * 问题：UserMapper映射接口的代理对象如何创建？
    	 * 
    	 * 
    	 * 一，使用Spring之前
    	 * 1.读取mybatis-config.mxl主配置文件，创建SqlSessionFactory工厂对象
    	 * 
    	 * 2.使用工厂对象创建SqlSession 会话对象
    	 * 
    	 * 3.使用SqlSession的getMapper方法创建映射接口代理对象
    	 * 	UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    	 * 
    	 * 4.提交事务
    	 * 
    	 * 5.关闭SqlSession
    	 * 所有步骤全部开发者自己编写代码完成
    	 * 
    	 * 二，和Spring集成，全部操作交给Spring管理
    	 * 
    	 * MyBatis框架已经和Spring集成好了，在MyBatis和Spring集成的桥梁包中
    	 * 	mybatis-spring-1.3.1.jar,开发者只需要将创建代码配置到Spring即可
    	 * 
    	 * 
    	 * 1.Spring帮忙创建SqlSessionFactory对象
    	 * MyBatis框架已经和Spring集成好了，而且编写好了创建SqlSessionFacoty对象的代码
    	 * 桥梁包：org.mybatis.spring.SqlSessionFactoryBean
    	 * 
    	 * 
    	 * 2.和Spring集成不用创建SqlSession对象，每次创建映射接口代理对象会自动底层先创建
    	 * 		SqlSession，再创建映射接口的代理对象
    	 * 
    	 * 3，创建映射接口的代理对象
    	 * 	3.1创建单个映射接口代理对象
    	 * 	桥梁包：org.mybatis.spring.mapper.MapperFactoryBean<T>
    	 * 
    	 *	3.2使用包扫面创建包下面所有的映射接口代理对象（推荐）
    	 * 	桥梁包：org.mybatis.spring.mapper.MapperScannerConfigurer
    	 * */
    	
    	@Autowired
    	private UserMapper UserMapper;
    	
    	@Override
    	public int insert(User user) {
        
    		
    		return UserMapper.insert(user);
    	}
    
    	@Override
    	public User selectByPrimaryKey(Integer id) {
        
    		
    		return UserMapper.selectByPrimaryKey(id);
    	}
    
    	public List<User> selectList() {
        
    		// TODO Auto-generated method stub
    		return UserMapper.selectList();
    	}
    
    	public int deleteByPrimaryKey(Integer id) {
        
    		// TODO Auto-generated method stub
    		return UserMapper.deleteByPrimaryKey(id);
    	}
    
    	@Override
    	public User selectNameAndPassword(String name, String password) {
        
    		return UserMapper.selectNameAndPassword( name, password);
    	}
    
    }

#### UserController代码 ####

package com.ywq.ssm.controller;
    
    import java.util.List;
    
    import javax.servlet.http.HttpSession;
    import javax.websocket.Session;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import com.ywq.ssm.pojo.User;
    import com.ywq.ssm.service.UserService;
    
    @Controller
    @RequestMapping("/user")
    public class UserController {
        
    
    	@Autowired
    	private UserService userService;
    	
    	@RequestMapping("/list")
    	public String list(Model m) {
        
    		
    		List<User> users = userService.selectList();
    		m.addAttribute("users", users);
    		
    		return "userList";
    		
    	}
    	
    	@RequestMapping("/delete")
    	public String delet(Integer userId) {
        
    		userService.deleteByPrimaryKey(userId);
    		
    		//重定向跳转到列表页面
    		return "redirect:/user/list.do";
    		
    	}
    	
    	@RequestMapping("/login")
    	public String login(String name,String password,Model m,HttpSession session) {
        
    		
    		User user = userService.selectNameAndPassword(name,password);
    		
    		if (user ==null) {
        
    			m.addAttribute("msg", "亲，账号或密码错误! 请重新登录！");
    			// 返回登录页
    		return "forward:/login.jsp";
    		}else {
        
    			session.setAttribute("USER_IN_SESSION", user);
    		}
    		
    		//重定向到用户列表
    		return "redirect:/user/list.do";
    	}
    	
    	
    }

#### CheckLoginlnterceptor代码 ####

package com.ywq.ssm.interceptor;
    
    import java.util.Date;
    
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import org.springframework.web.servlet.HandlerInterceptor;
    import org.springframework.web.servlet.ModelAndView;
    
    import com.ywq.ssm.pojo.User;
    
    public class CheckLoginlnterceptor implements HandlerInterceptor {
        
    
    	
    	/*
    	 * 此方法再控制器的方法执行之前进行拦截，可以做登录检查，权限判断等
    	 * 
    	 * return boolean 返回boolean类型
    	 * 1. true 说明满足条件，放行
    	 * 2.false 说明不满足条件，不放行。同时开始自己编写调转到登录页面，没有权限访问提示页面等
    	 * 
    	 * */
    	public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler)
    			throws Exception {
        
    		//从session获取登录储存User对象
    		User user = (User) request.getSession().getAttribute("USER_IN_SESSION");
    		System.out.println("user:"+user);
    		if (user == null) {
        
    			//跳转页面
    			response.sendRedirect(request.getContextPath()+"/login.jsp");
    			return false;
    		}
    		
    		return true;
    	}
    	
    	
    	/*
    	 * 此方法是后续处理方法，再控制器方法执行完毕以后执行，可以记录操作日志等
    	 * */
    	public void postHandle(HttpServletRequest request, HttpServletResponse response, Object handler,
    			ModelAndView modelAndView) throws Exception {
        
    		
    		User user = (User) request.getSession().getAttribute("USER_IN_SESSION");
    		
    		Date date = new Date();
    		String currentTime = date.toLocaleString();
    		System.out.println(user.getName()+"在"+currentTime+",做了"+handler+"操作");
    	}
    
    	/*
    	 *此方法再视图渲染完毕以后执行，可以释放资源等操作 
    	 * */
    	public void afterCompletion(HttpServletRequest request, HttpServletResponse response, Object handler, Exception ex)
    			throws Exception {
        
    	}
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTg4NzI3NQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200525220521596.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTg4NzI3NQ==,size_16,color_FFFFFF,t_70