t1=request.form(\ t2=request.form(\ t3=request.form(\ t4=request.form(\
sql=\* from teacher where t_name='\ or t_no='\or t_sex='\ or t_duty='\
set rs=cn.execute(sql) %>
无标题文档
您要找的教师资料如下：
<%
response.write\ for i=0 to rs.fields.count-1
response.write \ next
response.write\ while not rs.eof
response.write\
for i=0 to rs.fields.count-1
response.write \ next
response.write\ rs.movenext wend
response.write\ rs.close %>
6．成绩查询系统：
这个子系统的后台数据库为teachdb中的表choice。输入学号，能查询该学生所选修的各门课程的成绩；输入课程号，可以查询该门课程都有哪些人选并且能显示成绩是多少。运行过程和运行结果如图8-39和图8-40所示。
cjcx.asp //cjcx.asp
<%@ LANGUAGE=\
无标题文档
请输入您的查询条件(下列条件之一）
cjcxcheck.asp //cjcxcheck.asp
<%@ LANGUAGE=\<%
set cn=server.createobject(\cn.provider=\
yyy=\cn.open yyy
set rs=server.CreateObject(\ t1=request.form(\ t2=request.form(\
sql=\ or c_no='\ set rs=cn.execute(sql) %>
无标题文档
您要找的资料如下：
<%
response.write\ for i=0 to rs.fields.count-1
response.write \ next
response.write\ while not rs.eof
response.write\
for i=0 to rs.fields.count-1
response.write \ next
response.write\ rs.movenext wend
response.write\ rs.close %>