Campus website design

Campus website design

Published: 2004-03-17 Author:

table of Contents

Chapter 1: Popularization ...............................................................................................

1.1 Design Thought .................................................................................................... 1

1.2 Development Tools and Introduction ........................................................................

Chapter II: Website Overall Analysis and Design 2

2.1 Website System Analysis ............................................................................................ .2

2.2, Home Design 3

2.3, database design 4

Chapter 3: Detailed Design 4

3.1 Parents School Contact Book .................................................... 4

3.2 Online Library 11

3.3 Online evaluation voting system 20

3.4 Damage Examination Online Test System and Counter Production ......................... 22.

Part 4: Instructions for the system's instructions and installation 25

Part 5: References: 26

Appendix: Source File Code 27

Chapter 1

Today, the Internet has become an important channel for people to quickly acquire, release, and transfer information, which plays an important role in people politics, economics, and life. The publish information on the Internet is mainly implemented by the website. The information is also to be downloaded from the website from the website in the Internet "Ocean". Therefore, the status of website construction is obvious, it has become an important part of the government and enterprises informatization, which is subject to people's attention. In order to better run schools, improve school visibility, specialize in the website of Changsha City, Industrial and Commercial Technical College.

1. 1 design idea

Through the website, comprehensive publicity, display school style, strengths and characteristics, and release the major event arrangements and enrollment policies, enhance the contact between parents and schools, and implement partial schools on the Internet, improve the efficiency of the work.

1.2 Selection and introduction of development tools

Advantages of ASP:

Active Server Pages: "Dynamic Server Web", generally referred to as "ASP", the reason why ASP can be attached to and used, mainly due to the results generated are standard HTML format, and these programs are in the network During the server, use a general browser (such as IE or Netscape) to properly obtain the "execution" result of the ASP, and the result of this ASP is directly "browse" in the browser, unlike VBScript or JavaScript is Execute on the client (Client) browser, if you use the VBScript to design the program, the client (Client) can display the result of the program execution in the IE browser, but the client (Client) cannot be used. If you use the Netscape browser. Display the execution of VBScript.

ASP features:

Any development tool can develop ASP

As long as you use a general instrument editing program, such as Windows Notepad, you can edit. Of course, other web development tools, for example, FrontPage Express, FrontPage, etc., but it is recommended that you use the notepad to write, which saves money and convenient. If you use the web page editing that you want to write to write ASP, you may happen Some unexpected bizarre.

To eat all walks, because the ASP program is executed in the network server, the HTML file generated by the execution result is available for different browsers.

High language compatibility

The ASP is compatible with all ActiveX Script language, in addition to the HTML, VBScript, Java Script, Active X server components, and other manufacturers (Third) via "PLUG-IN" Party's language provided.

Higher security

If we directly view the original code of the webpage directly, we can only see the HTML file, the original ASP program code is not seen! This is the fact that the ASP program is executed first on the website service (the web server), converts the result into a standard HTML file, then transferred to the client (Client) browser, so the ASP program we have worked hard is not It will be easily seen to be stolen.

Easy to control database

ASP can easily connect a variety of different databases through the ODBC (Open Database Connectivity) driver, such as: Acss, FoxPro, DBASE, Oracle, etc. use.

Object-oriented learning is easy

The ASP has object-oriented (Object-Oriented) features, learning is easy, ASP provides five convenient powerful built-in objects: Request, Response, Sever, Application, and Session, if you use an APPLICATION object built by ASP Or the ASP program written by "Session" object can temporarily save the necessary information between multiple web pages.

Six internal objects of ASP

Object Name Function Description

RequestResponServerSessionApplicationObjectContext acquires information from the client to provide information to the client to provide some web server tools to user information in a session, which can only be accessed in an ASP-Application to make different client sharing information can be used Distributed transaction processing with Microsoft Transaction Server

So I chose ASP combined with FrontPage architecture Changsha City Business Vocational Secondary School Site

Chapter II Website Overall Analysis and Design

2.1 Website System Analysis

According to the previous design ideas, the website is decomposed according to the basic view of the system development, and the website can be divided from the content:

l The school style is shown through school summary, teacher style, campus star and some pictures.

l Advantages through news, vivid and lively educational teaching columns to show.

