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" ) ;
String selectQuery
= "SELECT * FROM Employee" ; 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 = ?" ; updateStatement.setDouble ( 1 , newSalary) ;
updateStatement.setInt ( 2 , employeeId) ;
updateStatement.executeUpdate ( ) ;
System .
out .
println ( "Salary updated for employee ID: " + employeeId
) ; }
}
}
}
}
e.printStackTrace ( ) ;
}
}
}
aW1wb3J0IGphdmEuc3FsLkNvbm5lY3Rpb247CmltcG9ydCBqYXZhLnNxbC5Ecml2ZXJNYW5hZ2VyOwppbXBvcnQgamF2YS5zcWwuUHJlcGFyZWRTdGF0ZW1lbnQ7CmltcG9ydCBqYXZhLnNxbC5SZXN1bHRTZXQ7CmltcG9ydCBqYXZhLnNxbC5TUUxFeGNlcHRpb247CgpwdWJsaWMgY2xhc3MgTWFpbiB7CgogICAgcHJpdmF0ZSBzdGF0aWMgZmluYWwgU3RyaW5nIEpEQkNfVVJMID0gImpkYmM6bXlzcWw6Ly9sb2NhbGhvc3Q6MzMwNi95b3VyX2RhdGFiYXNlX25hbWUiOwogICAgcHJpdmF0ZSBzdGF0aWMgZmluYWwgU3RyaW5nIFVTRVJOQU1FID0gInlvdXJfdXNlcm5hbWUiOwogICAgcHJpdmF0ZSBzdGF0aWMgZmluYWwgU3RyaW5nIFBBU1NXT1JEID0gInlvdXJfcGFzc3dvcmQiOwoKICAgIHB1YmxpYyBzdGF0aWMgdm9pZCBtYWluKFN0cmluZ1tdIGFyZ3MpIHsKICAgICAgICB0cnkgewogICAgICAgICAgICBDbGFzcy5mb3JOYW1lKCJjb20ubXlzcWwuY2ouamRiYy5Ecml2ZXIiKTsKICAgICAgICAgICAgdHJ5IChDb25uZWN0aW9uIGNvbm5lY3Rpb24gPSBEcml2ZXJNYW5hZ2VyLmdldENvbm5lY3Rpb24oSkRCQ19VUkwsIFVTRVJOQU1FLCBQQVNTV09SRCkpIHsKICAgICAgICAgICAgICAgIFN0cmluZyBzZWxlY3RRdWVyeSA9ICJTRUxFQ1QgKiBGUk9NIEVtcGxveWVlIjsKICAgICAgICAgICAgICAgIHRyeSAoUHJlcGFyZWRTdGF0ZW1lbnQgc2VsZWN0U3RhdGVtZW50ID0gY29ubmVjdGlvbi5wcmVwYXJlU3RhdGVtZW50KHNlbGVjdFF1ZXJ5KSkgewogICAgICAgICAgICAgICAgICAgIHRyeSAoUmVzdWx0U2V0IHJlc3VsdFNldCA9IHNlbGVjdFN0YXRlbWVudC5leGVjdXRlUXVlcnkoKSkgewogICAgICAgICAgICAgICAgICAgICAgICB3aGlsZSAocmVzdWx0U2V0Lm5leHQoKSkgewogICAgICAgICAgICAgICAgICAgICAgICAgICAgaW50IGVtcGxveWVlSWQgPSByZXN1bHRTZXQuZ2V0SW50KCJlbXBsb3llZV9pZCIpOwogICAgICAgICAgICAgICAgICAgICAgICAgICAgZG91YmxlIGN1cnJlbnRTYWxhcnkgPSByZXN1bHRTZXQuZ2V0RG91YmxlKCJzYWxhcnkiKTsKICAgICAgICAgICAgICAgICAgICAgICAgICAgIGRvdWJsZSBuZXdTYWxhcnkgPSBjdXJyZW50U2FsYXJ5ICogMS4wNTsgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICBTdHJpbmcgdXBkYXRlUXVlcnkgPSAiVVBEQVRFIEVtcGxveWVlIFNFVCBzYWxhcnkgPSA/IFdIRVJFIGVtcGxveWVlX2lkID0gPyI7CiAgICAgICAgICAgICAgICAgICAgICAgICAgICB0cnkgKFByZXBhcmVkU3RhdGVtZW50IHVwZGF0ZVN0YXRlbWVudCA9IGNvbm5lY3Rpb24ucHJlcGFyZVN0YXRlbWVudCh1cGRhdGVRdWVyeSkpIHsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB1cGRhdGVTdGF0ZW1lbnQuc2V0RG91YmxlKDEsIG5ld1NhbGFyeSk7CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgdXBkYXRlU3RhdGVtZW50LnNldEludCgyLCBlbXBsb3llZUlkKTsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB1cGRhdGVTdGF0ZW1lbnQuZXhlY3V0ZVVwZGF0ZSgpOwogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFN5c3RlbS5vdXQucHJpbnRsbigiU2FsYXJ5IHVwZGF0ZWQgZm9yIGVtcGxveWVlIElEOiAiICsgZW1wbG95ZWVJZCk7CiAgICAgICAgICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgIH0KICAgICAgICB9IGNhdGNoIChDbGFzc05vdEZvdW5kRXhjZXB0aW9uIHwgU1FMRXhjZXB0aW9uIGUpIHsKICAgICAgICAgICAgZS5wcmludFN0YWNrVHJhY2UoKTsKICAgICAgICB9CiAgICB9Cn0K