文档介绍：该【【教师管理操作流程】 】是由【zhangkuan1436】上传分享，文档一共【9】页，该文档可以免费在线阅读，需要了解更多关于【【教师管理操作流程】 】的内容，可以使用淘豆网的站内搜索功能，选择自己适合的文档，以下文字是截取该文章内的部分文字，如需要获得完整电子版，请下载此文档到您的设备，方便您编辑和打印。教师管理操作流程
使用Teaacherr账号登陆陆——教师管管理系统
代码区域::
if(lloginnTypee=="教师")
{{
sstrinngsqql=("sselecctcoount((*)ffromteaccherwherreLooginIId='{{0}'ANDLogiinPwdd='{11}'",,logginIdd,looginPPwd);;
ttry
{{
SSqlCoommanndcoommannd=newSqlCCommaand(ssql,));
DDBHellper..(();
ccountt=((int)();
iif(ccountt==1)
{{
iisVallidUsser==truue;
}}
eelse
{{
iindexx++;
iif(iindexx<=3)
{{
mmessaage=="用户名或或密码不存存在!";
}}
eelseif(iindexx>=3)
{{
(();
}}
iisVallidUsser==fallse;
}}
}}
ccatchh(Excceptiioneex)
{{
mmessaage==ex..Messsage;;
(ex..Messsage));
}}
查询修改信信息
查询教师基基本信息((代码区域域:)
TTeachherBaaseFoormtteachherBaaseFoorm==newwTeaccherBBaseFForm(();
(();
TeachherBaaseFoorm(教师基本信信息窗体)
查询及修改改学生信息息(代码区区域:)
UUpdatteStuudenttFormmupddateSStudeentFoorm==newwUpdaateSttudenntForrm();;
();;
(查询及修修改信息窗窗体)
AddSccoreFForm(学生成绩绩录入窗体体)
录入按钮代代码:
strinngsqql=("sselecctSttudenntId,,StuddentNNo,SttudenntNammefrromSStudeentwwhereeStuudenttId=''{0}''",);
ttry
{{
SSqlCoommanndcoommannd=newSqlCCommaand(ssql,));
..Openn();
SSqlDaataReeaderrreaader=(();
wwhilee(()))
{{
iid=(intt)reaader[["StuudenttId"]];
nno=(strring))readder[""StuddentNNo"];;
nname=(sstrinng)reeaderr["SttudenntNamme"];;
}}
(();
}}
ccatchh(Excceptiioneex)
{{
();
}}
ffinallly
{{
DDBHellper..();
}}
iif(TTianJJia()))
{{
iif(===(idd)&&&===noo&&==nname))
{{
sstrinngsttudenntNamme=;;
sstrinngsddudenntNo=;;
sstrinngsuubjecct=;;
sstrinngsccore=;;
iintcclasssId==GettClasssId(();
sstrinngsttudenntId=txxtId..Textt;
sstrinngsqql1==strring..Formmat(""inseertiintoScorre(SttudenntNo,,Subjject,,SScoore,SSNamee,ClaassIdd,StuudenttId)vvaluees('{{0}',,'{1
}}','{{2}',,'{3}}','{{4}',,{5}))",ssdudeentNoo,suubjecct,sscoree,sttudenntNamme,cclasssId,studdentIId);
ttry
{{
SSqlCoommanndcoommannd=newSqlCCommaand(ssql1,,);
DDBHellper..(();
iintrresullt=commmand..ExeccuteNNonQuuery(();
iif(rresullt!==1)
{{
(""添加失败败","输入提示示",,);
}}
eelse
{{
(""添加成功功","输入提示示",,);
}}
}}
ccatchh(Excceptiioneex)
{{
//("操操作数据库库出错!"","输输入提示"",MeessaggeBoxxButttons..OK,);;
///();
();
}}
ffinallly
{{
DDBHellper..();
}}
}}
eelse
{{
(""您输入的的学生在数数据库中没没有,请重重新输入"","输入提示示",,));
}}
}}
}}
pprivaatevoiddAdddScorreForrm_Looad(oobjecctseenderr,EvventAArgse)
{{
sstrinngsqql="sellectgraddeNammefrromGGradee";
ttry
{{
SSqlCoommanndcoommannd=newSqlCCommaand(ssql,));
DDBHellper..(();
SSqlDaataReeaderrreaader=(();
wwhilee(()))
{{
sstrinnggrradeNName=(sstrinng)reeaderr[0];;
ccboGrrade..(grradeNName));
}}
(();
}}
ccatchh(Excceptiioneex)
{{
();
}}
ffinallly
{{
DDBHellper..();
}}
sstrinngsqql1=="seelecttSubbjecttNameefroomSuubjecct";
ttry
{{
SSqlCoommanndcoommannd=newSqlCCommaand(ssql1,,);
DDBHellper..(();
SSqlDaataReeaderrreaader=(();
wwhilee(()))
{{
sstrinngsuubNamme=(strring))readder[00];
..Add((subNName));
}}
(();
}}
ccatchh(Excceptiioneex)
{{
();
}}
ffinallly
{{
DDBHellper..();
}}
}}
pprivaatevoiddcbooGradde_SeelecttedInndexCChangged(oobjecctseenderr,EvventAArgse)
{{
iif(ccboGrrade..()!=""")
{{
iintggradeeId==-1;;
sstrinngsqql=("sselecctGrradeIIdfrromGGradeewheereGGradeeNamee='{00}'",,);;
SSqlCoommanndcoommannd=newSqlCCommaand(ssql,));
ttry
{{
DDBHellper..(();
SSqlDaataReeaderrreaader=(();
iif(()))
{{
ggradeeId==(innt)reeaderr[0];;
}}
(();
}}
ccatchh(Excceptiioneex)
{{
(""操作数据据库出错"");
(ex..Messsage));
}}
ffinallly
{{
DDBHellper..();
}}
ssql=="SEELECTTClaassNaameFFROMClasssWHHEREGraddeId=="+grradeIId;
==sqll;
ttry
{{
DDBHellper..(();
SSqlDaataReeaderrreaader=(();
sstrinngcllassNName=""";
ccboCllass..(();
wwhilee(()))
{{
cclasssNamee=((striing)rreadeer["CClasssNamee"];
ccboCllass..(cllassNName));
}}
(();
}}
ccatchh(Excceptiioneex)
{{
(""操作数据据库出错"");
(ex..Messsage));
}}
ffinallly
{{
DDBHellper..();
}}
}}
}}
pprivaatevoiddtxttId_TTextCChangged(oobjecctseenderr,EvventAArgse)
{{
}}
UpdatteScooreFoorm(更新成绩绩窗体)
保存按钮代代码:
DialoogRessultresuult==MesssageeBox..Showw("确实要将修修改保存到到数据库吗吗?","输入提示示",,);
iif(rresullt===)
{{
SSqlCoommanndBuiilderrbuiilderr=nnewSqlCCommaandBuuildeer(daataAddapteer);
(daataSeet,""Scorre");;
(""保存成功功","输入提示示",,);
}}
eelse
{{
(""保存失败败","输入提示示",,);
}}