# 11_19 SpringBoot使用ActiveRecordPlugin插件

11_19 SpringBoot使用ActiveRecordPlugin插件

---

1. 加入Jfinal的maven依赖

   <!-- https://mvnrepository.com/artifact/com.jfinal/jfinal -->
   <dependency>
       <groupId>com.jfinal</groupId>
       <artifactId>jfinal</artifactId>
       <version>4.7</version>
   </dependency>

2. 配置ActiveRecordPlugin

 private Logger log = LoggerFactory.getLogger(this.getClass());
    /**
     * 配置数据源头
     */
    @Bean
    public  ActiveRecordPlugin initActiveRecordPlugin() {
        try {
            Prop prop = PropKit.use("db.config");
            String url = prop.get("dburl");
            String username = prop.get("dbusername");
            String password = prop.get("dbpassword");
            DruidPlugin druidPlugin = new DruidPlugin(url, username, password);
            //加强数据库安全
            WallFilter wallFilter = new WallFilter();
            wallFilter.setDbType("mysql");
            druidPlugin.addFilter(wallFilter);
            //添加startFilter才会有数据
            druidPlugin.addFilter(new StatFilter());
            druidPlugin.start();
            ActiveRecordPlugin arp = new ActiveRecordPlugin("mysql",druidPlugin);
            arp.setShowSql(true);
            arp.getEngine().setSourceFactory(new ClassPathSourceFactory());
            //配置sql模版位置
            arp.setBaseSqlTemplatePath("/sql/*.sql");
            arp.start();
            log.info("The ActiveRecordPlugin is start!");
            return arp;
        } catch (Exception e) {
            e.printStackTrace();
            log.error(e.getMessage());
            return null;
        }
    }