Option Explicit,所有變數必須 Dim/Public/Private 宣告。| 型別 | 前綴 | 範例 |
|---|---|---|
| Integer | i | iRecordCount |
| Single | f | fPrice |
| Double | d | dAmount |
| String | s | sUserName |
| Boolean | b | bIsValid |
| Array | 型別_Array_ | s_Array_UserList |
| Object | obj | objConn, objRS |
Dim iStudentCount、Dim sSchoolName。Dim iPageSize ' 每頁筆數。全大寫 + 底線分隔:Const sDB_CONN_STR = "Provider=..."、Const iMAX_UPLOAD_MB = 10。
Function GetUserName(ByVal iUserId)。If / For / While / Function 結構換行對齊,End If / Next / Loop / End Function 縮進對齊。SELECT id, name, created_at FROM users WHERE status = 1 ORDER BY created_at DESC<input value="<%=sVal%>">。Set objRS = Nothing: Set objConn = Nothing。SELECT *,明確列出欄位。Response.Buffer = True 並分段 Response.Flush,減少記憶體壓力。ADODB.Command 參數化查詢,嚴禁字串拼接。