<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
    <dependency>
		<groupId>org.mybatis</groupId>
		<artifactId>mybatis</artifactId>
		<version>3.5.5</version>
    </dependency>
    <dependency>
		<groupId>org.mybatis</groupId>
		<artifactId>mybatis-spring</artifactId>
		<version>2.0.5</version>
	</dependency>
    <!-- https://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2 -->
	<dependency>
		<groupId>org.apache.commons</groupId>
		<artifactId>commons-dbcp2</artifactId>
		<version>2.7.0</version>
	</dependency>

<!--SQL session Template 클래스를 빈으로 등록 -->
<!-- id 첫번째 글자는 무조건 소문자!  -->
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
	<constructor-arg ref="sqlSessionFactory" />
</bean>

<!-- SQL session FactoryBean 클래스 빈으로 등-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<property name="dataSource" ref="dataSource" />
	<property name="configLocation" value="classpath:config/SqlMapConfig.xml" />
    <!-- mapperLocations를 통해 사용할 Mapper XML파일을 등록-->
	<property name="mapperLocations">
		<list>
		<value>classpath:config/*Mapper.xml</value>
        	</list>
<!-- <value>classpath:config/*Mapper.xml</value> 는 -->
<!-- <value>classpath:config/UserMapper.xml</value>
    <value>classpath:config/StudentMapper.xml<value> 와 같은 설정 -->
	</property>
</bean>


<!-- BasicDataSource Bean으로 등록  -->
<!-- value는 properties파일에서 불러옴 -->
<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" >
	<property name="driverClassName" value="${db.driverClass}" />
	<property name= "url" value="${db.url}" />
	<property name="username" value="${db.username}" />
	<property name="password" value="${db.password}" />
</bean>

<?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>
	<typeAliases>
    <!-- alias로 자바객체 연결 -->
		<typeAlias alias="User" type="myspring.user.vo.UserVO" />
		<typeAlias alias="Person" type="myspring.user.vo.PersonVO" />
		<typeAlias alias="Student" type="myspring.user.vo.StudentVO" />
		<typeAlias alias="Dept" type="myspring.user.vo.DeptVO" />
		<typeAlias alias="Course" type="myspring.user.vo.CourseVO" />
		<typeAlias alias="CourseStatus" type="myspring.user.vo.CourseStatusVO" />
	</typeAliases>

</configuration>

<?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="myspring.user.dao.mapper.UserMapper"> -->
<mapper namespace="userNS">
	<select id="selectUserById" parameterType="string" resultType="User">
		select * from users where userid=#{value}
	</select>

	<select id="selectUserList" resultType="User">
		select * from users order by userid
	</select>

	<insert id="insertUser" parameterType="User">
    	<!-- getuserId, getName, getGender, getCity로 여기 받아옴 -->
		insert into users
		values
		(
		#{userId},
		#{name},
		#{gender},
		#{city}
		)
	</insert>

	<update id="updateUser" parameterType="User">
		update users set
		name = #{name},
		gender = #{gender},
		city = #{city}
		where userid = #{userId}
	</update>

	<delete id="deleteUser" parameterType="string">
		delete from users where
		userid = #{value}
	</delete>
</mapper>

 <mapper namespace="studentNS">

	<resultMap id="studentDeptResultMap" type="Student">
	<!--type="Student" 는 StudentVO를 인자로 받겠다는 뜻 -->
	<!-- property="name" 는 StudentVO 클래스 내의 setName를 의미 -->

     	<!-- 테이블의 칼럼명이 StudentVO의 setter method와 다르기때문에 resultMap으로 하나하나 매핑해줌 -->
		<id property="id" column="stu_id" javaType="Integer" jdbcType="NUMERIC" />
		<result property="name" column="stu_name" javaType="String"
			jdbcType="VARCHAR" />
		<result property="age" column="stu_age" javaType="Integer"
			jdbcType="NUMERIC" />
		<result property="grade" column="stu_grade" javaType="String"
			jdbcType="VARCHAR" />
		<result property="daynight" column="stu_daynight" javaType="String"
			jdbcType="VARCHAR" />

			<!-- deptResultMap 참조 : Association 태그 사용 -->
		<association property="dept" column="dept_id" javaType="Dept"
			resultMap="deptResultMap" />
	</resultMap>

	<resultMap id="deptResultMap" type="Dept">
		<id property="deptid" column="dept_id" javaType="Integer" jdbcType="NUMERIC" />
		<result property="deptname" column="dept_name" javaType="String"
			jdbcType="VARCHAR" />
	</resultMap>

    <!-- SQL 쿼리 -->
	<select id="selectStudentCourseStatusById" resultMap="studentCourseStatusResultMap">
	select  s.stu_id,
		    s.stu_name,
		    s.stu_age,
		    s.stu_grade,
		    s.stu_daynight,
	        d.dept_id,
	        d.dept_name,
		    c.course_id,
		    c.course_name,
		    c.course_instructor,
		    t.status_id,
		    t.COURSE_SCORE
		from  student s, COURSE_STATUS t, course c, dept d
		where s.stu_id = t.stu_id
		  and s.DEPT_ID = d.DEPT_ID
		  and t.course_id = c.course_id
	</select>
</mapper>