Java -- springboot 配置 Mybatis

1、配置 maven 依赖

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>1.1.1</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>5.1.10</version>
</dependency>
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.3</version>
</dependency>

2、搭建 mvc 结构 -- User.java

package com.vim.modules.web.model;


import java.io.Serializable;

public class User implements Serializable {

    private String id;

    private String name;

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

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

    @Override
    public String toString() {
        return "User{" +
                "id='" + id + '\'' +
                ", name='" + name + '\'' +
                '}';
    }
}

3、搭建 mvc 结构 -- UserDao.java

package com.vim.modules.web.dao;


import com.vim.modules.web.model.User;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface UserDao {

    User getUser(String id);

    List<User> findList(User user);
}

4、搭建 mvc 结构 -- UserService.java

package com.vim.modules.web.service;

import com.github.pagehelper.PageInfo;
import com.vim.modules.web.dao.UserDao;
import com.vim.modules.web.model.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService {

    @Autowired
    private UserDao userDao;

    public User getUser(String id){
        return userDao.getUser(id);
    }

    public List<User> findList(User user){
        return userDao.findList(user);
    }

    public PageInfo<User> findListPage(User user){
        return new PageInfo<>(findList(user));
    }
}

5、搭建 mvc 结构 -- UserController.java

package com.vim.modules.web.controller;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.vim.modules.web.model.User;
import com.vim.modules.web.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

@Controller
public class UserController {

    @Autowired
    private UserService userService;

    @RequestMapping(value = "/user")
    @ResponseBody
    public User get(@RequestParam(value = "id") String id){
        return userService.getUser(id);
    }

    @RequestMapping(value = "/userList")
    @ResponseBody
    public PageInfo<User> userList(
            @RequestParam(value = "pageNum") Integer pageNum,
            @RequestParam(value = "pageSize") Integer pageSize, User user){
        PageHelper.startPage(pageNum, pageSize);
        return userService.findListPage(user);
    }
}

6、搭建 mvc 结构 -- User.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.vim.modules.web.dao.UserDao">

    <select id="getUser" resultType="User">
        SELECT *
        FROM user a
        WHERE a.id = #{id}
    </select>

    <select id="findList" resultType="User">
        SELECT *
        FROM user a
    </select>
</mapper>

8、配置文件 -- application.properties

server.context-path=/mybatis
server.port=8082

mybatis.mapper-locations=classpath:mapper/*.xml
mybatis.type-aliases-package=com.vim.modules.web.model
mybatis.configuration.mapUnderscoreToCamelCase=true
pagehelper.helperDialect=mysql

spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://10.10.1.16:3306/maven_ssm?useUnicode=true&characterEncoding=utf-8
spring.datasource.username = root
spring.datasource.password = 123456

9、启动类

package com.vim;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.vim.modules.web.dao")
public class MybatisApplication {
    public static void main( String[] args ) {
        SpringApplication.run(MybatisApplication.class, args);
    }
}