JDBC driver

JDBC driver

Fundamentals of Database Technology and Database-Driven Web Applications

Published in Barney L. Capehart, Timothy Middelkoop, Paul J. Allen, David C. Green, Handbook of Web Based Energy Information and Control Systems, 2020

Fangxing Li

JDBC architecture contains a driver manager and database-specific drivers to provide transparent connectivity to databases from different vendors. This is shown in Figure 15-6. A JDBC driver translates standard JDBC calls into a protocol that the underlying database can understand. This translation function makes JDBC applications able to access many different databases. There are four distinct types of JDBC drivers. Details about the four drivers and their mechanisms are beyond this chapter but can be found in reference 5.

Smartphone-based parking guidance algorithm and implementation

View Article

Journal Information

Published in Journal of Intelligent Transportation Systems, 2021

Hongyan Gao, Qian Yun, Rundong Ran, Jun Ma

The server provides necessary functions of database connection, client-server communication, and implementation of parking guidance algorithm. The project creates database connection using MySQL JDBC driver through the steps of defining the connection URL, establishing the JDBC connection, creating statements, setting parameters, and retrieving results. The server handles client’s requests and returns responses to client using Java Servlet, which provides a communication interface between Java program handler and client’s request. Java program handler processes the data according to parking guidance algorithm and then obtains optimal parking lot and driving route.

Explore chapters and articles related to this topic

Fundamentals of Database Technology and Database-Driven Web Applications

Smartphone-based parking guidance algorithm and implementation