jdbc连接td2.6.0.34数据库

1.下载驱动包

https://www.taosdata.com/all-downloads

 配置文件C:\TDengine\cfg\taos.cfg

firstEp tdengine1-0001:6030
secondEp tdengine1-0002:6030

2.host文件配置集群地址C:\Windows\system32\drivers\etc\hosts

172.100.100.11 tdengine1-0001
172.100.100.12 tdengine1-0002
172.100.100.13 tdengine1-0003

3.本地连接td数据库

<dependency>
    <groupId>com.taosdata.jdbc</groupId>
    <artifactId>taos-jdbcdriver</artifactId>
    <version>2.0.38</version>
</dependency>

java代码：

public class TdDemo2 {
    public static void main(String[] args) throws SQLException {
        String jdbcUrl = "jdbc:TAOS://:6030?user=root&password=password";
        Properties connProps = new Properties();
        connProps.setProperty(TSDBDriver.PROPERTY_KEY_CHARSET, "UTF-8");
        connProps.setProperty(TSDBDriver.PROPERTY_KEY_LOCALE, "en_US.UTF-8");
        connProps.setProperty(TSDBDriver.PROPERTY_KEY_TIME_ZONE, "UTC-8");
        Connection conn = DriverManager.getConnection(jdbcUrl, connProps);
        System.out.println("Connected");
        conn.close();
    }
}

 

参考连接：

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