作业十

controller层

//    登录
    @RequestMapping(value = "/doLogin.html", method = RequestMethod.POST)
    public String doLogin(@RequestParam String userName, @RequestParam String userPwd, HttpSession session) {
        //        验证账号
        User user = oss.doLogin(userName, userPwd);
        if (user != null) {
            //           跳转到系统主界面
            session.setAttribute("users", user);
            return "redirect:/outStaff/regIndex";
        } else {
            session.setAttribute("errors", "用户名密码不正确，请重新登录");
            return "redirect:/outStaff/login.html";
        }
    }

//    跳转到登录
    @RequestMapping(value = "/login.html")
    public String login() {

        return "login";
    }

service层

 public User doLogin(String userName, String userPwd) {
        User user = null;
        user = outStaffMapper.doLogin(userName, userPwd);
        if (user != null) {//有用户名
            if (!user.getUserPwd().equals(userPwd)) {//密码不相等
                user = null;
            }
        }
        return user;
    }

Mapper层

 <!--   登录-->
    <select id="doLogin" resultType="User">
        select * from loginuser u
        <trim prefix="where" prefixOverrides="and|or">
            <if test="userName!=null">
                and u.userName=#{userName}
            </if>
            <if test="userPwd！=null">
                and u.userPwd=#{userPwd}
            </if>
        </trim>
    </select>