Q>what is not JDBC?
=>JDBC is not a programming language like java.
=>JDBC is not a software to install into our computer syatem inorder to use it.
=>JDBC is not a shortcut for the expression Java Data Base Technology.
Q>what is JDBC?
=>JDBC is a data acess technolgy from sun micros system that enable any kind of a java program
to communicate with any kind of database in a standard manner.
=>JDBC is a J2SE technology.
=>JDBC is a specification.
=>JDBC is an API.
Q>explain the architecture of JDBC?
=>Java power is making method calls.
=>Java method calls are not understandable to database.They understand only SQL,
=>Java compiler doesnot accept SQL syntax directly.
=>Java and database are heterogeneous to each other.Still they have to communicate each other.
=>Knowing about the elements involved in java-database communication is nothing but understanding the
architecture of JDBC.
=>JDBC architecture has 5 elements.
1.JDBC client
2.JDBC API
3.Driver manager
4. JDBC driver
5.database server
JDBC Architecture:-
Q>what is JDBC client?what are the responsibilities of JDBC?
=>A client is a software or a program/application that requests the server for resources sake.
=>which java program communicating with database for CRUD operations using JDBC technology that java
program is known as a JDBC client or JDBC application.
=>ODBC(open data base connectivity )technology is used to connect other than java program to
communicate with database.
Responsibilities of JDBC client:-
=>establishing the connection.
=>submitting appropriate SQL statements.
=>processing and presenting the result.
=>handling the exceptions.
=>dealing with transactions whenever necessary.
=>closing the connection.
=>JDBC is not a programming language like java.
=>JDBC is not a software to install into our computer syatem inorder to use it.
=>JDBC is not a shortcut for the expression Java Data Base Technology.
Q>what is JDBC?
=>JDBC is a data acess technolgy from sun micros system that enable any kind of a java program
to communicate with any kind of database in a standard manner.
=>JDBC is a J2SE technology.
=>JDBC is a specification.
=>JDBC is an API.
Q>explain the architecture of JDBC?
=>Java power is making method calls.
=>Java method calls are not understandable to database.They understand only SQL,
=>Java compiler doesnot accept SQL syntax directly.
=>Java and database are heterogeneous to each other.Still they have to communicate each other.
=>Knowing about the elements involved in java-database communication is nothing but understanding the
architecture of JDBC.
=>JDBC architecture has 5 elements.
1.JDBC client
2.JDBC API
3.Driver manager
4. JDBC driver
5.database server
JDBC Architecture:-
=>A client is a software or a program/application that requests the server for resources sake.
=>which java program communicating with database for CRUD operations using JDBC technology that java
program is known as a JDBC client or JDBC application.
=>ODBC(open data base connectivity )technology is used to connect other than java program to
communicate with database.
Responsibilities of JDBC client:-
=>establishing the connection.
=>submitting appropriate SQL statements.
=>processing and presenting the result.
=>handling the exceptions.
=>dealing with transactions whenever necessary.
=>closing the connection.