java activerecordplugin_spring boot+jfinal的ActiveRecordPlugin重新整合林业厅会议系统

package com.example.bf.config;

import com.alibaba.druid.wall.WallFilter;

import com.example.bf.BfApplication;

import com.example.bf.entity._MappingKit;

import com.jfinal.plugin.activerecord.ActiveRecordPlugin;

import com.jfinal.plugin.druid.DruidPlugin;

import com.jfinal.template.source.ClassPathSourceFactory;

import org.springframework.beans.factory.annotation.Value;

import org.springframework.boot.SpringApplication;

import org.springframework.context.ConfigurableApplicationContext;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import java.sql.Connection;

/**

* @author wgw

* @date 2018/07/29 10:16

*/

@Configuration

public class ActiveRecordPluginConfig {

@Value("${spring.datasource.username}")

private String username;

@Value("${spring.datasource.password}")

private String password;

@Value("${spring.datasource.url}")

private String url;

@Bean

public ActiveRecordPlugin initActiveRecordPlugin() {

DruidPlugin druidPlugin = new DruidPlugin(url, username, password);

// 加强数据库安全

WallFilter wallFilter = new WallFilter();

wallFilter.setDbType("mysql");

druidPlugin.addFilter(wallFilter);

// 添加 StatFilter 才会有统计数据

// druidPlugin.addFilter(new StatFilter());

// 必须手动调用start

druidPlugin.start();

ActiveRecordPlugin arp = new ActiveRecordPlugin(druidPlugin);

arp.setTransactionLevel(Connection.TRANSACTION_READ_COMMITTED);

_MappingKit.mapping(arp);

arp.setShowSql(false);

arp.getEngine().setSourceFactory(new ClassPathSourceFactory());

arp.addSqlTemplate("/sql/all_sqls.sql");

// 必须手动调用start

arp.start();

return arp;

}

public static DruidPlugin getDruidPlugin () {

ConfigurableApplicationContext context= SpringApplication.run(BfApplication.class);

String username=context.getEnvironment().getProperty("spring.datasource.username");

String password=context.getEnvironment().getProperty("spring.datasource.password");

String url=context.getEnvironment().getProperty("spring.datasource.url");

return new DruidPlugin(url, username, password);

}

}