Web Framework) Integrating Hibernate with the Spring Framework 실습

1)Maven Dependency - helloSpringMVC의 pom.xml에 추가

1.스프링에서 hibernate 연동을 위한 설정 추가

<dependency>
	<groupId>org.springframework</groupId>
	<artifactId>spring-orm</artifactId>
	<version>${org.springframework-version}</version>
</dependency>

2. hibernate 모듈 설정 추가

   <dependency>
     <groupId>org.hibernate</groupId>
     <artifactId>hibernate-core</artifactId>
     <version>5.4.28.Final</version>
   </dependency>

2)Spring Bean Configuration

스프링 컨테이너에 DataSource, SessionFactory, TransactionManager 3개의 Bean 등록 및 설정

위치 : src/main/webapp/WEB-INF/spring/appServlet/dao-context.xml

1.dataSource

<bean id="dataSource"
		class="org.apache.commons.dbcp2.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName"
			value="${jdbc.driverClassName}" />
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
</bean>

2.SessionFactory

: property ref="dataSource"는 위의 dataSource bean id와 동일해야함

<bean id="sessionFactory"
	class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
  <property name="dataSource" ref="dataSource"></property>

  <property name="packagesToScan"> <!-- 아래의 패키지 안에 @Entity가 달려 있는 것을 스캔 -->
    <list>
      <value>kr.ac.hansung.cse.model</value>
    </list>
  </property>

  <property name="hibernateProperties">
    <props>
      <prop key="hibernate.dialect">org.hibernate.dialect.MySQL8Dialect</prop>
      <prop key="hibernate.hbm2ddl.auto">create</prop>
      <prop key="hibernate.show_sql">true</prop>
      <prop key="hibernate.format_sql">false</prop>
    </props>
  </property>
</bean>

3.TransactionManager

<tx:annotation-driven transaction-manager="transactionManager" />

<bean id="transactionManager"
	class="org.springframework.orm.hibernate5.HibernateTransactionManager">
  <property name="sessionFactory" ref="sessionFactory"></property>
</bean>

<context:component-scan base-package="kr.ac.hansung.dao">	<!-- @Repository 애노테이션 달린 클래스 찾아서 bean으로 등록 -->
</context:component-scan>

<dao-context.xml 전체 코드>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">

	<context:property-placeholder
		location="/WEB-INF/props/jdbc.properties" />

	<bean id="dataSource"
		class="org.apache.commons.dbcp2.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName"
			value="${jdbc.driverClassName}" />
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	</bean>

	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>	<!-- 위의 bean id(dataSource) 와 동일해야함 -->

		<property name="packagesToScan"> <!-- 아래의 패키지 안에 @Entity가 달려 있는 것을 스캔 -->
			<list>
				<value>kr.ac.hansung.cse.model</value>
			</list>
		</property>

		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQL8Dialect</prop>
				<prop key="hibernate.hbm2ddl.auto">create</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.format_sql">false</prop>
			</props>
		</property>
	</bean>

	<tx:annotation-driven
		transaction-manager="transactionManager" />

	<bean id="transactionManager"
		class="org.springframework.orm.hibernate5.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>


	<context:component-scan base-package="kr.ac.hansung.dao">	<!-- @Repository 애노테이션 달린 클래스 찾아서 bean으로 등록 -->
	</context:component-scan>

</beans>

3)Entity Bean(with annotation) - Mapping Model Class

위치: src/main/java / kr.ac.hansung.model/ Offer.java

@Entity, @Table, @Id, @GeneratedValue , @Column

package kr.ac.hansung.model;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.validation.constraints.Digits;
import javax.validation.constraints.Email;
import javax.validation.constraints.NotEmpty;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;

import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import lombok.ToString;

@Getter
@Setter
@NoArgsConstructor
@ToString

@Entity
@Table(name="offer")
public class Offer {
	
	@Id
	@GeneratedValue(strategy=GenerationType.AUTO)
	@Column(name="offer_id")// 추가 속성 : updatable=업데이트 가능 여부/ nullable =null 가능 여부
	private int id;	//id
	
	
	@Size(min=2, max=100, message="Name must be between 2 and 100 chars")//교과목명은 2~100자리 사이로 입력 가능하다 
	private String name;	
	
	@Email(message="Please provide a valid email address")
	@NotEmpty(message="The email address cannot be empty")
	private String email;
	
	@Size(min=5, max=100, message="Text must be between 5 and 100 chars")
	private String text;
	
}

4)DAO

위치: src/main/.../dao/OfferDao

: spring jdbc -> hibernate 사용하도록

@Repository , @Transactional

package kr.ac.hansung.dao;

import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.query.Query;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import kr.ac.hansung.model.Offer;

@Repository
@Transactional
public class OfferDao {

	@Autowired
	private SessionFactory sessionFactory;

	// query and return a single object
	public Offer getOfferbyId(int id) { // CRUD 중 R 객체 하나 조회

		Session session = sessionFactory.getCurrentSession();
		Offer offer = (Offer) session.get(Offer.class, id);

		return offer;

	}

	// query and return multiple objects
	// cRud method
	public List<Offer> getOffers() { // CRUD 중 R 리스트 전체 조회

		Session session = sessionFactory.getCurrentSession();
		String hql = "from Offer"; //table 이름이 아닌 클래스 이름

	    Query<Offer> query = session.createQuery(hql, Offer.class);
	    List<Offer> offerList =  query.getResultList();

	    return offerList;

	}

	// Crud method
	public void insert(Offer offer) {// CRUD 중 C
		
		Session session = sessionFactory.getCurrentSession();
        session.saveOrUpdate(offer);
        session.flush(); //생략 가능

	}

	// crUd method
	public void update(Offer offer) {// CRUD 중 U
		
		Session session = sessionFactory.getCurrentSession();
        session.saveOrUpdate(offer);
        session.flush();

	}

	// cruD method
	public void delete(Offer offer) { // CRUD 중 D
		
        Session session = sessionFactory.getCurrentSession();
        session.delete(offer);
        session.flush();


	}

}