Preface |
|
xi | |
The Authors |
|
xv | |
Acknowledgments |
|
xvii | |
|
|
1 | (8) |
|
|
1 | (1) |
|
1.2 Computer Programming Languages |
|
|
1 | (3) |
|
1.2.1 Role of Computer Programming Language |
|
|
1 | (1) |
|
|
2 | (1) |
|
1.2.3 Taxonomies of Computer Programming Languages |
|
|
3 | (1) |
|
1.3 Computing Architecture in the Internet Environment |
|
|
4 | (1) |
|
1.4 Key Characteristics Shared by All Procedural Programming Languages |
|
|
5 | (4) |
|
1.4.1 Syntax, Sentence, and Word |
|
|
5 | (1) |
|
|
5 | (1) |
|
1.4.3 Arithmetic Operation |
|
|
6 | (1) |
|
|
6 | (1) |
|
|
6 | (1) |
|
|
6 | (1) |
|
|
7 | (2) |
|
|
9 | (44) |
|
2.1 Introduction to Function-Oriented and Object-Oriented Programming |
|
|
9 | (1) |
|
|
9 | (11) |
|
2.2.1 C and C++ Keyword and User-Defined Word |
|
|
14 | (1) |
|
|
14 | (1) |
|
|
14 | (1) |
|
|
14 | (1) |
|
2.2.5 Structure of a C Program, Functions, and Arguments |
|
|
15 | (1) |
|
2.2.6 Statements and Semicolon |
|
|
16 | (1) |
|
|
16 | (1) |
|
2.2.8 Arithmetic Operations |
|
|
16 | (1) |
|
|
17 | (1) |
|
2.2.10 printf() Statement with Conversion Specifier |
|
|
18 | (1) |
|
|
18 | (2) |
|
2.2.12 String and String Processing |
|
|
20 | (1) |
|
|
20 | (9) |
|
2.3.1 Functional Decomposition |
|
|
20 | (1) |
|
2.3.2 A Simple Example of User-Defined Function |
|
|
21 | (1) |
|
2.3.3 Declaration of User-Defined Function |
|
|
22 | (1) |
|
2.3.4 Calling-Function and Called-Function |
|
|
22 | (1) |
|
|
23 | (1) |
|
2.3.6 An Example of Two Functions |
|
|
23 | (2) |
|
2.3.7 An Example of Multiple Functions |
|
|
25 | (4) |
|
2.4 Object-Oriented Approach |
|
|
29 | (6) |
|
|
29 | (2) |
|
2.4.2 Descriptions of Class |
|
|
31 | (1) |
|
2.4.3 Public and private Statements |
|
|
32 | (1) |
|
|
32 | (1) |
|
2.4.5 Use of Class---Declare Object and Message Sending |
|
|
32 | (3) |
|
2.5 Design of Objected-Oriented Program |
|
|
35 | (4) |
|
2.6 Connection between Classes---An Example with Two Classes |
|
|
39 | (4) |
|
2.7 An Example of Inheritance |
|
|
43 | (5) |
|
|
48 | (1) |
|
|
48 | (5) |
|
Appendix 2.1 Commonly Used C and C++ Keywords |
|
|
52 | (1) |
|
|
52 | (1) |
|
|
52 | (1) |
|
Chapter 3 HTML, JavaScript, and CSS |
|
|
53 | (34) |
|
3.1 Introduction to the Internet |
|
|
53 | (1) |
|
3.2 Creating Web Pages Using HTML |
|
|
54 | (1) |
|
3.3 Simple Container Tags |
|
|
55 | (1) |
|
|
55 | (1) |
|
|
55 | (1) |
|
|
55 | (1) |
|
|
55 | (1) |
|
3.3.5 Headings <H1> <H2>... <H6> |
|
|
56 | (1) |
|
|
56 | (1) |
|
|
56 | (1) |
|
3.3.8 <TABLE>, <TH>, <TR>, and <TD> |
|
|
56 | (1) |
|
|
56 | (1) |
|
|
56 | (1) |
|
|
56 | (3) |
|
|
56 | (1) |
|
|
56 | (1) |
|
|
57 | (2) |
|
3.5 Complex Container Tags |
|
|
59 | (2) |
|
|
59 | (1) |
|
|
59 | (1) |
|
|
60 | (1) |
|
3.5.1.3 <INPUT> and Its Attributes TYPE, NAME, SIZE, and VALUE |
|
|
60 | (1) |
|
|
60 | (1) |
|
|
61 | (1) |
|
3.7 Introduction to JavaScript |
|
|
61 | (1) |
|
|
62 | (2) |
|
3.8.1 Object Classes and Their Methods and Attributes |
|
|
63 | (1) |
|
|
64 | (1) |
|
3.9 FORM Input Data Verification |
|
|
64 | (5) |
|
3.9.1 Comparison of JavaScript with C and C++ |
|
|
66 | (1) |
|
3.9.2 Function and Calling a Function |
|
|
67 | (1) |
|
|
68 | (1) |
|
|
68 | (1) |
|
|
69 | (1) |
|
3.10 FORM Data Calculation |
|
|
69 | (2) |
|
|
71 | (3) |
|
3.12 Miscellaneous JavaScript Statements |
|
|
74 | (1) |
|
|
74 | (1) |
|
3.12.2 Miscellaneous Functions and Methods |
|
|
74 | (1) |
|
3.13 Cascading Style Sheet |
|
|
74 | (6) |
|
|
75 | (1) |
|
|
76 | (3) |
|
|
79 | (1) |
|
3.14 Debugging Source Code of Web Pages |
|
|
80 | (7) |
|
Appendix 3.1 List of HTML Commonly Used Tags |
|
|
85 | (1) |
|
Appendix 3.2 JavaScript Reserved Words and Other Keywords |
|
|
86 | (1) |
|
JavaScript Reserved Words |
|
|
86 | (1) |
|
|
87 | (28) |
|
4.1 Graphical User Interface |
|
|
87 | (1) |
|
4.2 Microsoft Visual Studio and VB.NET Environment |
|
|
87 | (3) |
|
|
90 | (3) |
|
4.4 Example of a Single Form |
|
|
93 | (3) |
|
|
96 | (10) |
|
|
96 | (2) |
|
|
98 | (1) |
|
|
99 | (1) |
|
|
100 | (6) |
|
4.6 Programming with VB.NET |
|
|
106 | (5) |
|
4.6.1 General Format of Code, Comments, and Keywords |
|
|
106 | (2) |
|
|
108 | (1) |
|
|
108 | (1) |
|
|
109 | (1) |
|
|
109 | (1) |
|
4.6.6 Arithmetic Operations |
|
|
109 | (1) |
|
4.6.7 If-Then-Else Statement |
|
|
110 | (1) |
|
|
110 | (1) |
|
4.6.9 String Processing and Format Statement |
|
|
110 | (1) |
|
|
110 | (1) |
|
|
111 | (1) |
|
|
111 | (4) |
|
|
115 | (30) |
|
5.1 Microsoft Visual Studio and C# Programming Environment |
|
|
115 | (2) |
|
|
117 | (1) |
|
5.3 Run a C# Console Application Program |
|
|
117 | (1) |
|
|
118 | (5) |
|
5.4.1 Arrays and foreach loop |
|
|
119 | (1) |
|
5.4.2 Command Line Arguments |
|
|
120 | (1) |
|
|
121 | (2) |
|
5.5 Examples of Console Application |
|
|
123 | (4) |
|
5.6 Windows Forms Application |
|
|
127 | (3) |
|
5.7 Examples of Windows Forms Application |
|
|
130 | (8) |
|
|
138 | (7) |
|
|
145 | (56) |
|
6.1 Introduction to ASP.NET |
|
|
145 | (1) |
|
|
146 | (33) |
|
6.2.1 Structure of ASP.NET Program |
|
|
147 | (2) |
|
6.2.2 HTML Controls Versus ASP.NET Web Controls |
|
|
149 | (1) |
|
|
149 | (1) |
|
|
150 | (1) |
|
|
150 | (1) |
|
|
151 | (1) |
|
|
152 | (1) |
|
|
153 | (1) |
|
|
154 | (2) |
|
6.2.5 Validation Controls |
|
|
156 | (1) |
|
6.2.6 The Code-Behind Programming Framework |
|
|
157 | (2) |
|
6.2.7 Server-Side File Processing |
|
|
159 | (3) |
|
|
162 | (1) |
|
6.2.8.1 Sending E-mail Message |
|
|
162 | (1) |
|
|
163 | (1) |
|
|
164 | (2) |
|
|
166 | (2) |
|
6.2.9 Web Application Design |
|
|
168 | (4) |
|
6.2.10 ADO.NET---Server-Side Database Processing |
|
|
172 | (1) |
|
6.2.10.1 Database Connection and SQL in ASP.NET |
|
|
173 | (2) |
|
|
175 | (2) |
|
|
177 | (1) |
|
6.2.10.4 Use Data of Database for Decision |
|
|
177 | (2) |
|
|
179 | (16) |
|
6.3.1 C# Programming with ASP.NET Web Controls |
|
|
179 | (5) |
|
6.3.2 Code-Behind Programming |
|
|
184 | (1) |
|
6.3.3 Server-Side File Processing |
|
|
185 | (7) |
|
6.3.4 <asp:SqlDataSource> Control for Database Processing |
|
|
192 | (3) |
|
|
195 | (6) |
|
|
201 | (28) |
|
7.1 Introduction to PHP and PHP Development Environment |
|
|
201 | (1) |
|
7.2 Format of PHP Program |
|
|
202 | (3) |
|
7.3 Structure of PHP Program |
|
|
205 | (1) |
|
7.4 Activate PHP in Web Page and Process Form Data on Server |
|
|
206 | (1) |
|
|
207 | (5) |
|
|
207 | (2) |
|
|
209 | (1) |
|
7.5.3 Read Datable from Server |
|
|
209 | (1) |
|
7.5.4 fopen() and fclose() |
|
|
210 | (1) |
|
|
211 | (1) |
|
|
211 | (1) |
|
7.5.7 Write Data File to Server and fputs() |
|
|
211 | (1) |
|
7.6 Relay Data through Multiple Dynamic Web Pages Using Hidden Fields |
|
|
212 | (3) |
|
7.7 Example of Web Application Design |
|
|
215 | (4) |
|
7.8 PHP and MySQL Database |
|
|
219 | (6) |
|
|
219 | (2) |
|
7.8.2 Create and Delete Table in PHP Using SQL |
|
|
221 | (1) |
|
7.8.3 Insert Data to Table |
|
|
222 | (1) |
|
|
222 | (2) |
|
|
224 | (1) |
|
7.8.6 Use ODBC Connection |
|
|
225 | (1) |
|
|
225 | (4) |
|
|
229 | (38) |
|
|
229 | (2) |
|
8.1.1 HTML Documents Are Difficult to Process |
|
|
229 | (1) |
|
8.1.2 Databases Need Common Data Format to Exchange Data |
|
|
230 | (1) |
|
8.2 XML Documents Are Data Sheets |
|
|
231 | (2) |
|
8.2.1 XML Instance Documents |
|
|
231 | (1) |
|
|
232 | (1) |
|
|
232 | (1) |
|
|
232 | (1) |
|
8.2.5 Comment Line and Editorial Style |
|
|
233 | (1) |
|
8.3 Cascading Style Sheets |
|
|
233 | (1) |
|
8.4 Extensible Style Language |
|
|
234 | (2) |
|
|
235 | (1) |
|
|
235 | (1) |
|
|
235 | (1) |
|
|
235 | (1) |
|
|
236 | (1) |
|
|
236 | (1) |
|
|
236 | (1) |
|
|
237 | (2) |
|
8.7 Document Type Definition and Validation |
|
|
239 | (3) |
|
8.7.1 Simple Example of Internal DTD |
|
|
240 | (1) |
|
8.7.2 Simple Example of External DTD |
|
|
240 | (1) |
|
|
241 | (1) |
|
|
241 | (1) |
|
|
242 | (1) |
|
|
242 | (1) |
|
|
242 | (3) |
|
|
243 | (1) |
|
8.8.2 Data Element, Attribute, and Data Type |
|
|
244 | (1) |
|
|
244 | (1) |
|
|
244 | (1) |
|
|
244 | (1) |
|
|
244 | (1) |
|
|
244 | (1) |
|
8.9 Summary of Application of XML |
|
|
245 | (1) |
|
8.10 An Example of XML Application |
|
|
246 | (5) |
|
8.11 Advanced Subjects of XML |
|
|
251 | (9) |
|
8.11.1 Conversion of Relational Database into XML Tree |
|
|
251 | (3) |
|
|
254 | (5) |
|
|
259 | (1) |
|
|
260 | (1) |
|
|
260 | (2) |
|
|
262 | (5) |
|
8.13.1 Comparison of XBRL with XML |
|
|
262 | (1) |
|
|
263 | (1) |
|
8.13.3 Prepare XBRL-Based Reports |
|
|
263 | (4) |
|
|
267 | (14) |
|
|
267 | (1) |
|
|
267 | (1) |
|
9.3 INSERT, UPDATE, DELETE |
|
|
268 | (1) |
|
|
269 | (2) |
|
9.5 WHERE Clause and Comparison |
|
|
271 | (1) |
|
|
272 | (1) |
|
|
273 | (1) |
|
9.8 GROUP BY Clause and HAVING Clause |
|
|
273 | (1) |
|
|
274 | (1) |
|
|
275 | (3) |
|
9.10.1 Subquery---Reducing Computational Workload of Join Operation |
|
|
275 | (2) |
|
9.10.2 Subquery as an Alternative to GROUP BY |
|
|
277 | (1) |
|
9.10.3 Subquery---Determining an Uncertain Criterion |
|
|
277 | (1) |
|
9.11 Tactics for Writing Queries |
|
|
278 | (1) |
|
9.12 SQL Embedded in Host Computer Programming Languages |
|
|
278 | (3) |
Index |
|
281 | |