Overview of 1. 1 ASP 2

1.2 ASP environment configuration2

1.2. 1 Install IIS server 2.

1.2.2 configuration of IIS server 3

1.2.3 Test the website server 4

The construction of 1.3 ASP Page 9

1.3.1Basic structure of ASP program 9

1.3.2 Advantages of ASP in Building Websites 10

The working principle of 1.4 Web 10.

1.4. 1 server and client 10

1.4.2 working principle of static web pages 1 1

1.4.3 working principle of dynamic web pages 1 1

1.5 ASP built-in object 1 1

1.5. 1 overview of built-in objects 1 1

1.5.2 Request Object 12

1.5.3 response object 14

1.5.4 application object 19

1.5.5 server object21

1.5.6 Session Object 23

1.5.7 Object Context Object 27

1.6 ASP security maintenance 28

1.6. 1 Maintain website security through permission setting.

Security vulnerabilities in 1.6.2 28

1.6.3 Improve safety precautions 29

Chapter 2 Access 2003 Database Fundamentals 3 1

2. 1 database overview 32

2. 1. 1 What is database 32?

2. 1.2 relational database 32

2. 1.3 records and fields 32

2.2 Access 2003 database 33

2.2. 1 Installing and Starting Access 2003 33

2.2.2 Access 2003 working environment 36

Database operation 38

Data table operation 42

2.3 Database connection 47

2.3. 1 non-DSN access database 47

2.3.2 Access database 48 through DSN

2.4 SQL query 50

2.4. Simple SELECT statement of1query51

2.4.2 in Article 52

2.4.3 Setting query conditions with WHERE clause 53

2.4.4 using the ORDER BY clause to sort the query results 54

2.4.5 Grouping the query results with the GROUP BY clause 55

2.4.6 Nested Queries 56

2.4.7 Multi-table query 58

Add data 59

Modify data 60

Delete data 6 1

Chapter III Personal Website 63

3. 1 overview 65

3.2 System Analysis 65

3.2. 1 demand analysis 65

feasibility analysis

3.3 Overall Design 65

3.3. 1 project planning 65

3.3.2 System Function Structure Diagram

3.4 System Design 66

3.4. 1 design objective 66

3.4.2 Development and operation environment 67

3.5 Database design 67

3.5. 1 data sheet summary 67

3.5.2 Structure of main data tables

3.6 Technical preparation 69

3.6. 1 knowledge needs of readers 69

Naming rule 69

3.6.3 Document management planning

3.7 Detailed design of main function modules at the front desk 70

3.7. 1 General Framework of Front Desk Documents 70

3.7.2 My article module design 72

3.7.3 Design of Blog Calendar Module 75

3.7.4 My Album Module Design 80

3.7.5 Online Music on Demand Module Design 82

3.8 Detailed design of main function modules in the background 86

3.8. 1 Background Overall Architecture 86

3.8.2 Item Management Module Design 87

3.8.3 Audio file management module design 92

3.8.4 Exit login module design 96

3.9 Analysis and solution of difficult problems 97

3.9. 1 Preventing SQL Injection Vulnerabilities 97

3.9.2 Using Cookie to count website visits 97

3. 10 program debugging and error handling 98

Chapter 4 News Website 99

4. 1 Overview 10 1

4.2 system analysis 10 1

4.2. 1 demand analysis

4.2.2 Feasibility analysis 10 1

4.3 Overall design 10 1

4.3. 1 project planning 10 1

4.3.2 System Function Structure Diagram 102

4.4 system design 102

Design objective 102

4.4.2 Development and Operation Environment 103

4.5 database design 103

4.5. 1 data sheet 103 summary

4.5.2 Structure of master data table 103

4.6 technical preparation 105

4.6. 1 knowledge needs of readers 105

Naming rules 105

4.6.3 document management planning 106

4.7 Detailed design of main function modules at the front desk 106

4.7. 1 general framework of foreground documents 106

4.7.2 Design of connecting database module 108

4.7.3 Design of news display module 109

4.7.4 Design of previous news viewing module 1 12

4.7.5 Design of news ranking module 1 14

4.8 Detailed design of main function modules in the background 1 15

4.8. 1 overall background structure 1 15

4.8.2 Function menu module design 1 17

4.8.3 news management module design 1 19

4.8.4 Administrator Settings Module Design 12 1

4.8.5 website information statistics module design 125

4.8.6 Database Maintenance Management Module Design 129

4.9 Analysis of Difficult Problems and Solutions 13 1

4.9. 1 prevent Access database from being downloaded 13 1

4.9.2 Change the color of the mouse through the text box 13 1.

4. 10 program debugging and error handling 13 1

The fifth chapter office automation management system 133

5. 1 overview 135

5.2 system analysis 135

5.2. 1 demand analysis 135

Feasibility analysis 135

5.3 Overall Design 136

5.3. 1 project planning 136

5.3.2 System Function Structure Diagram 136

5.4 system design 136

Design objective 136

