Næste |
|
JDBC serie, Planche nr. 18 |
![]() |
Alternativt |
Siden WHERE begrænser valget til en forekomst af en række, kan man klare sig uden en while-løkke:
rs.next(); String s = rs.getString(1); int n = rs.getInt(2); System.out.println(n + " pounds of " + s + " sold this week.")Opdater TOTAL-kolonnen
String updateString = "UPDATE COFFEES " + "SET TOTAL = TOTAL + 75 " + "WHERE COF_NAME LIKE 'Colombian'"; stmt.executeUpdate(updateString); String query = "SELECT COF_NAME, TOTAL FROM COFFEES " + "WHERE COF_NAME LIKE 'Colombian'"; ResultSet rs = stmt.executeQuery(query); while (rs.next()) { String s = rs.getString(1); int n = rs.getInt(2); System.out.println(n + " pounds of " + s + " sold to date.") }Her bruges kolonnenummer-metoden istedet for kolonnenavnet.
Næste |
|
JDBC serie, Planche nr. 18 |