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.

Question

Want to see the full answer?

Answer 1

Question

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.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Benefits of using arrays as instance variables: What are the advantages of incorporating arrays as instance variables within a class? Initializing and managing arrays: How do you initialize and manage arrays within class constructors and mutators (setters)? Example of using arrays as instance variables: Share an example where you have used arrays as instance variables and discuss its application in a real-world scenario. Common mistakes with arrays as instance variables: What are some common mistakes to avoid when working with arrays as instance variables? Information hiding violations: What is the potential violation of information hiding when using arrays as instance variables? How can this be resolved?

Do you think that computers should replace teachers? Give three references with your answer.

Is online learning or face to face learning better to teach students around the around the world? Give reasons for your answer and provide two references with your response. What are benefits of both online learning and face to face learning ? Give two references with your answer. How does online learning and face to face learning affects students around the world? Give two references with your answer.