import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
 
public class Main {
 
    private static final String JDBC_URL = "jdbc:mysql://localhost:3306/your_database_name";
    private static final String USERNAME = "your_username";
    private static final String PASSWORD = "your_password";
 
    public static void main(String[] args) {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            try (Connection connection = DriverManager.getConnection(JDBC_URL, USERNAME, PASSWORD)) {
                String selectQuery = "SELECT * FROM Employee";
                try (PreparedStatement selectStatement = connection.prepareStatement(selectQuery)) {
                    try (ResultSet resultSet = selectStatement.executeQuery()) {
                        while (resultSet.next()) {
                            int employeeId = resultSet.getInt("employee_id");
                            double currentSalary = resultSet.getDouble("salary");
                            double newSalary = currentSalary * 1.05; 
                            String updateQuery = "UPDATE Employee SET salary = ? WHERE employee_id = ?";
                            try (PreparedStatement updateStatement = connection.prepareStatement(updateQuery)) {
                                updateStatement.setDouble(1, newSalary);
                                updateStatement.setInt(2, employeeId);
                                updateStatement.executeUpdate();
                                System.out.println("Salary updated for employee ID: " + employeeId);
                            }
                        }
                    }
                }
            }
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
    }
}
 

aW1wb3J0IGphdmEuc3FsLkNvbm5lY3Rpb247CmltcG9ydCBqYXZhLnNxbC5Ecml2ZXJNYW5hZ2VyOwppbXBvcnQgamF2YS5zcWwuUHJlcGFyZWRTdGF0ZW1lbnQ7CmltcG9ydCBqYXZhLnNxbC5SZXN1bHRTZXQ7CmltcG9ydCBqYXZhLnNxbC5TUUxFeGNlcHRpb247CgpwdWJsaWMgY2xhc3MgTWFpbiB7CgogICAgcHJpdmF0ZSBzdGF0aWMgZmluYWwgU3RyaW5nIEpEQkNfVVJMID0gImpkYmM6bXlzcWw6Ly9sb2NhbGhvc3Q6MzMwNi95b3VyX2RhdGFiYXNlX25hbWUiOwogICAgcHJpdmF0ZSBzdGF0aWMgZmluYWwgU3RyaW5nIFVTRVJOQU1FID0gInlvdXJfdXNlcm5hbWUiOwogICAgcHJpdmF0ZSBzdGF0aWMgZmluYWwgU3RyaW5nIFBBU1NXT1JEID0gInlvdXJfcGFzc3dvcmQiOwoKICAgIHB1YmxpYyBzdGF0aWMgdm9pZCBtYWluKFN0cmluZ1tdIGFyZ3MpIHsKICAgICAgICB0cnkgewogICAgICAgICAgICBDbGFzcy5mb3JOYW1lKCJjb20ubXlzcWwuY2ouamRiYy5Ecml2ZXIiKTsKICAgICAgICAgICAgdHJ5IChDb25uZWN0aW9uIGNvbm5lY3Rpb24gPSBEcml2ZXJNYW5hZ2VyLmdldENvbm5lY3Rpb24oSkRCQ19VUkwsIFVTRVJOQU1FLCBQQVNTV09SRCkpIHsKICAgICAgICAgICAgICAgIFN0cmluZyBzZWxlY3RRdWVyeSA9ICJTRUxFQ1QgKiBGUk9NIEVtcGxveWVlIjsKICAgICAgICAgICAgICAgIHRyeSAoUHJlcGFyZWRTdGF0ZW1lbnQgc2VsZWN0U3RhdGVtZW50ID0gY29ubmVjdGlvbi5wcmVwYXJlU3RhdGVtZW50KHNlbGVjdFF1ZXJ5KSkgewogICAgICAgICAgICAgICAgICAgIHRyeSAoUmVzdWx0U2V0IHJlc3VsdFNldCA9IHNlbGVjdFN0YXRlbWVudC5leGVjdXRlUXVlcnkoKSkgewogICAgICAgICAgICAgICAgICAgICAgICB3aGlsZSAocmVzdWx0U2V0Lm5leHQoKSkgewogICAgICAgICAgICAgICAgICAgICAgICAgICAgaW50IGVtcGxveWVlSWQgPSByZXN1bHRTZXQuZ2V0SW50KCJlbXBsb3llZV9pZCIpOwogICAgICAgICAgICAgICAgICAgICAgICAgICAgZG91YmxlIGN1cnJlbnRTYWxhcnkgPSByZXN1bHRTZXQuZ2V0RG91YmxlKCJzYWxhcnkiKTsKICAgICAgICAgICAgICAgICAgICAgICAgICAgIGRvdWJsZSBuZXdTYWxhcnkgPSBjdXJyZW50U2FsYXJ5ICogMS4wNTsgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICBTdHJpbmcgdXBkYXRlUXVlcnkgPSAiVVBEQVRFIEVtcGxveWVlIFNFVCBzYWxhcnkgPSA/IFdIRVJFIGVtcGxveWVlX2lkID0gPyI7CiAgICAgICAgICAgICAgICAgICAgICAgICAgICB0cnkgKFByZXBhcmVkU3RhdGVtZW50IHVwZGF0ZVN0YXRlbWVudCA9IGNvbm5lY3Rpb24ucHJlcGFyZVN0YXRlbWVudCh1cGRhdGVRdWVyeSkpIHsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB1cGRhdGVTdGF0ZW1lbnQuc2V0RG91YmxlKDEsIG5ld1NhbGFyeSk7CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgdXBkYXRlU3RhdGVtZW50LnNldEludCgyLCBlbXBsb3llZUlkKTsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB1cGRhdGVTdGF0ZW1lbnQuZXhlY3V0ZVVwZGF0ZSgpOwogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFN5c3RlbS5vdXQucHJpbnRsbigiU2FsYXJ5IHVwZGF0ZWQgZm9yIGVtcGxveWVlIElEOiAiICsgZW1wbG95ZWVJZCk7CiAgICAgICAgICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgIH0KICAgICAgICB9IGNhdGNoIChDbGFzc05vdEZvdW5kRXhjZXB0aW9uIHwgU1FMRXhjZXB0aW9uIGUpIHsKICAgICAgICAgICAgZS5wcmludFN0YWNrVHJhY2UoKTsKICAgICAgICB9CiAgICB9Cn0K