整合MyBatis - 自定义mapper的实现

请结合springboot学习教程项目github地址 https://github.com/heng1234/spring-boot_one来理解

 

这里不用进行配置了因为在启动类进行了全包扫描

 

Mapper定义一个mapper接口

 

package com.yh.mapper;

import java.util.List;

import com.yh.pojo.TUser;

public interface UserMapper {

	public List<TUser> findListTuser();
}

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="com.yh.mapper.UserMapper" > 
  
  <!-- 查询简单的用户信息 -->
	<select id="findListTuser" resultType="com.yh.pojo.TUser"  >
	    select 
	    	*
	    from 
	    	t_user
	  
	</select>
</mapper>

service

@Autowired
	private UserMapper userMapper;

/**
	 * 查询全部
	 * <p>Title: findTusers</p>  
	 * <p>Description: </p>  
	 * @return
	 */
	@Override
	@Transactional(propagation=Propagation.SUPPORTS)
	public List<TUser> findTusers() {
		// TODO Auto-generated method stub
		return userMapper.findListTuser();
	}

controller

@Autowired
	private TuserService tuserService;

/**
	 * 测试mapper查询
	 * <p>Title: saveTuser</p>  
	 * <p>Description: </p>
	 */
	@RequestMapping("findTusers")
	@ResponseBody
	public List<TUser> findTusers() {
		List<TUser> list = tuserService.findTusers();
		return	list;
	}