2 4

Advanced Java Programming with
Database Application

Centre for Information Technology and Engineering, Manonaniam Sundaranar University

CONTENTS
Lecture 1

1
Data Base Management Systems
Introduction
Summary of DBMS Functions
CODD's Rules

Lecture 2

17
Structured Query Language
Structured Query Language
Using SQL as a Data Definition Language
Using SQL as a Data Manipulation Language
Using SQL as a Data Query Language
Functions

Lecture 3

33
JDBC Architecture
Remote Database Access

Lecture 4

40
JDBC
Introduction
Connecting to an ODBC Data Source
JDBC Connection
JDBC Implementation
Resultset Processing: Retrieving Results

Lecture 5

67
Prepared Statement
Callable Statement
Other JDBC Classes
Moving the Cursor in Scrollable Result Sets
Making Updates to Updatable Result Sets
Updating a Result Set Programmatically

Lecture 6

94
Introduction To Software Components
Software Component Model
Features of Software Component
Javabean
Importance of Java Component Model4
Bean Development Kit
Starting the BeanBox
Using The BDK Beanbox and The Demo Javabeans

Centre for Information Technology and Engineering, Manonaniam Sundaranar University

Lecture 7

107
Building Simple Bean
Building the First Bean
Event Handling

Lecture 8

117
Bean Persistence
Serialization and Deserialization
Serializable Bean

Lecture 9

130
Introspection
Introspector
Bean Info
Simple Bean Info
Feature Descriptor
Bean Descriptor
EventSetDescripter
Property Descripter

Lecture 10

141
Properties
Simple property
Boolean property
Indexed Property
Bound properties

Lecture 11

149
Constraint properties
Customization
Property Editor and Customization
Level of customization

Lecture 12

158
Discussion

Lecture 13

159
EJB – Overview
How Did We Get Here?
Component Transaction