Nein, keine Schleife. Nur:
[code=Java]
String sql = "UPDATE leistungen"
+ "SET Baustelle=?, Grund=?, Beginnt=?, Endet=?, ZwischenA=?, BisB=? "
+ "WHERE Tage BETWEEN ? AND ?";
dbConnection = getDBConnection();
try(preparedStatement = dbConnection.prepareStatement(sql)) {
preparedStatement.setBoolean(1, true);
preparedStatement.setString(2, individuell.getText());
preparedStatement.setString(2, individuell.getText());
preparedStatement.setDate(3, (java.sql.Date)sqlTag1);
preparedStatement.setDate(4, (java.sql.Date)sqlTag2);
preparedStatement.setString(5, a.getText());
preparedStatement.setString(6, b.getText());
// es folgen die zwei BETWEEN-Parameter
preparedStatement.setDate(7, (java.sql.Date)sqlTag1);
preparedStatement.setDate(8, (java.sql.Date)sqlTag2);
preparedStatement.executeUpdate();
}
[/code]
