TDengine涛思时序数据库的搭建应用

1.下载服务端的tar包
2.解压到指定目录
3.进入到子目录执行install.sh
4.编辑 /etc/taos/taos.cfg 单机默认即可
5.启动服务:systemctl start taosd (非root用户加 sudo)
6.连接使用:taos
7.如果其它机器连接需要安装客户端

import com.taosdata.jdbc.TSDBDriver;

import java.sql.*;
import java.util.Properties;

/**
 * @description:
 * TDengine: 时序数据库,又名涛思(taos)
 * 测试版本: Community Edition, version is 1.6.6.1
 * 服务端地址: 172.24.103.5:6030
 * 已建数据库: wzw_test
 * 用户: root
 * 密码:taosdata
 * 服务端 shell操作:执行命令 taos
 * @author: ZhiWen
 * @create: 2020-08-12
 **/
public class TDengineUse {



    public static Connection getConnection() throws ClassNotFoundException, SQLException {

        Class.forName("com.taosdata.jdbc.TSDBDriver");
        String jdbcUrl = "jdbc:TAOS://172.24.103.5:6030/wzw_test";
        Properties connProps = new Properties();
        connProps.setProperty(TSDBDriver.PROPERTY_KEY_USER, "root");
        connProps.setProperty(TSDBDriver.PROPERTY_KEY_PASSWORD, "taosdata");
        //以下可不写
        connProps.setProperty(TSDBDriver.PROPERTY_KEY_CONFIG_DIR, "C:\TDengine\cfg");
        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);
        return conn;

    }

    public static void main(String[] args) {


        try (Connection connection = getConn()) {

            Statement statement = connection.createStatement();
            //statement.executeUpdate("insert into student values(now, 'Wangwu', 20, 3) (now+1s, 'Zhaoliu', 22, 4)");
            ResultSet resultSet = statement.executeQuery("select * from student");
            Timestamp ts = null;
            int age = 0;
            while(resultSet.next()){
                ts = resultSet.getTimestamp(1);
                age = resultSet.getInt(3);
                System.out.printf("%s, %d\n", ts, age);
            }
            resultSet.close();
            statement.close();

        }catch (Exception e){
            System.out.println(e);
            System.out.println("--------------");
        }


    }

    public static Connection getConn() throws Exception{
        Class.forName("com.taosdata.jdbc.TSDBDriver");
        String jdbcUrl = "jdbc:TAOS://172.24.103.5:6030/wzw_test?user=root&password=taosdata";
        Connection conn = DriverManager.getConnection(jdbcUrl);
        return conn;
    }

}

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

注意点:
1.服务端客户端需要版本一致
2.windows本地需要安装客户端
3.学习路径