INFS2609 SOFTWARE IMPLEMENTATION

SESSION ONE 2000

LABORATORY EXERCISE EIGHT

WEEK BEGINNING 8/5/2000

 
During this lab you will write the code for GetDBConnection(), GetRecordName(), SaveOldRecord(), SaveNewRecord(), and DisplayRecord() methods of MyEditorDB.java program. You must follow the instructions provided in the program comments that start with // **.

You must download the program skeleton (i.e. MyEditorDB.java) and the database (i.e. EditorDB.mdb) that will be used for testing.

Before testing the program you must register the data base (e.g. MyEditorDB) with ODBC.
 

  1. Click on the START button

  2. Select PROGRAM option

  3. Then, Select ODBC32cp.cpl option

  4. Click on ADD button

  5. Double click on Microsoft Access Driver.mdb

  6. Enter data source name (e.g. EditorDB)

  7. Click on SELECT button and select the file name (e.g. A:\EditorDB.mdb)

  8. Double click on "file name" or select and click OK button

  9. Then, Click on OK button

  10. Check that your data base is on the list  and click on OK button.

 
Please compile and test (execute) your program.

The completion of each "method" (listed above) gives you 0.2 mark totalling 1 mark
 

 Work to be submitted:

MyEditorDB.java (Compiled and tested - Working!)

Submit your completed work in a 3 1/4; inch high-density floppy disk. The disk should be marked with student number, student name, lab session ( e.g. INFS2609 - MON 19:00) and computing environment ( JDK or Visual Age).