Repeat Exercise 10.7 and 10.9, but use JDBC with Java as the host language. Referen...

Repeat Exercise 10.7 and 10.9, but use JDBC with Java as the host language.

Reference 10.7

Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. Write a program segment to read a student’s name and print his or her grade point average, assuming that A = 4, B = 3, C = 2, and D = 1 points. Use embedded SQL with C as the host language.

Reference 10.9

Consider the library relational database schema in Figure 6.6. Write a program segment that retrieves the list of books that became overdue yesterday and that prints the book title and borrower name for each. Use embedded SQL with C as the host language.