数据库表:示例
编写实体类,会话层,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;
}
}