Programming languages for business problem solving:
Gespeichert in:
| Beteiligte Personen: | , |
|---|---|
| Format: | Buch |
| Sprache: | Englisch |
| Veröffentlicht: |
Boca Raton, Fla. [u.a.]
Auerbach Publ.
2008
|
| Schlagwörter: | |
| Links: | http://www.loc.gov/catdir/toc/ecip0719/2007021973.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016240844&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| Umfang: | XXV, 357 S. Ill. |
| ISBN: | 9781420062649 1420062646 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV023037087 | ||
| 003 | DE-604 | ||
| 005 | 20080129 | ||
| 007 | t| | ||
| 008 | 071206s2008 xxua||| |||| 00||| eng d | ||
| 010 | |a 2007021973 | ||
| 020 | |a 9781420062649 |9 978-1-4200-6264-9 | ||
| 020 | |a 1420062646 |9 1-4200-6264-6 | ||
| 035 | |a (OCoLC)137331465 | ||
| 035 | |a (DE-599)DNB 2007021973 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-945 |a DE-473 |a DE-11 | ||
| 050 | 0 | |a HF5548.2 | |
| 082 | 0 | |a 005.13 | |
| 084 | |a QP 345 |0 (DE-625)141866: |2 rvk | ||
| 084 | |a ST 510 |0 (DE-625)143676: |2 rvk | ||
| 100 | 1 | |a Wang, Shouhong |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Programming languages for business problem solving |c Shouhong Wang ; Hai Wang |
| 264 | 1 | |a Boca Raton, Fla. [u.a.] |b Auerbach Publ. |c 2008 | |
| 300 | |a XXV, 357 S. |b Ill. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 4 | |a Wirtschaft | |
| 650 | 4 | |a Business |x Computer programs | |
| 650 | 4 | |a Programming languages (Electronic computers) | |
| 650 | 4 | |a Problem solving |x Computer programs | |
| 650 | 4 | |a Management information systems | |
| 650 | 0 | 7 | |a Programmiersprache |0 (DE-588)4047409-4 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Wirtschaftsinformatik |0 (DE-588)4112736-5 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Problemlösen |0 (DE-588)4076358-4 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Wirtschaftsinformatik |0 (DE-588)4112736-5 |D s |
| 689 | 0 | 1 | |a Programmiersprache |0 (DE-588)4047409-4 |D s |
| 689 | 0 | 2 | |a Problemlösen |0 (DE-588)4076358-4 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Wang, Hai |e Verfasser |4 aut | |
| 856 | 4 | |u http://www.loc.gov/catdir/toc/ecip0719/2007021973.html |3 Table of contents only | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016240844&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-016240844 | |
Datensatz im Suchindex
| _version_ | 1819257079887560704 |
|---|---|
| adam_text | Contents
Preface ..................................................................................... xvii
List of Credits ............................................................................xxiii
Typographical Conventions ....................................................... xxv
Compilers/Interpreters Used for the Programs in
This Book ................................................................................. xxv
Chapter 1 COBOL and File Processing .......................................... 1
1.1 Introduction to COBOL ................................................................. 1
1.2 Legacy Information Systems .......................................................... 1
1.2.1 File, Record, Data Item, and Key ...................................... 2
1.2.2 Tape and Disk .................................................................... 3
1.2.3 Three Basic File Organizations .......................................... 3
1.2.3.1 Sequential File....................................................... 3
1.2.3.2 Random File ......................................................... 5
1.2.3.3 Indexed File ......................................................... 6
1.2.4 Types of Business Data Files ............................................. 7
1.2.4.1 Master Files .......................................................... 7
1.2.4.2 Transaction Files .................................................. 7
1.2.4.3 Reference Files ..................................................... 8
1.2.4.4 Backup Files ......................................................... 8
1.2.4.5 Working Files ....................................................... 8
1.2.4.6 Report Files .......................................................... 8
1.2.5 Design of Organizations of Files ....................................... 8
1.3 General Structure of COBOL—Four Divisions ............................. 8
vi Contents
1.4 COBOL Words ............................................................................. 9
1.5 COBOL Program Format—Positioning, Spacing, and
Punctuation .................................................................................. 10
1.6 Typical Examples of COBOL Programs ...................................... 11
1.6.1 Build a Master File ........................................................... 11
1.6.2 Identification Division ...................................................... 15
1.6.3 Environment Division ...................................................... 15
1.6.4 Configuration Section ....................................................... 15
1.6.5 Input Output Section and File Control ........................... 15
1.6.6 Data Division .................................................................... 16
1.6.7 File Section and FD .......................................................... 16
1.6.8 Data Structure and Picture ............................................... 17
1.6.9 WORKING STORAGE Section ......................................... 19
1.6.10 PROCEDURE DIVISION ................................................... 19
1.6.11 PERFORM Statement ........................................................ 20
1.6.12 STOP RUN Statement ....................................................... 21
1.6.13 OPEN and CLOSE Statements .......................................... 21
1.6.14 DISPLAY Statement .......................................................... 21
1.6.15 ACCEPT Statement ........................................................... 21
1.6.16 MOVE Statement .............................................................. 22
1.6.17 WRITE a Record to the Disk File .................................... 23
1.6.18 Walk Through a Procedure Division
of a COBOL Program ..................................................... 23
1.6.19 Build a Transaction File ................................................... 25
1.6.20 Data Processing ................................................................ 27
1.6.21 READ Statement ............................................................... 30
1.6.22 IF ELSE Statement ............................................................. 31
1.6.23 COMPUTE Statement ....................................................... 32
1.6.24 WRITE a Record to the Printed Report ........................... 32
1.6.25 Maintenance ..................................................................... 32
1.6.26 REWRITE a Record to the Disk File ................................ 34
1.7 Computing Context of COBOL Programming ............................ 35
1.8 Use 3GL ........................................................................................ 35
1.9 Debugging .................................................................................... 36
1.9 1 Syntax Errors .................................................................... 36
1.9 2 Logical Errors .................................................................... 37
1.9 3 Operational Errors ............................................................ 37
1.10 Design and Documentation of 3GL Programming ................... 37
1.11 Differences between 3GL and 4GL ........................................... 38
1.12 Self Review Exercise .................................................................. 40
Appendix 1.1 Commonly Used COBOL Reserved Words ............... 45
Appendix 1.2 Instructions for Using COBOL on Mainframe ........... 46
Appendix 1.3 Guideline for COBOL Project Report ........................ 48
Contents vii
Chapter 2 C++ and Object Oriented Programming ..................... 51
2.1 Introduction to Object Oriented Programming .......................... 51
2.2 Tour of C Language ..................................................................... 52
2.2.1 C/C++ Keywords .............................................................. 53
2.2.2 Comment Statements ....................................................... 53
2.2.3 Preprocessor ..................................................................... 53
2.2.4 Structure of a C Program, Functions, and
Their Arguments ............................................................. 53
2.2.5 Statements and Semicolon................................................. 54
2.2.6 Data Type ......................................................................... 54
2.2.7 Arithmetic Operations ...................................................... 54
2.2.8 for Loop .......................................................................... 55
2.2.9 printf () Statement with Conversion Specifiers
and Free Format Input Output ....................................... 55
2.2.10 if Statement ..................................................................... 56
2.2.11 String and String Processing ............................................ 57
2.3 Functional Approach ................................................................... 58
2.3 1 Functional Decomposition ............................................... 58
2.3 2 User Defined Functions ................................................... 58
2.3.2.1 Declaration of User Defined Functions ............ 59
2.3.2.2 Called Function and Calling Function .............. 60
2.3 3 Example of Multiple Functions of C Program ................ 60
2.4 Object Oriented Approach .......................................................... 63
2.4.1 Object and Class ............................................................... 63
2.4.2 Descriptions of Class, Object, Method,
and Message ..................................................................... 65
2.4.2.1 public and private Statement .................... 66
2.4.2.2 Constructor ......................................................... 67
2.4.2.3 Scope Resolution ............................................... 67
2.4.2.4 Declare an Object .............................................. 68
2.4.2.5 Message Sending ............................................... 68
2.5 Example of C++ Program with One Object Class ...................... 70
2.6 Example of C++ Program with Two
Object Classes .............................................................................. 75
2.7 Example of C++ Program with Multiple Classes
and Inheritance ............................................................................ 79
2.8 Identify Classes for OOP Projects ............................................... 87
2.9 Debugging .................................................................................... 88
2.10 Self Review Exercise .................................................................... 88
Appendix 2.1 Commonly Used C and C++ Keywords .................... 91
Appendix 2.2 Instructions for Using C++ on Mainframe ................. 91
Appendix 2.3 Guideline for C++ Project Report .............................. 91
viii Contents
Chapter 3 HTML, JavaScript, and Web Pages ............................ 93
3.1 Introduction to World Wide Web and the Internet ................. 93
3.2 Creating Web Pages Using HTML ............................................. 94
3.3 Simple Container Tags ............................................................... 95
3.3.1 HTML .......................................................................... 95
3.3.2 HEAD and TITLE .................................................. 95
3.3.3 BODY .......................................................................... 96
3.3.4 Comments ! ... .............................................. 96
3.3.5 Headings H1 ... H6 .............................................. 96
3.3.6 P ................................................................................. 96
3.3.7 l ................................................................................. 96
3.3.8 DL DT DD ............................................................ 96
3.3.9 A ................................................................................. 96
3.3.10 CENTER ...................................................................... 97
3.4 Empty Tags ................................................................................. 97
3.4.1 HR ............................................................................... 97
3.4.2 BR ............................................................................... 97
3.4.3 img ............................................................................. 97
3.5 Complex Container Tags ........................................................... 98
3.5.1 FORM .......................................................................... 98
3.5.1.1 Attribute ACTION ............................................ 100
3.5.1.2 Attribute METHOD ............................................ 100
3.5.2 INPUT and Its Attributes TYPE, NAME, SIZE,
and VALUE ..................................................................... 100
3.5.3 FRAME and FRAMESET .................................................. 100
3.6 Publish the Web Page and Create Web Pages
without Writing HTML ............................................................... 101
3.7 Introduction to JavaScript .......................................................... 101
3 8 Typical Examples of JavaScript ................................................. 102
3.8.1 Image Manipulations ...................................................... 102
3.8.2 Object Classes and Their Methods and Attributes ........ 103
3.8.3 Event Handler ................................................................. 104
3.8.4 Verify Input on the FORM ............................................. 104
3.8.5 Similarity and Dissimilarity of JavaScript
and C/C++ ...................................................................... 106
3.8.6 Function and Calling a Function ................................... 107
3.8.7 String Processing ............................................................ 107
3.8.8 If Statement ................................................................... 108
3.8.9 alert Statement ............................................................ 108
3.8.10 Client Side Calculation ................................................... 108
3.8.11 JavaScript and Cookies .................................................. 110
3.8.12 Miscellaneous JavaScript Statements ............................. 112
3.8.12.1 new Statements ............................................. 112
3.8.12.2 Miscellaneous Functions and Methods ......... 112
Contents ix
3.9 Debugging Source Codes of Web Pages .................................. 113
3.10 Self Review Exercise .................................................................. 113
Appendix 3.1 HTML Tag List ........................................................... 116
Appendix 3 2 JavaScript Reserved Words and Other Keywords .... 117
Appendix 3 3 Guideline for Web Page Project Report .................. 117
Chapter 4 Java and Computing on the Internet.......................... 119
4.1 Web Based Computing .............................................................. 119
4.2 Web Servers with Java Style ...................................................... 119
4.3 Introduction to Java Applets ..................................................... 120
4.4 Run a Java Applet within a Web Page ..................................... 121
4.5 Java Applet Programming ......................................................... 122
4.5.1 Similarity of Java Syntax and C and C++ Syntax .......... 123
4.5.2 Difference between Java Applets and C++ ................... 123
4.5.3 import Statement ......................................................... 124
4.5.4 Heading of an Applet .................................................... 124
4.5.5 Methods and Parameters ................................................ 124
4.5.6 image ............................................................................. 124
4.5.7 audio ............................................................................... 125
4.5.8 Thread ............................................................................. 125
4.5.9 Keywords new and this .............................................. 126
4.5.10 try and catch Statements ......................................... 126
4.5.11 paint and repaint Statements ................................. 126
4.5.12 Structure of Java Applets ............................................... 126
4.6 Examples of Java Applets .......................................................... 128
4.6.1 Animations ...................................................................... 128
4.6.2 Audio Playing ................................................................. 130
4.6.3 Get Parameters from the HTML Program ..................... 133
4.6.3.1 getParameter in Java Applet ..................... 133
4.6.3.2 PARAM Tag in Host HTML program ........... 134
4.7 Java Applications (Free Standing Java Programs) .................... 134
4.7.1 AWT Based Java Applications ....................................... 134
4.7.1.1 Class Frame and Its Methods ......................... 138
4.7.1.2 ActionListener .................................................. 138
4.7.1.3 WindowListener ............................................... 138
4.7.1.4 Main Program ................................................... 138
4.7.1.5 Widgets ............................................................. 138
4.7.1.6 Cast Operator ................................................... 138
4.7.1.7 String Processing .............................................. 139
4.7.1.8 Run AWT Based Java Application .................. 139
4.7.2 Non AWT Java Applications .......................................... 139
4.7.2.1 Run Non AWT Java Application
and args ....................................................... 143
4.7.2.2 System, out .println ................................ 144
x Contents
4.8 Java Servlets ............................................................................... 144
4.8.1 Software Requirements of Java Servlets ........................ 145
4.8.2 Edit and Compile Java Servlets ...................................... 145
4.8.3 Web Page That Triggers Java Servlet ............................ 147
4.8.4 Trigger a Java Servlet ..................................................... 147
4.8.5 Structure of Java Servlets ............................................... 150
4.8.6 Java Servlet Programming .............................................. 152
4.8.6.1 Web Page to Trigger Java Servlets .................. 152
4.8.6.2 Simple Servlet .................................................. 153
4.8.6.3 HttpServlet ................................................ 154
4.8.6.4 doGet and doPost ........................................ 154
4.8.6.5 throws and Exceptions ................................. 155
4.8.6.6 setContentType ................................................ 155
4.8.6.7 PrintWriter, getWriter, println, and close .......... 155
4.8.6.8 Information of the Client s Request ................ 155
4.8.6.9 Save FORM Data to the Server s Disk ............ 156
4.8.6.10 getParameter .............................................. 160
4.8.6.11 FileWriter, Write, and Close ............................ l6l
4.8.6.12 Read Data File from the Server ....................... l6l
4.8.6.13 FileReader and BufferedReader ...................... 163
4.8.6.14 readLine Method .......................................... 165
4.8.6.15 while Loop ..................................................... 165
4.8.6.16 Comparison of Strings ..................................... 165
4.8.6.17 Convert String to Numerical Number ............. 165
4.9 Example of Web Based Business Application
Usingjava Servlets ..................................................................... 165
4.10 Databases Connection and the Use of SQL .............................. 168
4.11 Typical Scheme of Web Based Business Applications ............ 171
4.12 Debugging Java Programs ......................................................... 172
4.13 Self Review Exercise .................................................................. 173
Appendix 4.1 Set up Java Platform for JDK and Java Servlets on
Computer with Windows Operating System .......... 178
Appendix 4.2 Use WS FTP to Upload and Download Files .......... 184
Appendix 4.3 Guideline for Web Page Integrating ........................ 186
Appendix 4.4 Guideline for Server Side Programming
(Java Servlet) Project Report ................................... 186
Chapter 5 Visual Basic and Graphical User Interface ................ 189
5.1 Graphical User Interface ............................................................ 189
5.2 VB.NET Environment ................................................................. 190
5.3 Event DrivenProgramsandBriefOverviewofVB.NET ......... 192
5.4 Single Form VB.NET Project ..................................................... 194
5.5 VB.NET Project with Multiple Forms ........................................ 198
5.5.1 Design Forms ................................................................. 198
Contents xi
5.5.2 Module ............................................................................ 200
5.5.3 Class ................................................................................ 201
5.5.4 Coding for Forms ........................................................... 202
5.6 ProgrammingwithVB.NET ....................................................... 209
5.6.1 General Format of Code, Comments, and Keywords ...... 209
5.6.2 Class and Object ............................................................. 209
5.6.3 Methods .......................................................................... 210
5.6.4 Constant Variables .......................................................... 210
5.6.5 Data Types ...................................................................... 210
5.6.6 Arithmetic Operations .................................................... 211
5.6.7 If Then Else Statement ................................................... 211
5.6.8 For Loop ......................................................................... 211
5.6.9 String Processing and Format Statement ....................... 211
5.6.10 Print a Document ........................................................... 212
5.6.11 Message Box ................................................................... 212
5.7 Debugging .................................................................................. 213
5.8 Self Review Exercise .................................................................. 213
Appendix 5.1 Guideline for VB.NET Project Report ...................... 215
Chapter 6 Visual Basic for Applications and Decision
Support Systems ....................................................... 217
6.1 Concepts of Decision Support Systems .................................... 217
6.2 Macro .......................................................................................... 219
6.3 DSS Example of VBA ................................................................. 220
6.4 Macro Code of the Example ..................................................... 224
6.5 Analyzing Code of VBA and Other Features of VBA .............. 226
6.5.1 Syntax of VBA Statements ............................................. 227
6.5.2 Comments ....................................................................... 227
6.5.3 Variable Setting .............................................................. 227
6.5.4 Combo Box .................................................................... 228
6.5.5 If Then Else Statement ................................................... 228
6.5.6 Dialog Box ...................................................................... 229
6.5.7 For Loop and Do Loop Statement ................................ 229
6.6 Self Review Exercise .................................................................. 230
Chapter 7 Perl and CGI for Web Based Applications ............. 233
7.1 Web Based Applications ........................................................... 233
7.2 CGI and CGI Programming ....................................................... 233
7.3 Introduction to Perl ................................................................... 234
7.4 Test Perl on the Server .............................................................. 235
7.5 Perl Programming ...................................................................... 236
7.5.1 Web Page to Trigger Perl Programs .............................. 237
7.5.1.1 Test Perl Program ............................................ 238
7.5.1.2 Learn ENVIRONMENT Variables ..................... 239
xii Contents
7.5.1.3 Check Your IP Address ................................... 239
7.5.1.4 Learn CGI Data Strings .................................... 239
7.5.1.5 Data Processing Using Perl Programs ............ 239
7.5.1.6 Communication Interaction between the
Client and the Server ....................................... 239
7.5.2 Simple Perl Program ...................................................... 240
7.5.3 General Format of Perl .................................................. 240
7.5 4 print Statement, Quotes, and Character n ............... 241
7.5.5 Variables and Environment Variables ........................... 241
7.5.5.1 Scalar Variable ................................................. 241
7.5.5.2 Array ................................................................. 242
7.5.5.3 Associative Arrays ............................................ 242
7.5.5.4 Global and Local Variables ............................. 242
7.5.5.5 Environment Variables .................................... 242
7.5.6 Read Data from a File on the Server ............................. 243
7.5 7 Subroutines ..................................................................... 245
7.5.8 open close Statements ............................................... 246
7.5.9 while Loop ................................................................... 246
7.5.10 if elseif else Statement ...................................... 247
7.5.11 for Loop and foreach Loop ..................................... 247
7.5.12 String Processing ............................................................ 247
7.5.12.1 chop Statement ............................................. 248
7.5.12.2 split Statement ........................................... 248
7.5.12.3 push and pop Statements ............................ 248
7.5.12.4 String Appending ........................................... 248
7.5.12.5 Translate ......................................................... 248
7.5.12.6 Substitution .................................................... 249
7.5.13 Arithmetic Operations .................................................... 249
7.5.14 Read Standard Input Data Submitted by the
Client through FORM ..................................................... 249
7.5.15 Write Data to a File on the Server ................................. 250
7.5.16 Interaction between the User of the Client
and the Server ................................................................ 254
7.5.17 Example of Web Based Business
Application Using Perl ................................................... 258
7.6 Debugging .................................................................................. 260
7.7 Framework of CGI Implemented Web Based
Applications for Electronic Commerce ..................................... 261
7.8 Self Review Exercise .................................................................. 262
Appendix 7.1 Installation of ActivePerl on the Server
with the Windows Platform ..................................... 265
Appendix 7.2 Guideline for Server Side Programming (Perl)
Project Report ........................................................... 267
Contents xiii
Chapter 8 PHP for Web Based Applications ............................. 269
8.1 Introduction to PHP ................................................................... 269
8.2 Structure of a PHP Script ........................................................... 270
8.3 Web Page to Trigger PHP ......................................................... 272
8.3.1 PHP Functions ................................................................ 274
8.3.2 if else Statement ....................................................... 274
8.4 Read Data Files from the Server ............................................... 274
8.4.1 fopen( ) and fclose( ) ..................................................... 276
8.4.2 feof( ) and fgets( ) .......................................................... 276
8.4.3 while Loop ................................................................... 276
8.5 Write Data Files to the Server and fputs () .......................... 276
8.6 Relay Data through Multiple Forms Using Hidden Fields ....... 277
8.7 Debugging .................................................................................. 280
8.8 Self Review Exercise .................................................................. 280
Appendix 8.1 Guideline for Server Side Programming
(PHP) Project Report ................................................ 282
Chapter 9 ASP. NET for Web Based Applications ...................... 283
9.1 IntroductiontoASP.NET ........................................................... 283
9.2 Structure of an ASP.NET Program ............................................. 284
9.3 HTML Controls vs. Web Controls ............................................. 286
9.4 HTML Controls ........................................................................... 286
9.4.1 Submit Button ................................................................. 286
9.4.2 Textbox ........................................................................... 287
9.4.3 Checkbox ........................................................................ 287
9.4.4 Radio Button ................................................................... 288
9.4.5 Select ............................................................................... 289
9.5 Web Controls ............................................................................. 290
9.6 Validation Controls .................................................................... 292
9.7 Code Behind Programming Framework ................................... 293
9.8 ASP.NET Web Page Application Examples .............................. 295
9.8.1 Sending E Mail Message ................................................ 295
9.8.2 Calendar .......................................................................... 296
9.8.3 File Input/Output ........................................................... 297
9.8.4 Security ........................................................................... 299
9.9 Debugging .................................................................................. 301
9.10 Self Review Exercise .................................................................. 302
Appendix 9.1 InstallIISforASP.NET .............................................. 305
Appendix 9.2 Guideline for Server Side Programming
(ASP.NET) Project Report ......................................... 306
Chapter 10 XML and the Uniform Data Format for the Internet ..... 307
10.1 Introduction to XML .................................................................. 307
10.1.1 HTML Documents Are Difficult to Extract .................. 307
xiv Contents
10.1.2 Databases Need Common Data Format to
Make Data Exchange ..................................................... 309
10.2 Simplest Examples of XML ........................................................ 310
10.2.1 Feature of XML Instance Documents ............................ 311
10.2.1.1 Declaration ..................................................... 311
10.2.1.2 Tags and Element .......................................... 312
10.2.1.3 Attribute .......................................................... 312
10.2.1.4 Comment Line and Editorial Style ................ 312
10.2.1.5 Empty Tag ...................................................... 312
10.2.2 Cascading Style Sheets (CSS) ......................................... 312
10.2.3 Extensible Style Language ............................................. 313
10.2.3.1 xsl:stylesheet .............................................. 314
10.2.3.2 xsl:template ................................................ 315
10.2.3.3 HTML Presentation ........................................ 315
10.2.3.4 xsl:for each ................................................ 315
10.2.3.5 xsl:value of ................................................. 315
10.2.4 CSSvs. XSL ..................................................................... 315
10.2.5 More Simple Examples of XML
with CSS and XSLT ....................................................... 316
10.3 Document Type Definition and Validation .............................. 317
10.3.1 Simple Example of Internal DTD .................................. 318
10.3.2 Simple Example of External DTD ................................. 319
10.3.3 Features of DTD ............................................................. 320
10.3 3.1 !ELEMENT ................................................. 320
10.3.3.2 !ATTLIST ................................................. 321
10.3.3.3 !ENTITY ................................................... 321
10.4 XML Schemas ............................................................................. 322
10.4.1 Schema Element ............................................................. 324
10.4.2 Data Element, Element Name, and
Element Type ................................................................. 324
10.4.3 complexType .................................................................. 324
10.4.4 sequence ...................................................................... 324
10.4.5 Cardinality ....................................................................... 324
10.4.6 Attribute .......................................................................... 325
10.5 Business Applications of XML ................................................... 325
10.6 XHTML ....................................................................................... 330
10.7 extensible Business Reporting Language ................................. 331
10.7.1 Comparison of XBRL with XML ..................................... 331
10.7.2 Taxonomy ....................................................................... 332
10.7.3 Prepare XBRL Based Reports ......................................... 332
10.8 Self Review Exercise .................................................................. 333
Appendix 10.1 Guideline for XML Project Report ........................ 334
Contents XV
Chapter 11 SQL for Database Query ......................................... 337
11.1 Introduction to SQL ................................................................... 337
11.2 View SQL of a Query Created in Access .................................. 337
11.3 Write and Run SQL in Access ................................................... 338
11.4 Major Features of SQL—SELECT ............................................... 339
11.4.1 Including Fields ............................................................ 340
11.4.2 Conditions ..................................................................... 340
11.43 Grouping and Sorting .................................................. 340
11.4.4 Built in Functions ......................................................... 341
11.4.5 Joining Tables ............................................................... 341
11.5 Sub Query .................................................................................. 341
11.6 Other SQL Features .................................................................... 343
11.7 SQL in Web Applications .......................................................... 343
11.8 Self Review Exercise .................................................................. 346
Appendix 11.1 Guideline for SQL Project Report .......................... 347
Six Key Concepts Shared by All Procedural
Programming Languages .................................................................... 349
Index ................................................................................................... 351
|
| any_adam_object | 1 |
| author | Wang, Shouhong Wang, Hai |
| author_facet | Wang, Shouhong Wang, Hai |
| author_role | aut aut |
| author_sort | Wang, Shouhong |
| author_variant | s w sw h w hw |
| building | Verbundindex |
| bvnumber | BV023037087 |
| callnumber-first | H - Social Science |
| callnumber-label | HF5548 |
| callnumber-raw | HF5548.2 |
| callnumber-search | HF5548.2 |
| callnumber-sort | HF 45548.2 |
| callnumber-subject | HF - Commerce |
| classification_rvk | QP 345 ST 510 |
| ctrlnum | (OCoLC)137331465 (DE-599)DNB 2007021973 |
| dewey-full | 005.13 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.13 |
| dewey-search | 005.13 |
| dewey-sort | 15.13 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01999nam a2200517zc 4500</leader><controlfield tag="001">BV023037087</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20080129 </controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">071206s2008 xxua||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2007021973</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781420062649</subfield><subfield code="9">978-1-4200-6264-9</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1420062646</subfield><subfield code="9">1-4200-6264-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)137331465</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)DNB 2007021973</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-945</subfield><subfield code="a">DE-473</subfield><subfield code="a">DE-11</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HF5548.2</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.13</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 345</subfield><subfield code="0">(DE-625)141866:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 510</subfield><subfield code="0">(DE-625)143676:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Wang, Shouhong</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Programming languages for business problem solving</subfield><subfield code="c">Shouhong Wang ; Hai Wang</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Boca Raton, Fla. [u.a.]</subfield><subfield code="b">Auerbach Publ.</subfield><subfield code="c">2008</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXV, 357 S.</subfield><subfield code="b">Ill.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Wirtschaft</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Programming languages (Electronic computers)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Problem solving</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Management information systems</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Programmiersprache</subfield><subfield code="0">(DE-588)4047409-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Wirtschaftsinformatik</subfield><subfield code="0">(DE-588)4112736-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Problemlösen</subfield><subfield code="0">(DE-588)4076358-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Wirtschaftsinformatik</subfield><subfield code="0">(DE-588)4112736-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Programmiersprache</subfield><subfield code="0">(DE-588)4047409-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">Problemlösen</subfield><subfield code="0">(DE-588)4076358-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Wang, Hai</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/toc/ecip0719/2007021973.html</subfield><subfield code="3">Table of contents only</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016240844&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-016240844</subfield></datafield></record></collection> |
| id | DE-604.BV023037087 |
| illustrated | Illustrated |
| indexdate | 2024-12-20T13:07:10Z |
| institution | BVB |
| isbn | 9781420062649 1420062646 |
| language | English |
| lccn | 2007021973 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-016240844 |
| oclc_num | 137331465 |
| open_access_boolean | |
| owner | DE-945 DE-473 DE-BY-UBG DE-11 |
| owner_facet | DE-945 DE-473 DE-BY-UBG DE-11 |
| physical | XXV, 357 S. Ill. |
| publishDate | 2008 |
| publishDateSearch | 2008 |
| publishDateSort | 2008 |
| publisher | Auerbach Publ. |
| record_format | marc |
| spellingShingle | Wang, Shouhong Wang, Hai Programming languages for business problem solving Wirtschaft Business Computer programs Programming languages (Electronic computers) Problem solving Computer programs Management information systems Programmiersprache (DE-588)4047409-4 gnd Wirtschaftsinformatik (DE-588)4112736-5 gnd Problemlösen (DE-588)4076358-4 gnd |
| subject_GND | (DE-588)4047409-4 (DE-588)4112736-5 (DE-588)4076358-4 |
| title | Programming languages for business problem solving |
| title_auth | Programming languages for business problem solving |
| title_exact_search | Programming languages for business problem solving |
| title_full | Programming languages for business problem solving Shouhong Wang ; Hai Wang |
| title_fullStr | Programming languages for business problem solving Shouhong Wang ; Hai Wang |
| title_full_unstemmed | Programming languages for business problem solving Shouhong Wang ; Hai Wang |
| title_short | Programming languages for business problem solving |
| title_sort | programming languages for business problem solving |
| topic | Wirtschaft Business Computer programs Programming languages (Electronic computers) Problem solving Computer programs Management information systems Programmiersprache (DE-588)4047409-4 gnd Wirtschaftsinformatik (DE-588)4112736-5 gnd Problemlösen (DE-588)4076358-4 gnd |
| topic_facet | Wirtschaft Business Computer programs Programming languages (Electronic computers) Problem solving Computer programs Management information systems Programmiersprache Wirtschaftsinformatik Problemlösen |
| url | http://www.loc.gov/catdir/toc/ecip0719/2007021973.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016240844&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT wangshouhong programminglanguagesforbusinessproblemsolving AT wanghai programminglanguagesforbusinessproblemsolving |