5.4.2 Development and operation environment 137

5.4.3 IIS configuration in Windows XP system 137

5.5 database design 140

5.5. 1 entity E-R diagram of data sheet 140.

5.5.2 Structure of master data table 14 1

Summary of data sheet 143

5.6 technical preparation 144

5.6. 1 knowledge needs of readers 144

Naming rules 144

5.6.3 Document Management Planning 145

5.7 Detailed design of main functional modules 145

5.7. 1 overall framework of documents 145

File schema 146

5.7.3 Operation Effect of Homepage 146

5.7.4 Create database connection 147

5.8 attendance management module design 148

5. 8. 1 page design for going out to register 148

5.8.2 Design of Arrival and Departure Registration Page 150

5.9 Design of Audit Management Module 152

5.9. 1 Publishing application page design 152

5.9.2 Audit Instruction Management Design 154 Page

5. 10 employee management module design 157

5. 10. 1 page design for adding employee information 157

5. 10.2 employee maintenance page design 158

5. 1 1 communication management module design 163

5. 1 1. 1 Page design showing distribution group information 164

5. 1 1.2 Add communication details page design 167

5. 12 Analysis and solution of difficult problems 170

5. 12. 1 making tree navigation menu 170

5. 12.2 displays the records in the database in the drop-down list 172.

5. 12.3 When modifying data, the default value of the drop-down list is the original data information in the database 173.

5. 12.4 Select the time 174 by the date selector.

5. 13 program debugging and error handling 176

Chapter VI Enterprise Portal 179

6. 1 Overview 18 1

6.2 system analysis 18 1

6.2. 1 demand analysis

6.2.2 Feasibility Analysis 18 1

6.3 Overall Design 182

6.3. 1 project planning 182

6.3.2 System Function Structure Diagram 182

6.4 system design 183

Design objective 183

6.4.2 Development and operation environment 184

6.5 database design 184

6.5. 1 data sheet 184 summary

6.5.2 Structure of master data table 185

6.6 technical preparation 187

6.6. 1 knowledge needs of readers 187

6.6.2 Naming rules 187

6.6.3 document management planning 188

6.7 Detailed design of main function modules at the front desk 188

6.7. 1 Overall Framework of Front Desk Documents 188

6.7.2 Design of commodity display module 190

6.7.3 Design of Commodity Classification Module 193

6.7.4 franchisee application and login module design 195

6.7.5 Module Design of Franchise Center 196

6. 7. 6 197 Design of Station News Module

6.7.7 Design of Online Voting Module 198

6.8 Detailed design of main function modules in the background 199

6.8. 1 overall background structure 199

6.8.2 Design of Commodity Basic Information Management Module 202

6.8.3 franchisee information management module design 206

6.8.4 Current Management Module Design 2 12

6.8.5 Design of employee information management module 2 15

6.8.6 Design of Station Information Management Module 2 18

6.8.7 Design of Commodity Sales Statistics Module 22 1

6.8.8 System Setup Module Design 223

6.9 Analysis and solution of difficult problems 224

6.9. 1 The format of the input value is controlled by the input mask in the Access database 224.

6.9.2 Realization of two-level cascading menu 225

6.9.3 Display different controls 227 according to the value of the radio box.

6. 10 program debugging and error handling 228

Chapter VII E-commerce Website 23 1

7. 1 overview 233

7.2 System Analysis 233

7.2. 1 demand analysis

Feasibility analysis 233

7.2.3 Entity Relationship Diagram (ER Diagram) 234

7.3 Overall Design 234

7.3. 1 project planning 234

7.3.2 System Function Structure Diagram 234

7.3.3 Website Process Design 235

7.4 System Design 236

Design goal 236

7.4.2 Development and Operation Environment 236

7.4.3 IIS Configuring Windows 2003 System 236

7.5 Database design 239

Summary of data table 239

7.5.2 Structure of Master Data Table 239

7.6 Technical Preparation 24 1

7.6. 1 Readers' knowledge needs 24 1

7.6.2 Naming Rule 24 1

7.6.3 Document Management Planning 242

7.7 Detailed Design of Main Function Modules of Front Desk 242

7.7. 1 Overall Framework of Front Desk Docs 242

Website navigation design 245

7.7.3 Design of Connection Database Module 245

7.7.4 Design of commodity display module 246

Shopping cart module design 248

7.7.6 cashier module design 250

7.7.7 Member Module Design 253

7.7.8 Business Information Module Design 257

7.7.9 Design of in-station notification module 257

7.8 Detailed Design of Main Function Modules in the Backstage 258

7.8. 1 Background overall architecture 258

7.8.2 Design of Background Login Module 260

7.8.3 Website Information Management Module Design 262

7.8.4 Design of Commodity Information Management Module 265

7.8.5 Design of Commodity Classification Management Module 268

7.8.6 Design of Order Information Management Module 27 1

7.8.7 news information management module design 275

7.9 Analysis and solution of difficult problems 276

