bartleby

Concept explainers

Expert Solution & Answer
Book Icon
Chapter 16.4, Problem 16.21CP

Explanation of Solution

INSERT:

  • The "INSERT" statement would add rows into table.
  • The order of added values should be maintained as same as table columns.
  • The two ways to use "INSERT" statement would include:
    • The first method used for stating only data value inserted without column names.
    • The second method is used for stating both columns needed to fill as well as their corresponding values.

Example:

The example for "INSERT" statement is shown below:

INSERT INTO Book

(Title, PageNum, Price)

VALUES

(‘Java Programming’, ‘200’, 8.65)

Here, "Book" denotes the name of table...

Blurred answer
Students have asked these similar questions
Add a method called transfer () to the BankAccount class, that takes in an amount and destinationAccount as input and transfer the funds from current account to destination account. This method should return the balance of the current account after the transfer, also should check for the sufficient balance in current account before proceeding the transfer and if there is insufficient balance return an error message "Insufficient balance". Modify the BankAccount Test class, so that it calls the transfer () method and prints the balance after transfer. Make sure that the transfer() method updates the balance of both the current account and the destination account.
• Create a public method called deposit() that takes in an amount of type double as input and adds the amount to the current balance. This method should also return the updated balance. • Create another public method called withdraw() that takes in an amount of type double as input, checks if the withdrawal amount is less than the current balance, and if so, subtracts the amount from the balance. If the withdrawal amount is greater than the current balance, the method should return an error message "Insufficient balance". • Create a public method getAccountInfo() that returns the account information in the format "Account Number: xxxxx, Account Holder: John Doe, Account Type: SAVINGS/CHECKING, Balance: $xxxX.XX". • Finally, create a constructor method that takes in the account number, account holder name, initial balance and account type as input and initializes the corresponding instance variables. In the BankAccount class, make sure to use the private access modifier for the instance...
Create a BankAccount Test class that contains a main() method that instantiates an object of type BankAccount, with account number of 12345, account holder name of "John Doe", initial balance of 1000ドル and account type as SAVINGS . Then use the deposit() and withdraw() methods of the object to deposit 500ドル and withdraw 300ドル. Finally, use the getAccountInfo() method to print the current account information. Use the getAccountInfo() method to verify that the deposit and withdrawal actions are performed correctly and that the account information is updated accordingly.

Chapter 16 Solutions

Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)

Ch. 16.3 - Prob. 16.11CP Ch. 16.3 - Prob. 16.12CP Ch. 16.3 - Prob. 16.13CP Ch. 16.3 - Prob. 16.14CP Ch. 16.3 - What is the purpose of the % symbol in a character... Ch. 16.3 - How can you sort the results of a SELECT statement... Ch. 16.3 - Assume that the following declarations exist:... Ch. 16.3 - How do you submit a SELECT statement to the DBMS? Ch. 16.3 - Prob. 16.19CP Ch. 16.3 - Prob. 16.20CP Ch. 16.4 - Prob. 16.21CP Ch. 16.4 - Prob. 16.22CP Ch. 16.5 - The Midnight Coffee Roastery is running a special... Ch. 16.5 - Prob. 16.24CP Ch. 16.6 - Prob. 16.25CP Ch. 16.6 - Write a statement to delete the Book table you... Ch. 16 - Prob. 1MC Ch. 16 - This is a standard language for working with... Ch. 16 - Prob. 3MC Ch. 16 - The data that is stored in a row is divided... Ch. 16 - This is a column that holds a unique value for... Ch. 16 - This type of SQL statement is used to retrieve... Ch. 16 - This contains the results of an SQL SELECT... Ch. 16 - This clause allows you to specify search criteria... Ch. 16 - Prob. 9MC Ch. 16 - Prob. 10MC Ch. 16 - Prob. 11MC Ch. 16 - Prob. 12MC Ch. 16 - This method is specified in the Statement... Ch. 16 - This SQL statement is used to insert rows into a... Ch. 16 - This SQL statement is used to remove rows from a... Ch. 16 - Prob. 16MC Ch. 16 - Prob. 17MC Ch. 16 - True/False: Java comes with its own built-in DBMS. Ch. 16 - True/False: A Java programmer that uses a DBMS to... Ch. 16 - True/False: You use SQL instead of Java to write... Ch. 16 - True/False: In SQL, the not-equal-to operator is... Ch. 16 - Prob. 22TF Ch. 16 - Prob. 23TF Ch. 16 - Prob. 24TF Ch. 16 - Prob. 1FTE Ch. 16 - Prob. 2FTE Ch. 16 - Prob. 3FTE Ch. 16 - What SQL data types correspond with the following... Ch. 16 - Look at the following SQL statement. SELECT Name... Ch. 16 - Write a SELECT statement that will return all of... Ch. 16 - Write a SELECT statement that will return the... Ch. 16 - Prob. 5AW Ch. 16 - Write a SELECT statement that will return the... Ch. 16 - Write a SELECT statement that will return all of... Ch. 16 - Write a SELECT statement that will return the... Ch. 16 - Write a SELECT statement that will return the... Ch. 16 - Prob. 10AW Ch. 16 - Write an SQL statement that does the following:... Ch. 16 - Prob. 12AW Ch. 16 - Prob. 13AW Ch. 16 - Assuming that conn references a valid Connection... Ch. 16 - Look at the following declaration. String sql =... Ch. 16 - Prob. 16AW Ch. 16 - Prob. 17AW Ch. 16 - Prob. 18AW Ch. 16 - Prob. 1SA Ch. 16 - Prob. 2SA Ch. 16 - Prob. 3SA Ch. 16 - What is a primary key? Ch. 16 - Prob. 5SA Ch. 16 - What are the relational operators in SQL for the... Ch. 16 - What is the number of the first row in a table?... Ch. 16 - Prob. 8SA Ch. 16 - Prob. 9SA Ch. 16 - Customer Inserter Write an application that... Ch. 16 - Customer Updater Write an application that... Ch. 16 - Unpaid Order Sum Write an application that... Ch. 16 - Population Database Make sure you have downloaded... Ch. 16 - Personnel Database Creator Write an application... Ch. 16 - Employee Inserter Write a GUI application that... Ch. 16 - Employee Updater Write a GUI application that...
Knowledge Booster
Background pattern image
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
    SEE MORE QUESTIONS
    Recommended textbooks for you
    Text book image
    Programming with Microsoft Visual Basic 2017
    Computer Science
    ISBN:9781337102124
    Author:Diane Zak
    Publisher:Cengage Learning
    Text book image
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781285196145
    Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
    Publisher:Cengage Learning
    Text book image
    A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    Text book image
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781305627482
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
    Text book image
    Np Ms Office 365/Excel 2016 I Ntermed
    Computer Science
    ISBN:9781337508841
    Author:Carey
    Publisher:Cengage
    Text book image
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning