5 Advanced java tutorial | JDBC | Software Specification | Type 1 Driver | adv java

Описание: #Advanced java tutorial : #adv java, Understanding the process of developing the s/ws based on s/w specification(Our own)
1) JDBC Specification (Assumption)

a) MyConnection.java (Interface)
public interface MyCOnnection
{
public void makeConection(); //Rule 1
}

Send.java (Interface)
public interface Send{
public void sendQuery(String query);
}

Vendor 1(IBM COmpany):

------ developing JDBC Driver for oracle

b)OracleConnection.java (class)


public class OracleConnection implemests MyConnection
{
public void makeConnection()
{...........
...........
........... logic to establis connection with
Oracale Databse software.
...........

}
}

OracleSend.java
public class OracleSend implments Send
{
public vouid sendQuery(String query){
----------
logic to send & execute sql query in oracled
database s/w
----------
}
}

Vendor 2 (BossSoft Tech):
------------ gives JDBC driver logic for mysql

C) MySqlConnection.java (class)
public class MySqlCOnnectoin implements MyCOnnection
{
public void makeConnecction(){
---
logic to establish conneciton with mysql db s/w
---
}
}

--MySqlSend.java (class)
public class MySqlSend implements Send
{
public void sendQuery(String Qiery){
------
logic to send & execute sql query in mysql db s/w
}
}


Infosys Company(Programmer 1)
-- wants to devlop java application to interact with oracled
--Uses JDBC driver for oracle given by IBM (Vendor 1)

Appl1.java

-- Activate jdbc driver for oracle
call makeConnection() method.
call sendQuery("select * from student");

TCS Company( Programmer 2)
-Wants to develop java applicatin to interact with mysql db.
-uses JDBC Driver for mysql givern by Boss Soft Tech (Vendor 2)

Appl2.java
-- Activate jdbc driver for mysql.
call makeConnection() method.
call sendQuery("selecct * from Empployee");

Vendor companies develop jdbc drivers based on JDBC Specifiacaton rules & guidelines given by Sun MicorSystem where as programmer use these JDBC drivers in JAva application to interact with DB s/w.

-Every JDBC Driver is a set of classes implementing various interfaces given by JDBC API package.
In these-- DB S/w

ex- JDBC driver for oracle related classes logic to interact with Oracle DB S/w
JDBC Driver for mysql related calssed to interact with Mysql DB s/w.

JDBC Specificaiton is lik e coourse broucher.
JDBC driver is like Faculty .


-Since all vendor comapanies are giving JDBC Driver based on common jdbc specification, so we can use all the vendor supplied JDBC Driver in our application in a similar manner to talk/interact with database s/ws.

-- Along jdk s/w installation one built in JDBC driver is abailable given by SUn Ms its

Java Home-\Program Files\Java\jre1.8.0_121\lib\rt.jar

-JDBC API of Jdbc specification will be used by vendor comanies as rules & guidelines to develop JDBC drivers.

The same api will be used by prgramer to write jdbc peristence logic in our java application to activate & use JDBC Drivers to interact with db s/w

-Eventhough every jdbc driver contains so many classes but the jdbc driver will be identified with its driver class name.

the java class that implements java.sql.Driver interface is called as JDBC driver calss.

-By using this driver class name we can activate & use JDBC Driver in our application.

-the jdbc driver class name of JDK supplied built in jdbc driver is sun.jdbc.odbc.JdbcOdbcDriver
----------- --------------
package name driver class name implemetnig java.sql.Driver (interface)


implements
-sun.jdbc.odbc.JdbcOdbcDriver ----------java.sql.Driver

java.sql.Driver (interface)
^
!
! extends
!
sun.jdbc.odbc.JdbcOdbcDriverInterface (interface)
^
!
!implements
!
sun.jdbc.odbc.JdbcOdbcDriver (Class)

ODBC driver is identified thorugh its DSN (Data Source Name)

There are 3 types of DSN-

1) User DSN (Specific to currently logged in windows user)
2) System DSN (visible to all the windows users of current/same machine/shytem)
3) Along with windows installation we get ODBC drivers for differnt database s/w.

#PROCEDURE TO CREATE dsn FOR MICROSOFT ODBC DRIVER FOR ORACLE
1) KEEP ORACLE S/W TO BE READY. (INSTALLED IN YOUR MACHINE).