<dependency>
<groupId>org.ethereum</groupId>
<artifactId>ethereum-jdbc</artifactId>
<version>1.0.0</version>
</dependency>
jdbc.url=jdbc:ethereum://localhost:8545
jdbc.username=your_username
jdbc.password=your_password
import org.ethereum.jdbc.EthereumDataSource;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
public class EthereumIntegrationExample {
public static void main(String[] args) {
try {
EthereumDataSource dataSource = new EthereumDataSource();
Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM blocks ORDER BY number DESC LIMIT 1");
while (resultSet.next()) {
long blockNumber = resultSet.getLong("number");
System.out.println("Latest block number: " + blockNumber);
}
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
javac EthereumIntegrationExample.java
java EthereumIntegrationExample