l Information Release through the bulletin board, information inquiry and other columns, the content has an enrollment policy.

Activity arrangement, etc.

l Some schools are based on the publication of the school and the number of participants, and the special selection of books

Rules, evaluation, examination, family school contact four major schools are implemented online.

2.2 Home Design

The website home page features a quiet, moving method, that is, the static main screen and dynamic picture combined, reflecting the vitality of the school, the static home page introduces the school style, the advantages, information release, for the four major schools, Establish a database query management system using ASP and database, using an interactive dynamic web screen to implement. Home structure diagram

Note: The expansion of the underline is a link mode

2.3 Database Design

The use of the database is Microsoft Access, which is intended to establish a Teach.mdb library file, which contains the following table files:

AllMessage Message Meter

LibBooks Book Information Table

Libcategories Book Category Meter

Libemps library user information table;

Stud Business Student Information Form

Chapter III Detailed Design

3.1 Parents School Contact Book

3.1.1 Features:

Using SQL syntax to filter specific parental message, let the teacher can make an independent answer for the opinions of a particular student's parents. At the same time, when you express your personal opinion, if you think the content of the opinion involves sensitive topics or opinions involved Private privacy, you can speaking in a "whisper" way, these "whispers" will not be displayed to let everyone see, of course, the teacher has the ability to manage, as long as you log in to the management mode, you can do separate students. Comment reply, and you can see the "whisper" left by the parents.

3.1.2 Composition Construction

A total of six parts:

1. Message Results Web guest.asp: It is used to show the parents' speech and the teacher's reply, and there are also two display methods for general mode and management mode.

2, parents' speech sheet website addMsg.asp: Let the parents fill in the content and select the nature.

3, parents' speech data processing ASP program add.asp: Handle the parental published advice, and record these comments data and turn web pages to the comments message result web page.

4. Teacher replies form page Teachans.asp: Let the teacher make an independent answer for the opinions issued by a particular student parent.

5, teacher reply data processing ASP program ANSSAVE.ASP: Hands the data content of the teacher reply, and simultaneously data and turn the web page to the comments message result page.

6. Data table file AllMessage: The Access Type Database file used to store parents to speak data with the teacher replying to the data.

"Data Table File" is responsible for the storage of parents' speech data with the teacher's reply content, which is the Access type library file, which is named: "Message.mdb".

The figure below shows the composition and flow chart of the home contact book:

Teacher reply

Parental message

Read in writing

Write

3.1.3 Database Structure Design

Database file "TEACH.MDB" section "AllMessage" column setting, as shown below:

Field name field type

3.1.4 Interface design and key points, difficult code design

Database & message display program page

Parents' speech and the teacher reply to the teacher reply to the database, to display the current parent's speech and the teacher's reply data in the web page, you must first make a database link and open, to link the database We must use the ADO object group for the CONNECTION object; To open the database, you must use the RecordSet object of the ADO object group, the program:

SET CN = Server.createObject ("AdoDb.Connection")

CN.Open "FileDSN = C: / Program Files / Common Files / ODBC / DATA SOURCES / MS Access Database.dsn" SET RS = Server.createObject ("AdoDb.Recordset")

SQL = "SELECT * from allMessage Order By Message DESC"

RS.Open SQL, CN, 1, 1

The Recordset object is responsible for browsing the data taken from the database, and the Connection object is only responsible for linking the database and does not use the data in the database, so a Recordset object that can access database data can be established.

Access "TEACH.MDB" database using the RS.Open method

RS.Open SQL, CN, 1, 1

Use the Open method to open the data table or perform the SELECT command parameter setting as follows:

1, parameter one (source): For the data table or SQL instruction to be opened.

2, parameter 2 (ActionConnection): Specify an open database object, set this parameter to link We have established a good Connection object "CN".

3, the parameter three (CURSORTYPE): Specifies the open type of the Recordset, 1 is readable and free to move.

4, parameter four (LockType): Specify the lock type, 1 is read-only.

Data Sort by SQL Directive

1. Filter statement of SELECT instruction:

Format: SELECT ...

In the SQL language: "SELECT" Datasheet "is selected in some" field "data.

2. If the data table data to be selected contains more than one field, we can use the "," comma, the name is separated.

