In this application, there is a Dropdown List control, which displays the name of the Shop. This data is taken from a table named tblShop. Assuming your program has successfully loaded the appropriate JDBC driver and established the connection to dbPerdana database, write a fragment of Java source code that will display the store name in Dropdown List using Statement object. (refer Figure 1a).

Table la: Tables and columns No. Table Column 1. tblCustomer [ID] INT IDENTITY (1, 1) NOT NULL (PK) [Id_Scan] NCHAR (8) NULL [Id_Shop] NCHAR (8) NULL [Name] NVARCHAR (35) NULL 2. tblShop 3. tblScan [Phone] VARCHAR (12) NULL [Id_Shop] NCHAR (8) NOT NULL (PK) [Shop] NVARCHAR (35) NULL [Id_Scan] NCHAR (8) NOT NULL (PK) [Temperature] NVARCHAR (15) NULL Legend: (PK) - Primary Key c) In this application, there is a Dropdown List control, which displays the name of the Shop. This data is taken from a table named tblShop. Assuming your program has successfully loaded the appropriate JDBC driver and established the connection to dbPerdana database, write a fragment of Java source code that will display the store name in Dropdown List using Statement object. (refer Figure la). (6 marks) Perdana Mall Skudai Your safety is our utmost priority, please provide us your personal information together with the date and time of visit for record purposes. This collection of information is in accordance with Kickers Adidas Benang Hijau Uniqlo Daiso H&M Baskin Robbins Red Lobster Kickers Figure la: Dropdown list control to select Shop. Table la: Tables and columns No. Table Column 1. tblCustomer [ID] INT IDENTITY (1, 1) NOT NULL (PK) [Id_Scan] NCHAR (8) NULL [Id_Shop] NCHAR (8) NULL [Name] NVARCHAR (35) NULL 2. tblShop 3. tblScan [Phone] VARCHAR (12) NULL [Id_Shop] NCHAR (8) NOT NULL (PK) [Shop] NVARCHAR (35) NULL [Id_Scan] NCHAR (8) NOT NULL (PK) [Temperature] NVARCHAR (15) NULL Legend: (PK) - Primary Key c) In this application, there is a Dropdown List control, which displays the name of the Shop. This data is taken from a table named tblShop. Assuming your program has successfully loaded the appropriate JDBC driver and established the connection to dbPerdana database, write a fragment of Java source code that will display the store name in Dropdown List using Statement object. (refer Figure la). (6 marks) Perdana Mall Skudai Your safety is our utmost priority, please provide us your personal information together with the date and time of visit for record purposes. This collection of information is in accordance with Kickers Adidas Benang Hijau Uniqlo Daiso H&M Baskin Robbins Red Lobster Kickers Figure la: Dropdown list control to select Shop