| | | 姓名 | 班级 | 性别 | 联系电话 | 籍贯 | 民族 | 特长 | 来源学校 | 操 作 | <% if action="ok" then %> <%set rsstudent=server.createobject("adodb.recordset") if keyword="" then response.redirect "admin_xxcx.asp" end if if typeid="" then sqlstudent="select * from student where name like '%"&keyword&"%' order by adid desc" end if if typeid="1" then sqlstudent="select * from student where name like '%"&keyword&"%' order by adid desc" end if if typeid="2" then sqlstudent="select * from student where class like '%"&keyword&"%' order by adid desc" end if if typeid="3" then sqlstudent="select * from student where spcialty like '%"&keyword&"%' order by adid desc" end if if typeid="4" then sqlstudent="select * from student where Source_school like '%"&keyword&"%' order by adid desc" end if if typeid="5" then sqlstudent="select * from student where sex like '%"&keyword&"%' order by adid desc" end if if typeid="6" then sqlstudent="select * from student where Native_place like '%"&keyword&"%' order by adid desc" end if if typeid="7" then sqlstudent="select * from student where nation like '%"&keyword&"%' order by adid desc" end if if typeid="8" then sqlstudent="select * from student where father_name like '%"&keyword&"%' order by adid desc" end if if typeid="9" then sqlstudent="select * from student where mother_name like '%"&keyword&"%' order by adid desc" end if if typeid="10" then sqlstudent="select * from student where Population_property like '%"&keyword&"%' order by adid desc" end if if typeid="11" then sqlstudent="select * from student where name2 like '%"&keyword&"%' order by adid desc" end if if typeid="12" then sqlstudent="select * from student where status_number like '%"&keyword&"%' order by adid desc" end if if typeid="13" then sqlstudent="select * from student where Political_feature like '%"&keyword&"%' order by adid desc" end if if typeid="14" then sqlstudent="select * from student where adnumber like '%"&keyword&"%' order by adid desc" end if if typeid="15" then sqlstudent="select * from student where status_number like '%"&keyword&"%' order by adid desc" end if if typeid="16" then sqlstudent="select * from student where tele like '%"&keyword&"%' order by adid desc" end if if typeid="17" then sqlstudent="select * from student where Population_property like '%"&keyword&"%' order by adid desc" end if if typeid="18" then sqlstudent="select * from student where nowaddress like '%"&keyword&"%' order by adid desc" end if if typeid="19" then sqlstudent="select * from student where Address like '%"&keyword&"%' order by adid desc" end if if typeid="20" then sqlstudent="select * from student where mother_work like '%"&keyword&"%' order by adid desc" end if if typeid="21" then sqlstudent="select * from student where father_work like '%"&keyword&"%' order by adid desc" end if if typeid="22" then sqlstudent="select * from student where admin like '%"&keyword&"%' order by adid desc" end if if typeid="23" then sqlstudent="select * from student where change like '%"&keyword&"%' order by adid desc" end if rsstudent.open sqlstudent,conn,1,1%> <%if rsstudent.eof and rsstudent.bof then%> <%response.write ""%> <%else%> <%do while not rsstudent.eof or rsstudent.bof %> | <%=rsstudent("name")%> | <%=rsstudent("class")%> | <%=rsstudent("sex")%> | <%=rsstudent("tele")%> | <%=rsstudent("Native_place")%> | <%=rsstudent("nation")%> | <%=rsstudent("spcialty")%> | <%=rsstudent("Source_school")%> | ">详 细 | <% rsstudent.movenext %> <%loop%> <% rsstudent.close set rsstudent = nothing %> <%end if%> <%end if%> |
Copyright