1st Edition

Programming Languages for MIS Concepts and Practice

By Hai Wang, Shouhong Wang Copyright 2014
    317 Pages 140 B/W Illustrations
    by Auerbach Publications

    Programming Languages for MIS: Concepts and Practice supplies a synopsis of the major computer programming languages, including C++, HTML, JavaScript, CSS, VB.NET, C#.NET, ASP.NET, PHP (with MySQL), XML (with XSLT, DTD, and XML Schema), and SQL. Ideal for undergraduate students in IS and IT programs, this textbook and its previous versions have been used in the authors’ classes for the past 15 years.

    Focused on web application development, the book considers client-side computing, server-side computing, and database applications. It emphasizes programming techniques, including structured programming, object-oriented programming, client-side programming, server-side programming, and graphical user interface.

    • Introduces the basics of computer languages along with the key characteristics of all procedural computer languages
    • Covers C++ and the fundamental concepts of the two programming paradigms: function-oriented and object-oriented
    • Considers HTML, JavaScript, and CSS for web page development
    • Presents VB.NET for graphical user interface development
    • Introduces PHP, a popular open source programming language, and explains the use of the MySQL database in PHP
    • Discusses XML and its companion languages, including XSTL, DTD, and XML Schema

    With this book, students learn the concepts shared by all computer languages as well as the unique features of each language. This self-contained text includes exercise questions, project requirements, report formats, and operational manuals of programming environments. A test bank and answers to exercise questions are also available upon qualified course adoption.

    This book supplies professors with the opportunity to structure a course consisting of two distinct modules: the teaching module and the project module. The teaching module supplies an overview of representative computer languages. The project module provides students with the opportunity to gain hands-on experience with the various computer languages through projects.

    Introduction
    Computers
    Computer Programming Languages
         Role of Computer Programming Language 
         Software Systems
         Taxonomies of Computer Programming Languages
    Computing Architecture in the Internet Environment
    Key Characteristics Shared by All Procedural Programming Languages 
         Syntax, Sentence, and Word
         Variable
         Arithmetic Operation
         Execution Sequence 
         If-Then-Else Logic 
         Loop 
         Module

    C++
    Introduction to Function-Oriented and Object-Oriented Programming
    A Tour of C Language 
         C and C++ Keyword and User-Defined Word 
         Comment Statements 
         Preprocessor 
         Namespace 
         Structure of a C Program, Functions, and Arguments 
         Statements and Semicolon 
         Data Type 
         Arithmetic Operations 
         for-Loop
         printf() Statement with Conversion Specifier 
         if-Statement 
         String and String Processing
    Functional Approach 
         Functional Decomposition 
         A Simple Example of User-Defined Function 
         Declaration of User-Defined Function
         Calling-Function and Called-Function 
         Structure Diagram 
         An Example of Two Functions
         An Example of Multiple Functions
    Object-Oriented Approach
         Object and Class 
         Descriptions of Class 
         public and private Statements 
         Constructor 
         Use of Class—Declare Object and Message Sending
    Design of Objected-Oriented Program
    Connection between Classes—An Example with Two Classes
    An Example of Inheritance
    Identify Class
    Debugging
    Appendix 2.1: Commonly Used C and C++ Keywords
    C and C++ Keywords
    C++ Only Keywords

    HTML, JavaScript , and CSS
    Introduction to the Internet
    Creating Web Pages Using HTML
    Simple Container Tags 
         <HTML> 
         <HEAD> and <TITLE> 
         <BODY> 
         Comments <!-- ... --> 
         Headings <H1> <H2> ... <H6> 
         <P> 
         <I> 
         <TABLE>, <TH>, <TR>, and <TD>
         <A> 
         <CENTER>
    Empty Tags 
         <HR> 
         <BR> 
         <IMG>
    Complex Container Tags
         <FORM> 
              Attribute ACTION 
              Attribute METHOD 
              <INPUT> and Its Attributes TYPE, NAME, SIZE, and VALUE 
         FRAME and FRAMESET
    Publish Web Page
    Introduction to JavaScript
    Image Manipulation 
         Object Classes and Their Methods and Attributes 
         Event Handler
    FORM Input Data Verification 
         Comparison of JavaScript with C and C++ 
         Function and Calling a Function 
         String Processing 
         if-Statement
         alert-Statement
    FORM Data Calculation
    Cookies
    Miscellaneous JavaScript Statements 
         new Statement 
         Miscellaneous Functions and Methods
    Cascading Style Sheet
         Inline CSS 
         Internal CSS 
         External CSS
    Debugging Source Code of Web Pages
    Appendix: List of HTML Commonly Used Tags
    Appendix: JavaScript Reserved Words and Other Keywords
    JavaScript Reserved Words

    VB.NET
    Graphical User Interface
    Microsoft Visual Studio and VB.NET Environment
    Event Driven
    Example of a Single Form
    Multiple Forms 
         Design Forms 
         Module 
         Class 
         Coding
    Programming with VB.NET 
         General Format of Code, Comments, and Keywords 
         Class and Object 
         Methods 
         Constant Variables 
         Data Types 
         Arithmetic Operations
         If-Then-Else Statement 
         For-loop
         String Processing and Format Statement 
         Print Document 
         Message Box
    Debugging

    C#.NET
    Microsoft Visual Studio and C# Programming Environment
    C# Program Structure
    Run a C# Console Application Program
    C# Syntax
         Arrays and foreach loop 
         Command Line Arguments 
         Functions
    Examples of Console Application
    Windows Forms Application
    Examples of Windows Forms Application
    Debugging

    ASP.NET
    Introduction to ASP.NET
    ASP.NET with VB.NET 
         Structure of ASP.NET Program 
         HTML Controls Versus ASP.NET Web Controls 
         HTML Controls 
              Submit Button 
              Textbox 
              Checkbox 
              Radio Button 
              Select 
         Web Controls 
         Validation Controls 
         The Code-Behind Programming Framework 
         Server-Side File Processing 
         Accessory Features 
              Sending E-mail Message
              Calendar 
              Redirect Method 
              Security 
         Web Application Design 
              ADO.NET—Server-Side Database Processing 
              Database Connection and SQL in ASP.NET 
              Search Database 
              Update Database 
              Use Data of Database for Decision
    ASP.NET with C#.NET 
         C# Programming with ASP.NET Web Controls 
         Code-Behind Programming 
         Server-Side File Processing 
         <asp:SqlDataSource> Control for Database Processing
    Debugging

    PHP
    Introduction to PHP and PHP Development Environment
    Format of PHP Program
    Structure of PHP Program
    Activate PHP in Web Page and Process Form Data on Server
    Programming in PHP 
         PHP Functions 
         if-Statement
         Read Data File from Server 
         fopen() and fclose() 
         feof() and fgets()
         while-loop
         Write Data File to Server and fputs()
    Relay Data through Multiple Dynamic Web Pages Using Hidden Fields
    Example of Web Application Design
    PHP and MySQL Database 
         Set MySQL Database 
         Create and Delete Table in PHP Using SQL 
         Insert Data to Table 
         Access Database
         Search Database 
         Use ODBC Connection
    Debugging

    XML
    Introduction to XML 
         HTML Documents Are Difficult to Process 
         Databases Need Common Data Format to Exchange Data
    XML Documents Are Data Sheets 
         XML Instance Documents 
         Declaration 
         Tags and Element 
         Attribute 
         Comment Line and Editorial Style
    Cascading Style Sheets
    Extensible Style Language 
         <xsl:stylesheet> 
         <xsl:template> 
         HTML Presentation
         <xsl:value-of>
         Empty Tag 
         <xsl:for-each>
    XML Data Tree
    CSS Versus XSLT
    Document Type Definition and Validation 
         Simple Example of Internal DTD 
         Simple Example of External DTD
         <!DOCTYPE> 
         <!ELEMENT> 
         <!ATTLIST> 
         <!ENTITY>
    XML Schema 
         Schema Element 
         Data Element, Attribute, and Data Type 
         complexType 
         sequence 
         Cardinality 
         Attribute 
         XML Validation
    Summary of Application of XML
    An Example of XML Application
    Advanced Subjects of XML 
         Conversion of Relational Database into XML Tree 
         xlink and xsl:if 
              xlink 
              <xsl:if>
    XHTML
    XBRL 
         Comparison of XBRL with XML 
         Taxonomy 
         Prepare XBRL-Based Reports

    SQL
    Introduction to SQL
    CREATE and DROP
    INSERT, UPDATE, DELETE
    Query—SELECT
    WHERE Clause and Comparison
    ORDER BY Clause
    Aggregate Functions
    GROUP BY Clause and HAVING Clause
    Joining Tables
    Subquery 
         Subquery—Reducing Computational Workload of Join Operation 
         Subquery as an Alternative to GROUP BY
         Subquery—Determining an Uncertain Criterion
    Tactics for Writing Queries
    SQL Embedded in Host Computer Programming Languages

    Index

    Biography

    Shouhong Wang, PhD, Professor of Management Information Systems, Charlton College of Business, University of Massachusetts Dartmouth, USA

    Hai Wang, PhD, Associate Professor of Computing and Information Systems, Sobey School of Business, Saint Mary's University, Canada