Slide 17
Slide 17 text
@otaviojava || @kvarel4
try(Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(QUERY);) {
// Extract data from result set
while (rs.next()) {
// Retrieve by column name
System.out.print("ID: " + rs.getInt("id"));
System.out.print(", name: " + rs.getInt("name"));
System.out.print(", birthday: " + rs.getString("birthday"));
System.out.println(", city: " + rs.getString("city"));
System.out.println(", city: " + rs.getString("street"));
…
}
Challenges: Driver
Java + Database Integration
Code flexibility ++
Complex relation
with business logic