|
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>我的sql</title>
</head>
<body>
<form name="form1" method="post" action="data1.asp">
<p> 姓名:
<input name="text1" type="text" id="text1">
</p>
<p> 密码:
<input name="text2" type="password" id="text2">
</p>
<p>
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="取消">
</p>
</form>
<%
dim b
dim c
b=request.form("text1")
c=request.form("text2")
response.Write b
response.Write c
%>
<%
set connect=server.createobject("adodb.connection")
connect.open "students","sa","lx586"
create table hsyxf88(name varchar(10),hs int(8))
'connect.execute("insert into student(id,pwd)values('"b"','"c"')")
connect.execute("insert into student(id,pwd)values(9999,8888)")
set n=connect.execute("select pwd from student where id like'9%'")
response.write n("pwd")
response.write"你的数据已加入"
%>
</body>
</html> |
|