TDengine国产高性能时序数据库集成到Mybaits
2020-11-25 12:40
13394
2
一、安装,见官网快捷安装
二、在项目Maven中导入对应的引用包
<dependency>
<groupId>com.taosdata.jdbc</groupId>
<artifactId>taos-jdbcdriver</artifactId>
<version>2.0.4</version>
</dependency>
三、配置TDengine数据源
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
#使用多数据源
dynamic:
##配置默认数据源
primary: db1
datasource:
db1:
url: jdbc:mysql://localhost:3306/yyhouc?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
# db2:
# url: jdbc:mysql://localhost:3307/yyhouc?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true
# username: root
# password: 123456
# driver-class-name: com.mysql.cj.jdbc.Driver
# type: com.alibaba.druid.pool.DruidDataSource
db3:
url: jdbc:TAOS://yyhouc:6030/yyhouc
username: root
password: taosdata
driver-class-name: com.taosdata.jdbc.TSDBDriver
type: com.zaxxer.hikari.HikariDataSource
#排除Druid的自动数据原
autoconfigure:
exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
main:
allow-bean-definition-overriding: true
四、对其进行测试
mapper.xml文件
<insert id="test" >
INSERT INTO dev001 USING GPS TAGS (001, 01) VALUES (now, 37.113, 119.37,250);
</insert>
<select id="find" resultType="map" >
select * from GPS
</select>
mapper接口
void test();
List<Map> find();
service
@DS("db3")
@Override
public void test() {
this.baseMapper.test();
}
@DS("db3")
@Override
public List<Map> find() {
return this.baseMapper.find();
}
测试Controller
service.test();
System.out.println(service.find());
输出结果
c.h.c.s.mapper.baseMapper.test : ==> Preparing: INSERT INTO dev001 USING GPS TAGS (001, 01) VALUES (now, 37.113, 119.37,250);
c.h.c.s.mapper.baseMapper.test : ==> Parameters:
c.h.c.s.mapper.baseMapper.test : <== Updates: 1
c.h.c.s.mapper.baseMapper.find : ==> Preparing: select * from GPS
c.h.c.s.mapper.baseMapper.find : ==> Parameters:
c.h.c.s.mapper.baseMapper.find : <== Total: 1
[{phase=250.0, lng=119.37, location=001, type=1, lat=37.113, ts=1606275601668}]
全部评论