You need to embed a SQL query into a Java program using the…

You need to embed a SQL query into a Java program using the JDBC API. Analyze the Java block shown below and fill the blanks to enter the lines of code needed to embed a SQL query to retrieve the name of a drone, the capacity, and the distanceTraveled from a table Rental. The user already provided the drone name, and it is stored in a string variable droneName. The connection to the database is already established, and it’s using the variable conn. NOTE: If any of the blank lines is not needed, enter ” None”.   To end each line, type/include “; ” Rental Dname BatteryLife distanceTraveled Capacity Jasper 10 27 30 SuperD 15 35 22 Invincible 40 21 4   Line 1:       String sql = Line 2:       Line 3:       Line 4:       ResultSet rs = qstm.executeQuery();                  . . . . .                  . . . .  

You need to embed a SQL query into a Java program using the…

You need to embed a SQL query into a Java program using the JDBC API. Analyze the Java block shown below and fill the blanks to enter the lines of code needed to complete embedding a SQL query to retrieve the name of a drone, the capacity, and the distanceTraveled from a table Rental. The user already provided the drone name, and it is stored in a string variable droneName. The connection to the database is already established, and it’s using the variable conn. NOTE: If any of the blank lines is not needed, enter ” None”.   To end each line, type/include “; ” Rental Dname BatteryLife distanceTraveled Capacity Jasper 10 27 30 SuperD 15 35 22 Invincible 40 21 4   Line 1:       String sql = Line 2:       Line 3:       Line 4:       ResultSet rs = qstm.executeQuery();                  . . . . .                  . . . .