@@ -0,0 +1,1248 @@
+package net.jgp.labs.db.informix.record;%0A%0Aimport java.sql.SQLException;%0Aimport java.sql.Statement;%0Aimport java.time.Duration;%0Aimport java.time.LocalDateTime;%0Aimport java.time.Month;%0A%0Aimport net.jgp.labs.db.informix.utils.ConnectionManager;%0A%0Apublic class UpdateRecord %7B%0A%09public static void main(String%5B%5D args) %7B%0A%0A%09%09ReadRecord rr = new ReadRecord();%0A%09%09rr.executeDbOperation(%22SELECT * FROM manufact ORDER BY manu_code%22);%0A%0A%09%09// Update lead time of SNT supplier based on current day.%0A%09%09UpdateRecord ur = new UpdateRecord();%0A%09%09LocalDateTime now = LocalDateTime.now();%0A%09%09LocalDateTime nextXmas = LocalDateTime.of(now.getYear(), Month.DECEMBER, 25, 0, 0);%0A%09%09Duration leadTime = Duration.between(now, nextXmas);%0A%0A%09%09ur.executeDbOperation(%22UPDATE manufact SET lead_time='%22 + leadTime.toDays() + %22' WHERE manu_code='SNT'%22);%0A%0A%09%09rr.executeDbOperation(%22SELECT * FROM manufact ORDER BY manu_code%22);%0A%09%7D%0A%0A%09public boolean executeDbOperation(String sqlStatement) %7B%0A%09%09Statement statement = ConnectionManager.getStatement();%0A%09%09try %7B%0A%09%09%09statement.executeUpdate(sqlStatement);%0A%09%09%7D catch (SQLException e) %7B%0A%09%09%09System.out.println(%0A%09%09%09%09%09%22Could not execute the following SQL statement '%22 + sqlStatement + %22', got: %22 + e.getMessage());%0A%09%09%09return false;%0A%09%09%7D%0A%09%09return true;%0A%09%7D%0A%7D%0A

Update added.