基于账户密码的登录状态验证

数据库表：示例

编写实体类，会话层，mapper以及控制层。
此处省略实体类以及会话层；

service实现类：

@Service
public class WebLoginServiceImpl implements WebLoginService {

    @Autowired
    WebLoginMapper loginMapper;
    /**
     * 账户密码登录
     * @param after
     * @return
     */
    @Override
    public Map findLoginPassword(WebLogin after) {
        //判断用户是否存在
        WebLogin login = loginMapper.selectPassword(after.getEmail(), after.getPassword());
        if (login == null) {
            return Result.getErrResult("账号密码错误");
        }
        if(login.getAudit().equals("0")){
            return Result.getErrResult("该账户已失效，请填写新的账户");
        }
        return Result.getResult("登陆成功。");
    }
}

mapper:

/**
  * 根据密码验证邮箱
  * @param email
  * @param password
  * @return
  */
 @Select("SELECT * FROM web_login WHERE email=#{email} AND password=#{password}")
 WebLogin selectPassword(@Param("email") String email, @Param("password") String password);`

controller:

@RestController
@Api(tags = {"管理后台登录接口"})
@RequestMapping("/after")
public class WebLoginController {

    @Autowired
    WebLoginService loginService;

    /**
     * 账户密码验证登录
     * @param login
     * @return
     */
    @PostMapping("/login")
    @ApiImplicitParams({
            @ApiImplicitParam(name="email",value = "账户邮箱",required = true),
            @ApiImplicitParam(name = "password",value = "账户密码",required = true),
            @ApiImplicitParam(name="audit",value = "账户状态")
    })
    @ApiOperationSupport(
            /*接口作者*/
            author = "zgong@mvtech.cc",
            /*不需传入的参数*/
            ignoreParameters = "audit"
    )
    public Map findLogin(WebLogin login){
        if(login==null || login.getEmail()==null || login.getEmail().length()<1 || login.getEmail().length()>26){
            return Result.getErrResult("请正确填写邮箱地址。");
        }
        if(!IsNumber.validateEmail(login.getEmail())){
            return Result.getErrResult("请正确填写邮箱地址。");
        }
        if (login.getPassword()==null||login.getPassword().length()<1||login.getPassword().length()>16){
            return Result.getErrResult("请正确填写密码");
        }
        Map map = loginService.findLoginPassword(login);
        return map;
    }
}