<!-- applicationContext.xml 파일 에서-->
<beans>
    <!-- 빈을 생성하는 다양한 방법들 -->
    <!-- DI : 빈 정의 -->
    <bean id="ko" class="aDI.firstTime.MessageBeanKoImpl"/>
    <bean id="en" class="aDI.firstTime.MessageBeanEnImpl"/>

    <!-- 생성자의 인자로 빈을 생성-->
    <bean id="member" class=" aDI.firstTime.MemberBean">
        <constructor-arg value="홍길국"/>
        <constructor-arg value="23" type="int"/>
        <constructor-arg>
            <value>안녕하세요</value>
        </constructor-arg>
    </bean>

    <!-- 생성자의 setter를 이용하여 생성-->
    <bean id="member2" class=" aDI.firstTime.MemberBean">
        <property name="name" value="홍길도"/>
        <property name="age">
            <value>55</value>
        </property>
        <property name="message" value="즐거운 스프링"/>
    </bean>

    <!--
    생성자의 인자로 빈을 생성
    DAO에서 활용할 memberBean의 형태로 만든 빈을 참조하는 방법
    객체를 참조할때는 ref, 값을 입력할 때는 value
    -->
    <bean id="dao1" class="aDI.firstTime.MemberDAO">
        <constructor-arg ref="member"/>
    </bean>

    <bean id="dao2" class="aDI.firstTime.MemberDAO">
        <constructor-arg name="member" ref="member2"/>
    </bean>

    <bean id="beanList" class="aDI.firstTime.ListBean">
        <property name="intList">
            <list>
                <value>22</value>
                <value>33</value>
                <value>44</value>
            </list>
        </property>
        <property name="memberList">
            <list>
                <ref bean="m1"/>
                <ref bean="m2"/>
                <bean class="aDI.firstTime.MemberBean"/>
            </list>
        </property>
    </bean>
    <bean id="m1" class="aDI.firstTime.MemberBean"/>
    <bean id="m2" class="aDI.firstTime.MemberBean"/>

</beans>

<!-- applicationContext.xml 파일 에서, 컴포넌트 스캔 범위를 설정해줄 수 있다 -->
<!-- annotation이 붙은 클래스를 탐색하여 DI 컨테이너에 자동으로 등록 -->
<context:component-scan base-package="lastlast.aDI"/>

<!-- database-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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
    <!-- 내가 만든 database에 관한 변수들을 현재 파일에서 사용하겠다-->
    <context:property-placeholder location="classpath: database.properties"/>
    <!-- org.apache.commons.dbcp.BasicDataSource-->
    <!-- DataSource 설정 DB 와의 연결-->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.dbDriver}"></property>
        <property name="url" value="${jdbc.dbUrl}"></property>
        <property name="username" value="${jdbc.dbId}"></property>
        <property name="password" value="${jdbc.dbPw}"></property>
    </bean>

    <!-- Spring JDBC 설정-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!-- 해당 경로에 존재하는 컴포넌트를 스캔하여 bean 객체를 생성-->
    <context:component-scan base-package=" lastlast.db.board"/>
</beans>

<!-- pom.xml 에 관련 dependency를 추가해준다-->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.6</version>
</dependency>

        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency>

<!—mybatis-config.xml 파일을 생성해 -->
        <?xml version='1.0' encoding='UTF-8'?>
        <!DOCTYPE configuration
                PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
                "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- properties 설정-->
<properties resource=" database.properties"/>
<!--alias 설정-->
<typeAliases>
    <typeAlias type="com.system.lastlast.A0208.db.board.BoardVO" alias="board"/>
</typeAliases>
<!-- dataSource 설정-->
<environments default="development">
    <environment id="development">
        <transactionManager type="JDBC"/>
        <dataSource type="POOLED">
            <property name="driver" value="${jdbc.dbDriver}"></property>
            <property name="url" value="${jdbc.dbUrl}"></property>
            <property name="username" value="${jdbc.dbId}"></property>
            <property name="password" value="${jdbc.dbPw}"></property>
        </dataSource>
    </environment>
</environments>

<!--sql mapper 설정-->
<mappers>
    <mapper resource="board-mapping.xml"/>
</mappers>
</configuration>

<!-- board-mapping.xml 파일을 생성해-->
<?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">
<!-- sql문을 작성해준다-->
<mapper namespace="BoardDAO">
    <insert id="insertBoard" parametertype="board">
        INSERT INTO board(seq, title, writer, content, regdate, cnt)
        VALUES (board_seq.nextval, #{title}, #{writer}, #{content}, SYSDATE, 0)
    </insert>
</mapper>