/mybatis-crypt

mybatis 拦截器--实现数据库数据脱敏

Primary LanguageJavaMIT LicenseMIT

mybatis-crypt

mybatis 拦截器--实现数据库数据脱敏

介绍

注解类 @CryptField — 可作用于类成员变量、方法、方法参数

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target({ElementType.FIELD, ElementType.PARAMETER, ElementType.METHOD})
public @interface CryptField {

    String value() default "";

    boolean encrypt() default true;

    boolean decrypt() default true;
}

使用方法

  1. 引入jar包

  2. 配置mybatis插件

    • xml

      <!-- 配置SqlSessionFactory -->
          <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
              <!-- 数据源 -->
              <property name="dataSource" ref="dataSource"/>
              <property name="mapperLocations">
                  <array>
                      <value>classpath:mapper/*.xml</value>
                  </array>
              </property>
              <property name="plugins">
                  <array>
                      <bean id="cryptInterceptor" class="org.apache.ibatis.plugin.CryptInterceptor">
                      </bean>
                  </array>
              </property>
          </bean>
    • java config

      @Bean(name = "sqlSessionFactory")
      public SqlSessionFactory sqlSessionFactory() throws Exception {
      	SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
      	PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
              factoryBean.setMapperLocations(resolver.getResources("classpath:/mapper/*.xml"));
      	factoryBean.setDataSource(dataSource);
        
              List<Interceptor> interceptors = Lists.newArrayList();
      
      	CryptInterceptor cryptInterceptor = new CryptInterceptor();
      	interceptors.add(cryptInterceptor);
      
      	factoryBean.setPlugins(interceptors.toArray(new Interceptor[interceptors.size()]));
      
      	return factoryBean.getObject();
      }
  3. 注解使用场景

  • 方法

    表示返回值需要解密,适用对象包括String、List<String>、JavaBean、List<JavaBean>

    @CryptField
    List<AppInfo> select(String aaa);
  • 类成员变量

    表示类成员需要加解密,具体看使用场景、适用对象包括String、List<String>

  • 方法参数

    表示方法参数需要加密,适用对象包括String、List<String>、JavaBean、List<JavaBean>