1.在整合之前先来看一下我的目录结构

jpa2.jpg

2.整合mybatis当然需要在pom.xml加入相应的依赖了

  <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.31</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
        </dependency>

3.在application.properties中配置如下:

#服务器端口
server.port=9999
#数据源配置
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.url=jdbc:mysql://localhost:3306/supermarket
spring.datasource.username=root
spring.datasource.password=tiger
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#别名配置
mybatis.type-aliases-package=com.it.pojo
#映射文件的位置
mybatis.mapper-locations=classpath:mapper/*Mapper.xml

4.这里我们要给出实现代码:

(1)dao层代码

package com.it.dao;

import com.it.pojo.Users;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface UsersDao {

 List<Users> queryUsersAll();
}

上面的代码要注意如果你没有在主类中加上@MapperScan注解,那你必须要在每个dao接口中加入@Mapper注解
(2)service层代码:

package com.it.service;

import com.it.pojo.Users;

import java.util.List;

public interface UsersService {
    List<Users> queryUsersAll();
}

package com.it.service.impl;

import com.it.dao.UsersDao;
import com.it.pojo.Users;
import com.it.service.UsersService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Service
public class UsersServiceImpl implements UsersService {
    @Resource
    private UsersDao usersDao;

    @Override
    public List<Users> queryUsersAll() {
        return usersDao.queryUsersAll();
    }
}

(3)controller层代码

package com.it.controller;

import com.it.pojo.Users;
import com.it.service.UsersService;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.util.List;

@RestController
public class UsersController {
    @Resource
    private UsersService usersService;

    @RequestMapping("/users")
    public List<Users> queryUsersAll(){

        return usersService.queryUsersAll();
    }
}