簡(jiǎn)單學(xué)生校運(yùn)會(huì)成績(jī)管理系統(tǒng).doc

SQL數(shù)據(jù)庫(kù):use mastercreate database pkxgouse pkxcreate table bjxxb( /* 班級(jí)信息表 */bjbhchar(6) not null PRIMARY KEY , /*班級(jí)編號(hào)*/bjmcvarchar(64) not null, /*班級(jí)名稱(chēng)*/bjyxvarchar(64) not null, /*院系*/bjnjdatetime not null,/*年級(jí)*/bjbzchar(10),/* 班長(zhǎng) */bjxwchar(10),/* 學(xué)習(xí)委員 */)create table xsxxb( /* 選手信息表 */xsbhchar(10) not null PRIMARY KEY , /*選手編號(hào)*/bjbhchar(6) not null, /*班級(jí)編號(hào)*/xmvarchar(64) not null, /*姓名*/xbchar(2) not null,/*性別*/csrqdatetime,/*生日*/sfzhchar(20),/* 身份證號(hào) */rxrqdatetime,/* 入學(xué)日期 */)create table kcxxb ( /* 項(xiàng)目信息表 */kcbhchar(10) not null PRIMARY KEY , /*項(xiàng)目編號(hào)*/kcmcvarchar(64) not null, /*項(xiàng)目名稱(chēng)*/kcxffloat, /*項(xiàng)目學(xué)分*/rklschar(10), /*任課老師*/lsyxvarchar(64), /*任課老師院系*/)create table cjdjb ( /* 成績(jī)登記表 */xsbhchar(10) not null, /*學(xué)生編號(hào)*/kcbhchar(10) not null, /*項(xiàng)目編號(hào)*/kccjfloat,/*項(xiàng)目成績(jī)*/bkcjfloat,/*補(bǔ)賽成績(jī)*/)create index cjdjidx01 on cjdjb ( xsbh)insert into bjxxb values(090101,D09通信班,計(jì)算機(jī)工程系,2009-09-03,09010108,09010117)insert into bjxxb values(090102,D09平面設(shè)計(jì)（1）班,計(jì)算機(jī)工程系,2009-09-03,09010208,09010217)insert into bjxxb values(090103,D09平面設(shè)計(jì)（2）班,計(jì)算機(jī)工程系,2009-09-03,09010208,09010217)insert into xsxxb values(09010108,090101,張班長(zhǎng),男,1995-9-12009-9-3)insert into xsxxb values(09010117,090101,李學(xué)委,女,1996-7-32009-9-3)insert into xsxxb values(09010208,090101,何班長(zhǎng),男,1995-9-12009-9-3)insert into xsxxb values(09010217,090101,王學(xué)委,女,1996-7-32009-9-3)insert into xsxxb values(09010308,090101,劉班長(zhǎng),男,1995-9-12009-9-3)insert into xsxxb values(09010317,090101,鐘學(xué)委,女,1996-7-32009-9-3)insert into kcxxb values(010001,跳遠(yuǎn),3.5,麥三,計(jì)算機(jī)工程系)insert into kcxxb values(010002,跳高,4,何四,計(jì)算機(jī)工程系)insert into kcxxb values(010003,長(zhǎng)跑,2.5,蔣五,機(jī)電信息系)insert into cjdjb values(09010108,010001,87,0)insert into cjdjb values(09010117,010001,95,0)insert into cjdjb values(09010208,010002,87,0)insert into cjdjb values(09010217,010002,95,0)insert into cjdjb values(09010308,010003,87,0)insert into cjdjb values(09010317,010003,95,0)use mastergoindex.html學(xué)生校運(yùn)會(huì)成績(jī)管理系統(tǒng) 歡迎您使用簡(jiǎn)陋版學(xué)生校運(yùn)會(huì)成績(jī)管理系統(tǒng)！ 請(qǐng)選擇以下功能： 輸入選手項(xiàng)目信息 顯示所有選手項(xiàng)目記錄 CopyRight 2011pkx-版權(quán)所有，盜版必究！   input.asp輸入選手項(xiàng)目信息歡迎進(jìn)入選手項(xiàng)目管理 選手編號(hào): option value=name=xsbh 項(xiàng)目編號(hào):option value=name=kcbh 項(xiàng)目成績(jī): %if request.form(xsbh) thenset mycmd=server.createobject(ADODB.Command)set mycmd.activeconnection=mandtype=adCMDTextmycmd.execute()mandtext=insert into cjdjb values ( & request.form(xsbh) & ,_& request.form(kcbh) & , & request.form(kccj)& ,0)mycmd.execute()end ifconn.close% 主頁(yè) CopyRight 2011pkx-版權(quán)所有，盜版必究！   %if request.form(xsbh) = then response.writealert(數(shù)據(jù)無(wú)效，請(qǐng)重新輸入選手項(xiàng)目信息！); response.endelse r