Chapter: - 2 [10 marks] JDBC (Java Database Connectivity)

Chapter: - 2 [10 marks]

JDBC (Java Database Connectivity)

INDEX

Sr. No.	Topic	Page No.
2.1	Introduction of JDBC	20
2.2	JDBC Architecture	20 to 24
2.3	Data Types in JDBC	25 to 27
2.4	Processing Queries	27 to 31
2.5	Database Exception Handling	31 to 33
2.6	Discuss Types of Drivers	33 to 40
2.7	JDBC Introduction & Needs for JDBC	40
2.8	JDBC Architecture	41
2.9	Types of JDBC Drivers	41
2.10	JDBC API for Database Connectivity (java.sql package)	41 to 45
2.11	Statement, PreparedStatement	45 to 48
2.12	CallableStatement	48
2.13	ResultsetMetaData	48 to 49
2.14	DatabaseMetaData	49
2.15	Other JDBC APIs	50
2.16	Connecting with Databases	51
2.16.1	·         Access	51 to 59
2.16.2	·         MySQL	59 to 70
2.16.3	·         Oracle	71 to 77
2.17	Glossary of Important Terms and Abbreviation	78
2.18	Assignment – 2	79