A code writing standard

For example: Variables prefix example bln Boolean blnSuccess cur Currency curAmount dbl Double dblQuantity dat Date and Time datDate flt Float fltRatio lng Long lngMilliseconds int Integer intCounter str String strName arr Array arrUsers () obj named COM Object objPipeline functions and processes to be followed The above basic rules, and with a verb look down 4.2 statement uppercase or the first-letter capital IF, THEN, ELSE, and END IF and other VBScript statements. 4.3 String Connection To maintain consistency and reach a script target with more self-prophet, use the string connecting (&) instead of the plus sign ( ). 4.4 Comments Use annotations to explain the unintegrated or complex code. In-line comments should display two spaces after the corresponding code. The comments starting on the new line should be aligned with the previous row. It is recommended to use single quotes (') instead of the REM key, and add the REM key on the line without code. Comment statements Try to use English. 6. Database & ADO Operation 6.1 Unicode Data Type Database Places in the database to use the Chinese characters to use the Nchar, NVARCHAR, NTEXT type. 6.2 Database Connections All Connection Databases must include header files Connaaaaaaaaaaaaaaaaaaaaa.as for connection data (if different connection files are required, AAAAA represents different modules). Define the connection string using the OLEDB provider to connect the database (not allowed to use the database administrator SA) using the OLEDB provider. This file will not be placed under the site directory to use "include file" way of "Include File". SQL SERVER by using OLEDB, use the following syntax: Provider = SQLOLEDB.1; Password = mypassword; Persist Security Info = True; User ID = myuid; Initial Catalog = mydbname; Data Source = myserver; Connect Timeout = 15 If you want to use data configuration, OLEDB connection using the following syntax: Provider = MSDataShape; Date Provider = SQLOLEDB.1; Password = mypassword; Persist Security Info = True; User ID = myuid; Initial Catalog = mydbname; Data Source = myserver; connect Timeout = 15 6.3 References of ADO attribute constants If you need to use ADO constants, you should add the following code to this file, you can directly access all ADO constants: 6.4 Use the simplest cursor type and record lock mode to define four kinds in ADO Different cursor types: 1 ADOPENFORWARDONLY - Used to view addition, changes, and delete of other users, and use to move in all types of movements that do not depend on bookmarks. If the provider supports, you can use a bookmark. l Key Set Cursor - It is similar to a dynamic cursor. Different is only to view records added by other users, and disable access to other users' deletions, and the data changes made by other users will remain visible. It always supports bookmarks, thus allowing various types of movements in RecordSet. l Static Cursor - Provides a static copy of a record collection to find data or generate a report.

It always supports bookmarks, thus allowing various types of movements in RecordSet. The addition, changes, or deletion made by other users will be invisible. This is the only cursor type that allows usage when opening the client (Ador) Recordset object. l Only the forward cursor (AdomentStatic) - its behavior is similar to a dynamic cursor except only to scroll forward in the record. This way, performance can be improved when moving one-way movement in the Recordset. Set the CURSORTYPE attribute before opening Recordset to select the cursor type, or use the Open method to pass the CURSORTYPE parameter. Some providers do not support all cursor types. Check the provider's documentation. If you do not specify a cursor type, ADO will open only the forward cursor by default. Four different cursor types are defined in ADO: LadlockReadonly - default, read-only. Unable to change the data. LADLOCKPESSIMISTIC - conservative record lock (strip). The provider performs the necessary operations to ensure successful editing records, usually using the record of the data source immediately when editing. LADLOCKTIMISTIC - Open Record Locking (strip). The provider uses an open lock to lock the record only when the Update method is called. LadlockBatchOptimistic - open batch update. The batch update mode is used to update now. Setting the LockType property before opening RecordSet Specifies the lock type that the provider should use when the Open is open. Read this property returns the type of lock that is using on the open Recordset object. The LockType property is read / written when Recordset is closed. This property is read-only. The simplest cursor type and record locking method suitable for processing tasks should be used during actual use. For example: only open a static recordset and output: rs.open SQL, CONN, 0, 1 'AdopenForwardonly, ADLOCKREADOONLY Open Record in the record set with text Type: RS.Open SQL, CONN, 1, 1' AdopenkeySet, AdlockReadonly 6.4 SQL String Filter All String Enterlets You must check the function checking, insert, delete or modify a record to the database, ie: character: "'", "' ' "Whether using public functions CheckInputString ().) And check if the length of the string is long. Value: Use the isNumeric () to determine if the input is a number. Integer: Use int (), fix (), and Round () intercept its integer value. Date type: Use the isdate () function to determine if the correct date is entered. 6.5 SQL Transaction Execution transactions for database operations generally should be performed using SQL stored procedures. For database operations that need to be performed in the ASP page, all inserts, delete, modify the database must not use the RecordSet object, you must use the Connect object to perform with the SQL statement, the Recordset is only used when the query is executed. All search databases are prohibited from using "Select * from ...", and use "SELECT field 1, field two, field three, ... from ...". 6.6 Closing the ADO object All Connect and RecordSet, etc., the ADO objects such as Connect and RecordSet must be turned off immediately after running, and then release its object (set *** = nothing). V. ASP program 5.1 Variable declaration must write <% Option Explicit%> in the next line of the program instructions in all ASP pages for variables. Because the local variables are not as slowly as global variables (slower than the defined partial variables). The public file exceptions included.

5.2 Program Description Each program file must indicate the functionality or function of the file, the entry parameters of the program, the parameter description, the author, write a date (including the generation date, final modification date). The following format: <% '**' Comment: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 'Input: (must) logon_id-User Name; logon_pd-User Password' (plus) 'Editor: xxxxx 2000-11' Modify: xxxxx 2000-12 '**%> 5.3 Minimization Context Switching For Server Handling Script Performance, it is recommended to minimize HTML and scripts. In a possible case, a few large block scripts should be used instead of multiple dispersed fragments on one page. For example: <% IF a> 1 THEN%> First <% else%> second <% End IF%> It is best to write into the following format: <% if a> 1 Then Response.Write " First " else response.write " Second "END IF%> 5.4 Separation of the script to increase readability (" <% ","%> ") split into code as code Block, instead of writing delimiter in every line. Below code: <% streymail = session ("email")%> <% strfirstname = request ("firstname")%> <% strlastname = request ("lastname")%> should be written as the following format: <% streymail = session "Email" StrfirstName = Request ("firstname") strlastname = request ("Lastname")%> For a separate script row, the delimiter is kept in the same line as a script. For example: <% streymail = session ("email")%> If the script row consists of an equal number and a variable, the equal sign should be part of the delimiter. For example: <% = strsubscrlname%> 5.5 Forbidden use of Session Since the session affects load balancing, the session will no longer use, and uniform use cookie to maintain user status. 5.6 For pages long running time, use the response.flush method Each write operation produces a large system overhead (in IIS, in terms of data from the network through the network), the less the write operation is, the better. Due to its slow start and use the Nagling algorithm (used to mitigate the network plucking condition), TCP / IP is much higher than the efficiency when sending some large data blocks. For a page for long run, the response.flush method must be used. This approach sent all HTMLs converted to the ASP to the browser.