项目-----登录模块链接数据

1 mapper接口

   User getUserByUsername(String username);

2.静态资源mapper.xml

  <select id="getUserByUsername" resultType="com.cc.springboot.entities.User">
        select * from user where upper (username)=upper (#{username})
    </select>

3.controller实现

package com.cc.springboot.controller;

import com.cc.springboot.entities.User;
import com.cc.springboot.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.thymeleaf.util.StringUtils;

import javax.servlet.http.HttpSession;
import java.util.Map;

@Controller
public class LoginController {

    @Autowired
    UserMapper userMapper;

    @PostMapping("/login")
    public String login(HttpSession session, String username, String password, Map<String,Object>map){

        if(!StringUtils.isEmpty(username) &&!StringUtils.isEmpty(password)){
            User user =userMapper.getUserByUsername(username);
            if(user!=null && user.getPassword().equals(password)){
                //登录成功
                session.setAttribute("loginUser",username);
                return "redirect:/main.html";
            }
        }
        //          登陆失败
        map.put("msg","用户名或密码错误");
        return "main/login";

    }
//    退出登录
    @GetMapping("/logout")
    public String logout(HttpSession session){
//       1.清空session中的用户信息
        session.removeAttribute("loginUser");
//       2.再将session进行注销
        session.invalidate();
//       3.返回登录页面   index.html之前的视图映射

        return "redirect:/index.html";
    }
}