untitled

Size: px

Start display at page:

Download "untitled"

あまめさかど
9 years ago
Views:

1 JBoss Hibernate 2006 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice

4 Hibernate Hibernate O/R Mapping Tool Hibernate

5 Hibernate

6 Hibernate 2002 O/R Mapping Hibernate Core Hibernate Hibernate Annotation Hibernate EntityManager EJB3.0/JPA Hibernate Shards Horizontal Data Partitioning Hibernate Validator API Hibernate Search Apache Lucene Hibernate Tools Eclipse/Ant

7 Hibernate 3 JDK.3. JDK.4.2 JavaSE 5.0 Oracle, DB2, Sybase, MS SQL Server, PostgreSQL, MySQL, HypersonicSQL, Mckoi SQL, SAP DB, Interbase, Pointbase, Progress, FrontBase, Ingres, Informix, Firebird Java JMX.2 JTA.0.B JDBC 3.0 JNDI

8 : Hibernate Core ga : LGPL Red Hat Hibernate Core 3.2 JBoss EAP (Enterprise Application Platform) JBoss EAP EJB

9 Hibernate

10 RDB

11 SQL JDBC RDB SQL DAO Hibernate O/R Mapping Tool

12 SQL (Struts,JSF) Web :insert.; :select ; :update ; :delete ; Application Server (JBoss/Tomcat) Java SQL JDBC

13 DAO Web Data Access Object DAO JDBC Application Server (JBoss/Tomcat) Java

