Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)
7th Edition
ISBN: 9780134802213
Author: Tony Gaddis
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 16, Problem 11MC
Program Description Answer
The method that is specified in Statement interface and should be used for executing a SELECT statement is “executeQuery”.
Hence, the correct answer is option “C”.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Employee view attendance report
The employee must be logged in to the
system to perform this function. The
employee selects the report period (range
of dates: from - to). The employee selects
"show report". Range of dates for the
report must be maximum 3 months, so if
the range is invalid, the system displays an
error message. The system displays every
working day in the report with the status
of the employee in this day, which could
be one of the following: on time, late, did
not come.
One actor?
One use case name?
One class ?
Attributes for the class ?
One relation between classes ?
* The taskbar has a three sections
True
False
True or FalseThe Load event takes place after the form is displayed on the screen.
Chapter 16 Solutions
Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)
Ch. 16.1 - Why do most businesses use a DBMS to store their...Ch. 16.1 - When a Java programmer uses a DBMS to store and...Ch. 16.1 - Prob. 16.3CPCh. 16.1 - Prob. 16.4CPCh. 16.1 - Prob. 16.5CPCh. 16.1 - Prob. 16.6CPCh. 16.1 - What static JDBC method do you call to get a...Ch. 16.2 - Describe how the data that is stored in a table is...Ch. 16.2 - What is a primary key?Ch. 16.2 - What Java data types correspond with the following...
Ch. 16.3 - Prob. 16.11CPCh. 16.3 - Prob. 16.12CPCh. 16.3 - Prob. 16.13CPCh. 16.3 - Prob. 16.14CPCh. 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.19CPCh. 16.3 - Prob. 16.20CPCh. 16.4 - Prob. 16.21CPCh. 16.4 - Prob. 16.22CPCh. 16.5 - The Midnight Coffee Roastery is running a special...Ch. 16.5 - Prob. 16.24CPCh. 16.6 - Prob. 16.25CPCh. 16.6 - Write a statement to delete the Book table you...Ch. 16 - Prob. 1MCCh. 16 - This is a standard language for working with...Ch. 16 - Prob. 3MCCh. 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. 9MCCh. 16 - Prob. 10MCCh. 16 - Prob. 11MCCh. 16 - Prob. 12MCCh. 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. 16MCCh. 16 - Prob. 17MCCh. 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. 22TFCh. 16 - Prob. 23TFCh. 16 - Prob. 24TFCh. 16 - Prob. 1FTECh. 16 - Prob. 2FTECh. 16 - Prob. 3FTECh. 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. 5AWCh. 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. 10AWCh. 16 - Write an SQL statement that does the following:...Ch. 16 - Prob. 12AWCh. 16 - Prob. 13AWCh. 16 - Assuming that conn references a valid Connection...Ch. 16 - Look at the following declaration. String sql =...Ch. 16 - Prob. 16AWCh. 16 - Prob. 17AWCh. 16 - Prob. 18AWCh. 16 - Prob. 1SACh. 16 - Prob. 2SACh. 16 - Prob. 3SACh. 16 - What is a primary key?Ch. 16 - Prob. 5SACh. 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. 8SACh. 16 - Prob. 9SACh. 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
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
- Most of the memory locations declared in an application should be class-level variables. a. True b. Falsearrow_forwardInheritance and Polymorphism This assignment starts with the Account class from Labs 4 and 5. Our new and improved bank has two kinds of accounts, savings, and checking. In addition to an ID and a balance, savings accounts have an annual interest rate and a minimum balance. Checking accounts have a minimum balance and a monthly fee. Withdrawals and deposits can be made to both kinds of accounts. At the end of each month, savings accounts pay interest, but only if the account's balance is above the minimum. Also at the end of each month, a fee is deducted from each checking account, but the fee is waived if the account's balance is over the minimum. Tasks 1. Create a complete UML diagram which shows the relationships between the three classes, Account, Savings, and Checking and all of the fields and methods in each. The only modifications required to the Account class is the addition of two abstract methods called closeMonth and accountString. 2. The closeMonth function performs the…arrow_forwardIn CPP: Monthly Sales Create a program that allows you to view and edit the sales amounts for each month of the current year. Console Monthly Sales program COMMAND MENU view - View sales for specified month edit - Edit sales for specified month totals - View sales summary for year exit - Exit program Command: view Three-letter Month: jan Sales amount for Jan is 14,317.00. Command: edit Three-letter Month: jan Sales Amount: 15293 Sales amount for Jan is 15,293.00. Command: totals Yearly total: 77,786.71 Monthly average: 6,482.23 Command: view Three-letter Month: july Invalid three-letter month. Command: exit Bye! Specifications The program should use a map to store the sales data for each month with the three-letter abbreviation for the month (Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec) as the key for each item. When the program starts, it should read the sales data inserted from the user. If the user edits the sales data, the…arrow_forward
- At least three jobs are handled by the WinMain (beginning) procedure.arrow_forwardWrite this code in C# language: Scenario: A dog shelter would like a simple system to keep track of all the dogs that pass through their facility. You are required to make a command line-based dog shelter management application. Your application must allow a user to add, edit, search and view Contacts. The program must have a menu consisting of the following six (6) options: Add dog View all dogs View all available dogs View specific dog Update dog home status Exit Brief descriptions of each option in the menu Menu Item Description Add Dog 1) Asks the user for all the state value information for a dog. 2) Checks if there is space in the array to hold the new dog. 3) Check that the dogId is not already used in the system. 4) Creates a new Dog object and adds it to the array if there is space. If the array is full, print “Sorry… the Shelter is Full!”. Note: All new dogs have no home as yet (foundHome = false). View all dogs This menu option shows all…arrow_forwardThe memory locations listed in a procedure header’s parameterList have procedure scope and are removed from the computer’s main memory when the procedure ends. a. True b. Falsearrow_forward
- Make a Movie Database program Project Specifications Background This application must be able to handle creating new entries in a proprietary database as well as returning searches for items in the current database. You MUST implement the following: Start the program by displaying the title of your program (you come up with a name) Have a primary prompt that allows you to enter commands (e.g. “Enter command >” ) Interpret primary commands and move to secondary states based on the commands entered. Commands you must support at the primary prompt are: a.) new entry b.) search by actor c.) search by year d.) search by runtime (in minutes) e.) search by director f.) search by title g.) quit Your secondary states must do the following: For “new entry” → Prompts to do the following: Enter title > Enter year >…arrow_forwardA computer store uses a database to track inventory. The database has a table named Inventory, with the following columns: ProductID INTEGER PRIMARY KEY NOT NULL ProductName TEXT QtyOnHand INTEGER Cost REAL Also assume that the cur variable references a Cursor object for the database. Write Python code that does the following: Executes a SELECT statement to return all the columns from the rows where Cost is less than 999.99. Assigns all the results of the SELECT statement to a variable named results.arrow_forwardASSEMBLY You can reuse the same local variable name within different procedures in your program. True Falsearrow_forward
- In this exercise, you modify the Grade Calculator application from this chapter’s Apply lesson. Use Windows to make a copy of the Grade Solution folder. Rename the copy Grade Solution-Intermediate. Open the Grade Solution.sln file contained in the Grade Solution-Intermediate folder. Open the CourseGrade.vb file. The DetermineGrade method should accept an integer that represents the total number of points that can be earned in the course. (Currently, the total number of points is 200: 100 points per test.) For an A grade, the student must earn at least 90% of the total points. For a B, C, and D grade, the student must earn at least 80%, 70%, and 60%, respectively. If the student earns less than 60% of the total points, the grade is F. Make the appropriate modifications to the DetermineGrade method and then save the solution. Unlock the controls on the form. Add a label control and a text box to the form. Change the label control’s Text property to “&Maximum points:” (without the quotation marks). Change the text box’s name to txtMax. Lock the controls and then reset the tab order. Open the form’s Code Editor window. The txtMax control should accept only numbers and the Backspace key. Code the appropriate procedure. The grade should be cleared when the user makes a change to the contents of the txtMax control. Code the appropriate procedure. Modify the frmMain_Load procedure so that each list box displays numbers from 0 through 200. Locate the btnDisplay_Click procedure. If the txtMax control does not contain a value, display an appropriate message. The maximum number allowed in the txtMax control should be 400; if the control contains a number that is more than 400, display an appropriate message. The statement that calculates the grade should pass the maximum number of points to the studentGrade object’s DetermineGrade method. Make the necessary modifications to the procedure. Save the solution and then start and test the application.arrow_forwardWrite an Add method that adds the contents of the decPrice variable to the lstPrices control.arrow_forwardUsing C# in Microsoft Visual Studio create an application that displays the total for a customer’s visit . The application should have the following value-returning methods: OilLubeCharges —Returns the total charges for an oil change and/or a lube job, if any. FlushCharges —Returns the total charges for a radiator flush and/or a transmission flush, if any. MiscCharges —Returns the total charges for an inspection, muf fler replacement, and/or a tire rotation, if any. OtherCharges —Returns the total charges for other services (parts and labor), if any. TaxCharges —Returns the amount of sales tax, if any. Sales tax is 6% and is charged only on parts. If the customer purchases services only, no sales tax is charged. TotalCharges —Returns the total charges. The application should have the following void methods, called when the user clicks the Clear button: ClearOilLube —Clears the check boxes for oil change and lube job. ClearFlushes —Clears the check boxes for radiator flush and…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
Microsoft Visual C#Computer ScienceISBN:9781337102100Author:Joyce, Farrell.Publisher:Cengage Learning,
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
EBK JAVA PROGRAMMINGComputer ScienceISBN:9781337671385Author:FARRELLPublisher:CENGAGE LEARNING - CONSIGNMENT
C++ for Engineers and ScientistsComputer ScienceISBN:9781133187844Author:Bronson, Gary J.Publisher:Course Technology Ptr
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Microsoft Visual C#
Computer Science
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Cengage Learning,
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr