How is jdbc used

JDBC along with the database driver is capable of accessing databases and spreadsheets. The classes and interfaces of JDBC allows application to send request made by users to the specified database.

Attention reader! Get hold of all the important Java Foundation and Collections concepts with the Fundamentals of Java and Java Collections Course at a student-friendly price and become industry ready. So, interacting with a database requires efficient database connectivity which can be achieved by using the ODBC Open database connectivity driver.

JDBC Driver manager : It loads database-specific driver in an application to establish a connection with a database. It is used to make a database-specific call to the database to process the user request. It makes the use of sun. Architecture of JDBC. Description: Application: It is a java applet or a servlet which communicates with a data source.

It uses some database-specific drivers to effectively connect enterprise applications to databases. They are as described below: Two-tier model: A java application communicates directly to the data source.

The JDBC driver enables the communication between the application and the data source. When a user sends a query to the data source, the answers for those queries are sent back to the user in the form of results. R Programming. React Native. Python Design Patterns. Python Pillow. Python Turtle. Verbal Ability. Interview Questions. Company Questions. Artificial Intelligence. Cloud Computing. Data Science. Angular 7.

Machine Learning. Data Structures. Operating System. Note that your application must manually load any JDBC drivers prior to version 4. DataSource : This interface is preferred over DriverManager because it allows details about the underlying data source to be transparent to your application. A DataSource object's properties are set so that it represents a particular data source.

See Connecting with DataSource Objects for more information. Note : The samples in this tutorial use the DriverManager class instead of the DataSource class because it is easier to use and the samples do not require the features of the DataSource class. The method DriverManager. The following are some examples of database URLs:. This method specifies the user name and password required to access the DBMS with a Properties object.

Typically, in the database URL, you also specify the name of an existing database to which you want to connect. The samples in this tutorial use a URL that does not specify a specific database because the samples create a new database.