14 DAO Web RDB SQL DAO Application Server (JBoss/Tomcat) Java public Category findby(long id) { result = null; String sqlquery = SELECT,, + FROM WHERE = + id.tostring(); String sqlquery2 = SELECT FROM + WHERE = + id.tostring(); Connection conn = null; try { conn = getconnection(); ResultSet rs = conn.createstatement(). executequery(sqlquery); if (rs.next()) { result = new (); result.setid(rs.getlong()); result.set(rs.getstring(2)); result.set (rs.getlong(3)); // rs = conn.createstatement().executequery(sqlquery2); //... } catch (Execption e) { // } finally { if (conn!= null) conn.close(); } return result; } JDBC

15 DAO

16 Hibernate Web Hibernate DAO Hibernate O/R O/R Mapping Mapping Application Server (JBoss/Tomcat) Java public Category findbyid(long id) { Category result = null; // Hibernate Session session = HibernateUtil.getSession(); // result = (Category)session.load(.class, id); // session.close(); return result; } SQL RDB JDBC 2 3

17 Hibernate Hibernate 2 xxx-xxxx 26 2 xxx-xxxx USER_ 2 xxx-xxxx xxx-xxxx 0..*..* 0..* ISBN JBoss 2 Hibernate 2 0 Hibernate 2 xxxx-xxxxx ISBN 2007/2/3 2

18 Hibernate

19 Hibernate Hibernate 3 2 (null) Application Server Category.hbm.xml hibernate.cfg.xml Session Factory JTA Category Category DAO JDBC Session Session Session Hibernate O/R Mapping Hibernate

20 2 3 (null) Hibernate SessionFactory.openSession() Session / Session.close() Session Session Hibernate Hibernate RDB Category Application Server Hibernate Category DAO hibern ate.cf g.xml Session Factory Session Session JTA Catego O/R O/R ry.hb Mapping Mapping m.xml JDBC

22 get() load() createquery() save() saveorupdate() persist() evict() close() clear() update() saveorupdate() lock() delete() RDBHibarnate 3 Hibernate RDB Session

23 Hibernate 3 2 (null) Application ServerO/R Mapping O/R Mapping Categor y.hbm. xml hibern ate.cfg.xml Session Factory JTA Category Category DAO JDBC Session Session Session Category

24 Hibernate Order... JDBC Order... Order... Order... HTTP HTTP

25 RDB setter HibernateRDB getter RDB Hibernate lazy= true

27 . setter/getter 2. Session 3. Criteria API 4. Hibernate Query Language (HQL) 5. SQL

28 Session Session.save() Session.saveOrUpdate() Session.update() Session.delete() Session.get() Session.load() RDB RDB null RDB

29 Session public void updatecategory(category cat) { try { session = HibernateUtil.getSession(); trx = session.begingtransaction(); session.update(cat); trx.commit(); } catch (Exception e ) { if (trx!= null ) trx.rollback(); throw e; } finally { if (session!= null) session.close(); }

30 Criteria Java Session List<Category> result = SQL session.createcriteria(category.class).add( Restrictions.like( name, % ) ).addorder( Order.asc( name ) ).list(); name select, NAME, PARENT_ from CATEGORY where NAME like '%' order by NAME asc Categroy Criteria name

31 Hibernate Query Language (HQL) Hibernate SQL JOIN, WHERE, ORDER BY, GROUP BY, List<Category> result = session.createquery( FROM Category c WHERE c.name LIKE % ORDER BY c.id ).list(); SQL select, NAME, PARENT_ from CATEGORY where NAME like '%' order by NAME name

32 SQL RDBSQL List<Category> results = session.createsqlquery( SELECT source.id as {target.id}, source.name as {target.name}, source.parent_id as {target.parent_id} SQL FROM CATEGORY source WEHRE source.name LIKE % ORDER BY source.id ).addentity( target, SQL Category.class ).list();

34 Hibernate 2 JDBC JTA API JDBC JTA JDBC JTAHibernate

35 Hibernate Web Hibernate 3 2 (null) Application Server Java CategoryDAO O/R Mapping O/R Mapping O/R Mapping Hibernate Hibernate SessionFactory JTA JDBC/SQL JDBC Session Category Session Session Session Hibernate Hibernate JDBC JTA JDBC JTA

36 Hibernate Web 3 2 (null) Application Server Java CategoryDAO O/R Mapping O/R Mapping O/R Mapping Hibernate Hibernate SessionFactory JTA JDBC/SQL JDBC Session Category Session Session Session JTA Hibernate Hibernate Hibernate JTA JTA JTA JTA -

38 Hibernate Apache Commons logging Hibernate org.hibernate.sql org.hibernate.type org.hibernate.tool.hbm2ddl org.hibernate.pretty org.hibernate.cache org.hibernate.transaction org.hibernate.jdbc org.hibernate.hql.ast.ast org.hibernate.secure org.hibernate SQL JDBC DDL session JDBC HQL SQL JAAS

40 Hibernate Hibernate O/R Mapping Tool Hibernate

42 CATEGORY NAME PARENT_ 2 3 (null)

43 (null) Category.hbm.xml hibernate.cfg.xml Session Factory Category Category.java Main.java CategoryDAO.java JDBC Session Session Session Hibernate HibernateUtil.java

44 JDBC RDB JDBC msql-connector-java-5..5-bi.jar Hibernate3 Hibernate3lib hibernate3.jar antlr jar asm.jar asm-attrs.jar cglib-2..3.jar commons-collections-2...jar commons-loggin-.0.4.jar dom4j-.6..jar jta.jar log4j-.2..jar

45 Hibernate <hibernate-configuration> <session-factory> <property name="connection.driver_class"> com.mysql.jdbc.driver</property> <property name="connection.url"> jdbc:mysql://localhost:3306/hibernate</property> <property name="connection.username"> hibernate</property> <property name="connection.password"> hibernate</property> JDBC <property name="dialect"> org.hibernate.dialect.mysqlinnodbdialect</property> DataSource RDB SQL

46 Hibernate JDBC <property name="transaction.factory_class"> org.hibernate.transaction.jdbctransactionfactory</property> <property name="show_sql">false</property> SQL <property name="hbm2ddl.auto">create-drop</property> <mapping resource= dao/category.hbm.xml /> </session-factory> </hibernate-configuration> O/R Mapping SessionFactory

47 Category public class Category { private Long id; // private String name; // private Category parent; // private Set<Category> children; // } // setter/getter

48 Category O/R Mapping public class Category { Long id; String name; Category parent; Set<Category> children; } CATEGORY NAME PARENT_ (null) 2 3 <hibernate-mapping> <class name= Category table= CATEGORY > <id name="id" type="java.lang.long"> <column name="" /> <generator class="native" /> </id> <property name="name" type="string"> <column name="name" /> </property> name Category CATEGORY

49 Category O/R Mapping <many-to-one name="parent" class="category"> <column name="parent_" /> </many-to-one> <set name= children" lazy= true table= CATEGORY > <key column name="parent_"/> <one-to-many class= Category /> </set> </class> </hibernate-mapping> PARENT_ public class Category { Long id; String name; Category parent; Set<Category> children; } CATEGORY NAME PARENT_ 2 3 PARENT_ (null)

50 HibernateUtil Hiberante public class HibernateUtil { private static final SessionFactory sessionfactory; static { try { sessionfactory = new Configuration().configure().buildSessionFactory(); } catch (Throwable e) { throw new ExceptionInitializerError(e); } Hibernate } } public static Session getsession() { return sessionfactory.opensession(); } Hibernate

51 CategoryDAO public Category changename(long id, String newname) { Session session = null; Transaction trx = null; try { session = HibernateUtil.getSession(); trx = session.begingtransaction(); 2 3 CATEGORY NAME PARENT_ (null) JDBC ResultSetPOJO Category category = (Category)session.get(Category.class, new Long(Id)); category.setname(newname); trx.commit(); } catch (Exception e) { // trx.rollback(); } finally { session.close(); }

52 CategoryDAO Session session = HibernateUtil.getSession(); CATEGORY NAME PARENT_ (null) 2 3 Catgegory parent = (Category)session.get(Category.class, new Long(parent)); System.out.println( Category: + parent.getname()); Set<Category> children = parent.getchildren(); if (children!= null && children.size() > 0) for (Category child : children) System.out.println( - + child.getname());

Microsoft PowerPoint - 4-MySQL50_JDBC_failover.ppt

Microsoft PowerPoint - 4-MySQL50_JDBC_failover.ppt MySQL5.0 JDBC ドライバフェイルオーバ機能日本ヒューレットパッカード株式会社オープンソースコンピテンシセンター 2006 年 8 月 31 日 2006 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice 目次