欢迎来到天天文库
浏览记录
ID:44661203
大小:343.55 KB
页数:9页
时间:2019-10-24
《课程信息管理》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、1课程信息管理lession.jsp="tabLeBorder^BM>T^^S^32、H/manage/Lesson.jsp"/>3、H/>4■•w5/publicclassLessonFormextendsAc4、tionForm{privateDatejoinTime;privateStringname;privateintID;privateString[]delIdArray=newSt广ing[0];publicDategetJoinTime(){returnjoinTime;}publicvoidsetJoinTime(DatejoinTime){this.joinTimw=joinTime;6lessiondao完成以下代码^importcom.wgh・actionForm・LessonForm;二pub5、licclassLessonDAO{privateConnDBcorm=newConnDB();//添加数据bpublicintinsert(LessonFormlessonForm){□6、//查询方法bpublicListquwry(intid){□//查询方法dpublicListquery(StringstudentID){□//删除数据bpublicintdelete(LessonFormlessonForm){□参考代码•••■■■■••••••••■夕£//添加嘶0127、publicintins8、ert(LessonForTnlessonFo广m){Stringsqll二"SELECT*FROMtb_lessonWHEREname='M+lessonForm.getName()+M1M;ResultSetrs=conn.executeQuery(sqll);Stringsql=MM;intfalg=0;if(rs.next()){falg=2;}else{sql=MINSERTINTOtb_lesson(name)values(1M+lessonForm.getName()+falg=conn.ex9、ecutQUpdatQ(sql);System.out.printIn(8B1的SQL."+sql);conn・close();}}catch(Exceptionex){falg=0;}returnfalg;//删除数据publicintdelete(LessonFor^mlessonForm){intflag=0;String[]delId=lessonForm.getDelldA广广ay();if(delld•length>0){Stringid="for(inti=0;i10、++){id=id+delId[i]+H/f;}id=id•substring©id.length()-l);Stringsql=MDELETEFROMtb_lessonwhereidinH++id+“)”;~flag=conn.executeUpdate(sql);conn.close();}else{flag=0;}returnflag;}}//査询方法publicListquGry(intid){Listl
2、H/manage/Lesson.jsp"/>3、H/>4■•w5/publicclassLessonFormextendsAc4、tionForm{privateDatejoinTime;privateStringname;privateintID;privateString[]delIdArray=newSt广ing[0];publicDategetJoinTime(){returnjoinTime;}publicvoidsetJoinTime(DatejoinTime){this.joinTimw=joinTime;6lessiondao完成以下代码^importcom.wgh・actionForm・LessonForm;二pub5、licclassLessonDAO{privateConnDBcorm=newConnDB();//添加数据bpublicintinsert(LessonFormlessonForm){□6、//查询方法bpublicListquwry(intid){□//查询方法dpublicListquery(StringstudentID){□//删除数据bpublicintdelete(LessonFormlessonForm){□参考代码•••■■■■••••••••■夕£//添加嘶0127、publicintins8、ert(LessonForTnlessonFo广m){Stringsqll二"SELECT*FROMtb_lessonWHEREname='M+lessonForm.getName()+M1M;ResultSetrs=conn.executeQuery(sqll);Stringsql=MM;intfalg=0;if(rs.next()){falg=2;}else{sql=MINSERTINTOtb_lesson(name)values(1M+lessonForm.getName()+falg=conn.ex9、ecutQUpdatQ(sql);System.out.printIn(8B1的SQL."+sql);conn・close();}}catch(Exceptionex){falg=0;}returnfalg;//删除数据publicintdelete(LessonFor^mlessonForm){intflag=0;String[]delId=lessonForm.getDelldA广广ay();if(delld•length>0){Stringid="for(inti=0;i10、++){id=id+delId[i]+H/f;}id=id•substring©id.length()-l);Stringsql=MDELETEFROMtb_lessonwhereidinH++id+“)”;~flag=conn.executeUpdate(sql);conn.close();}else{flag=0;}returnflag;}}//査询方法publicListquGry(intid){Listl
3、H/>4■•w5/publicclassLessonFormextendsAc
4、tionForm{privateDatejoinTime;privateStringname;privateintID;privateString[]delIdArray=newSt广ing[0];publicDategetJoinTime(){returnjoinTime;}publicvoidsetJoinTime(DatejoinTime){this.joinTimw=joinTime;6lessiondao完成以下代码^importcom.wgh・actionForm・LessonForm;二pub
5、licclassLessonDAO{privateConnDBcorm=newConnDB();//添加数据bpublicintinsert(LessonFormlessonForm){□
6、//查询方法bpublicListquwry(intid){□//查询方法dpublicListquery(StringstudentID){□//删除数据bpublicintdelete(LessonFormlessonForm){□参考代码•••■■■■••••••••■夕£//添加嘶012
7、publicintins
8、ert(LessonForTnlessonFo广m){Stringsqll二"SELECT*FROMtb_lessonWHEREname='M+lessonForm.getName()+M1M;ResultSetrs=conn.executeQuery(sqll);Stringsql=MM;intfalg=0;if(rs.next()){falg=2;}else{sql=MINSERTINTOtb_lesson(name)values(1M+lessonForm.getName()+falg=conn.ex
9、ecutQUpdatQ(sql);System.out.printIn(8B1的SQL."+sql);conn・close();}}catch(Exceptionex){falg=0;}returnfalg;//删除数据publicintdelete(LessonFor^mlessonForm){intflag=0;String[]delId=lessonForm.getDelldA广广ay();if(delld•length>0){Stringid="for(inti=0;i10、++){id=id+delId[i]+H/f;}id=id•substring©id.length()-l);Stringsql=MDELETEFROMtb_lessonwhereidinH++id+“)”;~flag=conn.executeUpdate(sql);conn.close();}else{flag=0;}returnflag;}}//査询方法publicListquGry(intid){Listl
10、++){id=id+delId[i]+H/f;}id=id•substring©id.length()-l);Stringsql=MDELETEFROMtb_lessonwhereidinH++id+“)”;~flag=conn.executeUpdate(sql);conn.close();}else{flag=0;}returnflag;}}//査询方法publicListquGry(intid){Listl
此文档下载收益归作者所有