一些ASP小源程序

发表于:2007-06-30来源:作者:点击数: 标签:
嘻嘻,虽然是英文的,但是很简单,我想大家都能看懂^-^ Active Server Pages Password Script % Sub FormInput() % form method=post action=logon.asp center H1Generic Logon/H1 User Name:input type=text size=20 name=username brbr Password:input type=pa
嘻嘻,虽然是英文的,但是很简单,我想大家都能看懂^-^
Active Server Pages
Password Script
<%
Sub FormInput() %>
<form method=post action="logon.asp">
<center>
<H1>Generic Logon</H1>
User Name:<input type=text size=20 name=username>
<br><br>
Password:<input type=password size=20 name=password>
<br><br>
<input type=submit name=submit value="Submit">
</center>
</form>
<% End Sub %>
<!--#include file="adovbs.inc" -->

<%
@# *********** Password Login Code *********************
@# *********** programmed by Robert Robbins ************
@# *********** First Version 03/28/99 ******************
@# *****************************************************
@# Call Input Form subroutine
FormInput()

@# Create session variable. Username needed for filename.asp
Session("user") = ""

@# Initialize boolean flags to false
correct_name = False
correct_password = False

@# Connect to table in database
Set cn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
cn.Open "DSN Name"
rs.Open "Select * From TableName",cn,adOpenStatic,adLockPessimistic

@# Test for correct username and password
If Request.Form("submit") > "" Then
Do While Not rs.EOF
@# Compare form input to password database recordset values
If Request.Form("username") = rs("username") Then
correct_name = True
End If
If Request.Form("password") = rs("password") Then
correct_password = True
End If
rs.MoveNext
Loop

If correct_password = True And correct_name = True Then
@# If password and username are correct, jump to DataEntry.asp
@# Note: chr(34) is the double quotes character
Session("user") = Request.Form("username")
Response.write "<Script Language=" & chr(34) & "JavaScript" & chr(34) & ">"
Response.write "window.location = " & chr(34) & "DataEntry.asp" & chr(34) & """
Response.write "</Script>"
Else
@# If password or username is incorrect, write JavaScript code in HTML for an alert
dialog box
Response.write "<Script Language=" & chr(34) & "JavaScript" & chr(34) & ">"
Response.write "alert(" & chr(34) & "Aclearcase/" target="_blank" >ccess Denied!" & chr(34) & ");"
Response.write "</Script>"
End If
rs.Close
End If
%>
Password Protect Script
<%
@# Set local variable username to Session variable user
username = Session("user")

@# If username is an empty string, the user did not use logon.asp to login
If username = "" Then
Response.write "Sorry, you are not logged in!<br>"
Session.Abandon
Response.End
End If
%>
Email Script
Newline = chr(13) & chr(10)
Set Mailer = Server.CreateObject("CDONTS.NewMail")
Mailer.To = "" & Request.Form("Email") & ""
Mailer.From = "" & "rrobbins@sunlink.net" & ""
Mailer.Subject = "" & "Testing Automated Email" & ""
Mailer.Body = "" & "My email message" & Newline & "Second line" & ""
Mailer.Send
Set Mailer = Nothing
SQL Server Connection
<%
Set cn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
strConn = "driver={SQL Server};server=Pentium;uid=sa;pwd=;database=Test"
cn.Open strConn
%>
Windows Script Host
@# Windows Script Host File
@# programmed by Robert S. Robbins
@# Open database connecection and get recordset
Const adOpenForwardOnly = 0
Const adLockPessimistic = 2
Set cn = WScript.CreateObject("ADODB.Connection")
Set rs = WScript.CreateObject("ADODB.Recordset")
cn.Open "DSN Name"
rs.Open "Select * From TableName",cn,adOpenForwardOnly,adLockPessimistic
While Not rs.EOF
message = rs("Message")
MsgBox message,64,"Database Message"
rs.MoveNext
Wend

VBScript 5.0 Regular Expression
<%
Set objFile = Server.CreateObject("Scripting.FileSystemObject")
Set inFile = objFile.OpenTextFile("D:\Temp\test.txt", 1)
strInput = inFile.ReadALL
inFile.Close
Set myTest = new RegExp
myTest.Pattern = "\w+,"
myTest.Global = True
myTest.IgnoreCase = True
Set myCollection = myTest.Execute(strInput)
For Each element In myCollection
Response.write element & "<BR>"
Next
%>

原文转自:http://www.ltesting.net