Advanced Java Programming20805 marksDDL and DML Operations using Java, Prepared Statements, Mult
Assume a table MOVIE(id, title, genre). Now, using JDBC, perform the following queries; a. Add any three records to the MOVIE table. b. Using a prepared statement, update the genre to 'Comedy' having the title 'Jatra'.
Assume a table MOVIE(id, title, genre). Now, using JDBC, perform the following queries; a. Add any three records to the MOVIE table. b. Using a prepared statement, update the genre to 'Comedy' having the title 'Jatra'. [5]
--- --- Step Method Used Purpose ---------------------------- Load driver Class.forName() Registers MySQL JDBC driver Connect DriverManager.getConnection() Opens DB connection Insert records stmt.executeUpdate() Returns number of rows affected Prepared statement con.prepareStatement(sql) Pre-comp...