Chapter 23, Problem 2PE

Program Plan Intro

Program plan:

CarDataBase.java

• Import required packages.
• Create a class named “CarDataBase”.
  • 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.
      • Inside the “try” block use another “try” block to drop the table car if existed else handle the exception in the “catch” block if table doesn’t exist.
      • 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 fuel efficiency ratings stored in the field “Efficiency”.
        • 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.