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(); . . . . . . . . .