Question: Report Em Multi File Programming Question Marks : As a supermarket manager, I need to search the items available in my store. So, create a

Report Em Multi File Programming Question Marks : As a supermarket manager, I need to search the items available in my store. So, create a class Item Type with the following private attributes 1. id as long 2. name as String 3. deposit and costPerDay as Double Generate appropriate constructors, getters and setters. Create a class Item Type DAO with the following methods 1. public Item Type getItemType(int id) - Finds all details of Item Type based on Item returns Create a class Item TypeDAO with the following methods 7. public Item Type getitem Type(int id) - Finds all details of Item Type based on Item id ar returns Use below Database Credentials 1. Driver Class : 2. Default DB URL 3. Default USER : 4. Default PWD : com.mysql.jdbc.Driver : jdbc:mysql://localhost/rootuser rootuser rootuser Create a driver class Main to display the Item details. Note: Use System.out.format("%-55 %-15s %-10s %s ","ID","Name", "Deposit", "Cost perc display Item Type details. Table Details Table Name : itemtype id out.format("%-55 %-15s %-10s %s ", "ID","Name","Deposit", "Cost per day") to display Item Type details. Table Details Table Name : itemtype id int name varchar(20) deposit double costperday double Input format Item ID to search in first line Output format Item details as shown in sample output(use the format statement given) Sample testcases Input 1 Output 1 ID Name Deposit Cort Technical Table Details Table Name : itemtype id int name varchar(20) deposit double costperday double Input format Item ID to search in first line Output format Item details as shown in sample output(use the format statement given) Sample testcases Input 1 Output 1 2 ID Name Deposit 2 Electronics 85000.0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!