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.