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);