JDBC (Java Data Base Connectivity)

   Using JDBC jars we can establish connection to DB & perform the DB operations.
It is an application programming interface (API) for the programming language Java, which defines how a client may access a database.


Steps to configure JDBC jars:
1. Go to Oracle website & download the jdbc jars
    => following jars you have to download fom oracle website
	ojdbc5.jar
	ojdbc6.jar
	ojdbc6_g.jar
	
   OR
   
   go to the client installation path in your local PC & navigate to jdbc dir & copy the jar files.
  EX: C:\oraclexe\app\oracle\product\11.2.0\server\jdbc\lib

2. All the jdbc jars should be put in eclipse std folder structure

3. Set the build path for all the jar files
------------------------------------------


Steps to implement the JDBC connection (Object Model):

1. Establish a connection using 'Connection' interface & provide the appropriate connection string (DB address)

2. Execute query using 'Statement' OR 'PreparedStatement' interfaces.

3. Use 'ResultSet' interface to store the query output.

4. Use 'ResultSetMetaData' interface to get the table meta data

5. Close the connection & release the objects





Q: Difference between Statemet & PreparedStatement
Ans:
1. for static query		   		 1. for dynamic query
2. doesnot accept query as       2. accepts query as input
input
