The steps involved are:
-
The Java servlet establishes contact with the Oracle server installed on a UNIX machine (here osprey7) using sockets. By passing SQL statements, which contain the Oracle data tables and field rows, the LCU data of all quizzes, test, exercises etc. is retrieved. This data contains HTML tags and the workpages consisting of the problems and questions are displayed on the Internet browser.
-
The user can then select a particular problem and its related questions which needs to be modified. Upon selection, the Java servlet is called which makes a connection to the Acces database using the JDBC-ODBC driver on Windows and transfers data to Access's database's tables.
|
