The instructions are in the pictures. & here is the given code that's needs to be modified I already added in the derby.jar too.

: import java.sql.*;

public class DBTesterApp

{

private static Connection connection = null;

public static void main(String args[])

{

// get the connection and start the Derby engine

connection = MurachDB.getConnection();

if (connection != null)

System.out.println("Derby has been started. ");

// select data from database

printProducts();

printFirstProduct();

printLastProduct();

printProductByCode("java");

// modify data in the database

Product p = new Product("test", "Test Product", 49.50);

insertProduct(p);

printProducts();

deleteProduct(p);

printProducts();

// disconnect from the database

if (MurachDB.disconnect())

System.out.println("Derby has been shut down. ");

}

public static void printProducts()

{

try (Statement statement = connection.createStatement();

ResultSet rs = statement.executeQuery("SELECT * FROM Products"))

{

Product p = null;

System.out.println("Product list:");

while(rs.next())

{

String code = rs.getString("ProductCode");

String description = rs.getString("Description");

double price = rs.getDouble("Price");

p = new Product(code, description, price);

printProduct(p);

}

System.out.println();

}

catch(SQLException e)

{

e.printStackTrace(); // for debugging

}

}

public static void printFirstProduct()

{

Product p = null;

String code = rs.getString("ProductCod"); // add code that prints the record for the first product in the Products table

System.out.println("bvbn:");

printProduct(p);

System.out.println();

}

public static void printLastProduct()

{

Product p = null;

// add code that prints the record for the last product in the Products table

System.out.println("Last product:");

printProduct(p);

System.out.println();

}

public static void printProductByCode(String productCode)

{

Product p = null;

// add code that prints the product with the specified code

System.out.println("Product by code: " + productCode);

printProduct(p);

System.out.println();

}

public static void insertProduct(Product p)

{

System.out.println("Insert test: ");

// add code that inserts the specified product into the database

// if a product with the specifed code already exists, display an error message

printProduct(p);

System.out.println();

}

private static void deleteProduct(Product p)

{

System.out.println("Delete test: ");

// add code that deletes the specified product from the database

// if a product with the specified code doesn't exist, display an error message

printProduct(p);

System.out.println();

}

// use this method to print a Product object on a single line

private static void printProduct(Product p)

{

String productString =

StringUtils.padWithSpaces(p.getCode(), 8) +

StringUtils.padWithSpaces(p.getDescription(), 44) +

p.getFormattedPrice();

System.out.println(productString);

}

}

metadata. To do this, you may need to convert SQL data types to Java data types. Exercise 21-1 Work with JDBC In this exercise, you'll write JDBC code that works with the Derby database named MurachDB that was described in the previous chapter. 1. Open the project named ch21_ex1_DBTester that's in the ex_starts directory Add the derby.jar file to the Libraries folder for this project. Review the code in the source files and run the project. It should print all of the records in the Products table to the console three times with some blank product lines in between. 2