1.首先需要在pom.xml文件中添加依赖。

需要添加的依赖如下：

         

            org.mybatis.spring.boot

            mybatis-spring-boot-starter

            1.3.2

        



        

            mysql

            mysql-connector-java

            runtime

        
/code>
code class='prism'>#配置数据源

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.url=jdbc:mysql://192.168.1.121:3306/world?useUnicode=true&characterEncoding=utf8&useSSL=false

spring.datasource.username=root

spring.datasource.password=root


#Mybatis配置

#设置mapper文件的位置

mybatis.mapperLocations=classpath:mapper/*.xml
/code>
code class='prism'>package com.youyou.address.entity;



import lombok.Data;


/**

* 数据库实体，联系人

*/

@Data

public class ContacterEO {

/**

* 主键


*/

private String id;

/**

* 姓名

*/

private String name;


/**

* 性别（0，女；1，男）

*/

private String sex;


/**

* 年龄

*/

private Integer age ;


/**

* 电话

*/

private  String phone;


/**

* 地址

*/

private String location;


/**

* 删除（0，未删除；1，删除）

*/

private String dflag ;

}
/code>
code class='prism'>package com.youyou.address.dao;



import com.youyou.address.entity.ContacterEO;


import java.util.List;


public interface ContacterDao {


void insertOne(ContacterEO contacterEO);


/**

* 查询所有

* @return

*/

List
 findAll();



}
/pre>
h2>5.编写对应mapper文件
/h2>
pre class='language-javascript'>
 







    
        INSERT INTO ts_contacter VALUES(#{id} , #{name} , #{sex} , #{age} , #{phone} , #{location} , #{dflag})
    



    
        select * from ts_contacter
    

6.编写service类

 package com.youyou.address.service;



import com.youyou.address.dao.ContacterDao;

import com.youyou.address.entity.ContacterEO;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import org.springframework.transaction.annotation.Transactional;



import java.util.List;



@Service

@Transactional

public class ContacterService {



    @Autowired

    private ContacterDao dao;



    public void insertOne(ContacterEO contacterEO){

         dao.insertOne(contacterEO);

    }



    public List findAll(){

        return dao.findAll();

    }



}

7.编写controller类

 package com.youyou.address.controller;





import com.youyou.address.entity.ContacterEO;

import com.youyou.address.service.ContacterService;

import io.swagger.annotations.Api;

import io.swagger.annotations.ApiOperation;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.bind.annotation.GetMapping;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RestController;



import java.util.List;



@Api(description = "联系人接口")

@RestController

@RequestMapping(value = "/contacter")

public class ContacterController {



    @Autowired

    private ContacterService service;



    @ApiOperation(value = "新增")

    @GetMapping("/add")

    public ContacterEO  add(ContacterEO contacterEO){

        System.out.println("添加一个联系人");



        service.insertOne(contacterEO);



        return contacterEO;

    }



    @ApiOperation(value = "查询所有")

    @GetMapping("/findAll")

    public List findAll(){

        return service.findAll();

    }



}

运行结果

数据库中数据

运行结果