Spring Data JPA 맛보기 (2)

이전 포스팅에 이어 샘플 소스를 작성해보도록 하겠습니다.


1. 테이블 생성
샘플 테스트에 사용할 테이블을 아래 스크립트를 실행시켜 생성합니다.

CREATE TABLE "MEMBER" ( "ID" NUMBER NOT NULL, "MEMBER_ID" VARCHAR2(20) NOT NULL, "MEMBER_NAME" VARCHAR2(25) NOT NULL, "MEMBER_DESC" VARCHAR2(25) NULL, "INSERT_DATE" DATE DEFAULT SYSDATE NULL, "UPDATE_DATE" DATE DEFAULT SYSDATE NULL, CONSTRAINT "PK_MEMBER" PRIMARY KEY("ID") )


2. domain, repository 소스 구성

Member 클래스: id 컬럼을 기본적으로 제공해주는 AbstractPersistable 를 상속받습니다.
- kr.co.vicki.sample.spring.data.jpa.domain.Member
package kr.co.vicki.sample.spring.data.jpa.domain; import java.util.Date; import javax.persistence.Column; import javax.persistence.Entity; import org.springframework.data.jpa.domain.AbstractPersistable; @Entity public class Member extends AbstractPersistable<Long> { private static final long serialVersionUID = -7580946962260808515L; @Column(name = "MEMBER_ID", nullable = false) private String memberId; @Column(name = "MEMBER_NAME", nullable = false) private String memberName; @Column(name = "MEMBER_DESC") private String memberDesc; @Column(name = "INSERT_DATE") private Date insertDate; @Column(name = "UPDATE_DATE") private Date updateDate; /** * @return the memberId */ public String getMemberId() { return memberId; } /** * @param memberId the memberId to set */ public void setMemberId(String memberId) { this.memberId = memberId; } /** * @return the memberName */ public String getMemberName() { return memberName; } /** * @param memberName the memberName to set */ public void setMemberName(String memberName) { this.memberName = memberName; } /** * @return the memberDesc */ public String getMemberDesc() { return memberDesc; } /** * @param memberDesc the memberDesc to set */ public void setMemberDesc(String memberDesc) { this.memberDesc = memberDesc; } /** * @return the insertDate */ public Date getInsertDate() { return insertDate; } /** * @param insertDate the insertDate to set */ public void setInsertDate(Date insertDate) { this.insertDate = insertDate; } /** * @return the updateDate */ public Date getUpdateDate() { return updateDate; } /** * @param updateDate the updateDate to set */ public void setUpdateDate(Date updateDate) { this.updateDate = updateDate; } }


IMemberRepository 클래스: id 를 이용하여 기본적인 CRUD 를 제공해주는 CrudRepository 를 상속받습니다.
- kr.co.vicki.sample.spring.data.jpa.repository.IMemberRepository
package kr.co.vicki.sample.spring.data.jpa.repository; import kr.co.vicki.sample.spring.data.jpa.domain.Member; import org.springframework.data.repository.CrudRepository; public interface IMemberRepository extends CrudRepository<Member, Long> { }


3. 환경 설정

/META-INF/persistence.xml (JPA 설정)
<?xml version="1.0" encoding="UTF-8"?> <persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"> <persistence-unit name="spring-jpa" /> </persistence>

/infrastructure.xml (DB 환경 설정)
<?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:jdbc="http://www.springframework.org/schema/jdbc" xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd"> <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="jpaVendorAdapter"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"> <property name="showSql" value="true" /> <property name="database" value="ORACLE" /> </bean> </property> </bean> <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@[IP]:1521/[SID]" /> <property name="username" value="[username]" /> <property name="password" value="[password]" /> </bean> </beans>

/repository-context.xml (jpa repository 등록)
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:jpa="http://www.springframework.org/schema/data/jpa" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa.xsd"> <import resource="infrastructure.xml" /> <jpa:repositories base-package="kr.co.vicki.sample.spring.data.jpa.repository" /> </beans>



이제 테스트 코드를 만들일만 남았습니다.