7.9. 1 Realizing hierarchical selection of commodity categories and subcategories 276

7.9.2 Application framework technology, page 277

7. 10 program debugging and error handling 277

Chapter VIII New Town Alumni Record 279

8. 1 overview 28 1

8.2 System Analysis 28 1

8.2. 1 demand analysis 28 1

8.2.2 Feasibility Analysis 28 1

8.3 Overall Design 282

8.3. 1 project planning 282

8.3.2 System Function Structure Diagram 282

8.4 System Design 283

8.4. 1 design objective 283

8.4.2 Development and operation environment 283

8.5 Database design 284

8.5. 1 entity E-R diagram of data sheet 284

8.5.2 Structure of main data tables 284

8.5.3 Summary of Data Sheet 286

8.6 Technical preparation 286

8.6. 1 Naming rules

8.6.2 Document Management Planning 288

8.7 Detailed design of main function modules at the front desk 288

8.7. 1 Overall Framework of Front Desk Docs 288

8.7.2 File Architecture 288

8.7.3 Operation Effect of Home Page 289

8.7.4 Design of Alumni Record Login Module 290

8.7.5 Design of Class Album Module 292

8.7.6 Add student details module design 298

8.7.7 Design of True Love Blessing Module 30 1

8.8 Detailed Design of Main Function Modules in the Backstage 303

8.8. 1 Background Overall Architecture 303

8.8.2 Implementation process of background management on page 303

8.8.3 Design of Background Login Module 303

8.8.4 Design of Class Album Management Module 306

8.8.5 Design of classmate information management module 3 1 1

8.9 Analysis and Solution of Difficult Problems 3 14

8.9. 1 column and page display records 3 14

8.9.2 Refresh the parent window when closing the child window316

8.9.3 If you click on the page without logging in, you will be forced to jump to the login page 3 16.

8.9.4 difference between insert into statement and AddNew method 3 17

8. 10 program debugging and error handling 3 17

8. 10. 1 Error in updating Access database 3 17

8. 10.2 Using Err object to realize error handling 3 18

Chapter 9 Online Forums 32 1

9. 1 overview 323

9.2 System Analysis 323

9.2. 1 demand analysis 323

Feasibility analysis 323

9.3 Overall Design 324

Project planning 324

9.3.2 System Function Structure Diagram 324

9.4 System Design 325

Design goal 325

9.4.2 Development and Operation Environment 325

9.5 database design 326

Summary of data table 326

9.5.2 Overview of data table relationships 326

9.5.3 Structure of Master Data Table 327

Database query 330

9.6 Technical Preparation 33 1

9.6. 1 Readers' knowledge requirements 33 1

9.6.2 Naming Rule 33 1

File management planning 332

9.7 Detailed Design of Main Function Modules of Front Desk 332

9.7. 1 Overall Framework of Front Desk Docs 332

9.7.2 Website Navigation Design 334

9.7.3 Design of Connection Database Module 335

9.7.4 Forum Layout Module Design 335

User registration module design 339

9.7.6 User login module design 34 1

9.7.7 Design of Subject Information Publishing and Reply Module 344

9.7.8 Design of Theme Information Display Module 349

9.8 Detailed Design of Main Function Modules in the Backstage 354

9.8. 1 Background Overall Architecture 354

9.8.2 Design of Background Login Module 355

9.8.3 Design of Forum Management Module

9.8.4 User Management Module Design

9.8.5 System parameter setting module design 37 1

Database management module design 374

9.8.7 Design of other management modules 377

9.9 Analysis and solution of difficult problems 379

9.9. 1 Convert Access database to SQL Server database 379

9.9.2 Prevent the code in the forum from being executed by the browser 38 1

9. 10 program debugging and error handling 38 1

Chapter 10 intermediary information website 383

10. 1 overview 385

10.2 system analysis 385

1 demand analysis 385

10.2.2 Feasibility Analysis 385

10.3 overall design 386

10.3. 1 project planning 386

10.3.2 system function structure diagram 386

10.4 system design 387

1 design objective 387

Development and operation environment 388

10.5 database design 388

10.5. 1 data sheet abstract 388

10.5.2 master data table structure 389

10.6 technical preparation 39 1

Readers' knowledge needs 39 1

10.6.2 naming rules 392

Document management planning 392

10.7 detailed design of main function modules at the front desk.

10.7. 1 overall framework of foreground document 393

10.7.2 member login module design 394

10.7.3 job information module design 398

10.7.4 design of rental housing module 400

Detailed design of main function modules in the background 405

10.8. 1 background overall architecture 405

10.8.2 administrator login module design 408

10.8.3 Handling VIP card module design 409

10.8.4 customer update module design 409

10.8.5 Design of Rental Housing Information Management Module 4 12

10.9 Analysis and Solution of Difficult Problems 4 13

10.9. 1 encrypt the database and set the database password 4 13.

10.9.2 How to establish a connection with an encrypted Access database 4 14

10. 10 program debugging and error handling 4 14