Update Manager Salary

_UpdateManagerSalary.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class UpdateManagerSalary {

    private static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
    private static final String JDB_URL = "jdbc:mysql://localhost:3306/testdb";

    public static void main(String[] args) {

        String updateQuery = "UPDATE employee SET SALARY = 50000 WHERE post LIKE '%Manager'";

        try {
            Class.forName(JDBC_DRIVER);

            Connection con = DriverManager.getConnection(JDB_URL, "root", "");

            Statement st = con.createStatement();

            boolean isUpdated = st.execute(updateQuery);

            System.out.println("Updated");

            con.close();

        } catch (SQLException | ClassNotFoundException exc) {
            exc.printStackTrace();
        }
    }
}

managers.csv

table.sql

-- Creates database testdb. 
CREATE DATABASE IF NOT EXISTS `testdb`;

-- Creates table named employee with column id, name, post and salary.
CREATE TABLE IF NOT EXISTS `testdb`.`employee` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `post` VARCHAR(45) NULL,
  `salary` FLOAT NULL,
  PRIMARY KEY (`id`));

               
               use testdb;

insert into employee (name, post, salary) values ('Catherina Carruth', 'Cost Accountant', '30805.38');
insert into employee (name, post, salary) values ('Amaleta Byforth', 'Information Systems Manager', '35888.94');
insert into employee (name, post, salary) values ('Nichole Fullick', 'Registered Nurse', '42576.30');
insert into employee (name, post, salary) values ('Nadya Rittmeyer', 'Product Engineer', '25118.82');
insert into employee (name, post, salary) values ('Byrom Stanluck', 'Operator', '43693.13');
insert into employee (name, post, salary) values ('Bentlee McOmish', 'Chemical Engineer', '19175.54');
insert into employee (name, post, salary) values ('Sydney Aldersea', 'Safety Technician III', '18011.70');
insert into employee (name, post, salary) values ('Ambrosio Lockhead', 'Librarian', '36963.42');
insert into employee (name, post, salary) values ('Gretna Sheeres', 'Professor', '40788.87');
insert into employee (name, post, salary) values ('Ruthi Schottli', 'Nurse', '37975.30');
insert into employee (name, post, salary) values ('Ayn Bennen', 'Actuary', '35274.69');
insert into employee (name, post, salary) values ('Sarajane Maffei', 'Accountant IV', '19037.18');
insert into employee (name, post, salary) values ('Alicea Nattriss', 'Recruiting Manager', '41980.83');
insert into employee (name, post, salary) values ('Teddy Trusty', 'Software Test Engineer III', '36832.45');
insert into employee (name, post, salary) values ('Neale Sedgwick', 'Civil Engineer', '15904.49');
insert into employee (name, post, salary) values ('Stanly Espadate', 'Junior Executive', '22976.84');
insert into employee (name, post, salary) values ('Lotty Schelle', 'Account Coordinator', '29206.64');
insert into employee (name, post, salary) values ('Alexine McLice', 'Financial Analyst', '32156.27');
insert into employee (name, post, salary) values ('Vaughn Studdard', 'Clinical Specialist', '36214.62');
insert into employee (name, post, salary) values ('Monah Sarra', 'Senior Financial Analyst', '23820.26');
insert into employee (name, post, salary) values ('Ab Rowlett', 'Human Resources Assistant IV', '43992.43');
insert into employee (name, post, salary) values ('Ramona Nucator', 'Operator', '17523.20');
insert into employee (name, post, salary) values ('Keenan Stollenberg', 'Design Engineer', '24488.57');
insert into employee (name, post, salary) values ('Albrecht Garr', 'Senior Cost Accountant', '26896.87');
insert into employee (name, post, salary) values ('Dom Ridgeway', 'Human Resources Assistant III', '22994.24');
insert into employee (name, post, salary) values ('Court Cushworth', 'Sales Representative', '41485.22');
insert into employee (name, post, salary) values ('Lynnea Jude', 'Accountant IV', '36905.81');
insert into employee (name, post, salary) values ('Robbert Morrilly', 'Compensation Analyst', '21938.18');
insert into employee (name, post, salary) values ('Farris Jindacek', 'Dental Hygienist', '31986.82');
insert into employee (name, post, salary) values ('Jacklyn Chace', 'Civil Engineer', '18250.82');
insert into employee (name, post, salary) values ('Arlen Mourton', 'Quality Control Specialist', '23932.07');
insert into employee (name, post, salary) values ('Phedra Plomer', 'Design Engineer', '43176.32');
insert into employee (name, post, salary) values ('Harrie Ferretti', 'Nurse Practicioner', '21858.94');
insert into employee (name, post, salary) values ('Bendicty Cluelow', 'Recruiting Manager', '38359.12');
insert into employee (name, post, salary) values ('Joletta Wauchope', 'Electrical Engineer', '41733.75');
insert into employee (name, post, salary) values ('Elinore Aurelius', 'Registered Nurse', '30303.12');
insert into employee (name, post, salary) values ('Skippy Daintith', 'Information Systems Manager', '17700.11');
insert into employee (name, post, salary) values ('Chan Harkes', 'Nurse', '17761.16');
insert into employee (name, post, salary) values ('Ethelbert Doudny', 'Quality Engineer', '31492.07');
insert into employee (name, post, salary) values ('Gerome Scoon', 'Analyst Programmer', '24108.12');
insert into employee (name, post, salary) values ('Nanice Visick', 'Research Nurse', '41267.37');
insert into employee (name, post, salary) values ('Karlyn Breslane', 'Assistant Manager', '44383.57');
insert into employee (name, post, salary) values ('Dacy Bartkowiak', 'Account Executive', '15096.47');
insert into employee (name, post, salary) values ('Devonna Maddocks', 'Account Executive', '30422.25');
insert into employee (name, post, salary) values ('Conney Leonida', 'Human Resources Assistant II', '43641.32');
insert into employee (name, post, salary) values ('Whitman Gentiry', 'Civil Engineer', '36188.84');
insert into employee (name, post, salary) values ('Diannne McCraw', 'Budget/Accounting Analyst II', '34932.00');
insert into employee (name, post, salary) values ('Tann Olivetta', 'Assistant Professor', '24870.01');
insert into employee (name, post, salary) values ('Curtis Snare', 'Human Resources Assistant II', '42303.39');
insert into employee (name, post, salary) values ('Lannie Temperley', 'Recruiter', '24505.62');
insert into employee (name, post, salary) values ('Crista Barlee', 'Executive Secretary', '35245.27');
insert into employee (name, post, salary) values ('Allister Pittel', 'Help Desk Technician', '34634.97');
insert into employee (name, post, salary) values ('Humberto Goatman', 'Software Engineer III', '24998.45');
insert into employee (name, post, salary) values ('Birdie Eborn', 'Director of Sales', '32852.15');
insert into employee (name, post, salary) values ('Marena Vakhonin', 'Recruiting Manager', '34605.07');
insert into employee (name, post, salary) values ('Herold Calliss', 'Librarian', '20990.54');
insert into employee (name, post, salary) values ('Matthias MacCathay', 'Junior Executive', '37215.51');
insert into employee (name, post, salary) values ('Danny Blaymires', 'Junior Executive', '34758.63');
insert into employee (name, post, salary) values ('Marven McGeouch', 'Tax Accountant', '23213.03');
insert into employee (name, post, salary) values ('Elyse Ajam', 'Sales Associate', '31159.02');
insert into employee (name, post, salary) values ('Victoria Rignall', 'Administrative Officer', '37025.24');
insert into employee (name, post, salary) values ('Lonna Mettericke', 'Developer IV', '42481.79');
insert into employee (name, post, salary) values ('Daile Bengtsen', 'Structural Analysis Engineer', '17679.62');
insert into employee (name, post, salary) values ('Robbin Butfield', 'Paralegal', '39629.15');
insert into employee (name, post, salary) values ('Minda Beckmann', 'Health Coach III', '29215.54');
insert into employee (name, post, salary) values ('Ira Pettengell', 'Associate Professor', '40287.22');
insert into employee (name, post, salary) values ('Ninette Meadowcraft', 'Junior Executive', '22746.16');
insert into employee (name, post, salary) values ('Yvor Acott', 'Software Test Engineer I', '37423.16');
insert into employee (name, post, salary) values ('Tobe Mounfield', 'Senior Editor', '44748.42');
insert into employee (name, post, salary) values ('Harvey Stelle', 'Help Desk Technician', '26858.88');
insert into employee (name, post, salary) values ('Melodee Riby', 'Chief Design Engineer', '35059.58');
insert into employee (name, post, salary) values ('Adriana O''Leahy', 'Administrative Officer', '28522.31');
insert into employee (name, post, salary) values ('Case Haggleton', 'Editor', '21324.76');
insert into employee (name, post, salary) values ('Wheeler Jaime', 'Senior Sales Associate', '20639.79');
insert into employee (name, post, salary) values ('Danella Baxill', 'Paralegal', '19721.99');
insert into employee (name, post, salary) values ('Tani Kesper', 'Cost Accountant', '24711.07');
insert into employee (name, post, salary) values ('Cinnamon Hillhouse', 'Tax Accountant', '30983.18');
insert into employee (name, post, salary) values ('Nyssa Connechie', 'Tax Accountant', '23146.35');
insert into employee (name, post, salary) values ('Lilah Bootes', 'Associate Professor', '18772.54');
insert into employee (name, post, salary) values ('Celine Charlwood', 'Structural Engineer', '18224.68');
insert into employee (name, post, salary) values ('Jeno MacAndreis', 'Accountant III', '28930.91');
insert into employee (name, post, salary) values ('Elisabetta Chapleo', 'Cost Accountant', '28928.79');
insert into employee (name, post, salary) values ('Martina Berendsen', 'Sales Associate', '29309.10');
insert into employee (name, post, salary) values ('Storm Banishevitz', 'Web Designer IV', '26092.19');
insert into employee (name, post, salary) values ('Alla Dudliston', 'Recruiter', '25241.21');
insert into employee (name, post, salary) values ('Wandie Storch', 'Recruiter', '16861.64');
insert into employee (name, post, salary) values ('Eb Studdal', 'General Manager', '16753.49');
insert into employee (name, post, salary) values ('Ginnie Montague', 'Assistant Media Planner', '38460.63');
insert into employee (name, post, salary) values ('Rosabel Allwright', 'Pharmacist', '17296.94');
insert into employee (name, post, salary) values ('Hamel Crombie', 'Compensation Analyst', '22388.36');
insert into employee (name, post, salary) values ('Carlita Goodlake', 'Accountant II', '32149.65');
insert into employee (name, post, salary) values ('Vanessa Straffon', 'Media Manager I', '15144.08');
insert into employee (name, post, salary) values ('Rica McPheat', 'Technical Writer', '30531.05');
insert into employee (name, post, salary) values ('Curr Galbreath', 'VP Sales', '35895.04');
insert into employee (name, post, salary) values ('Muffin Shawl', 'Structural Engineer', '22324.13');
insert into employee (name, post, salary) values ('Granger Waldrum', 'Staff Accountant III', '30877.64');
insert into employee (name, post, salary) values ('Rancell Janout', 'Analog Circuit Design manager', '15721.99');
insert into employee (name, post, salary) values ('Leonard Medd', 'Mechanical Systems Engineer', '35218.72');
insert into employee (name, post, salary) values ('Maude Dagless', 'Web Designer IV', '37129.82');
insert into employee (name, post, salary) values ('Madelene Sanbrooke', 'Accounting Assistant III', '25707.38');
insert into employee (name, post, salary) values ('Gweneth Labrom', 'Programmer Analyst IV', '19209.52');
insert into employee (name, post, salary) values ('Emera Douglass', 'Assistant Professor', '21196.98');
insert into employee (name, post, salary) values ('Hagan Merrilees', 'Help Desk Technician', '22031.81');
insert into employee (name, post, salary) values ('Ericha Colicot', 'Clinical Specialist', '15511.56');
insert into employee (name, post, salary) values ('Ichabod Langworthy', 'Account Coordinator', '44324.28');
insert into employee (name, post, salary) values ('Bren Hallgath', 'Director of Sales', '33751.75');
insert into employee (name, post, salary) values ('Andras Ruprechter', 'Accountant II', '25226.14');
insert into employee (name, post, salary) values ('Kelsi McCaghan', 'Nurse', '30655.77');
insert into employee (name, post, salary) values ('Theda Junes', 'Account Coordinator', '28153.74');
insert into employee (name, post, salary) values ('Gwen Thwaites', 'Help Desk Operator', '39827.52');
insert into employee (name, post, salary) values ('Robin Heinz', 'Staff Accountant I', '21781.22');
insert into employee (name, post, salary) values ('Cathee Whetson', 'Human Resources Manager', '42989.11');
insert into employee (name, post, salary) values ('Roma Commusso', 'Safety Technician III', '23299.37');
insert into employee (name, post, salary) values ('Valma Hendrikse', 'Occupational Therapist', '36042.18');
insert into employee (name, post, salary) values ('Aurelia Maudett', 'Software Engineer III', '38072.67');
insert into employee (name, post, salary) values ('Mara Stopforth', 'VP Product Management', '40556.08');
insert into employee (name, post, salary) values ('Terese Reisen', 'Occupational Therapist', '38509.54');
insert into employee (name, post, salary) values ('Emmery Stanners', 'Safety Technician II', '20691.59');
insert into employee (name, post, salary) values ('Frederica Fellos', 'Developer IV', '41770.53');
insert into employee (name, post, salary) values ('Marijn Comusso', 'Database Administrator III', '30908.14');
insert into employee (name, post, salary) values ('Kahaleel Dresse', 'Project Manager', '18544.18');
insert into employee (name, post, salary) values ('Prisca Habberjam', 'Computer Systems Analyst I', '38973.98');
insert into employee (name, post, salary) values ('Yorgos Clissell', 'Environmental Specialist', '30078.66');
insert into employee (name, post, salary) values ('Linette Mouatt', 'Help Desk Technician', '28436.19');
insert into employee (name, post, salary) values ('Silvio Bruhnicke', 'Data Coordiator', '33037.34');
insert into employee (name, post, salary) values ('Christiano Valdes', 'Executive Secretary', '33652.46');
insert into employee (name, post, salary) values ('Lemmie Fosken', 'Sales Associate', '20707.33');
insert into employee (name, post, salary) values ('Athene Yggo', 'Social Worker', '41241.84');
insert into employee (name, post, salary) values ('Estella Berthon', 'Analyst Programmer', '40690.56');
insert into employee (name, post, salary) values ('Jozef Sweetenham', 'Business Systems Development Analyst', '44809.19');
insert into employee (name, post, salary) values ('Perla Conigsby', 'Nurse Practicioner', '15134.08');
insert into employee (name, post, salary) values ('Conrad Habishaw', 'Sales Associate', '34007.97');
insert into employee (name, post, salary) values ('Serge Newberry', 'Nurse Practicioner', '32153.39');
insert into employee (name, post, salary) values ('Charyl Bullingham', 'Registered Nurse', '31954.34');
insert into employee (name, post, salary) values ('Charlean Carlisi', 'Software Test Engineer III', '26822.36');
insert into employee (name, post, salary) values ('Rudy La Grange', 'Assistant Professor', '41167.96');
insert into employee (name, post, salary) values ('Mufi Cutbirth', 'Health Coach I', '24082.96');
insert into employee (name, post, salary) values ('Hank Nockells', 'Account Representative III', '16503.20');
insert into employee (name, post, salary) values ('Lizette Rudram', 'GIS Technical Architect', '24831.12');
insert into employee (name, post, salary) values ('Emerson Byass', 'Analog Circuit Design manager', '36023.11');
insert into employee (name, post, salary) values ('Nathalia Bard', 'Recruiter', '31838.01');
insert into employee (name, post, salary) values ('Moyna Woffenden', 'Executive Secretary', '15705.00');
insert into employee (name, post, salary) values ('Giorgio Harvatt', 'Computer Systems Analyst II', '35911.24');
insert into employee (name, post, salary) values ('Ken Souch', 'Community Outreach Specialist', '26733.04');
insert into employee (name, post, salary) values ('Shelia Dosdell', 'Geological Engineer', '28350.25');
insert into employee (name, post, salary) values ('Dolf Mildmott', 'Research Nurse', '42334.56');
insert into employee (name, post, salary) values ('Joceline Bellhouse', 'VP Accounting', '24574.80');
insert into employee (name, post, salary) values ('Gert Strother', 'Programmer Analyst III', '16104.73');
insert into employee (name, post, salary) values ('Freedman Knightsbridge', 'Research Nurse', '15711.13');
insert into employee (name, post, salary) values ('Paulina Napoleone', 'Design Engineer', '29125.37');
insert into employee (name, post, salary) values ('Garreth Brunner', 'Graphic Designer', '23927.16');
insert into employee (name, post, salary) values ('Finn Foley', 'Marketing Assistant', '16729.03');
insert into employee (name, post, salary) values ('Abdel Habbergham', 'Nuclear Power Engineer', '18456.22');
insert into employee (name, post, salary) values ('Martelle Wilcocks', 'General Manager', '24863.20');
insert into employee (name, post, salary) values ('Ulrike Dorsett', 'Programmer Analyst IV', '44270.37');
insert into employee (name, post, salary) values ('Tiebold Boxell', 'Research Associate', '35287.34');
insert into employee (name, post, salary) values ('Gabriela Keene', 'Operator', '31328.39');
insert into employee (name, post, salary) values ('Karol Kroon', 'Graphic Designer', '39341.43');
insert into employee (name, post, salary) values ('Christiana Thomassin', 'Automation Specialist II', '21583.25');
insert into employee (name, post, salary) values ('Lanae Pollendine', 'Help Desk Technician', '19266.69');
insert into employee (name, post, salary) values ('Daryl Debrett', 'Compensation Analyst', '36030.57');
insert into employee (name, post, salary) values ('Anthea Stovine', 'Quality Engineer', '31047.53');
insert into employee (name, post, salary) values ('Morna Kenshole', 'Nurse Practicioner', '24104.92');
insert into employee (name, post, salary) values ('Ianthe Dadge', 'Statistician II', '35153.99');
insert into employee (name, post, salary) values ('Juliana Durran', 'Programmer Analyst I', '36455.21');
insert into employee (name, post, salary) values ('Kerby Ovey', 'Nuclear Power Engineer', '15758.59');
insert into employee (name, post, salary) values ('Cymbre Chaloner', 'Research Nurse', '39677.87');
insert into employee (name, post, salary) values ('Onfre O''Leary', 'Desktop Support Technician', '28059.94');
insert into employee (name, post, salary) values ('Joli Dericot', 'Actuary', '40357.26');
insert into employee (name, post, salary) values ('Berkley Manolov', 'Staff Accountant I', '15631.91');
insert into employee (name, post, salary) values ('Lanny Boule', 'Assistant Media Planner', '35315.29');
insert into employee (name, post, salary) values ('Jillana Frossell', 'Geological Engineer', '22136.81');
insert into employee (name, post, salary) values ('Winonah Aldwick', 'Geologist II', '27627.09');
insert into employee (name, post, salary) values ('Cheryl Arch', 'Research Associate', '37702.79');
insert into employee (name, post, salary) values ('Marilee Sawart', 'Senior Financial Analyst', '37131.90');
insert into employee (name, post, salary) values ('Leo Smeeth', 'Developer II', '30620.16');
insert into employee (name, post, salary) values ('Paulie Kumaar', 'Web Designer III', '16391.05');
insert into employee (name, post, salary) values ('Lavinia Poston', 'Geological Engineer', '27429.27');
insert into employee (name, post, salary) values ('Kara Dinsale', 'Physical Therapy Assistant', '23532.82');
insert into employee (name, post, salary) values ('Bevan Danovich', 'Data Coordiator', '20540.23');
insert into employee (name, post, salary) values ('Kitty Dryden', 'Safety Technician III', '23946.41');
insert into employee (name, post, salary) values ('Kari Crumby', 'Actuary', '39850.56');
insert into employee (name, post, salary) values ('Tonya Mitford', 'Financial Analyst', '41674.46');
insert into employee (name, post, salary) values ('Arly Konneke', 'Programmer III', '37557.27');
insert into employee (name, post, salary) values ('Susannah Figure', 'Speech Pathologist', '25269.11');
insert into employee (name, post, salary) values ('Noby Pleace', 'Product Engineer', '30763.95');
insert into employee (name, post, salary) values ('Noble Dimitrov', 'Accountant IV', '43882.37');
insert into employee (name, post, salary) values ('Tracey Klain', 'VP Accounting', '21825.02');
insert into employee (name, post, salary) values ('Elfreda St. Hill', 'Automation Specialist II', '41942.18');
insert into employee (name, post, salary) values ('Reynold McGuffie', 'Pharmacist', '26753.82');
insert into employee (name, post, salary) values ('Brett Arndell', 'Recruiter', '24550.51');
insert into employee (name, post, salary) values ('Tina Dalliston', 'Senior Cost Accountant', '28801.87');
insert into employee (name, post, salary) values ('Natalina Batterbee', 'Senior Editor', '40407.94');
insert into employee (name, post, salary) values ('Chas Sherrell', 'Staff Accountant IV', '31586.68');
insert into employee (name, post, salary) values ('Billye Harrell', 'Sales Associate', '37398.09');
insert into employee (name, post, salary) values ('Pat Yurkov', 'Financial Advisor', '15042.83');
insert into employee (name, post, salary) values ('Raimund Aberdein', 'Engineer II', '26591.36');
insert into employee (name, post, salary) values ('Ingrid Balke', 'Graphic Designer', '15229.72');
insert into employee (name, post, salary) values ('Midge Bourgourd', 'Mechanical Systems Engineer', '40389.36');
insert into employee (name, post, salary) values ('Marc Dugdale', 'Programmer Analyst I', '42515.63');
               
-- After executing the script below, the only managers appear.

SELECT 
    *
FROM
    employee
WHERE
    post LIKE '%Manager';