Programming lanuages 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.

Author Notes

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

Preface	p. xi
The Authors	p. xv
Acknowledgments	p. xvii
Chapter 1 Introduction	p. 1
1.1 Computers	p. 1
1.2 Computer Programming Languages	p. 1
1.2.1 Role of Computer Programming Language	p. 1
1.2.2 Software Systems	p. 2
1.2.3 Taxonomies of Computer Programming Languages	p. 3
1.3 Computing Architecture in the Internet Environment	p. 4
1.4 Key Characteristics Shared by All Procedural Programming Languages	p. 5
1.4.1 Syntax, Sentence, and Word	p. 5
1.4.2 Variable	p. 5
1.4.3 Arithmetic Operation	p. 6
1.4.4 Execution Sequence	p. 6
1.4.5 If-Then-Else Logic	p. 6
1.4.6 Loop	p. 6
1.4.7 Module	p. 7
Chapter 2 C++	p. 9
2.1 Introduction to Function-Oriented and Object-Oriented Programming	p. 9
2.2 A Tour of C Language	p. 9
2.2.1 C and C++ Keyword and User-Defined Word	p. 14
2.2.2 Comment Statements	p. 14
2.2.3 Preprocessor	p. 14
2.2.4 Namespace	p. 14
2.2.5 Structure of a C Program, Functions, and Arguments	p. 15
2.2.6 Statements and Semicolon	p. 16
2.2.7 Data Type	p. 16
2.2.8 Arithmetic Operations	p. 16
2.2.9 for-Loop	p. 17
2.2.10 printf() Statement with Conversion Specifier	p. 18
2.2.11 if-Statement	p. 18
2.2.12 String and String Processing	p. 20
2.3 Functional Approach	p. 20
2.3.1 Functional Decomposition	p. 20
2.3.2 A Simple Example of User-Defined Function	p. 21
2.3.3 Declaration of User-Defined Function	p. 22
2.3.4 Calling-Function and Called-Function	p. 22
2.3.5 Structure Diagram	p. 23
2.3.6 An Example of Two Functions	p. 23
2.3.7 An Example of Multiple Functions	p. 25
2.4 Object-Oriented Approach	p. 29
2.4.1 Object and Class	p. 29
2.4.2 Descriptions of Class	p. 31
2.4.3 public and private Statements	p. 32
2.4.4 Constructor	p. 32
2.4.5 Use of Class-Declare Object and Message Sending	p. 32
2.5 Design of Objected-Oriented Program	p. 35
2.6 Connection between Classes-An Example with Two Classes	p. 39
2.7 An Example of Inheritance	p. 43
2.8 Identify Class	p. 48
2.9 Debugging	p. 48
Appendix 2.1 Commonly Used C and C++ Keywords	p. 52
C and C++ Keywords	p. 52
C++ Only Keywords	p. 52
Chapter 3 HTML, JavaScript, and CSS	p. 53
3.1 Introduction to the Internet	p. 53
3.2 Creating Web Pages Using HTML	p. 54
3.3 Simple Container Tags	p. 55
3.3.1 p. 55
3.3.2 and	p. 55
3.3.3 p. 55
3.3.4 Comments	p. 55
3.3.5 Headings ...	p. 56
3.3.6 p. 56
3.3.7 p. 56
3.3.8 , , , and	p. 56
3.3.9 p. 56
3.3.10 p. 56
3.4 Empty Tags	p. 56
3.4.1 p. 56
3.4.2 p. 56
3.4.3 p. 57
3.5 Complex Container Tags	p. 59
3.5.1 p. 59
3.5.1.1 Attribute ACTION	p. 59
3.5.1.2 Attribute METHOD	p. 60
3.5.1.3 and Its Attributes TYPE, NAME, SIZE, and VALUE	p. 60
3.5.2 FRAME and FRAMESET	p. 60
3.6 Publish Web Page	p. 61
3.7 Introduction to JavaScript	p. 61
3.8 Image Manipulation	p. 62
3.8.1 Object Classes and Their Methods and Attributes	p. 63
3.8.2 Event Handler	p. 64
3.9 FORM Input Data Verification	p. 64
3.9.1 Comparison of JavaScript with C and C++	p. 66
3.9.2 Function and Calling a Function	p. 67
3.9.3 String Processing	p. 68
3.9.4 if-Statement	p. 68
3.9.5 alert-Statement	p. 69
3.10 FORM Data Calculation	p. 69
3.11 Cookies	p. 71
3.12 Miscellaneous JavaScript Statements	p. 74
3.12.1 new Statement	p. 74
3.12.2 Miscellaneous Functions and Methods	p. 74
3.13 Cascading Style Sheet	p. 74
3.13.1 Inline CSS	p. 75
3.13.2 Internal CSS	p. 76
3.13.3 External CSS	p. 79
3.14 Debugging Source Code of Web Pages	p. 80
Appendix 3.1 List of HTML Commonly Used Tags	p. 85
Appendix 3.2 JavaScript Reserved Words and Other Keywords	p. 86
JavaScript Reserved Words	p. 86
Chapter 4 VB.NET	p. 87
4.1 Graphical User Interface	p. 87
4.2 Microsoft Visual Studio and VB.NET Environment	p. 87
4.3 Event Driven	p. 90
4.4 Example of a Single Form	p. 93
4.5 Multiple Forms	p. 96
4.5.1 Design Forms	p. 96
4.5.2 Module	p. 98
4.5.3 Class	p. 99
4.5.4 Coding	p. 100
4.6 Programming with VB.NET	p. 106
4.6.1 General Format of Code, Comments, and Keywords	p. 106
4.6.2 Class and Object	p. 108
4.6.3 Methods	p. 108
4.6.4 Constant Variables	p. 109
4.6.5 Data Types	p. 109
4.6.6 Arithmetic Operations	p. 109
4.6.7 If-Then-Else Statement	p. 110
4.6.8 For-loop	p. 110
4.6.9 String Processing and Format Statement	p. 110
4.6.10 Print Document	p. 110
4.6.11 Message Box	p. 111
4.7 Debugging	p. 111
Chapter 5 C#.NET	p. 115
5.1 Microsoft Visual Studio and C# Programming Environment	p. 115
5.2 C# Program Structure	p. 117
5.3 Run a C# Console Application Program	p. 117
5.4 C# Syntax	p. 118
5.4.1 Arrays and foreach loop	p. 119
5.4.2 Command Line Arguments	p. 120
5.4.3 Functions	p. 121
5.5 Examples of Console Application	p. 123
5.6 Windows Forms Application	p. 127
5.7 Examples of Windows Forms Application	p. 130
5.8 Debugging	p. 138
Chapter 6 ASP.NET	p. 145
6.1 Introduction to ASP.NET	p. 145
6.2 ASP.NET with VB.NET	p. 146
6.2.1 Structure of ASP.NET Program	p. 147
6.2.2 HTML Controls Versus ASP.NET Web Controls	p. 149
6.2.3 HTML Controls	p. 149
6.2.3.1 Submit Button	p. 150
6.2.3.2 Textbox	p. 150
6.2.3.3 Checkbox	p. 151
6.2.3.4 Radio Button	p. 152
6.2.3.5 Select	p. 153
6.2.4 Web Controls	p. 154
6.2.5 Validation Controls	p. 156
6.2.6 The Code-Behind Programming Framework	p. 157
6.2.7 Server-Side File Processing	p. 159
6.2.8 Accessory Features	p. 162
6.2.8.1 Sending E-mail Message	p. 162
6.2.8.2 Calendar	p. 163
6.2.8.3 Redirect: Method	p. 164
6.2.8.4 Security	p. 166
6.2.9 Web Application Design	p. 168
6.2.10 ADO.NET-Server-Side Database Processing	p. 172
6.2.10.1 Database Connection and SQL in ASP.NET	p. 173
6.2.10.2 Search Database	p. 175
6.2.10.3 Update Database	p. 177
6.2.10.4 Use Data of Database for Decision	p. 177
6.3 ASP.NET with C#.NET	p. 179
6.3.1 C# Programming with ASP.NET Web Controls	p. 179
6.3.2 Code-Behind Programming	p. 184
6.3.3 Server-Side File Processing	p. 185
6.3.4 Control for Database Processing	p. 192
6.4 Debugging	p. 195
Chapter 7 PHP	p. 201
7.1 Introduction to PHP and PHP Development Environment	p. 201
7.2 Format of PHP Program	p. 202
7.3 Structure of PHP Program	p. 205
7.4 Activate PHP in Web Page and Process Form Data on Server	p. 206
7.5 Programming in PHP	p. 207
7.5.1 PHP Functions	p. 207
7.5.2 if-Statement	p. 209
7.5.3 Read Data File from Server	p. 209
7.5.4 fopen() and fcloae()	p. 210
7.5.5 feof() and fgets()	p. 211
75.6 while-loop	p. 211
75.7 Write Data File to Server and f puts ()	p. 211
7.6 Relay Data through Multiple Dynamic Web Pages Using Hidden Fields	p. 212
7.7 Example of Web Application Design	p. 215
7.8 PHP and MySQL Database	p. 219
7.8.1 Set MySQL Database	p. 219
7.8.2 Create and Delete Table in PHP Using SQL	p. 221
7.8.3 Insert Data to Table	p. 222
7.8.4 Access Database	p. 222
7.8.5 Search Database	p. 224
7.8.6 Use ODBC Connection	p. 225
7.9 Debugging	p. 225
Chapter 8 XML	p. 229
8.1 Introduction to XML	p. 229
8.1.1 HTML Documents Arc Difficult to Process	p. 229
8.1.2 Databases Need Common Data Format to Exchange Data	p. 230
8.2 XML Documents Are Data Sheets	p. 231
8.2.1 XML Instance Documents	p. 231
8.2.2 Declaration	p. 232
8.2.3 Tags and Element	p. 232
8.2.4 Attribute	p. 232
8.2.5 Comment Line and Editorial Style	p. 233
8.3 Cascading Style Sheets	p. 233
8.4 Extensible Style Language	p. 234
8.4.1 p. 235
8.4.2 p. 235
8.4.3 HTML Presentation	p. 235
8.4.4 p. 235
8.4.5 Empty Tag	p. 236
8.4.6 p. 236
8.5 XML Data Tree	p. 236
8.6 CSS Versus XSLT	p. 237
8.7 Document Type Definition and Validation	p. 239
8.7.1 Simple Example of Internal DTD	p. 240
8.7.2 Simple Example of External DTD	p. 240
8.7.3 p. 241
8.7.4 p. 241
8.7.5 p. 242
8.7.6 p. 242
8.8 XML Schema	p. 242
8.8.1 Schema Element	p. 243
8.8.2 Data Element, Attribute, and Data Type	p. 244
8.8.3 complexType	p. 244
8.8.4 sequence	p. 244
8.8.5 Cardinality	p. 244
8.8.6 Attribute	p. 244
8.8.7 XML Validation	p. 244
8.9 Summary of Application of XML	p. 245
8.10 An Example of XML Application	p. 246
8.11 Advanced Subjects of XML	p. 251
8.11.1 Conversion of Relational Database into XML Tree	p. 251
8.11.2 xlink and xsl:if	p. 254
8.11.2.1 xlink	p. 259
8.11.2.2 p. 260
8.12 XHTML	p. 260
8.13 XBRL	p. 262
8.13.1 Comparison of XBRL with XML	p. 262
8.13.2 Taxonomy	p. 263
8.13.3 Prepare XBRL-Based Reports	p. 263
Chapter 9 SQL	p. 267
9.1 Introduction to SQL	p. 267
9.2 CREATE and DROP	p. 267
9.3 INSERT, UPDATE, DELETE	p. 268
9.4 Query-SELECT	p. 269
9.5 WHERE Clause and Comparison	p. 271
9.6 ORDER BY Clause	p. 272
9.7 Aggregate Functions	p. 273
9.8 GROUP BY Clause and HAVING Clause	p. 273
9.9 Joining Tables	p. 274
9.10 Subquery	p. 275
9.10.1 Subquery-Reducing Computational Workload of Join Operation	p. 275
9.10.2 Subquery as an Alternative to GROUP BY	p. 277
9.10.3 Subquery-Determining an Uncertain Criterion	p. 277
9.11 Tactics for Writing Queries	p. 278
9.12 SQL Embedded in Host Computer Programming Languages	p. 278
Index	p. 281

Available:*

On Order

Summary

Summary

Author Notes

Table of Contents