[멀티캠퍼스] 풀스택 개발자 아카데미 (23) - Spring Framework(3)

<dependencies>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>5.2.25.RELEASE</version>
    </dependency>

    <dependency>
        <groupId>org.apache.commons</groupId>
        <artifactId>commons-dbcp2</artifactId>
        <version>2.9.0</version>
    </dependency>

    <dependency>
        <groupId>com.oracle.database.jdbc</groupId>
        <artifactId>ojdbc11</artifactId>
        <version>23.3.0.23.09</version>
    </dependency>

    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.14</version>
    </dependency>

    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>3.0.3</version>
    </dependency>

    </dependencies>

<?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:jdbc="http://www.springframework.org/schema/jdbc"
       xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
       xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc.xsd
              http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd
              http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
              http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">

    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="url" value="jdbc:oracle:thin:@localhost:1521:XE"/>
        <property name="username" value="your_db_username"/>
        <property name="password" value="your_db_password"/>
        <property name="initialSize" value="5"/>
        <property name="maxTotal" value="10"/>
    </bean>
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="mapperLocations" value="classpath:/mappers/**/*.xml"/>
        <property name="typeAliasesPackage" value="com.example.spring.model"/>
    </bean>

    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg index="0" ref="sqlSessionFactory"/>
    </bean>


    <mybatis-spring:scan base-package="com.example.practice.product.dao"/>


</beans>

package com.example.practice.product.dao;

import com.example.practice.product.model.ProductVO;
import java.util.List;

public interface IProductDAO {
    // 상품 전체 목록 조회
    List<ProductVO> listAllProduct();

    // 상품 상세 정보 조회
    ProductVO detailViewProduct(String prdNo);

    // 상품 등록
    void insertProduct(ProductVO vo);

    // 상품 수정
    void updateProduct(ProductVO vo);

    // 상품 삭제
    void deleteProduct(String prdNo);

    // 상품 번호 중복 체크
    String prdNoCheck(String prdNo);
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.example.practice.product.dao.ProductMapper">

    <select id="listAllProduct" resultType="ProductVO">
        SELECT * FROM product ORDER BY prdNo ASC
    </select>

    <select id="detailViewProduct" parameterType="string" resultType="ProductVO">
        SELECT * FROM product WHERE prdNo = #{prdNo}
        </select>

    <insert id="insertProduct" parameterType="ProductVO">
        INSERT INTO product (prdNo, prdName, prdPrice, prdCompany, prdStock, prdDate)
        VALUES (#{prdNo}, #{prdName}, #{prdPrice}, #{prdCompany}, #{prdStock}, SYSDATE)
        </insert>

    <update id="updateProduct" parameterType="ProductVO">
        UPDATE product
        SET prdName = #{prdName},
            prdPrice = #{prdPrice},
            prdCompany = #{prdCompany},
            prdStock = #{prdStock}
        WHERE prdNo = #{prdNo}
    </update>

    <delete id="deleteProduct" parameterType="string">
        DELETE FROM product WHERE prdNo = #{prdNo}
    </delete>

    <select id="prdNoCheck" parameterType="string" resultType="string">
        SELECT prdNo FROM product WHERE prdNo = #{prdNo}
    </select>

</mapper>

package com.example.practice.product.service;

import com.example.practice.product.dao.ProductMapper;
import com.example.practice.product.model.ProductVO;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service; // @Service 어노테이션
import java.util.List;

@Service // 이 클래스는 서비스 계층의 빈임을 선언
public class ProductService { // 또는 IProductService 인터페이스 구현

    // @Autowired를 통해 Mapper 인터페이스(빈)를 주입받음
    private final ProductMapper productMapper;

    @Autowired // 생성자 주입 방식 권장
    public ProductService(ProductMapper productMapper) {
        this.productMapper = productMapper;
    }

    public List<ProductVO> listAllProduct() {
        return productMapper.listAllProduct(); // Mapper 메소드 호출
    }

    // ... (detailView, insert, update, delete 등 다른 메소드들)
}

package com.example.spring.controller;

import com.example.practice.product.model.ProductVO;
import com.example.practice.product.service.ProductService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import java.util.List;

@Controller
@RequestMapping("/product") // 클래스 레벨에서 공통 경로 설정
public class ProductController {

    private final ProductService productService;

    @Autowired
    public ProductController(ProductService productService) {
        this.productService = productService;
    }

    @RequestMapping(value = "/list", method = RequestMethod.GET)
    public String listProducts(Model model) {
        List<ProductVO> productList = productService.listAllProduct();
        model.addAttribute("productList", productList);
        return "product/productList"; // /WEB-INF/views/product/productList.jsp
    }

    // ... (상품 등록 폼, 등록 처리, 상세 보기 등 다른 핸들러 메소드들)
}