ϵͳҪһļһݿɣ

1ݿ⣨Accessݿ⣩
   ݿļDiaoCha.mdb
   ڲtableDiaoCha
   ֶ item      >   Ŀ
                     score     >   ĿƱ

2ļDiaoCha.ASP)
   ´뿽ҳĶɵôļ

 <form name='DiaoCha' action='diaocha/DiaoCha.asp?item=ΪASPѧ' method=post>
  <div align=center>
    <font color=#FF1800  style="font-size:11pt;font-weight:600">
      ΪASPѧ
    </font>
  </div>
  <table width=180 cellspacing=1 bgcolor='#FFC752' align=center><tr bgcolor='#42A6FF'><td>
  <%
   Set cnn=Server.CreateObject("ADODB.Connection")
   Set rst=Server.CreateObject("ADODB.Recordset")
   cnn.ConnectionString="Driver={Microsoft Access Driver (*.mdb)};Uid=;Pwd=;DBQ=" & Server.MapPath("diaocha/DiaoCha.mdb")
   cnn.Open
   rst.Open "SELECT * FROM DiaoCha",cnn,3,3
   dim n
   for n=1 to rst.RecordCount
     response.Write "<input type=radio name='opt' value='" & rst.Fields("item") & "'>" & rst.Fields("item") & "<br>"
     rst.MoveNext
   next

   rst.Close: cnn.Close
   set rst=nothing: set cnn=nothing
  %>
   <script language='javascript'>
    document.DiaoCha.opt(0).checked=true
   </script> 

  </td></tr>
  <tr bgcolor='#7371FF' height=28 align=center><td>
    <input type=submit name='ok' value='Ͷ Ʊ'>&nbsp;&nbsp;&nbsp;
    <input type=submit name='ok' value=' '>
  </td></tr>
  <table>
 </form>

   ļ˵
       עĶݿ·
