SSM框架的增删改查之用户登录

mapper层

    /**
     * 根据用户名和密码查询
     */
    @Select("select * " +
            "from user " +
            "where username=#{username} and password=#{password}")
    public User loing(User user) throws Exception;

Service层

 public User login(User user) throws Exception {
        return UserMapper.loing(user);
    }

controller

    @Autowired
    private LoginService loginService;

        /*登陆页面*/
        @RequestMapping("/goLogin")
        public String goLogin() throws Exception {
            return "login";
        }

        /*登陆接口*/
        @RequestMapping("/login")
        @ResponseBody
        public String login(User user, HttpSession session) throws Exception {
            User loginUser = loginService.login(user);
            //判断登陆是否成功
            if (loginUser != null) {
                session.setAttribute("loginUser", loginUser);
                return "true";
            }
            return "false";
    }

前端页面：

<script th:src="@{/layui/layui.js}"></script>
<script>
    layui.use(['jquery', 'form'], function () {
        var $ = layui.jquery;
        var form = layui.form;
        form.on('submit(LAY-user-login-submit)', function (data) {
            console.log(data.field)
            $.ajax({
                type: "post",
                url: '/login/login',
                data: data.field,
                success: function (data) {
                    if (data == "true") {
                            window.location.href="/index/goIndex";
                    } else {
                        layer.msg("登陆失败,用户名或账号错误！", {
                            icon: 2
                        });
                    }
                },
                error: function (error) {
                    layer.msg("操作失效", {
                        icon: 7
                    })
                }
            });
            return false;
        });
    })

</script>