1 / 32

Web to Oracle Using Net Express and OO Cobol

Web to Oracle Using Net Express and OO Cobol. Alden C. Lorents College of Business Northern Arizona University Flagstaff, AZ alden.lorents@nau.edu. Introduction. Next Wave After Y2K Web Development E-Commerce Linkage to Existing Systems Web, Java and Cobol

briar
Download Presentation

Web to Oracle Using Net Express and OO Cobol

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Web to Oracle Using Net Express and OO Cobol Alden C. Lorents College of Business Northern Arizona University Flagstaff, AZ alden.lorents@nau.edu

  2. Introduction • Next Wave After Y2K • Web Development • E-Commerce • Linkage to Existing Systems • Web, Java and Cobol • Project to teach Web/Existing System Integration using Net Express

  3. Project Components • Web Component • Forms and CGI Development • Java Script • Data Base Component • Database Interface to Oracle • OO Cobol • Oracle Database Running on an NT Server • Building, Packaging and Testing

  4. Figure 1 Project Components DBI.PCO Oracle Pre compile DBI.CBL Oracle Libraries Net Express Build CGI.CBL CGI.EXE Business Logic Java Script CPY, CPV, CPF Files Web Window Build Form & CGI Build HTML Forms Web Window Execute Net Express Test Process Database Solo Web Emulator Oracle SQL and Libraries

  5. Building the Web Component • Net Express IDE • Building the Input and Output Forms with Form Designer • Copy file generation from Designer • Generating the CGI • Adding Business Logic • Adding Java Script

  6. Input Form and IDE

  7. Output Form and IDE

  8. Form Designer Generated CPY

  9. Form Designer Generated CPV

  10. Form Designer Generated CPF

  11. Generating the CGI

  12. Partial List from Generated CGI

  13. Adding CGI Data Division Entries

  14. Adding CGI Business Logic

  15. Generated Input HTML

  16. Java Script Added to Input HTML

  17. Generated Output HTML

  18. Database Interface Component • The PCO Source File • Embedded SQL • OO Structure and Methods • The Oracle Precompile Process • Error Correction • The Cobol Compile Process

  19. Partial DBI Source (PCO)

  20. DBI Oracle Logon Method

  21. DBI Read-Reservation Method

  22. Oracle Precompile Process

  23. Precompiled Read-Reservation

  24. Compiling the DBI

  25. Building and Testing • Building the Executable • Testing using Solo • Animating • CGI Animation • DBI Animation - SQL Calls • Testing the Java Script • Migration to the Web Server • Oracle Client • Micro Focus OO Support

  26. Net Express Build Set UP

  27. Net Express Build Process

  28. Testing Data Validation

  29. Testing Good Data

  30. Output From a Successful Test

  31. Future Development • Multiple Web Form Interaction • More Robust System of Queries • Database Updating • Moving the System to a Web Server • Oracle Client • Micro Focus OO Support

More Related