Question

ASP调用SQL语句, 高手们,帮帮忙

我做一个表单想维护数据库,有"插入""更新""删除"三个功能,想问问ASP里怎么调用

<form action="___" method="post" id="fm" name="fm">
ID:<INPUT name="T00" ID="T00" value="">
名字:<INPUT name="T01" ID="T01" value="">
年龄:<INPUT name="T02" ID="T02" value="">
电邮:<INPUT name="T03" ID="T03" value="">

<INPUT type=submit value="新增">
<INPUT type=submit value="更新">
<INPUT type=submit value="删除">
</form>

表名是 Teachers
字段有 TeacherID 是自动编号的
Name 文本
Age 数字
Email 文本

Insert Into Teachers(Name,Age,Email) Values ('____', __, '____')
Update Teachers Set Name='____',Age=__,Email='____' where TeacherID='___'
Delete * From Teachers where TeacherID=??
还有的是“__”下划线怎么填,小弟刚学ASP,什么都不懂,请高手们帮帮忙.

Answer 1

<%

if request.form("button1")<>"" then
sql="select * from GC_PartTechConfess_SET"
rs1.open sql,conn1,1,3
rs1.addnew
rs1("title")=title1
rs1("display")=display1
rs1("text")=text1
rs1.update
response.write("<script>alert(""AddNew Success!"");history.back(1)</script>")
rs1.close
elseif request.form("button2")<>"" then
if num1 <> "" then
sql="Select * From GC_PartTechConfess_SET WHERE Num=" & num1
rs1.open sql,conn1,1,3
if not rs1.eof then
rs1("title")=title1
rs1("display")=display1
rs1("text")=text1
rs1.update
response.write ("<script>alert(""Update Success!"");history.back(1)</script>")
else
response.write ("<script>alert(""Database No Data!"");history.back(1)</script>")
end if
rs1.close
else
response.write ("<script>alert(""Operation Error!!!"");history.back(1)</script>")
end if
elseif request.form("del1")<>"" then
if num1="" then
response.write ("<script>alert(""Please Select the Number before Delete!"");history.back(1)</script>")
else
sql="delete From GC_PartTechConfess_SET WHERE Num=" & num1
conn1.execute sql
response.write ("<script>alert(""Delete Success!"");history.back(1)</script>")
end if
end if

Answer 2

1、request.form("T01"),request.form("T02"),request.form("T03")
2、request.form("T01"),request.form("T02"),request.form("T03"),request.form("T00")
3、request.form("T00"),
加分吧。