import java.sql.*;
String url = "jdbc:herddb://hostname:port/database";
String username = "your_username";
String password = "your_password";
Connection connection = DriverManager.getConnection(url, username, password);
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM table_name");
while (resultSet.next()) {
String column1 = resultSet.getString("column1");
int column2 = resultSet.getInt("column2");
// ...
}
Statement statement = connection.createStatement();
int updatedRows = statement.executeUpdate("UPDATE table_name SET column1 = 'new_value' WHERE condition");
System.out.println("Updated rows: " + updatedRows);
