Java | JSP | JSF Answers

Implement the concept of inheritance with example. 

“Code reuse is strong features of java” proof this statement.

Implement a standalone product search program in Java that lists matching products for a user who is looking for T-shirts.

You are given 3 CSV files, each containing the T-shirts data for Nike, Puma and Adidas respectively. Sample CSV files links are attached here for reference. You can add more data in existing files or can add more CSV files for another companies.

Create a Java program that simply outputs the text "Hello World" when you run it. Call your main class

"Application". In the same file as your main "Application" class, define a new class called "Person". You

don't need to put anything in the class. Now, right below where you output "Hello World" in your main

method, create an object from that (Person) class. Modify your "Person" class to add a constructor.

Make the constructor output the text "Constructor running!". Add another constructor in addition to

the constructor it's already got. Make this second constructor accept a parameter called name of type

String. Make this second constructor print the name parameter using System.out.println(). Finally,

change your "main" method, create two objects of Person class and call both constructors.

Write a program with a mother class animal. Inside it define a name and an age variables, and

set_value() method.Then create two instance variables Zebra and Dolphin which write a message

telling the age, the name and giving some extra information (e.g. place of origin).

Create a class called Book to represent a book. A Book should include four pieces of information as

instance variables‐a book name, an ISBN number, an author name and a publisher. Your class should

have a constructor that initializes the four instance variables. Provide a mutator method and accessor

method (query method) for each instance variable. In addition, provide method named getBookInfo

that returns the description of the book as a String (the description should include all the information

about the book). You should use this keyword in member methods and constructor. Write a test

application named BookTest to create an array of object for 30 elements for class Book to demonstrate

the class Book's capabilities.

Write a program with a mother class animal. Inside it define a name and an age variables, and

set_value() method.Then create two instance variables Zebra and Dolphin which write a message

telling the age, the name and giving some extra information (e.g. place of origin).

Create a console calculator application that:

 Takes one command-line argument; your name and surname. When the program 

starts, display the date with a welcome message for the user.

 Displays all the available options to the user. Your calculator must include the 

arithmetic operations, as well at least five scientific operations of the Math class. 

Your must also have the ability to round a number and truncate it. 

 Includes sufficient error checking to ensure that the user only enters valid input. 

 Make use of a menu. You should give the user the option to end the program 

when he or she enters a certain option.

 Displays a message for the user, stating the current time, and calculates and 

displays how long the user used your program, when the program exits.

 Makes use of helper classes (where possible)

The school of Computing and Mathematical Sciences is open for registration of ICT qualifications. Create a registration form that accepts a prospective student’s name, surname, race, gender, cellphone number, email address, home address and the ICT qualification the student wishes to apply for (Diploma in ICT: Applications Development, Advanced Diploma in ICT: Application Development, Post Graduate Diploma in ICT: Applications Development). Upon completion of the form, the prospective student must agree to the terms and conditions of the university by selecting a checkbox and submit the form. Insert this data into the database. Also include a delete and update button. 

NB: Please align your textboxes and text fields

1.1)

Given the vehicle table and data above, write down the SQL statement to create 

and populate the table.

(5)

1.2)

Write an SQL query that updates the BMW to Volkswagen and mileage to 65000

(3)

1.3)

Write an SQL query to display the customer id, customer email, vehicle make, 

model and amount. In your query include 10% discount and the total discounted 

amount.

(10)

1.4)

Write an SQL query that displays the different years of vehicles.

(2)

1.5)

Write an SQL query that will display vehicles made in 2018 only.

(2)

1.6)

Write an SQL query to rename the table vehicle to Car.

(2)

1.7)

Write an SQL query to delete the Car table.

(2)

Write an SQL query to display customer full names, the car make, model, year and 

amount.

(7)

1.8)

Write a php form to save a name and a picture into the database.

(6)