1st Edition
Programming Languages for Business Problem Solving
It has become crucial for managers to be computer literate in today’s business environment. It is also important that those entering the field acquire the fundamental theories of information systems, the essential practical skills in computer applications, and the desire for life-long learning in information technology.
Programming Languages for Business Problem Solving presents a working knowledge of the major programming languages, including COBOL, C++, Java, HTML, JavaScript, VB.NET, VBA, ASP.NET, Perl, PHP, XML, and SQL, used in the current business computing environment. The book examines the concepts shared by these languages and details the unique features of each. It also focuses on various programming techniques, including structured, object-oriented, client-side and server-side programming, as well as graphical user-interface and multi-media processing.
Self-contained, the book provides hands-on examples, self-review questions, project requirements, report formats, and operational manuals of programming environments for use by both MIS students and professionals.
COBOL AND FILE PROCESSING
Introduction to COBOL
Legacy Information Systems
A General Structure of COBOL—Four Divisions
COBOL Words
COBOL Program Format—Positioning, Spacing, and Punctuation
Typical Examples of COBOL Programs
The Computing Context of COBOL Programming
Use 3GL
Debugging
Design and Documentation of 3GL Programming
The Differences between 3GL and 4GL
Self-Review Exercise
APPENDIX 1.1 Commonly Used COBOL Reserved Words
APPENDIX 1.2 Instructions of Using COBOL on Mainframe
APPENDIX 1.3 A Guideline for COBOL Project Report
AU6264_C000.indd
C++ AND OBJECT-ORIENTED PROGRAMMING
Introduction to Object-Oriented Programming
A Tour of C Language
Functional Approach
Object-Oriented Approach
An Example of C++ Program with One Object Class
An Example of C++ Program with Two Object Classes
An Example of C++ Program with Multiple Classes and Inheritance
Identify Classes for OOP Projects
Debugging
Self-Review Exercise
Appendix 2.1 Commonly Used C and C++ Keywords
Appendix 2.2 Instructions for Using C++ on Mainframe
Appendix 2.3 A Guideline for C++ Project Report
AU6264_C000.indd
HTML, JAVASCRIPT, AND WEB PAGES
Introduction to World Wide Web and the Internet
Creating Web Pages Using HTML
Simple Container Tags
Empty Tags
Complex Container Tags
Publish the Web Page and Create Web Pages without Writing
HTML
Introduction to JavaScript
Typical Examples of JavaScript
Debugging Source Codes of Web Pages
Self-Review Exercise
Appendix 3.1 HTML Tag List
Appendix 3.2 JavaScript Reserved Words and Other Keywords
Appendix 3.3 A Guideline for Web Page Project Report
JAVA AND COMPUTING ON THE INTERNET
Web-Based Computing
Web Servers with Java-Style
Introduction to Java Applets
Run a Java Applet Within a Web Page
Java Applet Programming
Examples of Java Applets
Java Applications (Free-Standing Java Programs)
Java Servlets
An Example of Web-Based Business Application Using Java
Servlets
Databases Connection and the Use of SQL
Typical Scheme of Web-Based Business Applications
Debugging Java Programs
Self-Review Exercise
Appendix 4.1 Set up Java Platform for JDK and Java Servlets on Computer with
Windows
Operating System
Appendix 4.2 Use WS-FTP to Upload and Download Files
Appendix 4.3 A Guideline for Web Page Integrating
Appendix 4.4 A Guideline for Server-Side Programming (Java
Servlet) Project Report
VISUAL BASIC AND GRAPHICAL USER INTERFACE
Graphical User Interface
The VB.NET Environment
Event-Driven Programs and Brief Overview of VB.NET
A Single-Form VB.NET Project
A VB.NET Project with Multiple Forms
Programming with VB.NET
Debugging
Self-Review Exercise
Appendix 5.1 A Guideline for VB.NET Project Report
VISUAL BASIC FOR APPLICATIONS AND DECISION SUPPORT SYSTEMS
Concepts of Decision Support Systems
Macro
A DSS Example of VBA
Macro Code of the Example
Analyzing Code of VBA and Other Features of VBA
Self-Review Exercise
PERL AND CGI FOR WEB-BASED APPLICATIONS
Web-Based Applications
CGI and CGI Programming
Introduction to Perl
Test Perl on the Server
Perl Programming
Debugging
A Framework of CGI Implemented Web-Based Applications for
Electronic Commerce
Self-Review Exercise
Appendix 7.1 Installation of ActivePerl on the Server with the
Windows Platform
Appendix 7.2 A Guideline for Server-Side Programming (Perl)
Project Report
AU6264_C000.indd
PHP FOR WEB-BASED APPLICATIONS
Introduction to PHP
The Structure of a PHP Script
Web Page to Trigger PHP
Read Data Files from the Server
Write Data Files to the Server and fputs()
Relay Data through Multiple Forms Using Hidden Fields
Debugging
Self-Review Exercise
Appendix 8.1 A Guideline for Server-Side Programming (PHP) Project Report
ASP.NET FOR WEB-BASED APPLICATIONS
Introduction to ASP.NET
The Structure of an ASP.NET Program
HTML Controls vs. Web Controls
HTML Controls
Web Controls
Validation Controls
The Code-Behind Programming Framework
ASP.NET Web Page Application Examples
Debugging
Self-Review Exercise
Appendix 9.1 Install IIS for ASP.NET
Appendix 9.2 A Guideline for Server-Side Programming (ASP.NET) Project Report
XML AND THE UNIFORM DATA FORMAT FOR THE INTERNET
Introduction to XML
Simplest Examples of XML
Document Type Definition and Validation
XML Schemas
Business Applications of XML
XHTML
eXtensible Business Reporting Language
Self-Review Exercise
Appendix 10.1 A Guideline for XML Project Report
AU6264_C000.indd
SQL FOR DATABASE QUERY
Introduction to SQL
View SQL of a Query Created in Access
Write and Run SQL in Access
Major Features of SQL—SELECT
Sub-Query
Other SQL Features
SQL in Web Applications
Self-Review Exercise
Appendix 11.1 A Guideline for SQL Project Report
SIX KEY CONCEPTS SHARED BY ALL PROCEDURAL PROGRAMMING
LANGUAGES
INDEX
Biography
Shouhong Wang, Hai Wang