(a) Given the following method header:public boolean addMovie(Movie movie)Complete the implementation of the method above to insert a new movie into the Movies table in thedatabase. Your method should return true if an insert is successful, and false if an insert fails. You candetect a successful insert through the number of rows returned after the execution of a query. UsePreparedStatement in your answer and include the appropriate exception handling. The Movie classand database table structure specifications are shown in Figure 2.1 and Figure 2.2 below: public class Movie{private String id;private String name;private String category;private double price;public Movie () {}public Movie (String id, String name, String category, double price) {this.id = id;this.namename;this.category = category;this.price = price;}public String getId() {return id;public String getName () {return name;public String getCategory()return category;public double getPrice () {return price;}Figure 2.1: Movie Class Table StructureSample DataNBUSERМах. гows: 100Fetched Rows: 121 Matching Rows:TablesMOVIEIDMOVIENAMECATEGORYPRICEMOVIESCo01Comedy150 First Dates25.9MOVIEID2Co02Lady BirdComedy35.93Co03The Other GuysComedy29.9MOVIENAMΜΕ4C004Dolemite Is My Name Comedy30.0CATEGORY5Co05Between Two Ferns Comedy21.5H101In The Tall GrassHorror12.9PRICEH102CargoHorror21.98.H103The RitualHorror29.99н104HushHorror28.510H105The GuestThriller28.511R201The NotebookRomance21.912R202Eat Pray LoveRomance21.9Figure 2.2: Movies database table structure and sample data

As per the requirement program is developed. In the program, Connection…

Answered: (a) Given the following method header:…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

(a) Given the following method header:

public boolean addMovie(Movie movie)

Complete the implementation of the method above to insert a new movie into the Movies table in the
database. Your method should return true if an insert is successful, and false if an insert fails. You can
detect a successful insert through the number of rows returned after the execution of a query. Use
PreparedStatement in your answer and include the appropriate exception handling. The Movie class
and database table structure specifications are shown in Figure 2.1 and Figure 2.2 below: