Column Name Description Author Author of the book
Column Name Description Author Author of the book Price Price of the book The MusicShop table contains the description of available music titles: Column Name Description ItemNo Unique identifier for the music album ItemType CD/Cassette Title Title of the album Artist Artist Price Price of the album The Transaction table contains the records of user’s transactions: Column Name Description OrderNo Unique identifier for the user’s transaction. UserId User id of the user. ItemNo Unique identifier identifying the item. There must be a corresponding row for this item in either MusicShopor BookShop table. Quantity Number of ItemNo items ordered by the user. Date Date when the user did the transaction. Status Status of the item shipped/pending. The Session table, stores the data of PHP sessions: Column Name Description lastAccessed Time when the session was last accessed Id Unique session identifier Data Session data Database User One database user, PHP, is created for the shopping cart application. All the PHP scripts in the middle tier connect to the back-end database as user PHP. This user has all privileges on the tables of the shopping cart application. We need SQL commands for granting privileges on the tables in the shop database to the user PHP. To do so, execute the following SQL statement. The mysqlutility can be used for executing SQL commands. mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON shop.* TO ‘PHP@localhost’ IDENTIFIED BY “PHP”; Page 548
Hint: If you are looking for good and high quality web space to host and run your java application check Vision java web hosting services