⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 admin_edituser.asp

📁 25175成绩查询管理系统 v2.8beta2 完整功能: 1.成绩管理 2.课程管理 3.学生管理 4.添加 修改 删除系统管理员 5.添加班级及其学号对应代码,修改删除班级 6.学生直
💻 ASP
📖 第 1 页 / 共 2 页
字号:
        <option value="2005" <%if souty="2005" then response.write"selected"%>>2005</option>
        <option value="2006" <%if souty="2006" then response.write"selected"%>>2006</option>
        <option value="2007" <%if souty="2007" then response.write"selected"%>>2007</option>
        <option value="2008" <%if souty="2008" then response.write"selected"%>>2008</option>
        <option value="2009" <%if souty="2009" then response.write"selected"%>>2009</option>
        <option value="2010" <%if souty="2010" then response.write"selected"%>>2010</option>
        <option value="2011" <%if souty="2011" then response.write"selected"%>>2011</option>
        <option value="2012" <%if souty="2012" then response.write"selected"%>>2012</option>
        <option value="2013" <%if souty="2013" then response.write"selected"%>>2013</option>
        <option value="2014" <%if souty="2014" then response.write"selected"%>>2014</option>
        <option value="2015" <%if souty="2015" then response.write"selected"%>>2015</option>
      </select>
<select name="soutm" id="select4">
  <option value="1" <%if soutm="1" then response.write"selected"%>>1</option>
  <option value="2" <%if soutm="2" then response.write"selected"%>>2</option>
  <option value="3" <%if soutm="3" then response.write"selected"%>>3</option>
  <option value="4" <%if soutm="4" then response.write"selected"%>>4</option>
  <option value="5" <%if soutm="5" then response.write"selected"%>>5</option>
  <option value="6" <%if soutm="6" then response.write"selected"%>>6</option>
  <option value="7" <%if soutm="7" then response.write"selected"%>>7</option>
  <option value="8" <%if soutm="8" then response.write"selected"%>>8</option>
  <option value="9" <%if soutm="9" then response.write"selected"%>>9</option>
  <option value="10" <%if soutm="10" then response.write"selected"%>>10</option>
  <option value="11" <%if soutm="11" then response.write"selected"%>>11</option>
  <option value="12" <%if soutm="12" then response.write"selected"%>>12</option>
</select>
月</td>
    </tr>
    <tr>
      <td>状态</td>
      <td><select name="states" id="states">
        <option value="在读" <%if rs("states")="在读" then response.write"selected"%>>在读</option>
        <option value="离校" <%if rs("states")="离校" then response.write"selected"%>>离校</option>
        <option value="退学" <%if rs("states")="退学" then response.write"selected"%>>退学</option>
        <option value="毕业" <%if rs("states")="毕业" then response.write"selected"%>>毕业</option>
      </select></td>
      <td>退学</td>
      <td><select name="scancely" id="scancely">
        <option value="2002" <%if scancely="2002" then response.write"selected"%>>2002</option>
        <option value="2003" <%if scancely="2003" then response.write"selected"%>>2003</option>
        <option value="2004" <%if scancely="2004" then response.write"selected"%>>2004</option>
        <option value="2005" <%if scancely="2005" then response.write"selected"%>>2005</option>
        <option value="2006" <%if scancely="2006" then response.write"selected"%>>2006</option>
        <option value="2007" <%if scancely="2007" then response.write"selected"%>>2007</option>
        <option value="2008" <%if scancely="2008" then response.write"selected"%>>2008</option>
        <option value="2009" <%if scancely="2009" then response.write"selected"%>>2009</option>
        <option value="2010" <%if scancely="2010" then response.write"selected"%>>2010</option>
        <option value="2011" <%if scancely="2011" then response.write"selected"%>>2011</option>
        <option value="2012" <%if scancely="2012" then response.write"selected"%>>2012</option>
        <option value="2013" <%if scancely="2013" then response.write"selected"%>>2013</option>
        <option value="2014" <%if scancely="2014" then response.write"selected"%>>2014</option>
        <option value="2015" <%if scancely="2015" then response.write"selected"%>>2015</option>
      </select>
