精确模糊查询.docVIP

姓名模糊查询 提交页面 form method=POST action=search_user.asp table border=1 width=100% bordercolorlight=#000000 cellspacing=0 cellpadding=5 bordercolordark=#FFFFFF tr td width=33%p align=right按姓名查询：/td center td width=33%input type=text name=user_name size=20/td td width=34%input name=B1 type=image value=提交 src=index_files/saech.gif/td /tr /table /form 查询页面 % dim user_name user_name=trim(request(user_name)) if user_name= then response.write 姓名不能为空，3秒自动跳转 % script langugae=javascript function mytime(){ location.href=index.asp } mytime1=window.setTimeout(mytime(),3000); /script % response.end end if set rs=server.createobject(adodb.recordset) sql=select * from st_info where user_name like %user_name%（模糊查询） rs.open sql,conn,1,1 % table border=1 width=400 cellspacing=0 cellpadding=5 bordercolorlight=#000000 bordercolordark=#FFFFFF tr td width=100% colspan=5 p align=center查找结果/p /td /tr% if not rs.eof then % tr td width=20% align=centerID号/td td width=20% align=center学号/td td width=20% align=center姓名/td td width=20% align=center性别/td td width=20% align=center班级/td /tr %do while not rs.eof% tr title=tishi style = cursor:hand onClick = Javascript:window.location = viewuser2.asp?id=%=rs(id)% td width=20% align=center%=rs(id)%/td td width=20% align=center%=rs(user_number)%/td td width=20% align=center%=rs(user_name)%/td td width=20% align=center%=rs(user_sex)%/td td width=20% align=center%=rs(user_class)%/td /tr %rs.movenext% %loop% %else% tr td width=100% colspan=5marquee没有您所查找的学生/marquee/td /tr %end if% /table /center /div % rs.close set rs=nothing % 数字查询 % set rs=server.createobject(adodb.recordset) sql=select * from st_info where user_number like user_number（精确查询） rs.open sql,conn,1,1 % 高级查询 % dim user_testnumber,subject,testno user_testnumber=trim(request(user_testnumber)) subject=trim(request(subject)) testno=t