Database: You must run codes in the given file "database.sql" to create the database [PE_PRJ301] and use it in the practical exam.
tblProductstable
Field name
datatype
Note
productID
productName
Primary Key
Not null
char(5)
varchar(50)
description
price
status
Not null
varchar(500)
Float
Bit
Not null
Not null
Requirements:
Create a the application, which can be used for shopping. The application have the following
functions:
No
1
Function
Description
Display
Create a "get all" button on shopping.jsp page
products
Click "get all" button to get all products has status is active.
Display with productID, productName, description, price.
Shopping Page
x +
← localhost:8080/PE PRJ301 SPRING23/MainController
[email protected] [email protected] 150 Tôn Đức Thắng 2 LMS
Welcome to Thinh's shop
get all
No Product ID Product Name Description Price 1P001 Mouse chuot may tinh 10.0
Mark
3
Zoom
+ 100%
Close
