[200617.78일차] Spring 8 - 트랜잭션

DB Table 생성 및 기본틀 생성

create table userticket(
id varchar2(20),
ticketnum number(2)
);

create table systemticket(
id varchar2(20),
ticketnum number(2),
constraint constname check(ticketnum<5)
);

 

 한글 깨짐 방지 => web.xml에 아래 코드 추가 

<filter>
   <filter-name>encodingFilter</filter-name>
   <filter-class>
      org.springframework.web.filter.CharacterEncodingFilter     
   </filter-class>
   <init-param>
      <param-name>encoding</param-name>   
      <param-value>UTF-8</param-value>
   </init-param>
   <init-param>
      <param-name>forceEncoding</param-name>  
      <param-value>true</param-value>
   </init-param>
</filter>    
<filter-mapping>
   <filter-name>encodingFilter</filter-name>
   <url-pattern>/*</url-pattern>                 
</filter-mapping> 

 

 JDBC Template => pom.xml에 아래 코드 추가 

<!-- JDBC Template -->
 <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>4.1.4.RELEASE</version>
 </dependency>

 

 JDBC Template => applicationJDBC.xml 파일을 생성해서 아래 코드 추가 

<bean name="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
   <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
   <property name="url" value="jdbc:oracle:thin:@192.168.164.128:1521:xe" />
   <property name="username" value="jsp" />
   <property name="password" value="1234" />
</bean>
<bean name="template" class="org.springframework.jdbc.core.JdbcTemplate">
   <property name="dataSource" ref="dataSource" />
</bean>

TicketDTO

HomeController

(기본적으로 만들어지는 controller)

TicketDAO

TicketService 인터페이스

TicketServiceImpl

buy_ticket.jsp

buy_ticket_end.jsp

실행창

티켓 수가 5이상이면 시스템 결제 X

---

---

트랜잭션

---

문제

 

DB Table 생성