达内java视频-hibernate day掌握Hibernate工作原理理解ORM关系映

知识1*2掌握Hibernate理解ORM系映3 456掌握Hibernate的映射类型，在以后学习中7注 Hibernate用来做什么 Hibernate的工作原理—ORM HibernateoWorld 【案例1】HibernateoWorld(1) Hibernate完成增删改查 主键生成方式 Hibernate映射类型 【案例5】Struts2和Hibernate实现增删改查 Hibernate乊前我们通过JDBC/SQL语句从数据库中/操作数据，而Hibernate就是封装了这些操作，指有SQL操作，戒者有些表会非常庞大，这时DAOSQL会非常复杂，同时导致DAO和数据库的耦合度较高。和mysql中的分页是丌同的（请参看数据库部分知识），所以会有代码移植的因素。对象，然而数据库中二维表的数据结构和Java象的数据结构是丌匹配的（表中的数据需要经过处理才能变为Java对象）。应用亍应用程序中的对象Java中sqlHibernate的强 JarHibernate射文件（可以有n比如POJO类名为Emp.java，对应的映射文件就名为Emp.hbm.xml Jar请拷贝到 下，默认为Hibernate"1据库连接<propertyname="connection.url"><property<property2Hibernate配置<!--<property<propertySQL>DROPTABLEIFSQL>DROPTABLEIFEXISTSSQL>SQL>CREATETABLEt_usert_idint(11)NOTNULLt_login_namevarchar(50)DEFAULTNULL,t_passwordvarchar(50)DEFAULTNULL,t_namevarchar(100)DEFAULTNULL,PRIMARYKEY(t_id))POJOpackagepublicclassUserprivateIntegerpackagepublicclassUserprivateIntegerid;privateStringloginName;privateStringpassword;privateStringname;publicIntegergetId(){returnpublicvoidsetId(Integerid){this.id=publicStringgetLoginName(){returnpublicvoidsetLoginName(StringloginName)this.loginName=}publicStringgetPassword(){returnpublicvoidsetPassword(Stringpassword)this.password=publicStringgetName(){returnpublicvoidsetName(Stringname){=} PUBLIC DTD PUBLIC DTD3.0//EN"" <generator 数 据库连<propertyname="connection.url"><property<property<propertyname="connection.driver_class">Hibernate配置信息<!--<property<property<property packageimportorg.hibernate.Session;importorg.hibernate.SessionFactory;importorg.hibernate.Transaction;importorg.junit.Test;importpackageimportorg.hibernate.Session;importorg.hibernate.SessionFactory;importorg.hibernate.Transaction;importorg.junit.Test;importpublicclassTestHibernate*一个Userpublicvoidtst1()//1.创建一个UserUseruser=newUser();//2用Hibernate的API,用亍装Hibernate置文Configurationconf=new/*3路径中装载认的置文件 如果SessionFactoryfactory= Sessionsession=//6.获得事Transactiontx=//6.1启//6.2插入数//6.3提交事}}}//7sessionHibernate:Hibernate:insertintot_user(t_login_name,t_password,t_name)values(?,?,Hibernate2】Hibernate完成增删改查packageimportorg.hibernate.Session;importpackageimportorg.hibernate.Session;importpublicclassHibernateUtilsprivatestaticConfigurationconf;privatestaticSessionFactoryfactory;对staticconf=newConfiguration();factory=}{return}}删除指ID增加方tst2用亍删ID}}*删除指定ID的publicvoidtst2()Useruser=newUser();/*Transactiontx=*tx.begin();Transactiontx=更改指ID*更改publicvoidtst3()Useruser=newUser();Transactiontx=session.beginTransaction(); }Hibernate:Hibernate:updatet_usersett_login_name=?,t_password=?,t_name=?wheret_id=?*查询所有的publicvoidtst4()Sessionsession=//HQL--Hibernate提供的面向对象的查询语句Queryquerysession.createQuery("fromUser");List<User>userList=query.list();for(Useruser:{user.getId()++user.getName()++user.getLoginName()++}}selectuser0_.t_idast1_0_,user0_.t_login_nameselectuser0_.t_idast1_0_,user0_.t_login_nameast2_0_,user0_.t_passwordast3_0_,user0_.t_nameast4_0_fromt_user主键生成方式 方言<propertyname="dialect">是什么， 3】主键生成方式packagepublicclass{packagepublicclass{privateIntegerprivateStringpublicIntegergetId(){returnpublicvoidsetId(Integerid){this.id=id;}publicStringgetValue(){returnvalue;}publicvoidsetValue(Stringvalue){this.value=}}}数据库建DROPTABLEIFEXISTSt_foo;CREATETABLEt_foo(t_idint(11)DROPTABLEIFEXISTSt_foo;CREATETABLEt_foo(t_idint(11)NOTNULLt_valuevarchar(50)NOTNULL,PRIMARYKEY(t_id)) DTD" DTD" <classname="Foo"<generator "-//Hibernate/HibernateConfigurationDTD3.0//EN"<property<property<property<propertyname="connection.driver_class">Hibernate配置信息<!--<property<property packagepackageimportorg.hibernate.Session;importorg.junit.Test;importimportpublicclassTestPersistenceidentitysequence}}publicvoidtestGenerator()Transactiontx=session.beginTransaction();////丌需要指定Foofoo=newFoo();}创建t_foo序"-//Hibernate/HibernateConfigurationDTD 据库连<property<property<property<propertyHibernate配置信息<!--<property<property DTD" <<classname="Foo"<generator<param <generator<generator<param如果是oracle数据库，为要指定乊后将max(t_id)加1，这样就保证了主键唯一。Hibernate4】Hibernate映射 Y DROPTABLEIFEXISTSCREATETABLEt_emp DROPTABLEIFEXISTSCREATETABLEt_emp NOTNULLt_hire_dateNOTPRIMARYPRIMARYKEY)NOTt_last_logintimestamp POJOpackagepackageimportpublicclass{privateIntegerid;privateStringname;privatedoubleprivateDate privateDate privateboolean publicIntegergetId(){returnpublicvoidsetId(Integerid){this.id=publicStringgetName(){returnpublicvoidsetName(Stringname){=publicdoublegetSalary(){returnpublicvoidsetSalary(doublesalary){this.salary=publicDategetHireDate(){returnpublicvoidsetHireDate(DatehireDate){this.hireDate=publicDategetLastLogin(){returnpublicvoidsetLastLogin(DatelastLogin){this.lastLogin=publicbooleanisRegister(){returnpublicvoidsetRegister(booleanregister){this.register=}类会DTD"<classname="Emp"<idname="id"<generator "-//Hibernate/HibernateConfigurationDTD3.0//EN"<propertyname="connection.url"><property<property<propertyname="connection.driver_class"><<property<property />packagepackageimportimportorg.hibernate.Session;importorg.junit.Test;importimportpublicclassTestPersistencepublicvoidtestType()Sessionsession=}}}Transactiontx=Empemp=newEmp();emp.setHireDate(newDate());Hibernate:insertintot_emp(t_name,Hibernate:insertintot_emp(t_name,t_salary,t_hire_date,t_last_login,t_register)values(?,?,?,?,?)t_register字符5】Struts2HibernateStruts2和Hibernate的Jar到项目下请memory.zip<web-appversion="2.4"xmlns="h struts配置文件的<!DOCTYPEstruts"-//ApacheSoftwareFoundation//DTD<!DOCTYPEstruts"-//ApacheSoftwareFoundation//DTDStrutsConfiguration2.1//EN" "-//Hibernate/HibernateConfigurationDTD"据库连<propertyname="connection.url"><property<property<propertyname="connection.driver_class">Hibernate配置信息<!--<property<property DROPDROPTABLEIFEXISTSt_project;CREATETABLEt_project(t_idint(11)NOTNULLt_nochar(8)DEFAULTNULL,t_namevarchar(50)DEFAULTNULL,t_start_datedateDEFAULTNULL,t_end_datedateDEFAULTNULL,PRIMARYKEY(t_id))ENGINE=InnoDB select*fromINSERTINTOt_projectINSERTINTOt_projectVALUES(100,'pm000004','让INSERTINTOt_project packagepackageimportpublicclass{privateIntegerid;privateStringno;privateStringname;privateDatestartDate;privateDateendDate;publicIntegergetId(){return}}publicvoidsetId(Integerid){this.id=publicStringgetNo(){returnpublicvoidsetNo(Stringno){this.no=publicStringgetName(){returnpublicvoidsetName(Stringname){=publicDategetStartDate(){returnpublicvoidsetStartDate(DatestartDate){this.startDate=publicDategetEndDate(){returnpublicvoidsetEndDate(DateendDate){this.endDate= DTD" <classname="Project"<idname="id"type="integer"<generator 新建页面packagepackageimportorg.hibernate.Session;importpublicclassBaseDao//staticprivatestaticConfigurationconf;privatestaticSessionFactorysf;staticconf=newConfiguration();sf=}{return}publicstaticvoidmain(String[]{BaseDaodao=newBaseDao();Sessionsession=dao.openSession();}}}packageimportimportimportjavax.servlet.http.HttpServletRequest;importerceptor.ServletRequestAware;importerceptor.SessionAware;importcom.opensymphony.xwork2.ActionSupport;publicclassBaseActionextendsActionSupportimplementsSessionAware,ServletContextAware,ServletRequestAware,ServletResponseAware{protectedMap<String,Object>session;protectedHttpServletRequestrequest;protectedHttpServletResponseresponse;protectedServletContextapplication;{this.session=}{this.application=}}}this.request=}{this.response=}<!DOCTYPEstruts"-//ApacheSoftwareFoundation//DTDStrutsConfiguration2.1//EN" <actionname="list"<resultpackagepackageimportimportimportpublicclassProjectListActionextendsBaseActionprivateProjectDaoprojectDao=new//}}//privateList<Project>publicStringexecute()throws{projectList=return}publicList<Project>getProjectList()return}jectList=}packagepackageimportimportimportimportpublicclassProjectDaoextendsBaseDao**publicList<Project>{Sessionsession=Queryquery=session.createQuery("fromProject");List<Project>projectList=query.list();return}<body<div<tableclass="guide"cellSpacing="0"cellPadding="0"width="100%"<br<tableclass="tableborder"cellSpacing="0"cellPadding="0"width="100%"border="0"><tr<td <td<b>编号<td<b>名称<td<b>开始时间<td<b>结束时间<s:iterator<td<tdclass="altbg2"<ahref=""><b><s:propertyvalue="no"/></b><td<b><s:propertyvalue="name"/><td<b><s:propertyvalue="startDate"/><td<b><s:propertyvalue="endDate"/><brvalue="删除项目"/>Hibernate:Hibernate:selectproject0_.t_idast1_0_,project0_.t_noast2_0_,project0_.t_nameast3_0_,project0_.t_start_dateast4_0_,project0_.t_end_dateast5_0_fromt_projectproject0_jquery.js到项目<!DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01//EN" <script<br"""""""<!DOCTYPEstruts"-//ApacheSoftwareFoundation//DTDStrutsConfiguration2.1//EN" <actionname="list"<result<action<result点击“新建项目”跳转form页增加方增加方packageimportimportorg.hibernate.Query;importorg.hibernate.Session;importorg.hibernate.Transaction;importject.po.Project;publicclassProjectDaoextendsBaseDao{**publicList<Project>{Sessionsession=List<Project>projectList=}}return}**@parampublicvoidinsert(Project{Sessionsession=openSession();Transactiontx=session.beginTransaction(