S

SAG-X/Open CLI, Structured Query Language (SQL), 19–20

sample

database transactions, 253–269

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

Java database explorer. See Java database explorer

multimedia content, handling, 217–224

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

phonebook service example, 186–189

shopping cart example, 189–191

sample airline database

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

sample database explorer application

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

sample multitier application

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

sample remote access application

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

savepoint

deleting, 378

setting, 380

supported, 426

transaction management, 129–130

scalar functions

date and time, 122–123

numeric, 121–122

string, 122

Structured Query Language (SQL) escape syntax, 121–123

system, 121

scanning query results

creating cursors, 98

ResultSets, 77–78

schema, 548

scrolling, rows, 451

searchability

setting, 548–549

verifying, 487

security, drivers, choosing, 31

SELECT queries, 135

sending

BLOBs, 217–220

prepared statements, 154–155

Structured Query Language (SQL) statements, 68–71

serial communications, 4

server, remote method invocation (RMI)

defined, 5

HTTP tunneling, 50

multitier applications, 340–341

servers

car factory example, illustrated, 324

embedded Structured Query Language (SQL), limitations of, 16

interactive Structured Query Language (SQL), 203–217

JDBC 3.0 Extension (J2EE) client tier, 38

relational databases, 14–15

remote method invocation, 334–340

servers, application

components, distributed. See EJB)

connection pool, maintaining, 10

database-mapping code for entity beans, 192

servlets, 50

session beans

banking application, 41

defined, 185

stateful, 189–191

stateless, 186–189

tier location, 39

setXXX() methods, 146–148

shopping cart example, 189–191

short

callable statements, 365

column, updating, 481

column value, getting, 464–465

mapping, 113

prepared statements, 447

reading, 494

writing, 499

Simple Network Management Protocol (SNMP), 4

simultaneous connections, checking for maximum, 166–167

single-tier drivers, 22

size, row maximum, 166–167

SMALLINT, 180–181

smartcards, 6

SNMP. See Simple Network Management Protocol (SNMP)

software partitioning, defined, 323

software reuse, 5

software tier, 15

sound files. See Blob or BLOB

source code

Account.java banking application, 257–262

airline example, 227–252

BLOBs, 221–224

compiling, 55

connection for Java database explorer, 280–299

database connectivity for car factory example, 331–334

error box for Java database explorer, 299–301

help box for Java database explorer, 302–304

implementation for car factory example, 328–330

interfaces for car factory example, 330–331

login for Java database explorer, 305–306

main frame for Java database explorer, 306–312

navigator for Java database explorer, 313–320

NetBank.java banking application, 262–266

reference look-up for car factory example, 334–340

registry binding for car factory example, 340–341

Structured Query Language (SQL) commands for Java database explorer, 320–323

TimeT.java banking application, 267

space padding, 113

special characters

availability, checking, 400

Structured Query Language (SQL) escape syntax, 123

speech synthesis and recognition, 4

SQL-92, 16

SQLData, 488–489

SQLException

connections, 520–523

described, 489–491

interactive SQL tool, 278–280

queries, 509

SQLInput, 491–495

SQLOutput, 495–500

SQLPermission, 500

SQLWarning

clearing, 371

connection, checking, 374

constructors, 501–502

during query or update, 103–106

value, getting, 509

stateful session beans, 189–191

stateless session beans, 186–189

Statement

batch updates, 139–141

database and driver resources, creating, 502–511

delayed execution. See time-outs

getting, 465

length, maximum, 405

sending, 46

stored procedures

callable statements, 353–367

client-server architecture, 15

creating, 375

descriptions, 427–428

Structured Query Language (SQL) escape syntax, 120

unchained transactions, 125

streams, retrieving, 94–95

String

auto-generated keys, 158–159

callable statement, 365

CLOB pointer, 369–370

DATE, converting from, 89

date, converting to, 430

getting, 465

mapping, 182

parameters, accessing, 180

prepared statements, 447

reading, 494

Structured Query Language (SQL) escape syntax, 122

supported, 410

updating, 481

writing, 499

Structured Query Language (SQL)

constants and values, defined (Types), Java Database Connectivity (JDBC), 515–518

cursors, creating, 98

defined, 14

dynamic, creating. See Prepared Statements

grammar support, checking, 419–420

impedance mismatch with object-oriented programming language, 23

inheritance, 119

keywords, information, getting, 163–165

mapping. See type mapping

relational databases, 16–20

SAG-X/Open CLI, 19–20

syntax, 17–19

uses, 16–17

Structured Query Language (SQL) data type conversions

accessing data using type map, 119

defining, 117–119

mapping data types to Java, 112–115

object-orientation and, 6

SQL inheritance, 119

type mapping tables, 115–117

Structured Query Language (SQL) escape syntax

callable statements, 353

outer joins, 124

scalar functions, 121–123

special characters, 123

stored procedures, 120

time and date, 120

Structured Query Language (SQL) statements

BLOBs and CLOBs, storing, 71–72

building, 67–68

closing, 71

creating database and driver resources (Statement), 502–511

defined, 66

grouping to treat as whole. See transaction management

precompiling (PreparedStatement), 440–449

properties, adjusting, 72–73

sending, 68–71

sending to specific data source. See driver

time-outs, setting, 73–74

structured types (Struct or STRUCT)

data type conversion, 511–512

Structured Query Language (SQL) name, getting, 449

writing, 499

Sun Microsystems, Inc., 3

suppliers, database

drivers, 31–33

Java adoption, 9

stored procedures, 15

SWING, 274

Sybase

catalog information, 170–172

employees with messages, listing, 124

keywords, getting, 164–165

sample drivers, 226

sample URL, 58

stored procedures, 150

Sybase Jaguar, 185

synchronizing

client-server networks, 14–15

entity bean with data in database table. See persistence



JDBC 3. 0. JAVA Database Connectivity
JDBC 3: Java Database Connectivity
ISBN: 0764548751
EAN: 2147483647
Year: 2002
Pages: 148

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net