Springboot使用jfinal的数据库工具
1. maven依赖
<groupId>com.jfinal</groupId><artifactId>activerecord</artifactId>
<version>5.0.4</version>
</dependency>
2. 插件配置
public class DbConfig {@Value("${stockJdbcUrl}")
String jdbcUrl;
@Value("${spring.datasource.username:root}")
String user;
@Value("${spring.datasource.password:123456}")
String password;
public DruidPlugin createDruidPlugin() {
DruidPlugin druidPlugin = new DruidPlugin(jdbcUrl, user, password);
return druidPlugin;
}
@PostConstruct
public void initActiveRecordPlugin() {
DruidPlugin druidPlugin = createDruidPlugin();
ActiveRecordPlugin arp = new ActiveRecordPlugin(druidPlugin);
arp.setDevMode(true);
arp.setShowSql(true);
// 先启动 druidPlugin,后启动 arp
druidPlugin.start();
arp.start();
}
}
3. 查询数据
Record t5fMaxRec = Db.findFirst("select max(dttime) dttime from trade5f");