Hab ich, geht nicht. Eclipse sagt ich hätte einen error in meiner SQL syntax. Verstehe aber nicht wo.
[Code=Java]
String insertTableSQL = "UPDATE leistungen"
+ "SET (Baustelle, Grund, Beginnt, Endet, ZwischenA, BisB) VALUES"
+ "(?,?,?,?,?,?)"
+ "WHERE Tage BETWEEN'" + (java.sql.Date)sqlTag1 + "' AND '" + (java.sql.Date)sqlTag2 + "'";
LocalDate start = date1.toInstant().atZone(ZoneId.systemDefault()).toLocalDate();
LocalDate end = date2.toInstant().atZone(ZoneId.systemDefault()).toLocalDate();
for (LocalDate date = start; !date.isAfter(end); date = date.plusDays(1)) {
dbConnection = getDBConnection();
preparedStatement = dbConnection.prepareStatement(insertTableSQL);
preparedStatement.setBoolean(1, true);
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());
preparedStatement.addBatch();
}
preparedStatement.executeBatch();
// preparedStatement.executeUpdate();
System.out.println("Record is inserted into DBUSER table!");
[/Code]
