Herddb JDBC driver download and installation tutorial
HERDDB is a high -performance, scalability distributed database system that supports high throughput data access and storage.HerDDB provides a JDBC driver that allows developers to use standard JDBC interfaces to interact with HERDDB.This article will introduce how to download and install the Herddb JDBC driver and provide some Java code examples.
1. Download HERDDB JDBC driver
First, visit Herddb's official website (https://www.herddb.io/) and transfer to the download page.Find the download link of Herddb JDBC drive in the page and click to download.After the download is completed, the decompression obtained `Herddb-JDBC- <Version> .jar` file.
2. Set up project dependencies
Add the downloaded `Herddb-JDBC- <Version> .jar` file to the dependence of your Java project.You can use Maven or Gradle and other construction tools, or manually add it to the project path.
3. Connect Herddb database
The following steps are required to connect the HERDDB database using the JDBC driver:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class HerdDBExample {
public static void main(String[] args) {
// Define the connection information
String url = "jdbc:herddb://localhost:2181,localhost:2182,localhost:2183/herddb";
String user = "username";
String password = "password";
// Register HERDDB JDBC driver
try {
Class.forName("io.herd.jdbc.HerdDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
return;
}
// establish connection
try (Connection connection = DriverManager.getConnection(url, user, password)) {
// The connection is successful, you can perform the database operation
// ...
} catch (SQLException e) {
e.printStackTrace();
}
}
}
In the above example, we first define the URL, username and password connecting the HERDDB database.Then, we dynamically loaded the Herddb JDBC drive class through the `class.Forname` method.Finally, use the `DriverManager.getConnection` method to establish a connection with the Herddb database.After the connection is successful, you can perform various database operations.
4. Execute the database operation
After successfully connecting to the HERDDB database, you can perform various database operations, such as creating tables, inserting data, query data, etc.The following is a simple example:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class HerdDBExample {
public static void main(String[] args) {
// Define the connection information
String url = "jdbc:herddb://localhost:2181,localhost:2182,localhost:2183/herddb";
String user = "username";
String password = "password";
// Register HERDDB JDBC driver
try {
Class.forName("io.herd.jdbc.HerdDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
return;
}
// establish connection
try (Connection connection = DriverManager.getConnection(url, user, password)) {
// Create a statement object
Statement statement = connection.createStatement();
// Execute the query sentence
String query = "SELECT * FROM my_table";
ResultSet resultSet = statement.executeQuery(query);
// Process query results
while (resultSet.next()) {
// Get every line of data
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
// Print data
System.out.println("id: " + id + ", name: " + name);
}
// Close ResultSet and Statement
resultSet.close();
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
In the above example, we created a statement object through the `Connection.CreateStatement` method, and used the object to execute a simple query statement.Then, obtain the query results through the `ResultSet` object, and process each line of data.Finally, the `resultSet` and` statement` objects were closed.
The above is a brief introduction to downloading, installation and use of Herddb JDBC drive.Through these simple steps and examples, you can start using Herddb JDBC driver to interact with Herddb database.
