<%
Dim mode
mode=request.form("text4")
if mode=1 then
name=request.form("text1")
age=request.form("text2")
addr=request.form("text3")
if not isnumeric(age) then response.write "age must be number!<a
href=javascript:history.go(-1)>try again</a>":response.end
age=clng(age)
end if
'********************************************************************
' 锟斤拷SQL Server2000锟叫关碉拷锟斤拷锟斤拷
' 锟斤拷锟皆诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷匡拷锟斤拷锟斤拷
'********************************************************************
'锟斤拷锟斤拷注锟解：
'锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷StrServer,StrUid,StrSapwd,StrDbName锟侥革拷锟斤拷锟斤拷
Dim StrServer,StrUid,StrSaPwd,StrDbName
StrServer="(local)" '锟斤拷锟捷匡拷锟斤拷锟斤拷锟斤拷锟�
StrUid="testuser" '锟斤拷锟侥碉拷录锟绞猴拷
StrSaPwd="12345" '锟斤拷锟侥碉拷录锟斤拷锟斤拷
StrDbName="db_test_com" '锟斤拷锟斤拷锟斤拷锟捷匡拷锟斤拷锟斤拷
Dim Conn '锟斤拷锟捷匡拷锟斤拷锟斤拷
Dim StrDSN '锟斤拷锟捷匡拷锟斤拷锟斤拷锟街凤拷锟斤拷
Dim Rs '锟斤拷锟斤拷锟街凤拷锟斤拷
StrDSN="driver={SQL server};server="&StrServer&";uid="&StrUid&";pwd="&StrSaPwd&";database="&StrDbName
'锟斤拷锟斤拷锟斤拷锟斤拷锟捷匡拷master锟斤拷锟斤拷锟斤拷
set Conn = Server.CreateObject("ADODB.Connection")
set Rs=Server.CreateObject("ADODB.RecordSet")
Conn.Open StrDSN
'********************************************************************
'********************************************************************
Dim strsql
'********************************************************************
' 锟斤拷锟斤拷锟捷匡拷锟斤拷锟截诧拷锟斤拷
sub readdb()
strsql="select * from test"
rs.open strsql,conn,1,1
if rs.EOF then response.write "no record at all":exit
sub
response.write "<table border=1>"
response.write "<tr>"
for i=0 to rs.Fields.Count-1
response.write "<td><font color=blue>"&rs.Fields(i).Name&"</font></td>"
next
response.write "</tr>"
while not rs.EOF
response.write "<tr>"
for i=0 to rs.Fields.Count-1
response.write "<td>"&rs.Fields(i).Value&"</td>"
next
response.write "</tr>"
rs.MoveNext
wend
response.write "</table>"
rs.Close
end sub
'********************************************************************
'********************************************************************
' 写锟斤拷锟捷匡拷锟斤拷锟截诧拷锟斤拷
sub insertdata()
strsql="INSERT INTO test(name,age,addr) VALUES('"&name&"',"&age&",'"&addr&"')"
rs.Open strsql,conn,1,3
end sub
'********************************************************************
if
mode=1 then
call insertdata()
response.write "insert ok!"
elseif mode=2 then
call readdb()
end if
'锟酵凤拷锟斤拷锟捷匡拷锟斤拷锟接讹拷锟斤拷
set rs=nothing
set conn=nothing
%>
<HTML>
<HEAD>
<TITLE></TITLE>
<script language=javascript>
function clickit(flag){
var form1=document.form2
form1.text4.value=flag;
if (flag==1){
if (form1.text1.value==""){
alert("name cant empty!");
return false;
}
if (form1.text2.value==""){
alert("age cant empty!");
return false;
}
if (form1.text3.value==""){
alert("addr cant empty!");
return false;
}
}
form1.submit();
return true;
}
</script>
</HEAD>
<BODY>
<form method=post name=form2>
name:<INPUT type="text" id=text1 name=text1 size=12>
age:<INPUT type="text" id=text2 name=text2 size=12>
city:<INPUT type="text" id=text3 name=text3 size=12><br>
<INPUT type="hidden" id=text4 name=text4>
<INPUT type="button" value="write" id=button1
name=button1 onclick="clickit(1)">
<INPUT type="button" value="read" id=button2
name=button2 onclick="clickit(2)">
</form>
</BODY>
</HTML>
|
