Spring Data JPA 맛보기 (2)

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





1. 테이블 생성



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


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





2. domain, repository 소스 구성

Member 클래스: id 컬럼을 기본적으로 제공해주는 AbstractPersistable 를 상속받습니다.

- kr.co.vicki.sample.spring.data.jpa.domain.Member

<br/> package kr.co.vicki.sample.spring.data.jpa.domain;<br/><br/>import java.util.Date;<br/><br/>import javax.persistence.Column;<br/>import javax.persistence.Entity;<br/><br/>import org.springframework.data.jpa.domain.AbstractPersistable;<br/><br/>@Entity<br/>public class Member extends AbstractPersistable<Long> {<br/><br/> private static final long serialVersionUID = -7580946962260808515L;<br/> <br/> @Column(name = "MEMBER_ID", nullable = false)<br/> private String memberId;<br/> <br/> @Column(name = "MEMBER_NAME", nullable = false)<br/> private String memberName;<br/> <br/> @Column(name = "MEMBER_DESC")<br/> private String memberDesc;<br/> <br/> @Column(name = "INSERT_DATE")<br/> private Date insertDate;<br/> <br/> @Column(name = "UPDATE_DATE")<br/> private Date updateDate;<br/><br/> /**<br/> * @return the memberId<br/> */<br/> public String getMemberId() {<br/> return memberId;<br/> }<br/><br/> /**<br/> * @param memberId the memberId to set<br/> */<br/> public void setMemberId(String memberId) {<br/> this.memberId = memberId;<br/> }<br/><br/> /**<br/> * @return the memberName<br/> */<br/> public String getMemberName() {<br/> return memberName;<br/> }<br/><br/> /**<br/> * @param memberName the memberName to set<br/> */<br/> public void setMemberName(String memberName) {<br/> this.memberName = memberName;<br/> }<br/><br/> /**<br/> * @return the memberDesc<br/> */<br/> public String getMemberDesc() {<br/> return memberDesc;<br/> }<br/><br/> /**<br/> * @param memberDesc the memberDesc to set<br/> */<br/> public void setMemberDesc(String memberDesc) {<br/> this.memberDesc = memberDesc;<br/> }<br/><br/> /**<br/> * @return the insertDate<br/> */<br/> public Date getInsertDate() {<br/> return insertDate;<br/> }<br/><br/> /**<br/> * @param insertDate the insertDate to set<br/> */<br/> public void setInsertDate(Date insertDate) {<br/> this.insertDate = insertDate;<br/> }<br/><br/> /**<br/> * @return the updateDate<br/> */<br/> public Date getUpdateDate() {<br/> return updateDate;<br/> }<br/><br/> /**<br/> * @param updateDate the updateDate to set<br/> */<br/> public void setUpdateDate(Date updateDate) {<br/> this.updateDate = updateDate;<br/> }<br/><br/>}<br/>



IMemberRepository 클래스: id 를 이용하여 기본적인 CRUD 를 제공해주는 CrudRepository 를 상속받습니다.

- kr.co.vicki.sample.spring.data.jpa.repository.IMemberRepository

<br/> package kr.co.vicki.sample.spring.data.jpa.repository;<br/><br/>import kr.co.vicki.sample.spring.data.jpa.domain.Member;<br/><br/>import org.springframework.data.repository.CrudRepository;<br/><br/>public interface IMemberRepository extends CrudRepository<Member, Long> {<br/><br/>}<br/>





3. 환경 설정

/META-INF/persistence.xml (JPA 설정)

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


/infrastructure.xml (DB 환경 설정)

<br/> <?xml version="1.0" encoding="UTF-8"?><br/><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"<br/> xmlns:jdbc="http://www.springframework.org/schema/jdbc"<br/> xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd<br/> http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd"><br/><br/> <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"><br/> <property name="dataSource" ref="dataSource" /><br/> <property name="jpaVendorAdapter"><br/> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"><br/> <property name="showSql" value="true" /><br/> <property name="database" value="ORACLE" /><br/> </bean><br/> </property><br/> </bean><br/><br/> <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"><br/> <property name="entityManagerFactory" ref="entityManagerFactory" /><br/> </bean><br/><br/> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"><br/> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" /><br/> <property name="url" value="jdbc:oracle:thin:@[IP]:1521/[SID]" /><br/> <property name="username" value="[username]" /><br/> <property name="password" value="[password]" /><br/> </bean><br/><br/></beans><br/>


/repository-context.xml (jpa repository 등록)

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




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