项目实训课件第6天

6天课件12SVN324先用数据库设计开始配置如如 671select*fromstudentwhereclass_id=?and=?andnamelike? andage>?andage<? phonelike?2POJO2点要求long--publicpublicclassStudentWherePOprivateString private;privateStringprivateString3action4Liststuds;ListObject[]delIds; String StudentWherePOwhere;//publicpublicclassStudentList3ActionextendsS2SearchAction{privateListstuds; 别的名称是一个pojoprivate privateStringflag; publicStringexecute()throwsExceptionStringhql="fromqh.student.Student";"namelike:", "phonelike:where.phone", studs=execute(hql,params);return}4jspincludejsp业务 where.xxx//age1与age2age>=age1and查询<link<linkrel="styleSheet"type="text/css"<s:formaction="StudentList3"<s:include<table<tdalign="rightwidth="100">班级号<s:select <tdalign="right" <s:select <tdalign="right" <s:textfieldname=""size="10"<tdalign="right" <s:textfieldname="where.age1"size="2"<tdalign="right" <s:textfieldname="where.age2"size="2"<tdalign="right" <s:textfieldname="where.phone"size="10"<div<table<tralign="center"<tdwidth="100">序号<tdwidth="100">学号<td <tdwidth="150">班级号<td <td <td <tdwidth="200">入学时间<tdwidth="300">住址 torvalue="studs"id="stud"<tr<td<s:checkboxlistname="delIds"<td>${stud.studId<td<td<td }</td><td <td>${stud.age ;':stud.phone<td>${stud.ruxueTime <buttononclick="delSelectIds();">删除<button select*fromselect*fromsp_helptextv_study; sp_helpstudysp_helpcreateviewV_STUDYfromstudyt1,studentt2,coursewheret1.stud_id=t2.stud_idand class_id=?andcourse_namelike score>=?andpublicclassVStudyWherePO{privateIntegerstudId;privatepublicclassVStudyWherePO{privateIntegerstudId;privateIntegercourseId;privateStringcourseName;privateStringname;privateStringcla privateFloatscore1;privateFloatscore2;=:where 3=:where publicclassVStudyListActionextendsprivateListpublicclassVStudyListActionextendsprivateListprivate privateVStudyWherePO privateStringpublicStringexecute()throwsException{Stringhql="fromqh.vstudy.VStudy"; "namelike"score>="score<=studs=execute(hql,params);return}4jsp<s:formaction="StudyList1"<s:include<table<tdalign="rightwidth="100">学号<s:textfield<tdalign="rightwidth="100">课程<s:textfieldname="where.courseId"size="10"<tdalign="rightwidth="100">班级号<s:selectname="where.cla <td<tdalign="rightwidth="100">成绩<s:textfieldname="where.score1"size="4"<tdalign="rightwidth="100">成绩<s:textfieldname="where.score2"size="4"<tdalign="right" <s:textfieldname=""size="10"1deletefromstudywherestud_id=10000andpublicclassVStudyWherePOpublicclassVStudyWherePOprivateIntegerstudId;privateIntegercourseId;privateStringcourseName;privateStringname;privateStringcla privateFloatscore1;privateFloatscore2;4actionpublicpublicclassStudyListActionextendsprivateListprivateVStudyWherePOwhere;privateString[]delIds;privateStringflag;publicStringexecute()throwsException//TODOAuto-generatedmethodstubStringhql="from "score "scorestuds=execute(hql,return} publicStudyId[]xhgDelIds(){StudyId[]cmpIds=newfor(inti=0;i<delIds.length;i++){StringdelCmpId=delIds[i];IntegerstudId=Integer.parseInt(strs[0]);IntegercourseId=Integer.parseInt(strs[1]);StudyIdid=newStudyId(studId,courseId);}return}5jsptorvalue="studs"torvalue="studs"id="stud"<tr<td<s:checkboxlistname="delIds"<td>${stud.id.studId<td<td>${stud.score 六、关于.jar1jar2、将制做好class文件拷贝另外某 4winrar工具打开.jar七、直接删除MyEclipse有的jar1、如果这个jar文件在WEB- 22jar30999-38103