jsquery.asp

实训的小作品 关于后台SQL知识的 简单制作！

<!--#include file="../data/const.asp"-->
<% session("jsstr")="" %>
<!--#include virtual="../header.asp" -->
<br>
<table border="0" align="center" width="98%">
  <tr>
    <td>您当前的位置：教师->教师信息查询</td>
  </tr>
</table>

<form name="form2" method="post" action="jsquery1.asp?que=0">  
  <table width="60%" border="0" align="center">
    <tr>
	  <td colspan="2" align="center"><hr size="0" width="80%"></td>
	</tr>
	<tr> 
      <td width="30%" align="right">系所:<input type="checkbox" name="xsmchk"></td>
      <td width="70%">
	    <select name="xdxsm">
        <%  str="select 编号,名称,学院简称 from 系部信息表视图 order by 编号"
            set rs=dbconn.Execute(str)
            do while not rs.eof 
        %>
       <option value="<%=rs("编号")%>"><%=rs("学院简称")%><%=rs("名称")%></option>
        <%  rs.movenext
            loop
        %>
        </select>
	  </td>
    </tr>
    <tr> 
      <td align="right">职称:<input type="checkbox" name="zcchk"></td> 
      <td>
		<select name="zc">
        <% str="select distinct 职称 from 教师信息表"
           set rs=dbconn.Execute(str)
           do while not rs.eof 
        %>
        <option value="<%=rs("职称")%>"><%=rs("职称")%></option>
      <% rs.movenext
           loop
        %>
        </select>
	  </td>
    </tr>
    <tr> 
      <td align="right">学历:<input type="checkbox" name="xlchk"></td> 
      <td>
		<select name="xl">
        <% str="select distinct 学历 from 教师信息表"
           set rs=dbconn.Execute(str)
           do while not rs.eof 
        %>
        <option value="<%=rs("学历")%>"><%=rs("学历")%></option>
        <% rs.movenext
           loop
        %>
        </select>
	  </td>
    </tr>
    <tr> 
      <td align="right">性别:<input type="checkbox" name="xbchk"></td>
      <td> 
        <select name="xb">
          <option>男</option>
          <option>女</option>
        </select>
      </td>
    </tr>
    <tr> 
      <td align="right">年龄:<input type="checkbox" name="nlchk"></td>
      <td><input type="text" name="nl1" size=10>&nbsp;到&nbsp;<input type="text" name="nl2" size=10>
      </td>
    </tr>
	<tr>
	  <td colspan="2" align="center"><hr size="0" width="80%"></td>
	</tr>
	<tr>
	  <td colspan="2" align="center">
	    <input type="submit" name="Submit2" value="  查询  ">&nbsp;&nbsp;<input type="reset" name="Submit" value="  重置  ">
	  </td>
	</tr>    
  </table>
</form>  
<br>
<!--#include virtual="../footer.asp" -->