inf_modify_student.asp

一个修改过的ASP学籍管理系统,用javascript+ado写的

          <td width="712" height="20"><input size=12 name="Class" id="Class" value="<%=StudentRs("classId")%>">          
            <font size="2" color="#FF0000">请仔细填写（只写入班级号码）</font></td>            
        </tr>                       
       <tr>            
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">培养方式：</font></div></td>            
          <td width="712" height="20">          
		  <select name="Plant" id="Plant">
          	<%if(StudentRs("peiyangfs")=="非定向")%>
    		  <option value="非定向" selected="selected">非定向</option>          
		  	  <option value="定向">定向</option>   
            <%else if(StudentRs("peiyangfs")=="定向"){%> 
            	<option value="非定向">非定向</option>          
		  	    <option value="定向" selected="selected">定向</option> 
            <%}else{%> 
            	<option value="非定向">非定向</option>          
		  	    <option value="定向" selected="selected">定向</option> 
            <%}%>     
		  </select>          
		  </td>            
        </tr>            
        <tr>            
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">学制：</font></div></td>            
          <td width="712" height="20">          
		  <select name="Order" id="Order">          
		  <option value="3年" selected>3年</option>
		  <option value="4年">4年</option>
		  <option value="5年">5年</option>
		  <option value="2年半">2年半</option>
		  <option value="2年">2年</option>
		  </select>
		  <%Response.Write("<font size='2' color='#000000'>原值为："+StudentRs("xuezhi")+"</font>");%>
		  </td>  
        </tr>  
        <tr>  
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">入学年份：</font></div></td>  
          <td width="712" height="20"><input size=12 name="Intime" id="Intime" value="<%=StudentRs("ruxuenianfen")%>">
            <font size="2" color="#FF0000">请仔细填写，只须写入年份，如：&nbsp;           
            2004</font></td>           
        </tr>           
        <tr>           
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">学历：</font></div></td>           
          <td width="712" height="20">          
		  <select name="Grade" id="Grade">          
		  <option value="本科" selected>本科</option>          
		  <option value="大专">大专</option>          
		  <option value="高职">高职</option>          
		  <option value="硕士">硕士</option>          
		  <option value="博士">博士</option>          
		  <option value="博士后">博士后</option>          
		  </select>
		  <%Response.Write("<font size='2' color='#000000'>原值为："+StudentRs("xueli")+"</font>");%>
		  </td>           
        </tr>           
        <tr>           
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">外语语种：</font></div></td>           
          <td width="712" height="20"><input size=12 name="Foregin" id="Foregin" value="<%=StudentRs("waiyu")%>"></td>           
        </tr>           
        <tr>           
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">外语水平：</font></div></td>           
          <td width="712" height="20"><input size=12 name="Foregingrade" id="Foregingrade" value="<%=StudentRs("waiyushuiping")%>"></td>           
        </tr>           
        <tr>           
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">身体状况：</font></div></td>           
          <td width="712" height="20"><input size=12 name="Health" id="Health" value="<%=StudentRs("shentizz")%>"></td>           
        </tr>           
        <tr>           
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">在读情况：</font></div></td>           
          <td width="712" height="20">
		  <select name="Reading" id="Reading">
		  <option value="在读" selected>在读</option>
		  <option value="毕业">毕业</option>
		  </select>
		  <%Response.Write("<font size='2' color='#000000'>原值为："+StudentRs("zaiduqk")+"</font>");%>
		  </td>           
        </tr>           
        <tr>           
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">家庭住址：</font></div></td>           
          <td width="712" height="20"><input size=40 name="Address" id="Address" value="<%=StudentRs("address")%>"></td>           
        </tr>           
        <tr>           
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">联系电话：</font></div></td>           
          <td width="712" height="20"><input size=20 name="Telephone" id="Telephone" value="<%=StudentRs("phoneNum")%>"></td>           
        </tr>           
        <tr>           
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">EMAIL：</font></div></td>           
          <td width="712" height="20"><input size=40 name="Email" id="Email" value="<%=StudentRs("email")%>"></td>           
        </tr>           
        <tr>           
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">个人主页：</font></div></td>           
          <td width="712" height="20"><input size=40 name="Personalpage" id="Personalpage" value="<%=StudentRs("homepage")%>"></td>           
        </tr>           
        <tr>           
          <td width="288" height="100"><div align=center><font size="2" color="#FF0000">大学期间奖惩情况：</font></div></td>           
          <td width="712" height="100">
		  <textarea rows="10" cols="50" name="Text" id="Text" wrap="off">
		  <%=StudentRs("huojiangqk")%>
		  </textarea>
		  </td>           
        </tr>           
        <tr>           
          <td width="1000" height="20" colspan="2"><div align=center><div align=center><input type=submit value=提交 onClick="return SubmitTest()"></div></td>           
        </tr>           
    </table>           
    </form>
    <%
	    }
    else
	   {
	      Response.Write("<div algin=center><font size='6' color='#ff0000'>数据库发生错误，数据无法提取！</font></div>");
	   }		
	%>
	</td>
    <td width="20" rowspan="27" height="540"></td>
  </tr>
  <tr>
    <td width="80" background="images/bar1.gif" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="760" height="20" background="images/bar.gif" colspan="7"></td>
  </tr>
  <tr>
    <td width="760" height="20" colspan="7"></td>
  </tr>
</table>
<%
StuCol.Close();
StuPro.Close();
StudentRs.Close();
Conn.Close();
StuCol=null;
StuPro=null
StudentRs=null;
Conn=null;
%>
</body>
</html>