UC知道帮我具体解释一下代码 谢谢大家 我是新手
来源：百度知道 编辑：UC知道 时间：2024/06/15 12:46:51
dim college,Fcondition,Scondition,keywords
college = Request.Form("college")
Fcondition = Request.Form("Fcondition")
Scondition = Request.Form("Scondition")
keywords = Request.Form("keywords")
xl = Request.Form("xl")
sql = "Select userinfo.*,"&Fcondition&".* From [userinfo],["&Fcondition&"] Where userinfo.id = "&Fcondition&".owner "
if college <> "" then
sql = sql & " And userinfo.college = '"&college&"'"
end if
if Scondition <> "" then
sql = sql & " And "&Fcondition&".type = "&Scondition&" "
end if
if keywords <> "" then
'sql = sql & " And "&Fcondition&".type = "&Scondition&" "
end if
college = Request.Form("college")
Fcondition = Request.Form("Fcondition")
Scondition = Request.Form("Scondition")
keywords = Request.Form("keywords")
xl = Request.Form("xl")
sql = "Select userinfo.*,"&Fcondition&".* From [userinfo],["&Fcondition&"] Where userinfo.id = "&Fcondition&".owner "
if college <> "" then
sql = sql & " And userinfo.college = '"&college&"'"
end if
if Scondition <> "" then
sql = sql & " And "&Fcondition&".type = "&Scondition&" "
end if
if keywords <> "" then
'sql = sql & " And "&Fcondition&".type = "&Scondition&" "
end if
dim college,Fcondition,Scondition,keywords
college = Request.Form("college")
Fcondition = Request.Form("Fcondition")
Scondition = Request.Form("Scondition")
keywords = Request.Form("keywords")
xl = Request.Form("xl")
'以上是将post传递过来的变量分别存入各个变量中
sql = "Select userinfo.*,"&Fcondition&".* From [userinfo],["&Fcondition&"] Where userinfo.id = "&Fcondition&".owner "
'查询字符串 另:"&Fcondition&"以下暂时称为变量表
'select userinfo.*,"&Fcondition&".* '查询表userinfo和 变量表 中的所有字段
'From [userinfo],["&Fcondition&"] '从表userinfo和 变量表 中
'Where userinfo.id = "&Fcondition&".owner " '查询条件为userinfo表的id字段 等于 变量表 的owner字段
'如果看不懂,你需要了解SQL的查询语句的知识
if college <> "" then
sql = sql & " And userinfo.college = '"&college&"'"
end if
’如果col