3. If the data table data to be selected contains all the fields, you can use the multimeted character "*" to represent all of the fields.

SELECT instructions for sorting data

1. When we want to be selected, the data recorded data can be sorted according to the content of a certain field, as long as these sorting bars are placed after the "Order By" reserved word, then this is sorted The statement is connected behind "SELECT ... FROM".

2. The default sort method of "ORDER BY" is "from the small row to the big", but if you want the sort mode, "from the big row to small", then we can add "DESC" reserved after the column name! The sort mode is changed to "from the large row to small".

Open the statement in the Open Database ASP program in the "Show Message" webpage:

Select * from allmessage Order by message dates DESC

The function is: Take data from all fields from the data table "AllMessage", and sort the removed data record content in accordance with the "Big Row to Small" sorting by the "Meet Date" field.

Message Displaying the management mode of the web page

The "Show Message Opinions" must have the function of display mode selection. When the display mode is in general, the general statement of the parents can be displayed, and they have to hide the "whisper". When the teacher logs in to the management mode with a password, the general speech must be displayed all of the data to whisper, and it has to make the teachers to make an independent answer for the opinions issued by the parents of a particular student.

These two cases are implemented by password login management mode:

<% IF session ("checkedit") = "YES" THEN%>

<% ELSE%>

Password: & nbsp & nbsp

<% end if%>

In this web statement, use the Session object to record the current working mode. When we enter the "Show Message Opinions" webpage, the web screen we have seen must be general! Because the session has not been established, its "variable" value will not be "yes", so an input password will appear in the "Teacher Management" mode, only when we enter the password presses "teacher management" After tissue, the session object will be established after the process of entering the management mode statement in the ASP program, and the "checkit" session object variable value is set to "Yes", so we have entered the general speech and whispering All of the statements are displayed, while also allowing teachers to make an independent response to the management mode page for their opinions published by a particular student.

Message Display Paging

When parents' speech and the teacher reply have too much data pen, all the data content is displayed on the web page, waiting for web download time too long, so the fixed pen is used to display the web page.

To make a paging display, you know how much message data currently has, and the message data pen can be found through the RecordSet object "RecordCount" attribute, we will display every 10 data as a unit paging:

Count = rs.recordcount

IF count / 10> (count / 10) THEN

Totalpage = (count / 10) 1

Else Totalpage = (count / 10)

END IF

"/" Is a floating point number division, "/" is an integer division.

Jumping page selection ASP program statement

After all of the speech data is displayed in a fixed pen, you have to provide a function of jump link display, so that the viewer can select the page you want to browse to browse, ASP program statement:

PageCount = 0

rs.movefirst

If Request.QueryString ("Topage") <> "" "" topage "))

If PageCount <= 0 THEN PAGECOUNT = 1

IF PageCount> TotalPage Then Pagecount = TotalPage

rs.move (PageCount-1) * 10

Message form page

INSE TU3

Form parameters

The Action parameter of the form: Action parameter is a program for specifying the server-side processing of this form data content, here the form processing ASP program is "add.asp",

MOTHED parameters of the form: There are two ways to transfer the form to the Server side. The settings values ​​are GET and POST. If set to POST, the browser will wait for the Server terminal to read the data. If set to get, When the button is pressed, the browser immediately transmits the data in the form. Using the POST method, the data transmitted on the transmitted data will not be limited, and the amount of data transmitted by the GET method is about only 2K. Message handler

To make a subsequent processing of parents and deposits these data content into the database, you must use the INTO directive to add data records, and then write to the database file:

INSET INTO instruction statement format:

INSERT INTO Data Name (Column Name) VALUES (Column Value)

SQL = "INSERT INTO AllMessage (parental name, message theme, contact mailbox, message content, private public, message time, class) VALUES ("

SQL = SQL & "'" & Parent & "',"

SQL = SQL & "'" & Subject & ","

SQL = SQL & "'" & email & "", "

SQL = SQL & "'" & Memo & ","

SQL = SQL & "'" & personal & ","

SQL = SQL & "'" & now & "", "

SQL = SQL & "'" & bj & ")"

Cn.execute SQL

Reply form program page

Must allow teachers to make an independent answer for their views issued by a particular student.

Use SELECT ...WHER ... WHERE filter statement

