Repository for programs related to JDBC and MySQL connectivity
Consider relational schema Employees (Emp_ID, First_name, Last_name, Salary, Dept_ID, Email, City) and perform the following:
-
Write a program for creating a table. -
Write a program for inserting records into table. -
Write a program for retrieving records from table. -
Write a program for updating records into table. -
Write a program for deleting records from table. -
Write a program for retrieving records in ascending order by first name from table. -
Write a program to display the department number and average salary for each department. -
Write a program to display all records from table where city name is 'Delhi, 'Chandigarh' and 'Mumbai'.