<select name="scancelm" id="select5">
  <option value="1" <%if scancelm="1" then response.write"selected"%>>1</option>
  <option value="2" <%if scancelm="2" then response.write"selected"%>>2</option>
  <option value="3" <%if scancelm="3" then response.write"selected"%>>3</option>
  <option value="4" <%if scancelm="4" then response.write"selected"%>>4</option>
  <option value="5" <%if scancelm="5" then response.write"selected"%>>5</option>
  <option value="6" <%if scancelm="6" then response.write"selected"%>>6</option>
  <option value="7" <%if scancelm="7" then response.write"selected"%>>7</option>
  <option value="8" <%if scancelm="8" then response.write"selected"%>>8</option>
  <option value="9" <%if scancelm="9" then response.write"selected"%>>9</option>
  <option value="10" <%if scancelm="10" then response.write"selected"%>>10</option>
  <option value="11" <%if scancelm="11" then response.write"selected"%>>11</option>
  <option value="12" <%if scancelm="12" then response.write"selected"%>>12</option>
</select>
月</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td height="100" colspan="4" valign="bottom"><div align="center">
        <p>若状态为 在读 或 毕业,则忽略 离校 和 退学 时间   </p>
        <p>
          <input type="submit" name="Submit3" value="编辑">
          <input type="reset" name="Submit5" value="重置">
          <input type="button" name="Submit4" value="返回" onClick="javascript:history.go(-1)">
        </p>
      </div></td>
      </tr>
  </table>
</form>
<%	  
          end if
		  set rs=nothing
	  end sub
	  
	  sub save()
	      dim password,sname,sex,cla_id,states,scome,sout,scancel
		  password=request.form("password")
		  sname=replace(trim(request.form("sname")),"'","")
		  sex=request.form("sex")
		  cla_id=request.form("cla_id")
		  states=request.form("states")
		  scome=request.form("scomey")&"-"&request.form("scomem")
		  sout=request.form("souty")&"-"&request.form("soutm")
		  scancel=request.form("scancely")&"-"&request.form("scancelm")
		  if sname="" then
		      founderr="true"
			  errmsg="<li>请输入姓名"
		  end if
		  if sex="" then
		      founderr="true"
			  errmsg="<li>请选择性别"
		  end if
		  if cla_id="" then
		      founderr="true"
			  errmsg=errmsg&"<li>请选择所属班级"
		  end if
		  if states="" then
		      founderr="true"
			  errmsg=errmsg&"<li>请选择状态"
		  end if
		  if isdate(scome)=false then
		      founderr="true"
			  errmsg=errmsg&"<li>请选择入学年月"
		  end if
		  if isdate(sout)=false then
		      founderr="true"
			  errmsg=errmsg&"<li>请选择离校年月"
		  end if
		  if isdate(scancel)=false then
		      founderr="true"
			  errmsg=errmsg&"<li>请选择退学年月"
		  end if
		  
		  if founderr="true" then
		      call errormsg()
		  else
		      if password="" then
			      password=" "
			  else
			      password=" password='"&md5(password)&"', "
			  end if
		      conn.execute("update student set "&password&" sname='"&sname&"',sex='"&sex&"',cla_id="&cla_id&",states='"&states&"',scome='"&scome&"',sout='"&sout&"',scancel='"&scancel&"' where sid="&request("id")&"")
              response.write "<script language=JavaScript>" & chr(13) & "alert('编辑学生资料成功');"&"window.location.href = '?action=edit&id="&request("id")&"'"&" </script>"
		  end if
	  end sub
	  
	  sub del()
	      conn.execute("delete from student where sid="&request("id")&"")
          response.write "<script language=JavaScript>" & chr(13) & "alert('删除一个学生成功');"&"window.location.href = 'admin_user.asp'"&" </script>"
	  end sub
  end if
%></td>
                  </tr>
                  <tr>
                    <td height="25"><div align="center"></div></td>
                  </tr>
                </table></td>
              </tr>
              <tr>
                <td><img src="images/index_78.gif" alt="" width="620" height="24"></td>
              </tr>
            </table></td>
            <td width="43"><img src="images/index_22.gif" width="43" height="579" alt=""></td>
          </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table></td>
      </tr>
      <tr>
        <td><!--#include file="bottom.asp" -->
</td>
      </tr>
    </table></td>
  </tr>
</table>
<!-- End ImageReady Slices -->
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -