Want to learn about JDBC (Java Database Connectivity), the popular API for connecting to databases and performing SQL tasks with Java? Get ready to take your Java skills to the next level!
JDBC is a Sun Microsystems specification and is a Java API responsible for connecting to a database, issuing queries and commands, and processing database result sets.
JDBC was created as an alternative to ODBC API, which is written in C & platform-dependent. JDBC uses JDBC drivers & is written in Java, making it a "pure Java" option for database connectivity.
In this, commands are sent to a "middle tier" of services that transmit the commands to the data source. The results are then returned to the middle tier and passed on to the user.