传智javaee教学j2ee第6天课件

J2EE622hibernate映射的复杂性问题1hibernate有外键时，映射复杂2也就是数据表设计与hbm--droptable--droptableCLASS_REG_SPDAOcreatetableCLASS_REG_SPDAOCLASS_IDchar(7)primarykey,START_TIMEdatetime,END_TIMEdatetime,)--droptablecreatetable (STUD_IDintidentity(10000,1)primaryCLASS_IDchar(7) foreignkeyreferencesCLASS_REG_SPDAO(CLASS_ID),NAMEnvarchar(10)notnull,nchar(1) AGEintcheck(AGE>=0andAGE<=120),ADDRnvarchar(50),RUXUE_TIMEdatetimenotXUE_QIchar(1)notnullcheck(XUE_QI <classname="qh.student.ClassRegSpdao"table="CLASS_REG_SPDAO"><id "<columnname="CLASS_ID"length="7"<generator<propertyname="startTime"<columnname="START_TIME"length="23"<propertyname="endTime"<columnname="END_TIME"length="23"<setname="studentSpdaos"inverse="true"<columnname="CLASS_ID"length="7"<one-to-manyclass="qh.student.StudentSpdao" <classname="qh.student.StudentSpdao"table="STUDENT_SPDAO"<idname="studId"<columnname="STUD_ID"<generator<many-to-onename="classRegSpdao"class="qh.student.ClassRegSpdao"cascade="all"fetch="select"><columnname="CLASS_ID"length="7"publicpublicclassTestClass_Reg_Student_Insertpublicstaticvoidmain2(String[]args)//TODOAuto-generatedmethodClassRegSpdaomainPo=newClassRegSpdao("QH10005","2010-3-5","2010-12-30",null);StudentSpdaosubPo1=newStudentSpdao("检测name-1""2010-3-6",1,1);subPo1.setClassRegSpdao(mainPo);//StudentSpdaosubPo2=newStudentSpdao("检测name-2""2010-4-6",2,2);StudentSpdaosubPo3=newStudentSpdao("检测name-3""2010-5-6",3,3);Setset=newHashSet();Sessions=HibernateSessionFactory.getSession();Transactiontx=s.beginTransaction();}publicstaticvoidmain(String[]args)Sessions=HibernateSessionFactory.getSession();ClassRegSpdaomainPo=(ClassRegSpdao)Transactiontx=s.beginTransaction();}}publicclassTestStudent_ClassReg_Insertpublicstaticvoidmain2(String[]args)//TODOAuto-generatedmethodStudentSpdaosubPo1=newStudentSpdao("检测name-new""2010-8-8",1,1);ClassRegSpdaomainPo=newClassRegSpdao("QH10006","2010-8-8","2010-12-30",null); SessionTransactiontx=s.beginTransaction();}publicstaticvoidmain(String[]args)Sessions=HibernateSessionFactory.getSession();StudentSpdaosubPo=(StudentSpdao)Transactiontx=s.beginTransaction();}}5 <classname="qh.student.ClassRegSpdao"table="CLASS_REG_SPDAO"><id "<columnname="CLASS_ID"length="7"<generator<propertyname="startTime"<columnname="START_TIME"length="23"<propertyname="endTime"<columnname="END_TIME"length="23"<setname="studentSpdaos"inverse="true"<columnname="CLASS_ID"length="7"<one-to-manyclass="qh.student.StudentSpdao" name="qh.student.StudentSpdao"table="STUDENT_SPDAO"<idname="studId"<columnname="STUD_ID"<generatorcascade="all"<columnname="CLASS_ID"length="7"22--MEMBER_ID NAMEchar(10)default)--DROPTABLEIDCARDMEMBER_IDvarchar(36)PRIMARYKEYforeignkeyreferencesmember(member_id),ID_CARDchar(20),)2<class<classname="qh.one2one1.Member"table="MEMBER"schema="dbo"<idname="memberId"<columnname="MEMBER_ID"length="36"<generator<propertyname="name"<columnname="NAME"length="10"<one-to-onename="idCard"class="qh.one2one1.Idcard"cascade="all"/><classname="qh.one2one1.Idcard"table="IDCARD"schema="dbo"<idname="memberId"<columnname="MEMBER_ID"length="36"<generator<generator<param<propertyname="idCard"<columnname="ID_CARD"length="20"<propertyname="validateDate"<columnname="VALIDATE_DATE"length="23"<one-to-onename="member"class="qh.one2one1.Member"constrained="true"fetch="select"cascade="all">publicclasspublicclassTestMemberIdCardpublicstaticvoidmain3(String[]args)trySessionsession=HibernateSessionFactory.getSession();Transactiontx=session.beginTransaction();Membermember=newMember(); IdcardidCard=newIdcard(); idCard.setValidateDate(newDate()); }catch(Exceptione){}}publicstaticvoidmain6(String[]args)trySessionsession=HibernateSessionFactory.getSession();Transactiontx=session.beginTransaction();Membermember=(Member)session.get(qh.one2one1.Member.class,"testamember-1");member.setName("newmember");//IdcardidCard=idCard.setValidateDate(newDate()); }catch(Exceptione){}}publicstaticvoidmain2(String[]args)//TODOAuto-generatedmethodtrySessionsession=HibernateSessionFactory.getSession();Transactiontx=session.beginTransaction();IdcardidCard=(Idcard)session.get(qh.one2one1.Idcard.class,"testamember-1");idCard.setValidateDate(newDate());MembermemberidCard.getMember();//据}catch(Exceptione){}}publicstaticvoidmain(String[]args)trySessionsession=HibernateSessionFactory.getSession();Transactiontx=session.beginTransaction();IdcardidCard=(Idcard)session.get(qh.one2one1.Idcard.class,"testamember-1");}catch(Exceptione){}}}CREATETABLEMEMBER2(CREATETABLEMEMBER2(MEMBER_IDintidentity NAMEnvarchar(20)defaultNULL,)--DROPTABLEIDCARD2idintidentityprimaryMEMBER_IDintuniqueforeignkeyreferencesmember2(member_id),ID_CARDvarchar(20),)<classname=<classname="qh.one2one2.Member2"table="MEMBER2"schema="dbo"<idname="memberId"<columnname="MEMBER_ID"length="36"<generator<propertyname="name"<columnname="NAME"length="10"<one-to-onename="idCard"class="qh.one2one2.Idcard2"cascade="all"property-ref="member"<classname="qh.one2one2.Idcard2"table="IDCARD2"schema="dbo"<idname="id"<column<columnname="ID"<generator<propertyname="idCard"<columnname="ID_CARD"<propertyname="validateDate"<columnname="VALIDATE_DATE"length="23"<many-to-onename="member"class="qh.one2one2.Member2"column="member_id"cascade="all"unique="true">publicclasspublicclassTestMemberIdCard2publicstaticvoidmain6(String[]args)trySessionsession=HibernateSessionFactory.getSession();Transactiontx=session.beginTransaction();Member2member=newMember2(); Idcard2idCard=new idCard.setValidateDate(newDate());session.save(member);//保存主表的同时，子表也同时保存}catch(Exceptione){}}publicstaticvoidmain3(String[]args)trySessionsession=HibernateSessionFactory.getSession();Transactiontx=session.beginTransaction();Member2member=(Member2)session.get(qh.one2one2.Member2.class,1);member.setName("newmember");Idcard2idCard=member.getIdCard();idCard.setValidateDate(newDate());}catch(Exceptione){}}publicstaticvoidmain4(String[]args)trySessionsession=HibernateSessionFactory.getSession();Transactiontx=session.beginTransaction();Idcard2idCard=(Idcard2)session.get(qh.one2one2.Idcard2.class,1);idCard.setValidateDate(newDate());Member2member=idCard.getMember();}catch(Exceptione){}}publicstaticvoidmain2(String[]args){Transactiontx=null;trySessionsession=HibernateSessionFactory.getSession();tx=session.beginTransaction();Idcard2idCard=(Idcard2)session.get(qh.one2one2.Idcard2.class,2);}}catch(Exceptione){}}publicstaticvoidmain(String[]args){Transactiontx=null;trySessionsession=HibernateSessionFactory.getSession();tx=session.beginTransaction();Member2mainTb=(Member2)session.get(qh.one2one2.Member2.class,1);}catch(Exceptione){}}}MapCREATETABLEPRODUCT_SET1(IDINTNOTNULLidentityPRIMARYKEY,NAMEVARCHAR(30),PRICE)CREATETABLEIMAGES_SET1(PRODUCT_IDINTNOTNULLforeignkeyreferencesPRODUCT_SET1(ID),IMAGE_NAMEVARchar(30),)2<class<classname="qh.sets.map1.ProductSet1"table="PRODUCT_SET1"<idname="id"<columnname="ID"<generator<property<propertyname="name"<columnname="NAME"length="30"<propertyname="price"<columnname="PRICE"precision="10"scale="4"<mapname="imagesSet1s"table="IMAGES_SET1"<columnname="PRODUCT_ID"not-null="true"<indexcolumn="IMAGE_NAME"<elementcolumn="IMAGE_FILE"publicclasspublicclassTestMap1publicstaticvoidmain2(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();ProductSet1product=newProductSet1();product.setPrice(newDouble(15400)); Mapmap=newLinkedHashMap();Mapmap=newHashMap();}catch(Exceptione){}}publicstaticvoidmain4(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();product=(ProductSet1)s.get(qh.sets.map1.ProductSet1.class,1); Mapmap=newMap<String,String>map=product.getImagesSet1s();map.put("新加一个图","/ibm/test3新加- map.put("侧视图"/ibm/test3--修改-jgp");//录}catch(Exceptione){}}publicstaticvoidmain(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();product=(ProductSet1)s.get(qh.sets.map1.ProductSet1.class,1);Stringname=product.getName();Doubleprice=product.getPrice();product.setPrice(newDouble(20000)); Mapmap=newMap<String,String> Stringfile1=map.get("电源适配器图");Stringfile1=map.get("侧视图");System.out.println("子表数据file="+file1);map.put("侧视图","/ibm/test3-改.jgp");Set forfor(inti=0;it.hasNext();i++){Stringkey=it.next();Stringvalue=map.get(key);}}catch(Exceptione){}}publicstaticvoidmain3(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();product=(ProductSet1)s.get(qh.sets.map1.ProductSet1.class,1);}catch(Exceptione){}}}CREATETABLEPRODUCT_SET12(IDINTCREATETABLEPRODUCT_SET12(IDINTNOTNULLidentityPRIMARYKEY,NAMEVARCHAR(30),PRICE)CREATETABLEIMAGES_SET12(PRODUCT_IDINT foreignkeyreferencesPRODUCT_SET12(ID),IMAGE_NAMEVARchar(30),IMAGE_DESC)<classname=<classname="qh.sets.map2.ProductSet12"<idname="id"<columnname="ID"<generatorclass="native"<propertyname="name"<columnname="NAME"length="30"<propertyname="price"<columnname="PRICE"precision="10"scale="4"<mapname="imagesSet12s"<key<indexcolumn="IMAGE_NAME"<composite-element<propertyname="imageFile"column="IMAGE_FILE"<propertyname="imageDesc"column="IMAGE_DESC"3publicclassTestMap2publicstaticvoidmain2(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();ProductSet12product=newProductSet12();Mapmap=new Mapmap=new 标识-1"new 标识-2"new 标识-3"new 标识-4"new }catch(Exceptione){}}publicstaticvoidmain(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();product=(ProductSet12)s.get(qh.sets.map2.ProductSet12.class,2);Mapmap=product.getImagesSet12s();ImagesSet12ImagesSet12img=(ImagesSet12map.get("}catch(Exceptione){}}}map --DROPTABLEPRODUCT_SET2map --DROPTABLEPRODUCT_SET2IDINT NAMEVARCHAR(30),PRICE)--DROPTABLEIMAGES_SET2---map3CREATETABLEIMAGES_SET2(IDint primary intforeignkeyreferencesPRODUCT_SET2(ID),--这一行没有notnullIMAGE_NAMEVARchar(30),)2<classname="qh.sets.map3.ProductSet2"<idname="id"<columnname="ID"<generatorclass="native"<propertyname="name"<columnname="NAME"length="30"<propertyname="price"<columnname="PRICE"precision="10"scale="4"<mapname="imagesSet2s"<key<indexcolumn="IMAGE_NAME"<one-to-manyclass="qh.sets.map3.ImagesSet2"<classname="qh.sets.map3.ImagesSet2"<idname="id"<columnname="ID"<generatorclass="native"<propertyname="imageName"<columnname="IMAGE_NAME"length="30"<propertyname="imageFile"<columnname="IMAGE_FILE"length="50"publicclasspublicclassTestMap3publicstaticvoidmain(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();ProductSet2product=newProductSet2();Mapmap=new 名称-1",newImagesSet2("名称-map.put("名称-2",newImagesSet2("名称-map.put("名称-3",newImagesSet2("名称-map.put("名称-4",newImagesSet2("名称-}catch(Exceptione){}}}set--DROPTABLEPRODUCT_SET3set--DROPTABLEPRODUCT_SET3IDINT NAMEVARCHAR(30),PRICE)--DROPTABLEIMAGES_SET3PRODUCT_IDintforeignkeyreferencesPRODUCT_SET3(ID),IMAGE_FILEVARchar(50))<classname=<classname="qh.sets.set1.ProductSet3"<idname="id"<columnname="ID"<generatorclass="native"<propertyname="name"<columnname="NAME"length="30"<propertyname="price"<columnname="PRICE"precision="10"scale="4"<setname="imagesSet3s"<keycolumn="PRODUCT_ID"<elementcolumn="IMAGE_FILE"type="string"3publicclassTestSet1publicstaticvoidmain5(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();ProductSet3product=newProductSet3();Setset=new Setset=newHashSet();}catch(Exceptione){}}publicstaticvoidmain4(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession(); product=(ProductSet3)s.get(qh.sets.set1.ProductSet3.class,1);Setset=product.getImagesSet3s(); for(inti=0;it.hasNext();i++){Stringvalue=it.next();} set=new }catch(Exceptione){}}publicstaticvoidmain3(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();product=(ProductSet3)s.get(qh.sets.set1.ProductSet3.class,1); Setset=newSetset=product.getImagesSet3s();set.clear();//删除子表数据}catch(Exceptione){}}publicstaticvoidmain(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();}catch(Exceptione){}}} set2--DROPTABLEPRODUCT_SET4 set2--DROPTABLEPRODUCT_SET4IDINTLidentityPRIMARYKEY,NAMEVARCHAR(30),PRICE)--DROPTABLEIMAGES_SET4PRODUCT_IDintforeignkeyreferencesPRODUCT_SET4(ID),IMAGE_NAMEVARCHAR(50),)<classname=<classname="qh.sets.set2.ProductSet4"<idname="id"<columnname="ID"<generatorclass="native"<propertyname="name"<columnname="NAME"length="30"<propertyname="price"<columnname="PRICE"precision="10"scale="4"<setname="imagesSet4s"<columnname="PRODUCT_ID"<composite-element<propertyname="imageName"column="IMAGE_NAME"<propertyname="imageFile"column="IMAGE_FILE"publicclasspublicclassTestSet2@parampublicstaticvoidmain3(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();ProductSet4product=newProductSet4();Setset=newImagesSet4img1=new

