ASP调用SQL语句, 高手们,帮帮忙
我做一个表单想维护数据库,有"插入""更新""删除"三个功能,想问问ASP里怎么调用<formaction="___"method="post"id="fm"name="...
我做一个表单想维护数据库,有"插入""更新""删除"三个功能,想问问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,什么都不懂,请高手们帮帮忙. 展开
<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,什么都不懂,请高手们帮帮忙. 展开
2个回答
展开全部
<%
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
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
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询