SQL = "SELECT * ALLMESSAGE WHERE (Number =" & Id & ")"

RS.Open SQL, CN, 1, 3

Then put the specific parent's speech data in the form, the method is to take out the data in the database, and then placed in the form field:

"Parent Name" field page statement tag

<% = rs ("Parent Name")%>

"Message Topic" field webpage statement tag

<% = rs ("message topic")%>

"Message Content" field webpage statement tag

<% = rs ("message content")%>

The teacher fills in the recovery field must be given to the ASP program "ANSSAVE.ASP" of the teacher reply data to record and handle these reply data. When the teacher fills in the data of the reply, then press the "Send Reply" button, the data content in the form will be read by the SEVER side in "post", and then the data content is handed over to the ASP program for the teacher reply data. "ANSSAVE.ASP" to write data content into the database. 3.2 Online Library

Online libraries put the school library books in the network to people's borrows, which is not only convenient for students in the school and faculty employees using libraries, but also provides a simple management of libraries.

3.2.1 Function

Online library systems can be borrowed and returned by books. It can also be found in the system in accordance with a variety of fields. You can also browse all books. The application also provides library administrators with some features. Add, edit, and delete books, or add new types to the classified hierarchy.

3.2.2 Hierarchy of the system

Each box of the figure below represents a page in the campus library website. In addition to only HTML Search pages, other ASP pages are available. Because each book is different, most of the pages are actually multi-page.

3.2.3 Database Design

This system uses 3 data sheets:

The LibBooks table contains all the data related to the book. The general information of books of the field content in this table. In addition, for books that have been borrowed, the table also includes the ID number of the user who borrows the book, and the state of the book.

The watch is as follows:

Field Name Field Type Field Name Field Type

BookID Book No. (Key) Digital (No Null) Status Status Text

Title Title Text CheckedoutTo User ID Number

Author Word Reservedby User Learn Number

Subject Theme Text Description Description Text

ISBN ISBN number text keywords keyword text

The Libcategories table contains all categories in library, which will be used when visiting the list of books. Each category can be used as a parent category of additional categories. There is a special category, Top-level, no appears in the category list, but can be used as the parent category of any other category.

Field Name Field Type

CategoryName Category Text (NOLL)

ParentCategory parent category text (NOLL)

The libemption table contains user information that can access the library website. The table contains some universal information fields, such as user passwords used to enter the library.

Field Name Field Type Field Name Field Type

Empid User ID (Primary Key No Null) Digital Password User Password Text

Empname User Name Text Manager Administrator Code Number

EmailAddress user mailbox text

The data relationship of the library database is shown in Figure 9-22. Among them, the tables Libemps and tables lib categories are a pair of relationships with table libBooks. Each employee can borrow more books, each category can contain multiple books.

3.2.3 Design of Interface Design and Key Code

Online library systems have two users, one is administrator. The other is only the library system is allowed without managing functionality. Visitors enter the website, first log in, as shown below. Login page (INDEX.ASP)

Visitors Enter the E-Mail address and password to log in, and then click the "Login" button. Enter the data submit to match the user table in the database.

You must create a record to save user information based on visitors logged in.

SET RSFINDEMP = Conn.execute ("Select Empid, Manager from Libemps Where" _ & "Emailaddress = '" & Request.form ("EmailAddress") & "' and" _

& "Password = '" & Request.form ("Password") & "'")

IF rfindemp.eof

TheMessage = "Password or email address is wrong."

Else

Session ("Empid") = rsfindemp ("Empid")

Session ("Manager") = rsfindemp ("manager")

Response.Redirect "../yk.htm"

END IF

Table fields EmailAddress and Password are used in WHERE clauses to get a record. If the visitor enters an invalid username, the recordset will not return a matching record. We can determine if a recordset is empty by viewing an EOF tag. When it is empty, the visitor will be rejected into the system. Not empty, the visitors' EMPID and Manager values ​​will return from the recordset. Write the session variable, the variable will be valid for all the web pages of the entire website. The presence or absence of these variables will be used to determine whether to allow access to a particular web page, and also for the accesser's return and borrow operations.

Library Menu Page

