获取连接
package com.hzwaterit.iot.common.client;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class DBcommon {
public static Statement getConnect() {
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
try {
Class.forName("com.taosdata.jdbc.TSDBDriver");
String jdbcUrl = "jdbc:TAOS-RS://192.168.71.121:6041/iot?user=root&password=taosdata";
//上述地址为本地TDengine通用地址 “iot”为TDengine中的一个数据库 需要根据具体需求做更改
Connection conn = DriverManager.getConnection(jdbcUrl);
Statement stmt = conn.createStatement();
return stmt;
} catch (Exception e) {
System.out.println("error");
return null;
}
}
}
查询测试
import java.sql.ResultSet;
import java.sql.Statement;
public class Test {
public static void main(String[] args) {
try {
Statement stmt = DBcommon.getConnect();//调用连接配置文件
String sql = "select * from meters limit 0 , 10";
ResultSet rs = stmt.executeQuery(sql);//简单的查询语句
String name=null;
String job = null;
while (rs.next()) { // 判断是否还有下一个数据
// 根据字段名获取相应的值
name = rs.getString("ts");
job = rs.getString(("col6"));
//输出查到的记录的各个字段的值
System.out.println(name+" "+job);
}//简单的while循环语句示例(需要预先在数据库中输入相关信息)
} catch (Exception e) {
System.out.println("error sdffsw");
}
}
}