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>