Programming Languages for MIS: Concepts and Practice, 1st Edition (Hardback) book cover

Programming Languages for MIS

Concepts and Practice, 1st Edition

By Hai Wang, Shouhong Wang

Auerbach Publications

317 pages | 140 B/W Illus.

Purchasing Options:$ = USD
Hardback: 9781482222661
pub: 2014-01-23
SAVE ~$18.99
$94.95
$75.96
x
eBook (VitalSource) : 9780429162572
pub: 2014-01-23
from $47.48


FREE Standard Shipping!

Description

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.

Table of Contents

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

About the Authors

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

Subject Categories

BISAC Subject Codes/Headings:
COM032000
COMPUTERS / Information Technology
COM051010
COMPUTERS / Programming Languages / General
COM051230
COMPUTERS / Software Development & Engineering / General