SSM框架实现登录验证

实体类

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Login {
    private Integer id;
    private String name;
    private String password;
}

Mapper层

  LoginMapper

public interface LoginMapper {
    /*用户登录*/
    Login finOne(Login login);
    /*用户注册*/
    int addOne(Login login);
    /*注册时的重名检测*/
    Login checkReg(String name);
    /*删除注册的用户*/
    int delete(Integer id);
}

LoginMapper.xml

<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.niu.dao.LoginMapper">
    <select id="finOne" parameterType="com.niu.pojo.Login" resultType="com.niu.pojo.Login">
        select * from login where name=#{name} and password=#{password}
    </select>
    <insert id="addOne" parameterType="com.niu.pojo.Login">
        insert into login(name,password) values(#{name},#{password})
    </insert>
    <select id="checkReg" resultType="com.niu.pojo.Login">
        select * from login where name=#{name}
    </select>
    <delete id="delete" parameterType="Integer">
        delete from login where id=#{id}
    </delete>
</mapper>

Service层

LoginService

public interface LoginService {
    /*用户登录*/
    Login finOne(Login login);
    /*用户注册*/
    int addOne(Login login);
    /*注册时的重名检测*/
    Login checkReg(String name);
    /*删除注册的用户*/
    int delete(Integer id);

}

LoginServiceImpl

@Service
public class LoginServiceImpl implements LoginService{
    @Resource
    private LoginMapper loginMapper;
    @Override
    public Login finOne(Login login) {
        return loginMapper.finOne(login);
    }

    @Override
    public int addOne(Login login) {
        return loginMapper.addOne(login);
    }

    @Override
    public Login checkReg(String name) {
        return loginMapper.checkReg(name);
    }

    @Override
    public int delete(Integer id) {
        return loginMapper.delete(id);
    }
}

Controller层

LoginController

@Controller
public class LoginController {
    @Resource
    private LoginService loginService;

    @SneakyThrows
    @RequestMapping("/golog")
    public String log(Login login, @NotNull Model model) {
        Login login1 = loginService.finOne(login);
        model.addAttribute("login", login1);
        if (login1 != null) {
            return "logok";
        } else {
             return "log";

        }
    }

样式可让自己需求来 上述就是用SSM框架实现从mysql拿数据判断是否存在进行登录