SpringBoot+MySQL+MyBatis的入门教程

摘要：历史文章如何在安装最新版安装安装最新版教程内容备注本系列开发工具均为构建项目，选择四个基本的依赖。层与其实现，这个比较简单，一般做过项目的都了解层，我这边构建了一个方法，通过获取信息。

本博客 猫叔的博客，转载请申明出处
本系列教程为HMStrange项目附带。

如何在VMware12安装Centos7.6最新版

Centos7.6安装Java8

Centos7.6安装MySQL+Redis（最新版）

备注：本系列开发工具均为IDEA

大家可以看看pom文件

    4.0.0
    
        org.springframework.boot
        spring-boot-starter-parent
        2.1.4.RELEASE
         
    
    com.myself.mybatis
    datademo
    0.0.1-SNAPSHOT
    datademo
    Demo project for Spring Boot

    
        1.8
    

    
        
            org.springframework.boot
            spring-boot-starter-web
        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.0.1
        

        
            mysql
            mysql-connector-java
            runtime
        
        
            org.projectlombok
            lombok
            true
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        
    

    
        
            
                org.springframework.boot
                spring-boot-maven-plugin
            
        
    

DDL

CREATE TABLE `t_msg` (
  `id` int(11) NOT NULL,
  `message` varchar(255) DEFAULT NULL COMMENT "信息",
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

spring:
  datasource:
    url: jdbc:mysql://192.168.192.133:3306/datademo?characterEncoding=utf-8&useSSL=false
    username: root
    password: password
    driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
  mapper-locations: classpath*:mapper/*Mapper.xml
  type-aliases-package: com.myself.mybatis.entity

package com.myself.mybatis.entity;

import lombok.Data;

import java.io.Serializable;

/**
 * Created by MySelf on 2019/4/9.
 */
@Data
public class TMsg implements Serializable {

    private Integer id;

    private String message;

}

package com.myself.mybatis.mapper;

import com.myself.mybatis.entity.TMsg;
import org.apache.ibatis.annotations.Mapper;

/**
 * Created by MySelf on 2019/4/9.
 */
@Mapper
public interface TMsgMapper {

    public TMsg findById(Integer id);

}

    
        SELECT id,message from t_msg WHERE id = #{id}
    

我这边就单纯一个方法，大家可以扩展自己的方法。

package com.myself.mybatis.service;

import com.myself.mybatis.entity.TMsg;

/**
 * Created by MySelf on 2019/4/9.
 */
public interface TMsgService {

    public TMsg findById(Integer id);

}

package com.myself.mybatis.service.impl;

import com.myself.mybatis.entity.TMsg;
import com.myself.mybatis.mapper.TMsgMapper;
import com.myself.mybatis.service.TMsgService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * Created by MySelf on 2019/4/9.
 */
@Service
public class TMsgServiceImpl implements TMsgService {

    @Autowired
    private TMsgMapper tMsgMapper;

    @Override
    public TMsg findById(Integer id) {
        return tMsgMapper.findById(id);
    }
}

package com.myself.mybatis.controller;

import com.myself.mybatis.entity.TMsg;
import com.myself.mybatis.service.TMsgService;
import org.apache.ibatis.annotations.Param;
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;

/**
 * Created by MySelf on 2019/4/9.
 */
@RestController
@RequestMapping("/msg")
public class TMsgController {

    @Autowired
    private TMsgService tMsgService;

    @GetMapping("/getMsg")
    public String getMsg(@Param("id") Integer id){
        TMsg tMsg = tMsgService.findById(id);
        return tMsg.getMessage();
    }

}

欢迎到HMStrange项目进行下载：https://github.com/UncleCatMy...

学习交流群：728698035

现架构设计（码农）兼创业技术顾问，不羁平庸，热爱开源，杂谈程序人生与不定期干货。