1

spring -> database

• jsp(tomcat pooling : jndi)

• spring <-> jdbc

1. 직접연결
   : 쿼리 -> 문자열
2. JdbcTemplate(ORM) => Hibernate(JPA)
   : 쿼리 -> 객체
3. MyBatis

JdbcTemplate(ORM)를 통해 게시판 작성

MyBatis를 통해 현재시간 출력하기

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns="http://xmlns.jcp.org/xml/ns/javaee"
	xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
	id="WebApp_ID" version="4.0">
	<display-name>web01</display-name>
	<welcome-file-list>
		<welcome-file>index.html</welcome-file>
		<welcome-file>index.jsp</welcome-file>
		<welcome-file>index.htm</welcome-file>
		<welcome-file>default.html</welcome-file>
		<welcome-file>default.jsp</welcome-file>
		<welcome-file>default.htm</welcome-file>
	</welcome-file-list>

	<!-- share data -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>/WEB-INF/root-context.xml</param-value>
	</context-param>
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>

	<!-- encoding -->
	<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>
	</filter>
	<filter-mapping>
		<filter-name>encodingFilter</filter-name>
		<url-pattern>*.do</url-pattern>
	</filter-mapping>
	<servlet>
		<servlet-name>appServlet</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>/WEB-INF/servlet-context.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>appServlet</servlet-name>
		<url-pattern>*.do</url-pattern>
	</servlet-mapping>
</web-app>

servlet-context.xml

<beans:beans xmlns="http://www.springframework.org/schema/mvc"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:beans="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"	
	xsi:schemaLocation="
	http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
	http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
	http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">
	
	<!-- <resources mapping="/resources/**" location="/resources/" /> -->
	
	 <context:component-scan base-package="config"/>
	 <context:component-scan base-package="model1"/>
	 
	 <beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
	 	<!-- 접두어 -->
	 	<beans:property name="prefix" value="/WEB-INF/views/"/>
	 	<!-- 접미어 -->
	 	<beans:property name="suffix" value=".jsp"/>
	 </beans:bean>
	 
</beans:beans>

root-context.xml

<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd">
	
	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
	 	<property name="driverClassName" value="org.mariadb.jdbc.Driver"/>
	 	<property name="url" value="jdbc:mariadb://localhost:3306/sample"/>
	 	<property name="username" value="root"/>
	 	<property name="password" value="123456"/>
	</bean>
	 
	<!-- MyBatisConfig -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	 	<property name="dataSource" ref="dataSource"/>
	 	<property name="mapperLocations" value="classpath:mappers/mapper.xml"/>
	</bean>
	 
	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
	 	<constructor-arg ref="sqlSessionFactory"/>
	</bean>
	 
</beans>

mapper.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">
<mapper namespace="mybatis">
	<!-- xml처럼 sql문 작성 -->
	<select id="selectNow" resultType="String">
		select now() as now
	</select>
</mapper>

MyBatisDAO

package model1;

@Repository
public class MyBatisDAO {

	@Autowired
	private SqlSession sqlSession;
	
	public String selectNow() {
		return sqlSession.selectOne("selectNow");
	}
}

MyBatisController

package config;

@Controller
public class MyBatisController {

	@Autowired
	private SqlSession sqlSession;
	
	@Autowired
	private JdbcDAO dao;

	@RequestMapping("/jdbc1.do")
	public String jdbc1() {
		/*
		System.out.println("jdbc1() 호출 : " + sqlSession);
		
		String result = sqlSession.selectOne("selectNow");
		System.out.println("결과 : " + result);
		*/
		String result = dao.selectNow();
		System.out.println("결과 : " + result);
		
		return "jdbc1";
	}
 }

MyBatis를 통해 emp table 출력하기

: web, servlet-context, root-context는 동일.

mapper.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">
<mapper namespace="mybatis">
	<!-- xml처럼 sql문 작성 -->
	<select id="selectName" resultType="model1.EmpTO">
		select * from emp where ename like 's%' 
	</select>
</mapper>

EmpTO

package model1;

@Getter
@Setter
public class EmpTO {
	private String empno;
	private String ename;
	private String job;
}

EmpDAO

package model1;

@Repository
public class EmpDAO {

	@Autowired
	private SqlSession sqlSession;
	
	public ArrayList<EmpTO> selectName() {
		return new ArrayList<>(sqlSession.selectList("selectName"));
	}
}

MyBatisController

package config;

@Controller
public class MyBatisController {

	@Autowired
	private SqlSession sqlSession;
	
	@Autowired
	private EmpDAO dao1;
	
	@RequestMapping("/jdbc2.do")
	public String jdbc2() {

		ArrayList<EmpTO> result = dao1.selectName();
		System.out.println("결과 : " + result);

	    for (EmpTO to : result) {
	        System.out.println(to.getEmpno());
	        System.out.println(to.getEname());
	        System.out.println(to.getJob() + "\n");
	    }
	    
		return "jdbc2";
	}
	
}