Starting Out with Java: From Control Structures through Objects (6th Edition)
6th Edition
ISBN: 9780133957051
Author: Tony Gaddis
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 17.3, Problem 17.20CP
Explanation of Solution
ResultSet:
- The “SELECT” statement is been used for selecting data from a
database . - The result table is stored with data and is termed as “ResultSet”.
- A “ResultSet” object contains a set of rows as well as columns.
- All the fields present in table could be selected using “SELECT” statement.
- Specific fields can be selected by giving particular field names in “SELECT” statement.
Method to retrieve column 3 as a string:
- The method “getString(columnIndex)” of “ResultSet” object is invoked for retrieving “columnIndex” column as a String.
- Let “res” be a “ResultSet” class object.
- To retrieve column 3 as String from “ResultSet” object the method used is “res.getString(3)”.
- The method retrieves value of column 3 as a string...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Moving to another question will save this response.
Quèstion 8
The default data type for a sequence object is
Varchar
a.
Int
Ob.
Decimal
O c.
Char
Od.
A Moving to another question will save this response.
What does the Contains method return when the string does not contain the subString?
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
.
Chapter 17 Solutions
Starting Out with Java: From Control Structures through Objects (6th Edition)
Ch. 17.1 - Why do most businesses use a DBMS to store their...Ch. 17.1 - When a Java programmer uses a DBMS to store and...Ch. 17.1 - Prob. 17.3CPCh. 17.1 - Prob. 17.4CPCh. 17.1 - Prob. 17.5CPCh. 17.1 - Prob. 17.6CPCh. 17.1 - What static JDBC method do you call to get a...Ch. 17.2 - Describe how the data that is stored in a table is...Ch. 17.2 - What is a primary key?Ch. 17.2 - What Java data types correspond with the following...
Ch. 17.3 - Prob. 17.11CPCh. 17.3 - Prob. 17.12CPCh. 17.3 - Prob. 17.13CPCh. 17.3 - Prob. 17.14CPCh. 17.3 - What is the purpose of the % symbol in a character...Ch. 17.3 - How can you sort the results of a SELECT statement...Ch. 17.3 - Assume that the following declarations exist:...Ch. 17.3 - How do you submit a SELECT statement to the DBMS?Ch. 17.3 - Prob. 17.19CPCh. 17.3 - Prob. 17.20CPCh. 17.4 - Prob. 17.21CPCh. 17.4 - Prob. 17.22CPCh. 17.5 - The Midnight Coffee Roastery is running a special...Ch. 17.5 - Prob. 17.24CPCh. 17.6 - Prob. 17.25CPCh. 17.6 - Write a statement to delete the Book table you...Ch. 17 - Prob. 1MCCh. 17 - This is a standard language for working with...Ch. 17 - Prob. 3MCCh. 17 - The data that is stored in a row is divided...Ch. 17 - This is a column that holds a unique value for...Ch. 17 - This type of SQL statement is used to retrieve...Ch. 17 - This contains the results of an SQL SELECT...Ch. 17 - This clause allows you to specify search criteria...Ch. 17 - Prob. 9MCCh. 17 - Prob. 10MCCh. 17 - Prob. 11MCCh. 17 - Prob. 12MCCh. 17 - This method is specified in the Statement...Ch. 17 - This SQL statement is used to insert rows into a...Ch. 17 - This SQL statement is used to remove rows from a...Ch. 17 - Prob. 16MCCh. 17 - Prob. 17MCCh. 17 - True/False: Java comes with its own built-in DBMS.Ch. 17 - True/False: A Java programmer that uses a DBMS to...Ch. 17 - True/False: You use SQL instead of Java to write...Ch. 17 - True/False: In SQL, the not-equal-to operator is...Ch. 17 - Prob. 22TFCh. 17 - Prob. 23TFCh. 17 - Prob. 24TFCh. 17 - Prob. 1FTECh. 17 - Prob. 2FTECh. 17 - Prob. 3FTECh. 17 - What SQL data types correspond with the following...Ch. 17 - Look at the following SQL statement. SELECT Name...Ch. 17 - Write a SELECT statement that will return all of...Ch. 17 - Write a SELECT statement that will return the...Ch. 17 - Prob. 5AWCh. 17 - Write a SELECT statement that will return the...Ch. 17 - Write a SELECT statement that will return all of...Ch. 17 - Write a SELECT statement that will return the...Ch. 17 - Write a SELECT statement that will return the...Ch. 17 - Prob. 10AWCh. 17 - Write an SQL statement that does the following:...Ch. 17 - Prob. 12AWCh. 17 - Prob. 13AWCh. 17 - Assuming that conn references a valid Connection...Ch. 17 - Prob. 17AWCh. 17 - Prob. 18AWCh. 17 - Prob. 19AWCh. 17 - Prob. 1SACh. 17 - Prob. 2SACh. 17 - Prob. 3SACh. 17 - What is a primary key?Ch. 17 - Prob. 5SACh. 17 - What are the relational operators in SQL for the...Ch. 17 - What is the number of the first row in a table?...Ch. 17 - Prob. 8SACh. 17 - Prob. 9SACh. 17 - Customer Inserter Write an application that...Ch. 17 - Customer Updater Write an application that...Ch. 17 - Unpaid Order Sum Write an application that...Ch. 17 - Population Database Make sure you have downloaded...Ch. 17 - Personnel Database Creator Write an application...Ch. 17 - Employee Inserter Write a GUI application that...Ch. 17 - 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
- What is the index of the last item stored in a collection of 15 objects?arrow_forwardswitch_player(): we will allow the players to choose their own names, but for our purposes, it is easier to think of them as number (0 and 1, for indexing purposes). We will display their names to them on the screen, but in the background, we will keep track of them based on their number. This function should take 1 argument, an integer (either 0 or 1) representing the player and should return the opposite integer (1 if 0 is entered and 0 if 1 is entered). This is a simple function, but it will make our code cleaner later. Use your constants! Using Thonnyarrow_forwardCargo Container Report. You will be producing a program which will allow the user to generate the container report on the following page in Container Number order or Ship Name order. The program will also the user to lookup the data for any given Container by number. The % cargo weight is the percentage of the cargo of the gross weight (cargo weight/gross weight), % total is the percentage of the cargo for that container of the total amount of cargo unloaded (cargo weight for the container / total cargo unloaded. Hint: you are expected to use methods for your calculations. The accompanying file has the data for the containers unloaded today. The data includes container number int ship name. String tare weight of the container (empty weight) int the gross weight (container plus the cargo). Int You will need to computer the cargo weight as the gross weight minus the tare weight. If you have issues reading the data with the String, you may remove the String. However, you will lose points.…arrow_forward
- my_games = ['Zelda', 'Pokemon', 'Splatoon'] my_games[1] = 'Minecraft' Draw (or describe) the objects and labels that the Python interpreter creates in response to the first assignment. Then draw (or describe) the objects and labels that results from carrying out the second assignment immediately after the first assignment. Include your drawings or text descriptions in the solution document.arrow_forwardin C# Visual Studios Windows Form App (.Net Framework) Population Database In the Chap12 folder of the Student Sample Programs, you will find a database file named PopulationDB.mdf. The database has a table named City. The City table has the following columns: (see image) The City column stores the name of a city and the Population column stores the population of that city. The database has 20 rows already entered. Create an application that connects to the PopulationDB.mdf database and allows the user to perform the following: Use data-bound controls to add new rows to the database, change existing rows, and delete rows. Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the average population of all the cities. Get the highest population. Get the lowest population.arrow_forwardUsing the getSales() function as a reference, create a function thatt will take one parameter (string code) which is a product code (or part thereof), and when the search button is pressed, all sales that include this product code (or part thereof) will be displayed in the jTable. The date boxes in the GUI will be replaced with a text box. The schema of the database where the queries are being used is also attached. public List<Pos> getSales(String fromDate, String toDate){ List<Pos> salesList = new ArrayList<>(); try { String query = "SELECT sales_date, sales_number, prod_code, prod_name, unit_cost, quantity, sales_total " + "FROM Sales, SalesDetails, Product " + "WHERE Sales.sales_number = SalesDetails.sales_number " + "AND SalesDetails.prod_code = Product.prod_id " + "AND sales_date BETWEEN ? AND ?"; PreparedStatement stmt =…arrow_forward
- 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 uses the Cursor object to execute an SQL statement that deletes the row in the Inventory table in which ProductID is equal to 12.arrow_forwardwhich description defines data type? a) It is a named set of values. b) It is an unnamed tuple of values. c)It has values corresponding to columns. d) It has a name and varying set of row.arrow_forwardcreate a program called automobile loan this program stores a loan number, make and model of automobiles, and the loan balance. include the methods to set values for each data field and a methods that display all the loan information create two automobileloan objects and sets and display their values. create another two automobileloan objects and ask the user for the values, then display those values. you should have four objects in total created.arrow_forward
- Catch blocks allow how many arguments?arrow_forwardCreate a Windows Forms application. Use the following names for the project andsolution, respectively: Adaline Project and Adaline Solution. Save the application inthe VB2017\Chap08 folder. Create the interface shown in Figure 8-54. The figure alsocontains the major tasks that the application needs to perform. Code the application.Save the solution and then start and test the application.Tasks1). Declare a class-level Integer array to store the sales amounts for the following salespeople.You can create either a two-row, six-column array or a six-row, two-colurnn array.arrow_forwardCreate an Employee data type, and then create three employee objects. Each employee object has his/her name, employee ID, and balance. Set the first employee object’s name as “Lacey”, ID as 1234, and balance as 100; Set the second employee object’s name as “Dylan”, ID as 5678, and balance as 0; Set the third employee object’s name as “James”, ID as 9012, and balance as 50; Write a method for withdrawing money; Write a method for depositing money; Create one constructor for the objects Lacey and James, and one constructor for the object Dylan; Set the fields as private. Withdraw 50 on all three employees, and after that display each of their names, IDs, and balances.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
New Perspectives on HTML5, CSS3, and JavaScriptComputer ScienceISBN:9781305503922Author:Patrick M. CareyPublisher:Cengage Learning
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning