方式一:原生session,返回RowRecord
/**
* 查询返回RowRecord方式
* @throws Exception
*/
public static void query()throws Exception{
Session session = new Session("127.0.0.1",6667,"root","root");
session.open();
SessionDataSet dataSet = session.executeQueryStatement("select * from root.sestest.wf01.wt01");
List<String> list = dataSet.getColumnNames();
for (String s : list) {
System.out.printf("%-35s",s );
}
System.out.println();
dataSet.setFetchSize(1024);
while (dataSet.hasNext()){
RowRecord record = dataSet.next();
System.out.printf("%-35s",record.getTimestamp());
for (Field field : record.getFields()) {
System.out.printf("%-35s",field.getIntV());
}
System.out.println();
}
dataSet.closeOperationHandle();
session.close();
}
返回示例
方式二:原生session,返回原始类型
/**
* 返回原始类型
* @throws Exception
*/
public static void query2()throws Exception{
Session session = new Session("127.0.0.1",6667,"root","root");
session.open();
SessionDataSet dataSet = session.executeQueryStatement("select * from root.sestest.wf01.wt01");
SessionDataSet.DataIterator iterator = dataSet.iterator();
List<String> list = dataSet.getColumnNames();
for (String s : list) {
System.out.printf("%-35s",s );
}
System.out.println();
dataSet.setFetchSize(1024);
while(iterator.next()){
StringBuffer sb = new StringBuffer();
sb.append(iterator.getLong(1)).append(",");
if(!iterator.isNull(2)){
sb.append(iterator.getInt(2)).append(",");
}else{
sb.append("null").append(",");
}
if(!iterator.isNull(3)){
sb.append(iterator.getInt(3)).append(",");
}else{
sb.append("null").append(",");
}
//支持序列名
if(!iterator.isNull("root.sestest.wf01.wt01.s2")){
sb.append(iterator.getInt("root.sestest.wf01.wt01.s2")).append(",");
}else{
sb.append("null").append(",");
}
System.out.println(sb.toString());
}
session.close();
}
返回示例