package com.pet.aki.cmm.model;

public class MemberVO {

	private String code = "";
	private String name = "";
	private String team = "";

	public String getCode() {
		return code;
	}

	public void setCode(String code) {
		this.code = code;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getTeam() {
		return team;
	}

	public void setTeam(String team) {
		this.team = team;
	}

}

package com.pet.aki.cmm.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.pet.aki.cmm.model.MemberVO;

@Mapper
public interface MemberMapper {

	public List<MemberVO> selectMemberList();

	public MemberVO selectMemberById(Long id);

	public void insertMember(MemberVO memberVO);
}

package com.pet.aki.cmm.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.pet.aki.cmm.mapper.MemberMapper;
import com.pet.aki.cmm.model.MemberVO;

@Service
@Transactional
public class MemberService {

	@Autowired
	MemberMapper memberMapper;

	public MemberVO selectMemberById(Long id) {
		return memberMapper.selectMemberById(id);
	}

	public List<MemberVO> selectMemberList() {
		return memberMapper.selectMemberList();
	}

	public void insertMember(MemberVO memberVO) {
		memberMapper.insertMember(memberVO);
	}

}

package com.pet.aki.cmm.web;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.pet.aki.cmm.model.MemberVO;
import com.pet.aki.cmm.service.MemberService;

@Controller
@EnableAutoConfiguration
public class HelloWorldController {

	@Autowired
	private MemberService service;

	@RequestMapping("/")
	public String index() {
		System.out.println("@RequestMapping(\"/\")");
		return "index";
	}

	@RequestMapping("/hello")
	@ResponseBody
	public String helloWorld() throws Exception {
		System.out.println("@RequestMapping(\"/hello\")");

		List<MemberVO> list = service.selectMemberList();

		for (int i = 0; i < list.size(); i++) {
			System.out.println("name : " + list.get(i).getName());
			System.out.println("team : " + list.get(i).getTeam());
		}

		return "/com/pet/aki/cmm/hello";
	}

	@RequestMapping("/insert")
	@ResponseBody
	public String insert() throws Exception {
		System.out.println("@RequestMapping(\"/insert\")");

		MemberVO vo = new MemberVO();

		vo.setName("이동국");
		vo.setTeam("전북 현대 모터스");

		service.insertMember(vo);

		return "/com/pet/aki/cmm/insert";
	}
}

package com.pet.aki;

import javax.sql.DataSource;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.Bean;
import org.springframework.core.io.Resource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

@SpringBootApplication
@MapperScan(value = { "com.pet.aki.**.mapper" })
public class AkiApplication {

	public static void main(String[] args) {
		SpringApplication.run(AkiApplication.class, args);
	}

	@Bean
	public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
		SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
		sessionFactory.setDataSource(dataSource);

		Resource[] res = new PathMatchingResourcePatternResolver().getResources("classpath:com/pet/aki/**/*Mapper.xml");
		sessionFactory.setMapperLocations(res);

		return sessionFactory.getObject();
	}

}