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}]

 

全部评论

2023-07-03 15:43
有没有建表语句?