Chapter 23, Problem 5PE

Program Plan Intro

Program plan:

InvoicePrintDB.java

• Import required packages.
• Create a class named “InvoicePrintDB”.
  • 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.
      • Declaring “in” as an object of “Scanner” class
      • Prompt the user to enter an “Invoice number”.
      • Read integer value for invoiceNumber from the user and store it into the variable “invoiceNumber”.
      • Create a “Prepared Statement” object and select the data from “Customer” and “Invoice” tables where “Customer.Customer_Number” is equal to “Invoice.Customer_Number” and “Invoice.Invoice_Number” is equal to “?”.
      • Using “setInt()” function set Dynamic invoice number during runtime.
      • Execute the prepared statement and store the result into the “ResultSet” object named “result”.
      • Using “ result.next()” moves the cursor forward one row from its current position and display the values.
      • Get the amount due value and store it into the variable named “amountDue”.
      • Close “result”.
      • Using “PreparedStatement” interface, select the values from “Product” and “LineItem” tables where “Product.Product_Code” is equal to “LineItem.Product_Code” and “LineItem.Invoice_Number” is equal to “?”.
      • Using “setInt()” function set Dynamic invoice number during runtime.
      • Execute the prepared statement and store the result into the “ResultSet” object named “result”.
      • Using “While” loop, position the cursor using the “result.next()” method and extract the data from each column of the current row of the ResultSet object.
        • Print and display the customer formatted invoice.
        • • Close the “result” object.
          • At last print the amount due of the user prompted invoice number.
          • Close “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.