String url = "jdbc:teradata://localhost/DATABASE=mydatabase";
String username = "myuser";
String password = "mypassword";
Connection connection = DriverManager.getConnection(url, username, password);
String query = "SELECT * FROM mytable";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(query);
while (resultSet.next()) {
String column1Value = resultSet.getString("column1");
int column2Value = resultSet.getInt("column2");
// ...
}
String updateQuery = "UPDATE mytable SET column1 = ? WHERE column2 = ?";
PreparedStatement preparedStatement = connection.prepareStatement(updateQuery);
preparedStatement.setString(1, "new value");
preparedStatement.setInt(2, 123);
int rowsAffected = preparedStatement.executeUpdate();
System.out.println(rowsAffected + " rows updated");
try {
} catch (SQLException e) {
System.err.println("Database error: " + e.getMessage());
}
