lombok
创建实体类Users:
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Users {
private Integer id;
private String username;
private String password;
}
新建mapper包,创建UsersMapper接口:
想要使用接口,需要在启动器或配置类上添加注解:@MapperScan("com.ly.mapper")
@Repository
public interface UsersMapper extends BaseMapper {
}
配置文件添加数据库配置 :
spring:
#配置数据源
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/security?useSSL=false&serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8
username: root
password: 123456
在实现类中添加数据库相关操作:
@Service(“userDetailsService”)
public class MyUserDetailsService implements UserDetailsService {
@Autowired
private UsersMapper usersMapper;
@Override
public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {
//调用usersMapper方法,根据用户名查询数据库
QueryWrapper wrapper = new QueryWrapper<>();
wrapper.eq(“username”,username);
Users users = usersMapper.selectOne(wrapper);
//判断
if(users==null){//数据库没有数据,认证失败
throw new UsernameNotFoundException(“用户名不存在!”);
}
//手动设置了role,也可以通过数据库查询获取
List auths = AuthorityUtils.commaSeparatedStringToAuthorityList(“role”); //配置角色
return new User(users.getUsername(),
new BCryptPasswordEncoder().encode(users.getPassword()),auths);
}
}
测试访问:
自定义登陆页面:
用户名:
用户名:
在配置类实现相关配置:
@Override
protected void configure(HttpSecurity http) throws Exception {
//配置没有权限访问跳转自定义页面
http.exceptionHandling().accessDeniedPage(“/unauth.html”);
http.formLogin() //自定义自己编写的登陆页面
.loginPage(“/login.html”) //登陆页面设置
.loginProcessingUrl(“/user/login”) //登陆访问路径
.defaultSuccessUrl(“/test/hello”).permitAll() //登陆成功后跳转路径
.and().authorize