JDBC For You

In Information Technology we have two types of application. they are
i. Non-persistent/ volatile application
ii. Persistent logic/ non-volatile application


a non-persistent application is one in which the result of the program stored in primary memory /main-memory/RAM

a persistent application is one in which the result of the program stored permanently in secondary memory(Hard Disk)
They may be files(which is not having security)
They may be Databases(which is recommended because it gives security)

In JDBC API is not Depending on any of the database but it is independent of all databases.

Def for JDBC: JDBC is a open specification or technology developed by Java soft,INC,USA (Software Division of Sun Micro System) and they released lot of rules and guidelines to database vendors to perform various operations on the database such as insertion, deletion, modification and selection of the records from databases.


we deal with database we need to import java.sql.*, import javax.sql.*
When we are writing any kind of database program using JDBC API we use the Standard Guide Lines(Steps)

• Obtain the Database Connection
• Pass SQL Query
• Get the Result from Database and process.

any java program want to deal with any database, we need to use JDBC Driver.

Driver: a jdbc driver is the bridge between java application and database in other words it is the middle layer between java program and database and whose primary responsibility is converting java calls to database related calls and vice versa. 

Topics in  JDBC: 

1. Types of Drivers
2. Steps for Developing first JDBC Applications with JDBC
3. Dynamic Queries
4. Type-4 Driver
5. Group Function in JDBC
6. Stored Procedure in JDBC
7. Batch Processing
8. Dealing with MS-Access Database
9. Dealing with Excel database
10. Transfer Excel data to oracle
11. Meta Data
12. Developing Flexible JDBC Application
13. Scrollable ResultSet 
14. JDBC Objective Questions
15. JDBC Interview Questions