Chapter 23, Problem 6PE

Program Plan Intro

Program plan:

ReportPrintDB.java

• Import required packages.
• Create a class named “ReportPrintDB”.
  • Create function “main()”.
    • Check whether the length of command line argument is zero or not using “if” condition.
      • If the condition is true, then print the message that there is no command line argument.
      • End the program.
    • Make a call to the “init” function of “BasicDataSource” class to initialize the connection.
    • Use “try” block to create “Connection” and “Statement” objects.
    • Create a ResultSet object named “customerResult” and then select the data from “Customer” table.
    • close
      • Using “While” loop, position the cursor using the “customerResult.next()” method and extract the data from each column of the current row of the ResultSet object.
        • Create a “Prepared Statement” object and select the data from “Invoice” tables where “Customer_Number” is equal to “?”.
        • Using “setInt()” function set Dynamic customer number during runtime.
        • Print the retrieved “customerNumber” and “customerName”.
        • Use “try” block and create the ResultSet object.
        • • Using “While” loop, position the cursor using the “invoiceResult.next()” method and extract the data from each column of the current row of the ResultSet object.
            • Create a “Prepared Statement” object and select the data from “Product” and “Lineitem” tables where “LineItem.Invoice_Number” is equal to “?” and “Product.Product_Code” is equal to “LineItem.Product_Code”.
            • Using “setString()” function set Dynamic invoice number during runtime.
            • Execute the prepared statement and store the result into the “ResultSet” object named “totalResult”.
            • Using “ totalresult.next()” moves the cursor forward one row from its current position and retrieve the values by column number.
            • At last print and display the report of all customer payment details.
            • Close the “invoiceresult” object.
    • Close the “customerResult” object.
    • Close the “conn” object

BasicDataSource.java:

• Import required packages.
• Create a class named “BasicDataSource”.
  • Create a function named “init()”.
    • Create objects for “Properties” and “FileInputStream”.
    • Load the file.
    • Assign values for “driver”, “url”, “username”, and “password”.
    • Check whether the “username” and “password” are “null” or not.
    • Load the driver by checking whether the “driver” is not “null”.
  • Create a function named “getConnection()”.
    • Make a call to the “getConnection()” function of “DriverManager” class by passing the arguments “url”, “username”, and “password” to establish the connection and return to the called function.