月24日1安裝軟件并對Eclipse進(jìn)行某些設(shè)置比如生成的JSP打

SQL文本SQL配置好代碼的注釋，注意注釋的編寫，另外加上javaDoc文檔，如果當(dāng)前項目采用的編碼方式是否合理，如果不合理進(jìn) -encodingUTF-8-charsetUTF-web工程最后生成的是war .txt、源代 文 、warJSP我們要做是學(xué)生理系統(tǒng)班級表 [_目名 NUMBERnotnull,NAMEVARCHAR2(30),TEACHER學(xué)生表 NUMBERnotnull, BIRTHDAYDATE, altertableT_STUDENTaddconstraintPK_STUDENT_IDprimarykeyaltertableaddconstraintFK_STUDENT_CLASS_IDforeignkey(CLAID)referencesT_CLASS(ID)ondeletecascade;也可以根據(jù)條件加上checkaltertableaddconstraintCHECK_AGEcheck(age>0andage<100);altertableaddconstraintCHECK_check(genderin('男','女')); PK_表名(不要加T)_列1getset方【數(shù)據(jù)層】(2存放數(shù)據(jù)庫的操數(shù)據(jù)3存放數(shù)據(jù)庫的操456ServletWeb(表現(xiàn)層7servlet(UI指user89WEB-INF下。我們可以放在src或WEB-INF下，如果是src下，可以通過this.getClass().getClassLoader().getResourceAsStream()作了。切記不要再使用newFile的方式來了。 和com.guigu.service包中沒有文件，MyEclipse自作聰明把它合并了，這時候可以通過切換為什么要有com.guigu.exception如果我的sql語句寫錯SQLservice層知道出現(xiàn)異常了，所以我們不能在這里直接打印個堆棧，而是做出throwsSQLException有很大的弊 com.guigu.web.UI這個包里面的Servlet首先我們把要用到j(luò)avaBeanpackagecom.guigu.importimport項目名稱：guiguManager 類描述 創(chuàng)建人：吳長青Copyright(c) AllRightspublicclassCla{privateintid;privateStringname;privateStringprivateSet<Student>set=newid.獲得id屬性值的方法@returnthe JDKpublicintgetId()return}id為id賦值的方法 theidto JDKpublicvoidsetId(intid)this.id=}name.獲得name屬性值的方法@returnthe JDKpublicStringgetName()return}name為name賦值的方法 thenameto JDKpublicvoidsetName(Stringname)=}teacher.獲得teacher屬性值的方法@returnthe JDKpublicStringgetTeacher()return}teacher為teacher賦值的方法 theteacherto JDKpublicvoidsetTeacher(Stringteacher)this.teacher=}set.獲得set屬性值的方法@returnthe JDKpublicSet<Student>getSet()return}set為set賦值的方法 thesetto JDKpublicvoidsetSet(Set<Student>set)this.set=}publicCla()}publicCla(intid,Stringname,Stringteacher)this.id=id;=this.teacher=}/*(non-@seepublicStringtoString()return"Cla[id="+id+",name="+name+",teacher="+teacher+"]";}}packagecom.guigu.import項目名稱：guiguManager 創(chuàng)建人：吳長青Copyright(c) AllRightspublicclassStudent{privateintid;privateStringname;privateintage;privateStringgender;privateDatebirthday;privateClacla;id.id屬性值的方法@returnthe JDKpublicintgetId()return}idid賦值的方法 theidto JDKpublicvoidsetId(intid)this.id=}屬性值的方法@returnthe JDKpublicStringgetName()return}name thenameto JDKpublicvoidsetName(Stringname)=}age.age屬性值的方法@returnthe JDKpublicintgetAge()return}ageage賦值的方法 theageto JDKpublicvoidsetAge(intage)this.age=}gender.gender屬性值的方法@returnthe JDKpublicStringgetGender()return}gendergender賦值的方法 thegenderto JDKpublicvoidsetGender(Stringgender)this.gender=}birthday.獲得birthday屬性值的方法@returnthe JDKpublicDategetBirthday()return}birthday thebirthdayto JDKpublicvoidsetBirthday(Datebirthday)this.birthday=}cla.cla屬性值的方法@returnthe JDKpublicClagetCla()return}clacla賦值的方法 theclato JDKpublicvoidsetCla(Clacla)this.cla=}publicStudent()}publicStudent(intid,Stringname,intage,Stringgender,Datebirthday,Clacla){this.id=id;=name;this.age=age;this.gender=gender;this.birthday=birthday;this.cla=cla;}/*(non-@seepublicinthashCode(){finalintprime=31;intresult=1;result=prime*result+result=prime*result+((birthday==null)?0:result=prime*result+((cla==null)?0:cla.hashCode());result=prime*result+((gender==null)?0:result=prime*result+result=prime*result+((name==null)?0:return}/*(non-@seepublicbooleanequals(Objectobj)if(this==returntrue;if(obj==returnif(getClass()!=returnStudentother=(Student)if(age!=returnif(birthday==null)if(other.birthday!=null)returnfalse;}elseifreturnfalse;if(cla==null)if(other.cla!=null)returnfalse;}elseifreturnif(gender==null)if(other.gender!=null)returnfalse;}elseifreturnif(id!=returnfalse;if(name==null){if(!=null)returnfalse;}elseifreturnfalse;returntrue;}}packagecom.guigu.import項目名稱：guiguManager 類描述 創(chuàng)建人：吳長青Copyright(c) AllRightspublicclassPage{privateintbegin;privateintend;privateinttotalPages;privateinttotalRows;privateintcurrentPage=1;privateintpageRows=3;privateListlist;begin.獲得begin屬性值的方法@returnthe JDKpublicintgetBegin()returnpageRows*(current}begin為begin賦值的方法 thebeginto JDKpublicvoidsetBegin(intbegin)this.begin=}end.獲得end屬性值的方法@returnthe JDKpublicintgetEnd()return}end為end賦值的方 theendto JDKpublicvoidsetEnd(intend)this.end=}totalPages.獲得totalPages屬性值的方法@returnthe JDKpublicintgetTotalPages()return}totalPages為totalPages thetotalPagesto JDKpublicvoidsetTotalPages(inttotalPages)this.totalPages=}totalRows.獲得totalRows屬性值的方法@returnthe JDKpublicintgetTotalRows()return}totalRows為totalRows賦值的方法 thetotalRowsto JDKpublicvoidsetTotalRows(inttotalRows){this.totalRows=totalRows;this.totalPages=}currentPage.獲得currentPage屬性值的方法@returnthe JDKpublicintgetCurrentPage()return}currentPage為currentPage賦值的方 thecurrentPageto JDKpublicvoidsetCurrentPage(intcurrentPage)this.currentPage=totalPages;}elseif(current1<1){this.currentPage=1;this.currentPage=}}pageRows.獲得pageRows屬性值的方法@returnthe JDKpublicintgetPageRows()return}pageRows為pageRows賦值的方 thepageRowsto JDKpublicvoidsetPageRows(intpageRows)this.pageRows=}list.獲得list屬性值的方法@returnthe JDKpublicListgetList()return}list為list賦值的方 thelistto JDKpublicvoidsetList(Listlist)this.list=}}利用DBUtils來搭建DAOpackageimportjava.sql.Connection;importjava.sql.SQLException;importjava.util.List;項目名稱：guiguManager類全名 類描述 創(chuàng)建人：吳長青Copyright(c) AllRightspublicinterfaceICommonDao<T>*getForValue:(這里用一句話描述這個方法的作用TODO(這里描述這個方法適用條件–可選@author吳長青@param@param@param@throws@sinceJDKpublic<E>EgetForValue(Connectionconn,Stringsql,Object...args)throwsSQLException;getForList:(這里用一句話描述這個方法的作用TODO(這里描述這個方法適用條件–可選@author吳長青@param@param@param@throws@sinceJDKpublicList<T>getForList(Connectionconn,Stringsql,Object...args)throwsSQLException;update:(這里用一句話描述這個方法的作用TODO(這里描述這個方法適用條件–可選@author吳長青@param@param@param@throws@sinceJDKpublicvoidupdate(Connectionconn,Stringsql,Object...throwsget:(這里用一句話描述這個方法的作用TODO(這里描述這個方法適用條件–可選@author吳長青@param@param@param@throws@sinceJDKpublicTget(Connectionconn,Stringsql,Object...args)}packageimportimportjava.sql.Connection;importjava.sql.SQLException;importjava.util.List; 項目名稱：guiguManager類全名 創(chuàng)建人：吳長青Copyright(c) AllRights@parampublicclassCommonDaoImpl<T>implementsICommonDao<T>privateQueryRunnerqueryRunner=null;privateClass<T>clazz;publicqueryRunner=newQueryRunner();clazz=}/*(non- java.lang.String,java.lang.Object[])public<E>EgetForValue(Connectionconn,Stringsql,Object...throwsSQLExceptionreturnqueryRunner.query(conn,sql,new}/*(non- java.lang.String,java.lang.Object[])publicList<T>getForList(Connectionconn,Stringsql,Object...throwsSQLExceptionreturnqueryRunner.query(conn,sql,new}/*(non- java.lang.String,java.lang.Object[])publicvoidupdate(Connectionconn,Stringsql,Object...args)SQLExceptionqueryRunner.update(conn,sql,}/*(non- java.lang.String,java.lang.Object[])publicTget(Connectionconn,Stringsql,Object...args)SQLExceptionreturnqueryRunner.query(conn,sql,new}}packagecom.guigu.dao;importjava.util.List;importcom.guigu..Cla;項目名稱：guiguManager 類描述 創(chuàng)建人：吳長青Copyright(c) AllRightspublicinterfaceIClaDaoextendspublicvoidadd(Clapublicvoidupdate(Clapublicvoiddelete(intid);publicClafind(intid);publicList<Cla>getAll();publicintpublicList<Cla>getByPage(intbegin,int}packageimportjava.sql.Connection;importjava.sql.SQLException;importjava.util.List;importcom.guigu.dao.IClaDao;importcom.guigu..Cla;importcom.guigu.util.JdbcUtil;項目名稱：guiguManager類全名 創(chuàng)建人：吳長青Copyright(c) AllRightspublicclassClaDaoImplextendsCommonDaoImpl<Cla>implementsIClaDao/*(non-publicvoidadd(Clacla){Connectionconn=null;try{conn=Stringsql="insertintot_ClavaluesObject[]args={cla.getId(),cla.getName(),cla.getTeacher()};update(conn,sql,args);}catch(SQLExceptione){}}/*(non-publicvoidupdate(Clacla){Connectionconn=null;try{conn=Stringsql="updatet_Clasetname=?,teacher=?where=

Object[]args={cla.getName(),cla.getTeacher(),cla.getId()};update(conn,sql,args);}catch(SQLExceptione){}}/*(non-@seepublicvoiddelete(intid){Connectionconn=null;try{conn=Stringsql="deletet_Clawhereid=?";Object[]args={id};update(conn,sql,}catch(SQLExceptione){}}/*(non-@seepublicList<Cla>getAll()Stringsql="select*fromt_Cla";Connectionconn=null;List<Cla>list=null;try{conn=JdbcUtil.getConnection();list=getForList(conn,sql);}catch(SQLExceptione){}return}/*(non-@seepublicClafind(intid){Connectionconn=null;Clacla=null;tryconn=Stringsql="select*fromt_Clawhereid=?";cla=get(conn,sql,id);}catch(SQLExceptione){}return}/*(non-@seepublicintgetTotalRows(){Connectionconn=null;intcount=0;tryconn=Stringsql="selectcount(*)fromt_cla";count=getForValue(conn,sql);}catch(SQLExceptione){}return}/*(non-publicList<Cla>getByPage(intbegin,intend){Connectionconn=null;List<Cla>list=null;try{conn=Stringsql="select*from(selectc.*,rownumrnfrom*fromt_cla)whererownum<?)wherern>?";Object[]args={end,begin};list=getForList(conn,sql,}catch(SQLExceptione){}return}}packageimportimport import 項目名稱：guiguManager類全名 類描述 創(chuàng)建人：吳長青Copyright(c) AllRightspublicinterfaceIClaServicepublicvoidaddCla(Clacla);publicvoidupdateCla(Clac);publicvoiddeleteCla(intid);ClafindCla(intList<Cla>}PagegetByPage(Stringpackageimportimportimportimport import import項目名稱：guiguManager類全名 類描述 創(chuàng)建人：吳長青Copyright(c) AllRightspublicclassClaServiceImplimplementsprivateIClaDaoclaDao=new/*(non-publicvoidaddCla(Clacla){}/*(non-*@seepublicvoidupdateCla(Clac){}/*(non-*@seepublicvoiddeleteCla(intid){}/*(non-*@seepublicClafindCla(intid)return}/*(non-*@seepublicList<Cla>getAll()return}/*(non-*@seepublicPagegetByPage(StringcurrentPage){Pagepage=newPage();intcp=Integer.valueOf(currentPage);}List<Cla>list=claDao.getByPage(page.getBegin(),return}}packageimportimportimportimportimportimportimportcom.guigu.importcom.guigu.importimport項目名稱：guiguManager類全名 類描述 創(chuàng)建人：吳長青Copyright(c) AllRightspublicclassClaServletextendsHttpServletpublicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{Stringflag=request.getParameter("flag");IClaServicecla