ImagesSet4img2=newImagesSet4("-2","文件名Test-ImagesSet4img3=newImagesSet4("-3","文件名Test-ImagesSet4img4=newImagesSet4("-4","文件名}catch(Exceptione){}}@parampublicstaticvoidmain2(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();product=(ProductSet4)s.load(qh.sets.set2.ProductSet4.class,1);Setset=product.getImagesSet4s()此时得到set为一个指针，ImagesSet4img1=new

ImagesSet4img2=newImagesSet4(" ImagesSet4img3=new ImagesSet4ImagesSet4img4=new}catch(Exceptione){}}publicstaticvoidmain(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();product=(ProductSet4)s.load(qh.sets.set2.ProductSet4.class,1);}catch(Exceptione){}}}----listtest1----DROPTABLEPRODUCT_SET5----listtest1----DROPTABLEPRODUCT_SET5IDINT NAMEVARCHAR(30),PRICE)--DROPTABLEIMAGES_SET5PRODUCT_IDintforeignkeyreferencesPRODUCT_SET5(ID),IMAGE_INDEXINTNOTNULL,)<classname=<classname="qh.sets.list1.ProductSet5"<idname="id"<columnname="id"<generator<propertyname="name"<columnname="name"length="30"<propertyname="price"<column<listname="images"<keycolumn="product_id"<index<elementcolumn="image_file"3publicclassTestList1publicstaticvoidmain5(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();ProductSet5product=newProductSet5();product.setName("ThinkPadR4002784A46");Listlist=newArrayList();}catch(Exceptione){}}publicstaticvoidmain3(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();product=(ProductSet5)s.get(qh.sets.list1.ProductSet5.class,1);product.setName("DellVO6689--3");List//list.clear();//}catch(Exceptione){}}publicstaticvoidmain4(String[]args){Transactiontx=null;trySessions=HibernateSessionFactory.getSession();product=(ProductSet5)s.get(qh.sets.list1.ProductSet5.class,1);product.setName("DellVO6689--5");Listlist=product.getImages();System.out.println("listsize="+list.size());list.set(2,"image