shiro整合Mybatis[springboot11]

最新推荐文章于 2022-10-21 20:21:31 发布

诗若颜

最新推荐文章于 2022-10-21 20:21:31 发布

阅读量113

点赞数

分类专栏： SpringBoot 文章标签： shiro mybatis

本文链接：https://blog.csdn.net/qq_44718582/article/details/112130890

版权

SpringBoot 专栏收录该内容

21 篇文章 0 订阅

订阅专栏

shiro整合Mybatis

项目结构：

$[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-anzKRT4p-1609606387859)(D:\文件夹\MarkDown\photos\image-20210103003712355.png)]$

pom.xml

<!--lombok-->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
</dependency>

<!--mysql-->
<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <scope>runtime</scope>
   <version>5.1.39</version>
</dependency>

<!--log4j        -->
<dependency>
    <groupId>log4j</groupId>
     <artifactId>log4j</artifactId>
      <version>1.2.17</version>
</dependency>

<!--druid        -->
<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid</artifactId>
  <version>1.1.21</version>
</dependency>

<!--mybatis-springboot整合包        -->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.1</version>
</dependency>



<!--        Subject 用户
           SecurityManager 管理所有用户
           Realm  连接数据库     -->
        <!-- shiro整合spring的包       -->
<dependency>
    <groupId>org.apache.shiro</groupId>
    <artifactId>shiro-spring</artifactId>
    <version>1.4.1</version>
</dependency>


<!--Thymeleaf,我们都是基于3.x-->
<dependency>
   <groupId>org.thymeleaf</groupId>
   <artifactId>thymeleaf-spring5</artifactId>
</dependency>

<dependency>
    <groupId>org.thymeleaf.extras</groupId>
    <artifactId>thymeleaf-extras-java8time</artifactId>
</dependency>

application.yaml

spring:
  datasource:
    username: root
    password: xxxxx
    url: jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=UTF-8
    driver-class-name: com.mysql.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource

    #springBoot默认是不注入这些属性值的，需要自己绑定
    #druid数据源专有配置
    initialSize: 5
    minIdle: 5
    maxActive: 20
    maxWait: 60000
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    validationQuery: SELECT 1 FROM DUAL
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true

    #配置监控统计拦截的filters,stat:监控统计，log4j:日志记录，wall:防止sql注入
    #如果允许报错时 java.lang.ClassNotFoundException:org.apache.log4j.Priority
    #则导入log4j依赖即可，Maven地址：https://mvnrepository.com/artifact/log4j/log4j
    filters: stat,wall,log4j
    maxPoolPreparedStatementPerConnectionSize: 20
    useGlobalDataSourceStat: true
    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

application.properties

# 应用名称
spring.application.name=demo-shiro
# 应用服务 WEB 访问端口
server.port=8080
#整合mybatis
mybatis.type-aliases-package=com.example.demoshiro.pojo
mybatis.mapper-locations=classpath:mapper/*.xml

UserMapper.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.example.demoshiro.mapper.UserMapper">
   <select id="queryUserByName" parameterType="String" resultType="User">
       select * from test.user where name = #{name }
   </select>


</mapper>

add.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<h1>add</h1>
</body>
</html>

update.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<h1>update</h1>
</body>
</html>

index.html

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<h1>首页</h1>
<div th:text="${msg}"></div>
<hr>

<a th:href="@{/user/add}">add</a> | <a th:href="@{/user/update}">update</a>

</body>
</html>

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<h1>登录</h1>
<hr>
<p th:text="${msg}" style="color: red;"></p>
<form th:action="@{/login}">
    <p>用户名：<input type="text" name="username"> </p>
    <p>密码：<input type="text" name="password"> </p>
    <p><input type="submit"></p>
</form>
</body>
</html>

ShiroConfig.java

@Configuration
public class ShiroConfig {

//    ShiroFilterFactoryBean:3
    @Bean
    public ShiroFilterFactoryBean getShiroFilterFactoryBean(@Qualifier("securityManager") DefaultWebSecurityManager defaultWebSecurityManager){
        ShiroFilterFactoryBean bean = new ShiroFilterFactoryBean();
//        设置安全管理器
        bean.setSecurityManager(defaultWebSecurityManager);
//        添加shiro的内置过滤器
        /**
         * anon:无需认证就可以访问
         * authc:必须认证了才能访问
         * user:必须拥有 记住我 功能才能用
         * perms: 拥有对某个资源的权限才能访问
         * role :拥有某个角色权限才能访问
         */
