Using Table Example Create Query Return Number Books Author 999 Label Results Books Isaac Q37149455

Using this table as an example, create a query that will returnthe number of books by author 999 but label the results “Books byIsaac”

Solution

`Hey,

Note: Brother in case of any queries, just comment inbox I would be very happy to assist all your queries

import java.util.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import java.lang.ClassNotFoundException;
public class DatabaseQueryDemo extends JFrame
{
private Connection con;
private Statement st;
private JComboBox queryInput;
private JButton btnSubmit;
private JTextField txtInput;
private ResultSet resSet;
private ResultSetMetaData resMeta;
private JTable tbl;
public DatabaseQueryDemo()
{
super( “Select Query. Click Submit to See Results.” );
// The URL specifying the books database to
     //which this program connects to usingJDBC
String url = “jdbc:db2j:books”;
// Load

OR

 

OR