Slides 14: Mobile Commerce Systems (Cont.)

Slide 14.1: Oracle database management systems

Slide 14.2: Using SQL*Plus: the Oracle interface

Slide 14.3: Using SQL*Plus: the Oracle interface (cont.)

Slide 14.4: Using SQL*Plus: the Oracle interface (cont.)

Slide 14.5: Introduction to SQL

Slide 14.6: SQL (Structured Query Language)

Slide 14.7: The CREATE TABLE statement

Slide 14.8: The INSERT INTO statement

Slide 14.9: The SELECT statement

Slide 14.10: The SELECT statement

Slide 14.11: The WHERE clause

Slide 14.12: The WHERE clause (cont.)

Slide 14.13: The UPDATE statement

Slide 14.14: The DELETE statement

Slide 14.15: The ORDER BY keyword

Slide 14.16: The AND and OR keywords

Slide 14.17: The IN operator

Slide 14.18: The BETWEEN operator

Slide 14.19: Aliases

Slide 14.20: The UNION command

Slide 14.21: The SQL functions

Slide 14.22: JDBC (Java DataBase Connectivity)

Slide 14.23: A sample JDBC program

Slide 14.24: A typical JDBC API usage sequence

Slide 14.25: Importing packages

Slide 14.26: Registering the JDBC drivers

Slide 14.27: Opening a connection to a database

Slide 14.28: Creating a Statement object

Slide 14.29: Executing a query

Slide 14.30: Processing the result set

Slide 14.31: Closing the result set and statement objects

Slide 14.32: Making changes to the database

Slide 14.33: Committing changes

Slide 14.34: Closing the connection