Consider the following relations for a company database:• emp (ename, dname, salary)• mgr (ename, mname)and the Java code in Figure 5.20, which uses the JDBC API. Assume that the userid, password, machine name, etc. are all okay. Describe in concise English what the Java program does. (That is, produce an English sentence like “It finds v the manager of the toy department,” not a line-by-line description of what each Java statement does.) import java.sql.*:public class Mystery {public static void main(Stringt) args) {try (Connection con=DriverManager.getConnection"jdbc:oracle:thin:star/X@//edgar.cse.lehigh.edu:1521/XE");q = "select mname from mgr where ename = ?":Preparedstatement stmt=con.prepareStatement);String qString empName = "dog":boolean more;ResultSet result;do {stmt.setString(1, empName);result = stmt.executeQuery(q);more = resultnext();if (more) {empName = resultgetstring("mname");System.outprintin (empName);} while (more);s.close();con.close();}catch(Exception e){e.printstackTrace();Figure 5.20 Java code for Exercise 5.1 (using Oracle JDBC).

JDBC stands for Java DataBase Connectivity. JDBC is an API that allows the user to connect to the…

Answered: import java.sql.*: public class Mystery…

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

Consider the following relations for a company database:
• emp (ename, dname, salary)
• mgr (ename, mname)
and the Java code in Figure 5.20, which uses the JDBC API. Assume that the userid, password, machine name, etc. are all okay. Describe in concise English what the Java program does. (That is, produce an English sentence like “It finds v the manager of the toy department,” not a line-by-line description of what each Java statement does.)