显示表的内容
<%
set conn=Server.Createobject("adodb.connection")
connstr="driver={SQL Server};server=WIN-I1F2TODGAHT;uid=wg365;pwd=mark168@;database=WebBuy"onerrorresumenext
conn.open connstr
response.write conn.state
iferrthenresponse.write "错误!"elseresponse.write "成功!"
sql = "select * from Admin"set rs= Server.CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,1'获得连接信息与查询结果行数 Response.write("连接1:"&conn.ConnectionString&"<br/> spt_values行数:"&rs.recordcount&"<br/><br/>")
'循环结果输出 doWhilenot rs.eof
Response.write(rs(0)&","&rs(1)&","&rs(2)&","&rs(3)&","&rs(4)&"<br/>")
rs.MoveNext
Loop
rs.close()
conn.close()
endiferr.clear
%>
插入数据到表
alert是提示框,confirm是询问框
<%
set conn=Server.Createobject("adodb.connection")
connstr="driver={SQL Server};server=WIN-I1F2TODGAHT;uid=wg365;pwd=mark168@;database=WebBuy"onerrorresumenext
conn.open connstr
iferrthenresponse.write "错误!"else
m=request("m")
sql="INSERT INTO Admin (Accounts,Pwd) VALUES ('Wilson','"&m&"')"set rs= Server.CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,1
rs.close()
conn.close()
Response.Write("<script>confirm('发送成功,是否返回?');history.back();</script>")
Response.Write("<script>alert('发送成功,是否返回?');history.back();</script>")
endiferr.clear
%>
DELETE FROM 表名 WHERE 条件
update good set gicd=6 where gicd=4
asp操作txt
读取txt
<%
dim fso,f
set fso=server.CreateObject("Scripting.FileSystemObject")
Set f = fso.OpenTextFile(Server.MapPath("1.txt"),1)
DoWhileNot f.AtEndOfStream
response.write f.readline
loop
f.close
set f=nothingset fso=nothing
%>
line=txt.ReadAll'读取文件中的所有数据
line=txt.ReadLine'从文件中读取一行数据
line=txt.Read(N)'从文件中读取N个字节的数据
txt.SkipLine跳过一行
写入txt
<%
testfile=server.mappath("1.txt")
msg=request("df")
set fs=server.createobject("scripting.filesystemobject")
set thisfile=fs.opentextfile(testfile,8,true,0)
thisfile.writeline("message="+df)
thisfile=close
set fs=nothing
%><%
dim fso,f
set fso=server.CreateObject("Scripting.FileSystemObject")
Set f = fso.OpenTextFile(Server.MapPath("1.txt"),1)
f.SkipLine
one=f.readline
response.write one
f.close
set f=nothingset fso=nothing
%>