UC知道ASP如何实现模糊查询并分页列表显示
来源：百度知道 编辑：UC知道 时间：2024/09/18 07:05:54
<!--#include file="conn.asp"-->
<%
zkzh=replace(trim(Request("zkzh")),"'","")
studentname=replace(trim(Request("studentname")),"'","")
score=replace(trim(Request("score")),"'","")
CheckCode=replace(trim(Request("CheckCode")),"'","")
if CheckCode="" then
response.write("<script>alert('验证码不能为空！');window.close();</script>")
end if
if session("CheckCode")="" then
response.write("<script>alert('验证码失效，请重新输入！');window.close();</script>")
end if
if CheckCode<>CStr(session("CheckCode")) then
response.write("<script>alert('您输入的验证码与系统产生的不一致，请重新输入！');window.close();</script>")
end if
%>
<html>
<head>
<titl
<%
zkzh=replace(trim(Request("zkzh")),"'","")
studentname=replace(trim(Request("studentname")),"'","")
score=replace(trim(Request("score")),"'","")
CheckCode=replace(trim(Request("CheckCode")),"'","")
if CheckCode="" then
response.write("<script>alert('验证码不能为空！');window.close();</script>")
end if
if session("CheckCode")="" then
response.write("<script>alert('验证码失效，请重新输入！');window.close();</script>")
end if
if CheckCode<>CStr(session("CheckCode")) then
response.write("<script>alert('您输入的验证码与系统产生的不一致，请重新输入！');window.close();</script>")
end if
%>
<html>
<head>
<titl
你是指 如行政区分 你输入天津，包含天津的数据都出来是吧？？
如果是这样的话
sql="select * from studentinfo where zkzh like'%"&zkzh&"%'"
sql="select * from studentinfo where studentname like'%"&studentname&"%'"
sql="select * from studentinfo where score like'%"&score&"%'"