-
Notifications
You must be signed in to change notification settings - Fork 11
/
Query.java
69 lines (59 loc) · 2.88 KB
/
Query.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
/*******************************************************************************
* * Copyright 2018 Impetus Infotech.
* *
* * Licensed under the Apache License, Version 2.0 (the "License");
* * you may not use this file except in compliance with the License.
* * You may obtain a copy of the License at
* *
* * http://www.apache.org/licenses/LICENSE-2.0
* *
* * Unless required by applicable law or agreed to in writing, software
* * distributed under the License is distributed on an "AS IS" BASIS,
* * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* * See the License for the specific language governing permissions and
* * limitations under the License.
******************************************************************************/
package com.impetus.blkchn.eth;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
public class Query {
private static final Logger LOGGER = LoggerFactory.getLogger(Query.class);
public static void main(String[] args) throws ClassNotFoundException {
String url = "jdbc:blkchn:ethereum://127.0.0.1:8545";
String driverClass = "com.impetus.eth.jdbc.EthDriver";
try {
Class.forName(driverClass);
Connection conn = DriverManager.getConnection(url, null);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(
"select count(*) as cnt, blocknumber from transaction where blocknumber > 1652349 and blocknumber < 1652351 group by blocknumber");
while (rs.next()) {
LOGGER.info("" + rs.getInt(1));
LOGGER.info("" + rs.getString("blocknumber"));
}
LOGGER.info("Result set MetaData");
ResultSetMetaData rsMetaData = rs.getMetaData();
LOGGER.info("Total Columns : " + rsMetaData.getColumnCount());
LOGGER.info("column label name : " + rsMetaData.getColumnLabel(1));
LOGGER.info("column Name : " + rsMetaData.getColumnName(1));
LOGGER.info("column type : " + rsMetaData.getColumnType(1));
LOGGER.info("column type : " + rsMetaData.getColumnTypeName(1));
LOGGER.info("column Name : " + rsMetaData.getColumnName(2));
LOGGER.info("column type : " + rsMetaData.getColumnType(2));
LOGGER.info("column type : " + rsMetaData.getColumnTypeName(2));
LOGGER.info("tableName : " + rsMetaData.getTableName(1));
conn.close();
LOGGER.info("Connection closed "+conn.isClosed());
LOGGER.info("ResultSet closed "+rs.isClosed());
LOGGER.info("Statement closed "+stmt.isClosed());
} catch (SQLException e1) {
e1.printStackTrace();
}
}
}