STARTING OUT W/JAVA PLUS ACCESS >IP<
19th Edition
ISBN: 9780135396094
Author: MUGANDA
Publisher: PEARSON EDUCATION (COLLEGE)
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 16, Problem 13MC
This method is specified in the Statement interface, and should be used to execute an INSERT statement.
- a. execute
- b. executellpdate
- c. executeQuery
- d. executeSelect
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A 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
ProductName
contains the string "Laptop" with any characters before or after it.
Assigns all the results of the
SELECT
statement to a variable named
results
.
A 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.
A(n) is a function or method that is called when a specific event occurs.
1. callback function2. auto function3. startup function4. exception
Chapter 16 Solutions
STARTING OUT W/JAVA PLUS ACCESS >IP<
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...
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Write a program to print the corresponding Celsius to Fahrenheit table.
C Programming Language
Consider the adage Never ask a question for which you do not want the answer. a. Is following that adage ethica...
Using MIS (10th Edition)
Scientists estimate that roughly 10 grams of caffeine consumed at one time is a lethal overdose. Write a progra...
Absolute Java (6th Edition)
Can a package have any name you might want, or are there restrictions on what you can use for a package name? E...
Java: An Introduction to Problem Solving and Programming (8th Edition)
When displaying a Java applet, the browser invokes the _____ to interpret the bytecode into the appropriate mac...
Web Development and Design Foundations with HTML5 (8th Edition)
Grade Book Modification Modify the grade book application in Programming Challenge 8 so that it drops each stud...
Starting Out with Java: From Control Structures through Data Structures (3rd Edition)
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
- Inheritance 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_forwardEmployee 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 ?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
- * The taskbar has a three sections True Falsearrow_forwardMake 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_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
- When a breakpoint is set, the computer stops processing the code immediately it processes the breakpoint statement.a. afterb. beforearrow_forwardIn 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_forward
- The 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. True Falsearrow_forwardA(n) _____________ is generated when a user interacts with a GUI object. a. error b. occasion c. method d. eventarrow_forwardWhat kind of code should be placed in the Load event?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Microsoft Visual C#Computer ScienceISBN:9781337102100Author:Joyce, Farrell.Publisher:Cengage Learning,Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
- Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher: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
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Control Structure in Data Structure - Data Structures - Computer Science Class 12; Author: Ekeeda;https://www.youtube.com/watch?v=9FTw2pXLhv4;License: Standard YouTube License, CC-BY