The library menu page contains links to other 4 pages: management page, search page, book list page, and main page. There is also a button that shows books for users. If the visitor is a library administrator, the menu interface is shown in the figure. If the visitor is not a library administrator, it will see the interface shown in the figure. Non-administrators' visits do not point to the link to the Administrator Menu page.

Implementation: Visitors log in to the created session variable session on the login page to get the information about the visitor from the database, indicating whether it is an administrator. If the value is 1, it indicates that the visitor is an administrator, and the link to the administrator page is written with the following code:

<% IF session ("manager") = 1 THEN%>

Administrator menu

<% end if%>

By the button B1 is empty, if you want to display the user's book, you will use a recordset to obtain a list of all books that visitors have borrowed.

IF not isempty (Request.Form ("B1")) THEN

SET RSBOOKS = Conn.execute ("Select Bookid, Title from Libbooks Where" _

& "CheckedOutto =" & session ("Empid"))

END IF

Re-use the loop statement to display the book in the form of a table.

<% IF not ISempty (Request.form ("B1")).

DO Until Rsbooks.eof%>

<% response.write Rsbooks ("Title")%> <% rsbooks.movenext loop END IF %> The loop will traverse each record in the RSBooks recordset until the end of the recordset: All ASP pages in this site will log in to check them before the visitor access. This will happen to avoid accessers to enter a page address and then directly enter the page without logging in. In addition, each management page must confirm that the visitor is an administrator. Manage menu page The management menu page has an HTML form. According to the different button, 5 different operations can be performed: the return of the book, the edit of the book, the deletion of the book, and the addition of books, additions and categories. Regardless of which button is selected, the form is authorized to handle itself. To return the book's return, the book's editing, the deletion of the book, must be searched first, after finding the book, return a link by book book.asp: <% IF session ("manager") = 1 THEN%> > Administrator menu / A> <% end if%> And the manager page passes the following statement <% = Request.QueryString ("Title")%> This will pass the book number bookID of the book found, and the book name Title passes the administrator page. Again it is necessary. A total of 3 different ammonium directions can be performed. If you click the "Modify" button: Then redirect to the Edit Book page, and pass the bookID to this page. Response.Redirect "./EDit_book.asp?bookid="&request") Will other situations need to be established to the database connection: Set conn = server.createObject ("adoDb.connection") Conn.open ("FileDSN = C: / Program Files / Common Files / ODBC / DATA SOURCES / MS Access Database.dsn") IF not isempty (Request.Form ("delete")) and request ("bookid1") <> "" Conn.execute "delete from libbooks where bookid =" & request ("boxid1") END IF if (NOT isempty (Request.Form ( "checkin"))) and request ( "BOOKID1") <> "" thenconn.Execute "update LibBooks set checkedoutto = 0, status = 'Available' where BookID =" & Request ( "BOOKID1 ") END IF The added new type section in the page contains a text control and a selection control. The selection control is filled with all existing category lists, including special category TOP Level, which indicates the topmost of the current category is in the category hierarchy. code show as below: First use a recordset to fill the parent category selection control: Set rscategories = conn.execute ("Select CategoryName from Libcategories Order By CategoryName) Use the following cycle statement: <% Do Until Rscategories.eof %> > <% response.write rcategories (" categoryName ")%> <% Rscategories.Movenext Loop %> Traverse each record in the RSCategories record, and add it to the list as an option, and record the categoryName simultaneously as the display value and transfer value: This page also contains links to add a book page. Search results page The code for searching the page acquires books matching the visitor lookup rule, and then displaying these books to the visitor. The form on the search page contains a selection control and a text control. The options in the selection control are filled with searchable fields: You need to use a recordset to save records that match the visitor's lookup rules: Set Rsbooks = Conn.execute ("Select Bookid, Author, Title, Subject from Libbooks Where" _ & Request.form ("Searchfield") & "Like '%" & Request.Form ("Searchcriteria" & "%'") Note: Yes, symbol% ​​means a broad search. This is similar to the symbols in Access *. The found book is then displayed in a table. code show as below: <% Do Until Rsbooks.eof%>
Title: "> <% Response.write RSBooks (" Title ")%>	Welfare: <% response.write Rsbooks ("Author")%>	Topic: <% response.write Rsbooks ("Subject")%> <% Rsbooks.movenext LOOP%> Book page The code display of the book page shows the information of the book, as well as the management of books. This page passes Bookid via querystring If ISEMPTY (Request.QueryString ("Bookid")) THEN Response.Redirect "./search.html" END IF If there is no existence, the visitor will be redirected to the search page: If the variable Action included in the form is transmitted is not empty, the visitor is borrowing the book: IF not isempty (Request.QueryString ("Action")). In this case, you need to change the book state to Checkout, and you need to modify the CheckedoutTo field to the visit: Conn.execute "Update Libbooks Set Status = 'Checked Out'," _ & "CheckedOutto =" & session ("Empid") & "Where bookid =" _ & Request.QueryString ("BookID") Response.Redirect "./library_menu.asp" END IF Then will then redepatis the visit to the library menu page: Next, use the status of books to determine different links The link is not borrowed as follows: IF RSBooks ("status") = "available" then LinkText = " Borrowing this book If books have been borrowed, create a different message and set the link to point to the library menu page: LinkText = " Finally, depending on whether it is an administrator, the administrator menu link is displayed. <% IF session ("manager") = 1 THEN%> "> Administrator menu <% end if%> 3.3 online evaluation voting system 3.3.1 Function: You can achieve full school selection, fast, fair, and effective, not allowed to do. 3.3.2 Composition Construction This system consists of 3 parts - voting page vote.htm, handling scripts for voting results, showing the voting page. 3.3.3 Design of Data Sheet: 3.3.4 Interface Design and Key, Difficulty Code Design Voting page This page is a pure HTML file that allows users to choose candidates they want to elect, and fill in their own detailed information to confirm the validity of voting. The page is shown as shown. Form processing script After the data in vote.htm is completed, click the determined voting button, the data of the form is submitted. There are 4 candidates, but only two are available. Use the check box. The validity of the voting is judged by whether it is a student of the school, and whether it passes the ticket. IF Request ("Passno") <> "" " SQL = "SELECT * from stay where password =" & "'" & requirements "&"' "&" and yitu = 0 " SET RS = cn.execute (SQL) IF r.eof life%> <% response.write "You no right to vote"%> This design allows less options and does not allow multiple choices. By judging that the Vote voting interface passed the check button in the length of the value of the value. VO = Request ("Cand") IF LEN (VO)> 4 THEN%> <% response.write "more selected, invalid"%> Then, according to the votes of the vote, the corresponding candidate's voting result field is added, and the voter's deceived section is set to 1. SQQ = "Update stud set yitu = 1 Where password =" & "'") & "'" Cn.execute (SQQ) IF INSTR (Vo, "1") THEN Cn.execute ("Update Stud Set Result 1 WHERE Name = 'Li Ning') END IF IF INSTR (Vo, "2") THEN Cn.execute ("Update Stud Set Result 1 Where Name = 'Yang Lan') END IF IF INSTR (Vo, "3") Thencn.execute ("Update Stud Set Result 1 WHERE Name = 'JiangDuming') END IF IF INSTR (Vo, "4") THEN Cn.execute ("Update Stud Set RESULT 1 Where Name = 'Duan Genu") END IF%> Show current voting situation show.asp Since the voting processing page has completed most of the work, the display result page is very simple, and its function is to read the number of votes obtained from the STUD table file, displayed on the page. Page display It is worth noting that the code mainly has the following: This page has an automatic refresh feature that enables online users to see the latest elections as soon as possible. We set it automatically once every 30 seconds. When the vote is displayed, we use the While loop, display the candidate and its ticket, neatly in a table, which is often used in the display of the database query results. code show as below: <% While NOT HS.EOF%>
<% = HS ("Name" & "& HS (" Result ") &" Ticket "%> <% HS.MOVENEXT%> <% wend%> 3.4 Damage Examination Online Tissue System and Counter Production 3.4.1 Function: It provides online viewing results. Candidates can use this system online to query the results of the reach of the exam through the input admission ticket number. 3.4.2 Design of Data Sheet Sharing the STUD table with the evaluation system, the table design is the same. 3.4.3 Design of interface design and key difficulties This module requires a query to enter the admission ticket number later to view the results. When ID1 is not empty, it means a form input and start querying the database. Use the SQL instruction of the SELECT to query the data of the database. First set the SQL instruction, query the ID of the ID, the data of the admission ticket request.form ("ID1"), the next "Execute" instruction, you can start executing access, query the data. And store the query results into the RECORDSETS component RS. IF Request.form ("ID1") <> "" Set conn = server.createObject ("adoDb.connection") Conn.open ("FileDSN = C: / Program Files / Common Files / ODBC / DATA SOURCES / MS Access Database.dsn") SQL = "SELECT NAME, ID, Score from Stud WHERE ID = '" & Request.form ("Id1") & "'" set = conn.execute (SQL) If the exam is passed, the results of the test, including the name, admission ticket number, total division and test results, respectively, RS (0), RS (1), RS (2), RS (3), RS (2), RS (3), respectively. Fs.field.count indicates the total number of domains of the RecordSets component, from "for i = 0 to rs.fields.count-1", acquiring data in each domain of RS (i). With the Table HTML syntax, fill the results in each cell of the table. If there is still the next data, use rsmovenext to the next position. 3.4.4 Page Access Counter Production Using the powerful feature of file processing component FileSystem, it is better than the Application object counter, and the Application Counter is returned to zero when there is no one in 20 minutes of the page or shutdown. The file counter does not disappear due to time. I am using count.txt to store access to visitors. code show as below: Whichfile = server.mappath ("pic / count.txt") Set myfile = server.createObject ("scripting.filesystemObject") created one Set thisfile = myfile.opentextFile (Whichfile) Component object Visit = thisfile.readline thisfile.close Read the count data in count.txt in count.close Visit = Visit 1 records Length = len (Visit) For i = 1 to Length Response.write " " displayed the data with the picture NEXT SET thisfile = myfile.createtextfile (Whichfile, 1) Write the new count data into the file thisfile.writeline (Visit) Set myfile = Nothing Digital image I use the text special effects in Photoshop to make 9 cubic numbers: Wait four. System's instructions and installation 4.1 Operating environment requirements WINDOWS98 Personal Web Server 3.0 (PWS) Microsoft? Access 2000 (9.0.2812) 4.2 Installation Settings A. Copy this website to a certain directory on the hard disk, such as copying to C: / Y1. B. Run PWS, set the default Web site main directory to this directory, as follows: C: / Y1; Specific steps: a. Select "Advanced" item; b. Click the Edit Properties button to fill in "C: / Y1" in the "Directory" item in the "Edit Properties" dialog box appearing, others constant, determine; C. Set the boot default document as: yy.asp Thank you Through this graduation design, I feel the power of high-tech and new knowledge. During this graduation design, I received strong support from Changsha City's industrial and commercial career schools. I provided me with a comfortable work learning environment. I also got a careful guidance from UNICE, professor. I express my heartfelt thanks! Fives. references [1] Li Shijie Active Server Pages (ASP) 3.0 Web Design Handbook Beijing: Tsinghua University Press 1999 [2] Frontline computer image studio clever use Dreamweaver, Fireworks, Flash Production Page Beijing: People's Posts and Telecommunications Publishing House [3] ASP Getting Started and Example Drive Thin Xiaozhi Miya Publishing House 1. Dynamic webmaster video tutorial asp.php.jsp.php.jsp Tutorial introduction: This tutorial has 32 sections, and each section is about 50 minutes. Very detailed explains the basic knowledge of the web, in-depth explains how to design HTML, ASP, PHP, JSP procedures, is the web programming designer must see Good tutorial, personal recommendation! I have seen it, from the middle school to a lot of skill. Really from getting started to proficient video tutorial. 2. Programming Master ASP Tutorial introduction: All use animation teaching mode! The first set of comprehensive solutions for programming entry: CD content is rich in fluctuations, unique "trials" function guides you to practice in the software real environment, even if you don't pass the program, "Programming Master" can also teach you to compare real software. Practical knowledge: More considerately have a functional knowledge of functions, common techniques, etc., and contain all the examples and compile results. I strongly recommend that if you want to learn, it will give you unexpected surprises! ! ! 3. New Concept ASP.NET Tutorial The only ASP.NET in the network is currently learning ASP. Net friends don't miss it. 转载请注明原文地址:https://www.9cbs.com/read-70788.html 9cbs New Post(0)