jdbcTemplate 連接

使用springboot jdbcTemplate 連接TDengine時(shí)序數(shù)據(jù)庫(kù)

添加TDengine驅(qū)動(dòng)依賴包

<!--pom.xml-->
<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
  <groupId>com.taosdata.jdbc</groupId>
  <artifactId>taos-jdbcdriver</artifactId>
  <version>3.5.1</version>
</dependency>

查詢代碼

// JdbcTemplateConfig.java
@Configuration
public class JdbcTemplateConfig {

    @Autowired
    private DataSource dataSource;

    @Bean
    public JdbcTemplate jdbcTemplate() {
        return new JdbcTemplate(dataSource);
    }
}
// DataService.java
@Service
public class DataService {

    private final JdbcTemplate jdbcTemplate;

    @Autowired
    public DataService(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public List<Map<String, Object>> queryData(String sqlStr) {
        return jdbcTemplate.queryForList(sqlStr);
    }
}
// TdengineApplicationTests.java 測(cè)試類
@SpringBootTest
@Slf4j
class TdengineApplicationTests {
    @Autowired
    private DataService dataService;
    @Test
    void contextLoads() {
        List<Map<String, Object>> maps1 = dataService.queryData("SELECT AVG(current), MAX(voltage), MIN(phase) FROM meters;");
        log.info(maps1.toString());
        }
    }

druid連接池

使用druid連接池連接TDengine時(shí)序數(shù)據(jù)庫(kù)

添加依賴包

<!--pom.xml-->
<dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid-spring-boot-starter</artifactId>
        <version>1.2.6</version>
</dependency>
<dependency>
  <groupId>com.taosdata.jdbc</groupId>
  <artifactId>taos-jdbcdriver</artifactId>
  <version>3.5.1</version>
</dependency>

Restful昨登、WebSocket連接配置

spring:
        datasource:
                url: jdbc:TAOS-RS://localhost:6041/test 
                #url: jdbc:TAOS-WS://localhost:6041/test
                username: root
                password: taosdata
                driver-class-name: com.taosdata.jdbc.rs.RestfulDriver
                #driver-class-name: com.taosdata.jdbc.ws.WebSocketDriver
      jpa:
        show-sql: true #JPA是否顯示sql語(yǔ)句
        # 使用mysql的方言,否則報(bào)錯(cuò)
        database-platform: org.hibernate.dialect.MySQLDialect    

原生連接配置

spring:
        datasource:
                url: jdbc:TAOS://localhost:6030/test
                username: root
                password: taosdata
                driver-class-name: com.taosdata.jdbc.TSDBDriver
      jpa:
        show-sql: true #JPA是否顯示sql語(yǔ)句
        # 使用mysql的方言,否則報(bào)錯(cuò)
        database-platform: org.hibernate.dialect.MySQLDialect    

原生連接需要安裝TDengine客戶端驅(qū)動(dòng)taosc否則會(huì)報(bào)錯(cuò)稀蟋，為避免客戶端驅(qū)動(dòng)和服務(wù)端不兼容，使用一致的版本。

客戶端驅(qū)動(dòng)下載地址

https://docs.taosdata.com/develop/connect/#安裝客戶端驅(qū)動(dòng)-taosc

java.lang.UnsatisfiedLinkError: no taos in java.library.path: [\Java\jdk-11.0.2\bin, C:\Windows\Sun\Java\bin, C:\Windows\system32, C:\Windows, C:\Program Files (x86)\Common Files\Oracle\Java\javapath, C:\Windows\system32, C:\Windows, C:\Windows\System32\Wbem, C:\Windows\System32\WindowsPowerShell\v1.0\, C:\Windows\System32\OpenSSH\, D:\javaJDK\bin, D:\maven\apache-maven-3.9.6\bin, D:\Git\Git\cmd, D:\redis, C:\Users\Administrator\AppData\Local\Microsoft\WindowsApps, .]
    at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2660) ~[na:na]
    at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:829) ~[na:na]
    at java.base/java.lang.System.loadLibrary(System.java:1867) ~[na:na]
    at com.taosdata.jdbc.TSDBJNIConnector.<clinit>(TSDBJNIConnector.java:36) ~[taos-jdbcdriver-3.5.1.jar:na]
    at com.taosdata.jdbc.TSDBDriver.connect(TSDBDriver.java:176) ~[taos-jdbcdriver-3.5.1.jar:na]
    at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657) ~[druid-1.2.6.jar:1.2.6]
    at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) ~[druid-1.2.6.jar:1.2.6]
    at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2801) ~[druid-1.2.6.jar:1.2.6]

配置好之后可以直接使用正常jpa的代碼，直接對(duì)數(shù)據(jù)進(jìn)行增刪改查洽洁。

參考

https://docs.taosdata.com/develop/connect/

https://github.com/taosdata/TDengine/tree/main/docs/examples/JDBC