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

📄 shenqing2.asp

📁 asp+sql的教室申请系统,可以完成一个学期的教室分配情况
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/CSYD.asp" -->
<!--#include file="Function.asp" -->
<%
Dim KBID
KBID = "1"
If (Request.Form("KBID") <> "") Then 
  KBID = Request.Form("KBID")
End If
%>
<%
Dim rs
Dim rs_numRows

Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_CSYD_STRING
rs.Source = "SELECT Top 1 * FROM CS_SQInfo ORDER BY ID DESC"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 3
rs.Open()

rs_numRows = 0
%>
<%
Dim sq_bumen
Dim sq_xingming
Dim sq_changsuo
Dim sq_danwei
Dim sq_day
Dim sq_week
Dim sq_neirong
Dim sq_yaoqiu
Dim ID
Dim ranNum

ID=rs("ID")+1
sq_bumen=request.Form("sq_bumen")
sq_xingming=request.Form("sq_xingming")
sq_changsuo=request.Form("sq_changsuo")
sq_danwei=request.Form("sq_danwei")
sq_day=request.Form("sq_day")
sq_week=request.Form("sq_week")
sq_neirong=request.Form("sq_neirong")
sq_yaoqiu=request.Form("sq_yaoqiu")
zhouci=request.Form("zhouci")

rs.addnew()
rs("ID")=ID
rs("KBID")=KBID
rs("zhouci")=zhouci
rs("sq_bumen")=sq_bumen
rs("sq_xingming")=sq_xingming
rs("sq_changsuo")=sq_changsuo
rs("sq_danwei")=sq_danwei
rs("sq_day")=sq_day
rs("sq_week")=sq_week
rs("sq_neirong")=sq_neirong
rs("sq_yaoqiu")=sq_yaoqiu
rs("sq_date")=Now()
rs("flag")=0
rs("IP")=Request.ServerVariables("LOCAL_ADDR")
rs("usetime")=Request.Form("usetime")
rs.update

%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
	background-image: url(images/002_03.gif);
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style></head>

<body>
<table width="376" border="0" cellspacing="0" cellpadding="0">
<form name="form1" method="post" action="shenqing2.asp">
  <tr>
    <td bgcolor="#999999">
      <table width="376" height="190"  border="0" align="center" cellpadding="0" cellspacing="1">
        <tr bgcolor="#F0F7F0">
          <td><div align="center">
            <p>恭喜!<%=UpdateKBiao(KBID,sq_week,sq_day,ID)%></p>
            <p>申请成功,我们将尽快给你答复!</p>
          </div></td>
          </tr>
      </table>
    </td>
  </tr>
  </form>
</table>
</body>
</html>
<%
rs.Close()
Set rs = Nothing
%>

⌨️ 快捷键说明

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