Java is a high-level programming language which is rapidly growing advanced technologies in the field of computer and information fields. With the other machine, languages we can either compile or infer a program to run the program on the system, but the profit of using is that it can be both compiled and interpreted. In Java the program is divide into halfway code called the byte codes.
This is platform independent code and is interpreted by the interpreter on the Java platform. It has the following buzzwords:- • Simplicity• Object-oriented• Platfrorm independence• Robust• Secure• Dynamic• Portable• Multithreaded• High performance• Architectural neutral 2.4.2 . JAVA PLATFORM Generally, platform is defined as the hardware or software environment on which our programs run. Some of the reputed ones are windows 2000, Linux, Solaris and MacOS. Platform may be considered as a combination of the operating system and hardware. The Java platform is a software platform that runs on the top of the other hardware based platform.
The Java platform has two components namely:• The Java Virtual Machine(JVM)• The Java Programming Application Interface(Java API)Java Virtual Machine is the base platform for the Java platform and it is ported into various hardware-based platforms. Java API is generally grouped into libraries of classes and interfaces. This classes is also known as packages. The following diagram shows the uses of Java platform and how the Java virtual and the Java API insulate the program from the hardware 2.4.
3 ODBC ODBC stands for Open Database Connectivity is a standard programming interface for database service providers and the application developers. ODBC is the de facto for the windows to get connected or interact with the database system, programmers has to use different programming languages to get connected with the database. Now, the ODBC has made the choice of the database system easier and efficient.. Application engineers have considerably more vital things to stress over than the language structure that is expected to port their program starting with one database then onto the next when business needs abruptly change. Through the ODBC Administrator in Control Panel, you can determine the specific database that is related with an information source that an ODBC application program is composed to utilize.
Think about an ODBC information source as an entryway with a name on it. Every entryway will lead you to a specific database. For instance, the information source named Sales Figures may be a SQL Server database, while the Accounts Payable information source could allude to an Access database. The physical database alluded to by an information source can live anyplace on the LAN.
2.4.4 JDBC Java Database Connectivity or JDBC is developed by Sun Microsystems to develop an independent standard database API for Java.
A generic SQL database access mechanism is provided which in turn provides a consistent interface to variety of Relational Database Management System (RDMS).Database connectivity module use “plug-in” to maintain the interface consistency. Divers for each platform should be provided to the database & Java to have JDBC support. To pick up a more extensive acknowledgement of JDBC ,Sun construct JDBC’s system with respect to ODBC.JDBC GOAL Barely any product bundles are planned without objectives as a top priority. JDBC is one that, as a result of its numerous objectives, drove the advancement of the API.
These objectives, in conjunction with early commentator input, have settled the JDBC class library into a strong structure for building database applications in Java. The objectives that were set for JDBC are essential. They will give you some knowledge with reference to why certain classes and functionalities carry on the way they do. The eight design goals of JDBC are as follows• SQL Level API.• SQL Conformance.
• JDBC must be implemented on the top of common database interface.• A Java interface is provide which is consistent with the rest of the Java system.• It should be kept simple.• Keep the common cases simple.
It is executed as a Windows Script motor. This implies it can be “connected to any application that backings Windows Script, for example, Internet Explorer, Active Server Pages, and Windows Script Host. It furthermore implies that any application supporting Windows Script can utilize different dialects – JScript, VBScript, Perl, and others. JScript (and alternate dialects) can be utilized for both basic assignments, (for example, mouseovers on Web pages) and for more mind boggling errands, (for example, refreshing a database with ASP or running logon contents for Windows NT ).