Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database And SQL

Authors: Lucy Scott

3rd Edition

1087899699, 978-1087899695

More Books

Students also viewed these Databases questions

Question

Compare the current team to the ideal team.

Answered: 1 week ago

Question

Are the rules readily available?

Answered: 1 week ago

Question

Have ground rules been established for the team?

Answered: 1 week ago