1st Edition
Programming Languages for MIS Concepts and Practice
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