Description
Description: In this workshop assignment, you will practice connecting to Oracle using Thin and OCI drivers and learn how to call PL/SQL stored procedure in Java program. Create a Java project called Workshop10 in Eclipse. Then finish the following tasks: 1. Create a class named ShowEmpInfoByID which will query the employees table in your Oracle database for the employee’s full name, email and salary by given employee ID, such 180. Display them in console. Use Oracle OCI database driver to implement the connection. 2. Using Oracle SQL Developer, create a PL/SQL stored procedure named total_emp_by_dept_id, which has two parameters: IN – department ID; OUT – total number of employees in the department. Ensure the procedure is compiled without error and works properly. 3. In Eclipse, create a class named ShowTotalEmpByDeptID which will obtain the number of employees in a department by department id, such as 80, through calling PL/SQL stored procedure total_emp_by_dept_id. Show the number in console. Use Oracle Thin database driver to implement the connection. 4. Create a folder support in the project base folder in Eclipse. Create a file total_emp_by_dept_id.sql in the support folder. The content of the file is the PL/SQL script that generates the stored procedure. JAC – 444 Semester —- Workshop Header /********************************************** Workshop # Course: – Semester Last Name: First Name: ID: Section:
This assignment represents my own work in accordance with Seneca Academic Policy. Signature Date: **********************************************/ Code Submission Criteria: Please note that you should have: • Appropriate indentation. • Proper file structure • Follow java naming convention • Document all the classes properly • Do Not have any debug/ useless code and/ or files in the assignment • Do not have everything in the main method. • Have a separate TestClass with the main method in it. • Check your inputs if the user is not entering garbage inputs. • Use exceptional handling or other methods to let the user know if the inputs are incorrect. JAC – 444 Semester —- Deliverables and Important Notes: All these deliverables are to be uploaded on the blackboard once done. • You are supposed to create video/ record voice/ detailed document of your running solution. (20%) o Screen Video captured file should state your last name and id, like Ali_123456.mp4 (or whatever the extension of the file is) o Record voice clip should also include a separate word file with the screen shots of your program’s output, state your last name and id, like Ali_123456.mp3 (or whatever the extension of the file is) o Detailed document should include screen shots of your output, have your name and id on the top of the file and save the file with your last name and id, like li_123456.docx (or whatever the extension of the file is). • A word/ text file which will reflect on learning of your concepts in this workshop. Also include the instructions on how to run your code. (30%) o Should state your Full name and Id on the top of the file and save the file with your last name and id, like Ali_123456.txt • Submission of working code. (50%) o Make sure your follow the “Code Submission Criteria” mentioned above. o You should zip your whole working project to a file named after your Last Name followed by the first 3 digits of your student ID. For example, Ali123.zip. • Your marks will be deducted according to what is missing from the above-mentioned submission details. • For Late submissions, please refer to the late policy for the course. • Remember that you are encouraged to talk to each other, to the instructor, or to anyone else about any of the assignments, but the final solution may not be copied from any source.
