Answer Happy

Need answer for question (b)
The Department of Computer Scienc requires a new record keeping method to store information about organization that accepts students for internship. The organization details for database table is given in Table 1. Table 1: OrgDetails # 1 2 3 4 5 supervisor 6 Name organizationID • • Action • Method name address phone varchar(30) varchar(100) varchar(30) varchar(30) departmentAssigned varchar(30) The form will be used by the coordinator to store the information about the organization. Please code in HTML and/or JSP for the following processes. a) Produce a form to insert all the information above based on the following: File name : insertData.html Form name: organizationDetails Type Auto increment : organization_addnew.jsp : post Items in Department are: • I.T • Human Resource Finance Operation
2 ID 1 Alw 3 4 -Organization Details- Oganization Name • • 5 Adress Phone Supervisor Department Submit Reset b) Write Below are the database connection information: SP code to store all the information into the table "OrgDetails". File name Host Username Password Database name .. Oganization Name Compuland Netboy ZR PC Libra Comp Comp Savvy I.T : dbconn.jsp : localhost : intern : intern123 : dblntern c) Write a code to view the organization details on the result page as shown in the figure below. Apply JSTL in your codes. Show an error message if the connection is unsuccessful. Show appropriate message once the data is saved. Address Kangar Arau Kangar Kuala Perlis Padang Besar (10 marks) Phone 9794552 9584321 9763321 9248872 9631174 Supervisor Sam Azlan Alvin Simon Serena (10 marks) Department Human Resource Finance LT Operation Finance