springboot mybatis

本例采用springboot+mybtais技术对数据库表进行查询等操作，适合初学者。

结构：

连接配置使用：application.properties application.yml

sql:

CREATE TABLE `person` (
  `id` varchar(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `age` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

mapper:

import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.MySqlMapper;

/**
 * Created by Jack on 2017/7/20.
 */
public interface MyMapper<T> extends Mapper<T> , MySqlMapper<T>{
    //FIXME 特别注意，该接口不能被扫描到，否则会出错
}

/**
 * Created by Jack on 2017/7/20.
 */
public interface PersonMapper extends MyMapper<Person>{
}

service:

import com.github.pagehelper.PageHelper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * Created by Jack on 2017/7/20.
 */
@Service
public class PersonService {

    @Autowired
    private PersonMapper personMapper;

    public List<Person> getAll(Person person){
        if(person.getPage()!=null && person.getRows()!=null){
            PageHelper.startPage(person.getPage(),person.getRows());

        }
        return personMapper.selectAll();
    }
}

controller:

import com.fasterxml.jackson.databind.JavaType;
import com.fasterxml.jackson.databind.ObjectMapper;
import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.ArrayList;
import java.util.List;

/**
 * Created by Jack on 2017/7/20.
 */
@RestController
@RequestMapping(value = "/persons")
public class PersonController {

    private Logger logger = Logger.getLogger(PersonController.class);

    
    @Autowired
    private PersonService personService;




    //获取person所有信息
    @GetMapping
    public Object get(Person person){

      
        List<Person> list = new ArrayList<>();
        try
        {
             list = personService.getAll(person);
        }
        catch (Exception e)
        {
            e.printStackTrace();

        }
        return new ResponseEntity<>(new Result(HttpStatus.OK.value(), list, HttpStatus.OK), HttpStatus.OK);
    }

   
}

在postman模拟请求：

浏览器端：

下载：http://download.youkuaiyun.com/detail/carl_jiang/9905322 ，

请注意，使用tomcat8运行本例。