Alert dont submit aI generated answer. Read the following program and describe what the program does. Write comments in the program listing to follow “//” to show that you understand this program. import java.io.*; import java.sql.*; public class Example { public static void main(String args[]) throw SQLException, IOException { try { // // Class.forName(“oracle.jdbc.driver.OracleDriver”); } // // catch (ClassNotFoundException ex){ System.out.println(“Driver could not be loaded”); return; } // // String url = “jdbc:oracle:www.bookstore.com:3083”; // // Connection con; try { // // con = DriveManager.getConnection(url, userId, password); // // String sqlQuery = “SELECT isbn, title FROM Books WHERE publisher = ‘MIT Press’”; // // PreparedStatement stmt = con.prepareStatement(sqlQuery); // // ResultSet rs = stmt.executeQuery(sqlQuery); String isbn, title; System.out.println(“isbn title”); // // while (rs.next()) { isbn = rs.getString(1); title = rs.getString(“TITLE”); System.out.println(isbn + “ “ + title); } } // // catch(SQLException ex) { System.out.println(“ex.getMessage()); } } }
Alert dont submit
Read the following
import java.io.*;
import java.sql.*;
public class Example {
public static void main(String args[]) throw SQLException, IOException {
try {
//
//
Class.forName(“oracle.jdbc.driver.OracleDriver”);
}
//
//
catch (ClassNotFoundException ex){
System.out.println(“Driver could not be loaded”);
return;
}
//
//
String url = “jdbc:oracle:www.bookstore.com:3083”;
//
//
Connection con;
try {
//
//
con = DriveManager.getConnection(url, userId, password);
//
//
String sqlQuery =
“SELECT isbn, title FROM Books WHERE publisher = ‘MIT Press’”;
//
//
PreparedStatement stmt = con.prepareStatement(sqlQuery);
//
//
ResultSet rs = stmt.executeQuery(sqlQuery);
String isbn, title;
System.out.println(“isbn title”);
//
//
while (rs.next()) {
isbn = rs.getString(1);
title = rs.getString(“TITLE”);
System.out.println(isbn + “ “ + title);
}
}
//
//
catch(SQLException ex) {
System.out.println(“ex.getMessage());
}
}
}
Step by step
Solved in 3 steps
