- PDF 無料ダウンロード

Size: px

Start display at page:

Download ""

みいかこやぎ
4 years ago
Views:

2 Spring Framework Web

3 Web Web DB AOP DI Java EE 3

4 Web WebMVC Web Java 4

5 DB H2 Database Java H2 Database Version 1.0 Zip 5

6 H2 > cd $H2_HOME/bin > java cp h2.jar org.h2.tools.server JDBC URL jdbc:h2:tcp://localhost/test JDBC Driver org.h2.driver sa 6

7 H2 7

8 3-1 H2 H2 H2 H2 8

9 SQL H2 JDBC URL SQL 9

10 3-2 (1/2) ex3.zip H2 H2 members_h2.sql SELECT * FROM MEMBER 10

11 3-2 (2/2) ex3.war Web 11

13 (1/2) Spring Framework Spring DAO (Data Access Object) JDBC 13

14 (2/2) Spring Framework Spring ORM O/R ORM Hibernate JDO ibatis Oracle TopLink JPA 14

15 JDBC Java Database Connectivity Java SE API Java API API DB SQL DB SQL 15

16 JDBC SQL 4. SQL

17 Spring Framework SQL 4. SQL SF 17

18 JdbcTemplate JdbcTemplate Spring Framework JDBC DB DB SQL ResultSet JavaBean ResultSet iteration SF 18

19 JdbcTemplate (1/2) public class MemberDaoJDBCImpl implements MemberDao { private SimpleJdbcTemplate jdbctemplate; public void setdatasource(datasource datasource) { jdbctemplate = new SimpleJdbcTemplate(dataSource); public void insert(final MemberData member) { this.jdbctemplate.update(insert_sql, new Object[] { member.getname(), member.getloginname(), member.getpassword(), member.getdepartment(), member.getphonenumber() ); MemberDaoJDBCImpl.java 19

20 JdbcTemplate (2/2) private static final String FIND_ALL_SQL = "SELECT * FROM MEMBER"; public List<MemberData> findall() { return this.jdbctemplate.query(find_all_sql, new MemberRowMapper()); class MemberRowMapper implements ParameterizedRowMapper<MemberData> { public MemberData maprow(resultset rs, int rownum) throws SQLException { MemberData result = new MemberData(); result.setid(rs.getlong("id"));...// Bean return result; MemberDaoJDBCImpl.java 20

21 DAO <beans> <bean id="memberservice" class="sample.service.memberserviceimpl"> <property name="memberdao" ref="memberdaojdbc"/> </bean> <bean id="memberdaojdbc" class="sample.dao.memberdaojdbcimpl"> <property name="datasource" ref="datasource"/> </bean> <bean id="datasource" class="org.apache.commons.dbcp.basicdatasource" destroy-method="close"> <property name="driverclassname" value="org.h2.driver"/> <property name="urn" value="jdbc:h2:tcp://localhost/test"/> <property name="username" value="sa"/> <property name="password" value=""/> 21 </bean> WEB-INF/spring-servlet.xml </beans>

22 3-3 ex33.zip /src/sample/dao/memberdaojdbcim pl.java /WebContents/WEB-INF/springservlet.xml 22

23 O/R

24 O/R Public class User { private long id; private String name; public void setid(long id) { this.id = id; public long getid() { return id; Java Mapping O/R Java Java Java Java

25 Hibernate Gavin King Java O/R ( ) ( ) XML Java RDB Java POJO HQL Lazy Loading

26 POJO public publicclass classmemberdata { private privatelong longid; id; private privatestring name; name; public publiclong longgetid() getid() { return returnid; <?xml <?xml version="1.0" version="1.0"?>?> id; <!DOCTYPE <!DOCTYPE hibernate-mapping PUBLIC PUBLIC public publicvoid voidsetid(long setid(longid) id) { "-//Hibernate/Hibernate Mapping Mapping DTD//EN" DTD//EN" this.id this.id = id; " id; mapping-3.0.dtd"> public publicstring getname() getname() { <hibernate-mapping> return returnname; <class <class name="sample.data.memberdata" name; table="member"> <id name="id" column="id"> public publicvoid voidsetname(string setname(stringname) <id name) { name="id" column="id"> <generator class="native"/> this.name this.name = name; <generator class="native"/> name; </id> </id> <property name="name" column="name" /> <property name="name" column="name" /> </class> </class> POJO </hibernate-mapping>

27 Session DB Session Factory Hibernate Session Session

28 Hibernate Spring Framework DB Session Factory Hibernate Session Spring Framework Session

29 HibernateTemplate Spring Framework Hibernate org.springframework.orm.hibernate3.hib ernatetemplate Hibernate Session

30 HibernateTemplate (1/2) public class MemberDaoHibernateImpl implements MemberDao { private HibernateTemplate hibernatetemplate; public void setsessionfactory(sessionfactory sessionfactory) { this.hibernatetemplate = new HibernateTemplate(sessionFactory); MemberDaoHibernateImpl.java 30

31 HibernateTemplate (2/2) private static final String FIND_BY_DEPARTMENT_HQL = "FROM MemberData WHERE department =?"; public void insert(final MemberData member) { this.hibernatetemplate.persist(member); public List<MemberData> findbydepartment(string department) { return this.hibernatetemplate.find( FIND_BY_DEPARTMENT_HQL, department); MemberDaoHibernateImpl.java 31

32 DAO (1/2) <beans> <bean id="memberservice" class="sample.service.memberserviceimpl"> <property name="memberdao" ref="memberdaohibernate"/> </bean> <bean id="memberdaohibernate" class="sample.dao.memberdaohibernateimpl"> <property name= sessionfactory" ref= sessionfactory"/> </bean> <bean id="datasource" class="org.apache.commons.dbcp.basicdatasource" destroy-method="close"> <property name="driverclassname" value="org.h2.driver"/> <property name="urn" value="jdbc:h2:tcp://localhost/test"/> <property name="username" value="sa"/> <property name="password" value=""/> 32 </bean> WEB-INF/spring-servlet.xml

33 DAO (2/2) <bean id="sessionfactory" class="org.springframework.orm.hibernate3.localsessionfact orybean"> <property name="datasource" ref="datasource"/> <property name="mappingresources"> <list> <value>sample/data/memberdata.hbm.xml</value> </list> </property> <property name="hibernateproperties"> <value> hibernate.dialect=org.hibernate.dialect.h2dialect hibernate.show_sql=true </value> </property> </bean> </beans> WEB-INF/spring-servlet.xml 33

34 3-4 ex34.zip /src/sample/dao/memberdaohibernateimpl.java /src/sample/data/memberdata.hbm.xml /src/sample/data/memberdata.java /WebContents/WEB-INF/spring-servlet.xml 34

35 Spring Java/J2EE Application Framework /docs/2.0.x/reference/index.html II Middle Tier Data Access 10. DAO Support 11. Data Access using JDBC 12. Object Relational Mapping (ORM) data access 35

36 JDBC Java SE Java Database Connectivity (JDBC) atabase/index.jsp Hibernate Hibernate Reference Documentation rence/en/html/ 36

Microsoft PowerPoint - JavaFesta.ppt

Microsoft PowerPoint - JavaFesta.ppt DI コンテナ Spring Framework による次世代 Java EE アプリケーション開発河村嘉之日立ソフト研究部技師 / ソリューションアーキテクト Copyright Hitachi Softweare 2005 Engineering Hitachi Co., Software Ltd. 2004 Engineering All rights reserved. Co., Ltd.