import java.sql.*;
public class RedshiftConnectionExample {
public static void main(String[] args) {
try {
Class.forName("com.amazon.redshift.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:redshift://redshift-instance-name:5439/database-name",
"username", "password");
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
import java.sql.*;
public class RedshiftQueryExample {
public static void main(String[] args) {
try {
Class.forName("com.amazon.redshift.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:redshift://redshift-instance-name:5439/database-name",
"username", "password");
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM table_name");
while (resultSet.next()) {
String columnValue1 = resultSet.getString("column1");
int columnValue2 = resultSet.getInt("column2");
System.out.println("column1: " + columnValue1 + ", column2: " + columnValue2);
}
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
