Java 2 Ch 28 summary
database
A _______ is an integrated collection of data.
ResultSetMetaData
A _______ object describes a ResultSet's contents.
one-to-many
A _______ relationship between tables indicates that a row in one table can have many related rows in a separate table.
JDBC driver
A ________ enables Java applications to connect to a database in a particular DBMS and allows you to retreive and manipulate database data.
connection object, connection objects
A ________ manages the connection between a Java program and a database. _______ enable programs to create SQL statements that access data.
database management system (DBMS)
A _________ provides mechanism for storing, organizing, retrieving and modifying data.
tables
A relational database stores data in _______. Tables are composed of rows, and rows are composed of columns in which values are stored.
createStatement
Connection method _________ creates a statement object, which can be used to submit SQL statements to the database.
getConnection
DriverManger method _______ attempts to connect to a database at a URL that specifies the protocol for communication, the subprotocol for communication and database name.
attribute
Each column of a table represents a different _______.
one
Each statement object can open only ___ ResultSet at a time. When a statement returns a new ResultSet, the Statement closes the prior ResultSet.
getColumType
It's possible to extract each ResultSet column as a specific Java type. ResultSetMetaData method ______ returns a Types constant indicating the column's type.
MetaData
Programs can use _______ programmatically to obtain information about the ResultSet column names and types.
interface-software
Programs connect to, and interact with, relational databases via an ________ that facilitates communications between a DBMS and a program.
get
ResultSet ____ methods typically receive as an argument either a column number(as an int) or a column name(as a String) indicating which column's value to obtain.
next
ResultSet method _____ positions the ResultSet cursor to the next row and returns true if the row exist; otherwise, it returns false. This method must be called to begin processing a ResultSet because the cursor is initially positioned before the first row.
1
ResultSet row and column numbers start at __.
getColumnCount
ResultSetMetaData method ______ retrieves the number of ResultSet colums.
scrollable
Some JDBC drivers do not support _____ or updatable ResultSets.
executeQuery
Statement method ______ executes a query and returns a ResultSet object. ResultSet methods enable a program to manipulate query results.
result type
The _______ specifies whether the ResultSet's cursor is able to scroll in both directions or forward only and whether the ResultSet is sensitive to changes.
concurrency
The result _____ specifies whether the ResultSet can be updated.
relational database systems
Todays most popular database management systems are ________.
SQL
______ is the international standard language used to Query and manipulate relational data.
java.sql
package _____ contains classes and interfaces for accessing relational databases in Java.