A

aborting transactions, 133

abstract data types, passing, 148

Abstract Window Toolkit (AWT), 4

access errors

connections, 520–523

described, 489–491

interactive Structured Query Language (SQL) tool, 278–280

queries, 509

access warnings

clearing, 371

connection, checking, 374

constructors, 501–502

queries and updates, 103–106

value, getting, 509

account, bank

account balance and other controls, 255–256

Account.java class, 257–262

ATM panel, 256–257

business data components, 41–42

business logic components, 41

clock, updating (TimeT.java), 267

HyperText Markup Language (HTML) file, 257

NetBank.java class, 262–266

tables, creating (Data Definition Language (DDL)), 268–269

usefulness, 253

welcome screen, 254

ACID properties. See Transaction Management

addBatch()method, 139–141

airline database example

airport codes (AirportChoice.java), 235–236

airport information (Airport.java), 231–235

airport map with routes (FlightsPanel.java), 240–243

columns, arranging in single (ColumnLayout.java), 237–239

connection, establishing (Airplet.java), 226–231

flight information (Flight.java), 239–240

flight string x-y coordinates (MapInfo.java), 249–250

flights between airports (FlightsVector.java), 243–244

HyperText Markup Language (HTML) file, 226

images (ImageCanvas.java), 244–246

label (MultilineLabel.java), 250–252

map, displaying appropriate (MapCanvas.java), 246–249

Airplet.java, 226–231

AirportChoice.java, 235–236

Airport.java, 231–235

aliasing columns, 421

American National Standards Institute (ANSI), 419–420

API. See application programming interface (API)

applets

applications versus, 48

permissions, checking, 35

traditional applications versus, 48–49

application

applets versus, 48

database transactions, 253–269

driver manager, interaction with, 33

drivers, loading. See DriverManager

interactive Structured Query Language (SQL) client application, 203–217

Java Database Connectivity (JDBC), 26–27

Java database explorer. See Java database explorer

multimedia content, handling, 217–224

multitier applications, remote method invocation and Java Database Connectivity (JDBC), 323–341

Open Database Connectivity (ODBC) component, 20–21

phonebook service example, 186–189

remote database access through browser, 225–252

shopping cart example, 189–191

values, receiving, 146–148

application, database explorer

catalogs, browsing, 275–278

database engine specifications and limitations, 275

described, 271–272

interactive Structured Query Language (SQL) tool, 278–280

logging in, 272–274

navigation graphical control, 274

source code, 280–323

application, multitier

client class (CarSales.java), 334–340

client programs, 326–327

data structure, 324–325

described, 323–324

implementation, 328–334

interfaces, 330–331

remote method invocation (RMI) server, 340–341

application, remote access

airport codes (AirportChoice.java), 235–236

airport information (Airport.java), 231–235

airport map with routes (FlightsPanel.java), 240–243

columns, arranging in single (ColumnLayout.java), 237–239

connection, establishing (Airplet.java), 226–231

described, 225

flight information (Flight.java), 239–240

HyperText Markup Language (HTML) file, 226

application logic

embedding on database. See stored procedures

JDBC 3.0 Extension (J2EE) tier, 39

application programming interface (API)

availability, 54–55

Java Database Connectivity (JDBC), 45

listed, 4–5

usefulness, 3

application servers

components, distributed. See EJB)

connection pool, maintaining, 10

database-mapping code for entity beans, 192

Application Service Providers (ASPs), 9

Array or ARRAY

callable statement, 353

column, updating, 472

column value, 453

data type conversion, 491

defined, 34

Java Database Connectivity (JDBC) interface, 345–348

parameter, setting, 529

PreparedStatement, 441

updating, 134–135

writing, 495

AsciiStream

callable statements, 367

CLOB pointer, 368–369

column, updating, 473

mapping to Java, 491

prepared statements, 441–442

retrieving, 529

updating ResultSet, 134–135

writing, 495

ASPs. See Application Service Providers (ASPs)

ATM panel, banking application, 256–257

atomicity, data, 124

.au, 221

audio synthesis and recognition, 4

auto-generated keys, 422

automobile factories application

client class (CarSales.java), 334–340

client programs, 326–327

data structure, 324–325

described, 323–324

implementation, 328–334

interface (CarFactory.java), 330–331

interface (Car.java), 327–328

remote method invocation (RMI) server, 340–341

AWT. See Abstract Window Toolkit (AWT)