求个位大虾,帮我解释一下下面的代码,谢谢了
set rs=server.createobject("adodb.recordset")
sqltext="select * from Class_1 where Class_1_name='" & request.form("class_name") & "'"
rs.open sqltext,conn,1,1if rs.recordcount >= 1 then
if rs("Class_1_name")=request.form("class_name") then
Response.Redirect "messagebox.asp?msg=此商品大类已经存在,请选用其它名称!"
response.end
rs.close
end if
end if
set rs=server.createobject("adodb.recordset")
sqltext="select * from Class_1"
rs.open sqltext,conn,3,3rs.addnew
rs("Class_1_name")=request.form("class_name")
rs.update
%>
<%
set rs_detail=server.createobject("adodb.recordset")
sqltext2="select * from Class_1 where Class_1_name='" & request.form("class_name") & "'"
rs_detail.open sqltext2,conn,1,1
set rs=server.createobject("adodb.recordset")
sqltext="select * from Class_1 where Class_1_name='" & request.form("class_name") & "'"
rs.open sqltext,conn,1,1if rs.recordcount >= 1 then
if rs("Class_1_name")=request.form("class_name") then
Response.Redirect "messagebox.asp?msg=此商品大类已经存在,请选用其它名称!"
response.end
rs.close
end if
end if
set rs=server.createobject("adodb.recordset")
sqltext="select * from Class_1"
rs.open sqltext,conn,3,3rs.addnew
rs("Class_1_name")=request.form("class_name")
rs.update
%>
<%
set rs_detail=server.createobject("adodb.recordset")
sqltext2="select * from Class_1 where Class_1_name='" & request.form("class_name") & "'"
rs_detail.open sqltext2,conn,1,1
select * from tb where Class_1_name=?
?是你要输入的值
sqltext="select * from Class_1 where Class_1_name='" & request.form("class_name") & "'"//指定sql语句
rs.open sqltext,conn,1,1,打开数据库,传入sql语句,和2个附加的参数if rs.recordcount >= 1 then//如果存在记录//如果存在存在Class_1_name等于界面上名字为class_name的控件的值
if rs("Class_1_name")=request.form("class_name") then
//转到提示页面
Response.Redirect "messagebox.asp?msg=此商品大类已经存在,请选用其它名称!"
response.end
rs.close//关闭数据集
end if
end if
set rs=server.createobject("adodb.recordset")
sqltext="select * from Class_1"
rs.open sqltext,conn,3,3//这三句跟前面一样rs.addnew//增加一个新的记录(跟下面两句一起)
rs("Class_1_name")=request.form("class_name")
rs.update
%>
<%
set rs_detail=server.createobject("adodb.recordset")
sqltext2="select * from Class_1 where Class_1_name='" & request.form("class_name") & "'"
rs_detail.open sqltext2,conn,1,1