1st Edition

Programming Languages for Business Problem Solving

By Shouhong Wang, Hai Wang Copyright 2008
    384 Pages 111 B/W Illustrations
    by Auerbach Publications

    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