1. STS로 Spring MVC Project 생성 후 접속 확인
- 한글이 깨져서 나오니 home.jsp 파일에
<%@ page language="java" contentType="text/html; charset=UTF-8" %> 추가
2. pom.xml에 dependency 추가
(버전 확인 - http://mvnrepository.com/)
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.2.7</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.31</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>3.2.3.RELEASE</version>
</dependency>
3. root-context.xml에 bean 추가
<bean id="dataSource" class="org.apache.ibatis.datasource.pooled.PooledDataSource">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/스키마이름"/>
<property name="username" value="계정"/>
<property name="password" value="암호"/>
</bean>
<bean id ="sqlSessionFactory" class= "org.mybatis.spring.SqlSessionFactoryBean" >
<property name ="dataSource" ref= "dataSource"></property >
<property name ="configLocation"
value= "classpath:/mybatis/mybatis-config.xml" >
</property >
</bean >
<bean id ="transactionManager"
class= "org.springframework.jdbc.datasource.DataSourceTransactionManager" >
<property name ="dataSource" ref= "dataSource"></property >
</bean >
<bean id ="sqlSession"
class= "org.mybatis.spring.SqlSessionTemplate" >
<constructor-arg ref= "sqlSessionFactory"></constructor-arg >
</bean >
4. mybatis-config.xml 생성
(src/main/resources/mybatis/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>
<mappers >
<mapper resource ="/mybatis/mapper-sample.xml"/>
</mappers >
</configuration>
5. mapper-sample.xml 생성
(src/main/resources/mybatis/mapper-sample.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= "userControlMapper" >
<select id ="selectSample" parameterType="java.util.HashMap" resultType= "java.util.HashMap">
SELECT *
FROM TEST_USERS
WHERE NAME = #{name}
</select>
<insert id ="insertTable01" parameterType="java.util.HashMap" >
INSERT INTO TEST_USERS
(NAME, EMAIL)
VALUES
( #{name}, #{email} )
</insert>
</mapper>
6. MySQL에 테스트 table과 data 준비
CREATE TABLE `스키마이름`.`TEST_USERS` (
`NO` INT NOT NULL AUTO_INCREMENT,
`NAME` VARCHAR(100) NULL,
`EMAIL` VARCHAR(100) NULL,
PRIMARY KEY (`NO`),
UNIQUE INDEX `NO_UNIQUE` (`NO` ASC));
INSERT INTO TEST_USERS (NAME, EMAIL) VALUES ("han", "han@test.com");
7. HomeController.java 수정
@Controller
public class HomeController {
@Controller
public class HomeController {
// <--- 추가
@Autowired
private SqlSession sqlSession;
// 추가 --->
private static final Logger logger = LoggerFactory.getLogger(HomeController.class);
/**
* Simply selects the home view to render by returning its name.
*/
@RequestMapping(value = "/", method = RequestMethod.GET)
public String home(Locale locale, Model model) {
logger.info("Welcome home! The client locale is {}.", locale);
Date date = new Date();
DateFormat dateFormat = DateFormat.getDateTimeInstance(DateFormat.LONG, DateFormat.LONG, locale);
String formattedDate = dateFormat.format(date);
model.addAttribute("serverTime", formattedDate );
// <--- 추가
HashMap<String, String> input = new HashMap<String, String>();
input.put("name", "han");
List<HashMap<String, String>> outputs = sqlSession.selectList("userControlMapper.selectSample", input);
System.out.println(outputs.toString());
// 추가 --->
return "home";
}
}
8. 브라우저로 server 접속 후 Console 출력 확인
- [{NO=1, EMAIL=han@test.com, NAME=han}]
참고 :
http://blog.naver.com/refreshin/150170189512
http://hangaebal.blogspot.kr/2014/08/spring-spring-tool-suitests-mysql.html