Program plan: CoinDataBase.java Import required packages. Create a class named “CoinDataBase”. 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 table named “Coin” using SQL statements. Insert corresponding values into the table. Use “try” block to create “ResultSet” object. Compute and display the sum of values stored in the field “Value”. Close “result”. Close “stat”. Close “conn”. 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 1PE

Program Plan Intro

Program plan:

CoinDataBase.java

Import required packages.

Create a class named “CoinDataBase”.

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 table named “Coin” using SQL statements.

Insert corresponding values into the table.

Use “try” block to create “ResultSet” object.

Compute and display the sum of values stored in the field “Value”.

Close “result”.

Close “stat”.

Close “conn”.

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

make corrections of this program based on the errors shown. this is CIS 227 .

Create 6 users: Don, Liz, Shamir, Jose, Kate, and Sal. Create 2 groups: marketing and research. Add Shamir, Jose, and Kate to the marketing group. Add Don, Liz, and Sal to the research group. Create a shared directory for each group. Create two files to put into each directory: spreadsheetJanuary.txt meetingNotes.txt Assign access permissions to the directories: Groups should have Read+Write access Leave owner permissions as they are “Everyone else” should not have any access Submit for grade: Screenshot of /etc/passwd contents showing your new users Screenshot of /etc/group contents showing new groups with their members Screenshot of shared directories you created with files and permissions

⚫ your circuit diagrams for your basic bricks, such as AND, OR, XOR gates and 1 bit multiplexers, ⚫ your circuit diagrams for your extended full adder, designed in Section 1 and ⚫ your circuit diagrams for your 8-bit arithmetical-logical unit, designed in Section 2. 1 An Extended Full Adder In this Section, we are going to design an extended full adder circuit (EFA). That EFA takes 6 one bit inputs: aj, bj, Cin, Tin, t₁ and to. Depending on the four possible combinations of values on t₁ and to, the EFA produces 3 one bit outputs: sj, Cout and rout. The EFA can be specified in principle by a truth table with 26 = 64 entries and 3 outputs. However, as the EFA ignores certain inputs in certain cases, it is easier to work with the following overview specification, depending only on t₁ and to in the first place: t₁ to Description 00 Output Relationship Ignored Inputs Addition Mode 2 Coutsjaj + bj + Cin, Tout= 0 Tin 0 1 Shift Left Mode Sj = Cin, Cout=bj, rout = 0 rin, aj 10 1 1 Shift Right…