//        拦截
        Map<String, String> filterMap = new LinkedHashMap<>();
//        可以用代码替换 filterMap.put("/user/*","authc");
        filterMap.put("/user/add","anon");
        filterMap.put("/user/update","authc");

        bean.setFilterChainDefinitionMap(filterMap);

//        设置登录的请求
        bean.setLoginUrl("/toLogin");

        return bean;
    }


//    DefaultWebSecurityManager:2
    @Bean(name="securityManager")
    public DefaultWebSecurityManager getDefaultWebSecurityManager(@Qualifier("userRealm") UserRealm userRealm){
        DefaultWebSecurityManager securityManager = new DefaultWebSecurityManager();
//        关联UserRealm
        securityManager.setRealm(userRealm);
        return securityManager;
    }

//    创建realm对象，需要自定义类：1
    @Bean
    public UserRealm userRealm(){
        return new UserRealm();
    }

}

UserRealm.java

//自定义的UserRealm extends AuthorizingRealm
public class UserRealm extends AuthorizingRealm {
    @Autowired
    UserService userService;

//    授权
    @Override
    protected AuthorizationInfo doGetAuthorizationInfo(PrincipalCollection principalCollection) {
        System.out.println("执行了->授权doGetAuthorizationInfo");
        return null;
    }

//    认证
    @Override
    protected AuthenticationInfo doGetAuthenticationInfo(AuthenticationToken authenticationToken) throws AuthenticationException {
        System.out.println("执行了->认证doGetAuthorizationInfo");
//        用户名,密码,数据中取
//        String name = "root";
//        String password = "123456";
        UsernamePasswordToken userToken = (UsernamePasswordToken) authenticationToken;
        //连接真实数据库
        User user = userService.queryUserByName(userToken.getUsername());
        if(user == null){ //没有这个人
            return null; //UnknownAccountException
        }
        //可以加密, MD5加密,MD5盐值加密
        //密码认证,shiro做
        return new SimpleAuthenticationInfo("",user.getPwd(),"");
    }
}

MyController.java

@Controller
public class MyController {

    @RequestMapping({"/","/index"})
    public String toIndex(Model model){
            model.addAttribute("msg","hello,shiro");
            return "index";
    }

    @RequestMapping("/user/add")
    public String add(){
        return "user/add";
    }

    @RequestMapping("/user/update")
    public String update(){
        return "user/update";
    }

    @RequestMapping("/toLogin")
    public String toLogin(){
        return "login";
    }

    @RequestMapping("/login")
    public String login(String username,String password,Model model){
//        获取当前的用户
        Subject subject = SecurityUtils.getSubject();
//        封装用户的登录数据
        UsernamePasswordToken token = new UsernamePasswordToken(username, password);
        try{
//        执行登录方法,如果没有异常就说明ok了
            subject.login(token);
            return "index";
        }catch (UnknownAccountException e){  //用户名不存在
            model.addAttribute("msg","用户名错误");
            return "login";
        }catch (IncorrectCredentialsException e){//密码不存在
            model.addAttribute("msg","密码错误");
            return "login";
        }
    }


}

UserMapper.java

@Repository
@Mapper
public interface UserMapper {
    public User queryUserByName(String name);
}

User.java

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private int id;
    private String name;
    private String pwd;
}

UserService.java

public interface UserService {
    public User queryUserByName(String name);
}

UserServiceImpl.java

@Service
public class UserServiceImpl implements UserService{

    @Autowired
    UserMapper userMapper;


    @Override
    public User queryUserByName(String name) {
        return userMapper.queryUserByName(name);
    }
}

诗若颜

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
shiro整合Mybatis[springboot11]

shiro整合Mybatis项目结构：pom.xml<dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId></dependency><dependency> <groupId>mysql<
复制链接

扫一扫