Driver is an interface defined in java.sql package. Implementation will be provided by the respective vendors of the database.
Implementation of Driver will include how to communicate/connect with the database, how to pass data to and from database to java program and vise-versa etc.,
If you are using DriverManager to manage your connection objects, you need to load the Driver in to the memory. That�s why you execute the statement Class.forName(�Driver Name�);When you load any driver, it will register itself with the DriverManager.
DriverManager is a class in which getConnection is a static method which helps to achieve connectivity with corresponding database mentioned within it.
Connection , an interface in java.sql, provides methods for 3 type of SQL queries - 1. creatStatement - for simple query- return type is Statement interface 2.prepareStatement -for prepared query - retrun type is PreparedStatement Interface 3. prepareCall - for stored procedure and function - return type is CallableStatement
Statement , an Interface in java.sql , provides 3 types of methods again -1. executeQuery - return type ResultSet - for database query (select statements) 2. executeUpdate - return type int(no. of rows updated) - for insert ,update , delete operation of databese 3. execute - return type is boolean - true if ResultSet is returned and false if no. of Updated rows is returned - used for all type of database operation .
ResultSet ,an Interface in java.sql. , provides few methods like getMetaData() .
Please let me know whether your doubts are clear or not .
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus