String jdbcURL = "jdbc:mysql://your-database-endpoint:port/database-name";
String username = "your-username";
String password = "your-password";
Class.forName("com.amazonaws.glue.jdbc.Driver");
Connection connection = DriverManager.getConnection(jdbcURL, username, password);
import java.sql.*;
public class AWSDatabaseExample {
public static void main(String[] args) {
String jdbcURL = "jdbc:mysql://your-database-endpoint:port/database-name";
String username = "your-username";
String password = "your-password";
try {
// Load AWS JDBC driver
Class.forName("com.amazonaws.glue.jdbc.Driver");
// Establish database connection
Connection connection = DriverManager.getConnection(jdbcURL, username, password);
// Execute SQL query
String query = "SELECT * FROM your-table";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(query);
// Process query results
while (resultSet.next()) {
String col1 = resultSet.getString("column1");
String col2 = resultSet.getString("column2");
System.out.println(col1 + " - " + col2);
}
// Close connections
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
