import java.sql.*;
public class RedshiftJDBCExample {
public static void main(String[] args) {
String jdbcUrl = "jdbc:redshift://hostname:port/database";
String user = "username";
String password = "password";
try {
Connection conn = DriverManager.getConnection(jdbcUrl, user, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM table_name");
while (rs.next()) {
String column1 = rs.getString("column1");
int column2 = rs.getInt("column2");
System.out.println(column1 + "\t" + column2);
}
rs.close();
stmt.close();
conn.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
