Database: ebookshop Table: books | title | author I (VARCHAR (50)) I (FLOAT) I (INT) I | id | (INT) | (VARCHAR (50)) I price I qty | 1001 | Java for dummies | 1002 | More Java for dummies | 1003 |...

Create a table “books” in the database (name:ebookshop) with the following fields
Table 1.
• Write a code to establish a connection with the data source you want to use.
• Create a webform request for the user to check the book information by id.
• Write a SQL query and execute the query via the SQL SELECT Statement and SQL UPDATE
Statement.
• Process the query result.

Extracted text: Database: ebookshop Table: books | title | author I (VARCHAR (50)) I (FLOAT) I (INT) I | id | (INT) | (VARCHAR (50)) I price I qty | 1001 | Java for dummies | 1002 | More Java for dummies | 1003 | More Java for more dummies | Mohammad Ali | 1004 | A Cup of Java | 1005 | 11.11 | 22.22 | 33.33 | 44.44 | 55.55 | Tan Ah Teck | Tan Ah Teck 11 | 22 33 | Kumar | Kevin Jones 44 |A Teaspoon of Java 55 |