UC知道谁能帮我看看这些ASP SQL代码的意思？菜鸟感谢你。
来源：百度知道 编辑：UC知道 时间：2024/06/11 14:25:46
rs_book.close
sql="insert into Customer(Customer_ID,Customer_name,Password"
sql=sql&",Cardid,education,Address,Zip,Telephone,email)"
sql=sql&"values('"&Customer_ID&"','"&Customer_name&"','"
sql=sql&Password&"','"&Cardid&"','"&education&"','"
sql=sql&Address&"','"&Zip&"','"&Telephone&"','"&email&"')"
con_User.execute(sql)
rs_book.open"select * from Customer where Customer_ID='"&Customer_ID&"'",Con_User,adopendynamic
2：if rs_User.recordcount > 0 then
Session("Guest_ID")=User_ID
Session("First_Book")=""
response.write "<script>alert('登陆成功，现转向首页！');"
response.write "window.location.href='/biye/index.asp'</script>"
sql="insert into Customer(Customer_ID,Customer_name,Password"
sql=sql&",Cardid,education,Address,Zip,Telephone,email)"
sql=sql&"values('"&Customer_ID&"','"&Customer_name&"','"
sql=sql&Password&"','"&Cardid&"','"&education&"','"
sql=sql&Address&"','"&Zip&"','"&Telephone&"','"&email&"')"
con_User.execute(sql)
rs_book.open"select * from Customer where Customer_ID='"&Customer_ID&"'",Con_User,adopendynamic
2：if rs_User.recordcount > 0 then
Session("Guest_ID")=User_ID
Session("First_Book")=""
response.write "<script>alert('登陆成功，现转向首页！');"
response.write "window.location.href='/biye/index.asp'</script>"
<%
rs_book.close '这句是关闭上面的记录集的啦
sql="insert into Customer(Customer_ID,Customer_name,Password"
sql=sql&",Cardid,education,Address,Zip,Telephone,email)"
sql=sql&"values('"&Customer_ID&"','"&Customer_name&"','"
sql=sql&Password&"','"&Cardid&"','"&education&"','"
sql=sql&Address&"','"&Zip&"','"&Telephone&"','"&email&"')" '插入值的sql。你可以这样在con_User.execute(sql) 的上一行插入：
'Response.Write sql '显示sql的内容
'Response.End '程序执行到这里中断了，不执行下面的语句了
'就可以知道sql insert语句的原型。
con_User.execute(sql)
rs_book.open"select * from Customer where Customer_ID='"&Customer_ID&"'",Con_User,adopendynamic '这句的格式，你百度关键字”记录集游标“。一般人这样写：rs.open sql,conn,1,1。最好别用adopendynamic这些常数表示。
2：if rs_User.recordcount > 0