Using ODBC-JDBC with java.sql.*
Filed Under (Software Development) by admin on 06-11-2008
Tagged Under : Java ODBC-JDBC
Open Database Connectivity (ODBC) is a standard or open Application Programming Interface (API), helpful in accessing a database. You can access files in a number of different databases, such as MS Access, dBase, DB2, MS Excel, and Text by using ODBC statements in a program. ODBC also allows programs to use SQL requests that can access databases without enabling to know the proprietary interfaces to the databases and handles the SQL request and it can convert the same into a request that the individual database system can understand.
Java Database Connectivity (JDBC) is a Java API that consists of a set of classes and interfaces written in Java for connecting programs written in Java to the data in Relational Databases. JDBC provides a standard API for tool or database developers enabling to write database applications using a pure Java API. It can also establish a connection with a database, sends SQL statements, and processes the results. It also allows SQL-based database access for EJB persistence.







