Java-based approaches for accessing databases on the Internet and a JDBC-ODBC implementation
An important area of Java development is to create Java based software or tools with the capability of accessing databases over the Internet. JDBC and its various properties are explored. Several Java based technical approaches for accessing databases on the Internet are proposed and investigated in detail. A design and implementation of the Java software for accessing databases on the Internet is proposed and described, where the design scheme of an interactive applet by using Java JDBC programming is proposed and investigated, the main JDBC classes used in the Java program and the relationship between them are discussed, the implementation of the software is provided, and some instances for running the Java program are given. This Java software provides an interactive and user friendly interface on the browser which supports Java JDK 1.1 or later and the software has the capability for the connection, SQL access, retrieval and display of a database on the Internet.