Springboot整合mybatis的步骤

<!--   mybatis整合     -->

< dependency >

< groupId >org.mybatis.spring.boot</ groupId >

     < artifactId >mybatis-spring-boot-starter</ artifactId >

     < version >2.1.4</ version >

</ dependency >

spring:

   datasource:

     username: root

     password: 123456

     url: jdbc:mysql: //localhost :3306 /mybatis ?serverTimezone=UTC&useUnicode= true &characterEncoding=utf-8

     driver-class-name: com.mysql.cj.jdbc.Driver

package com.example.pojo;

import lombok.AllArgsConstructor;

import lombok.Data;

import lombok.NoArgsConstructor;

@Data

@AllArgsConstructor

@NoArgsConstructor

public class User {

     private Integer id;

     private String name;

     private String pwd;

}

<!-- lombok     -->

< dependency >

     < groupId >org.projectlombok</ groupId >

     < artifactId >lombok</ artifactId >

</ dependency >

package com.example.mapper;

import com.example.pojo.User;

import org.apache.ibatis.annotations.Mapper;

import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper

@Repository

public interface UserMapper {

     //查询用户的全部信息

     List<User> getUserList();

     //select 找出id=1的用户

     User getUserById( int id);

     //insert 增加一个用户

     int insertUser(User user);

     //delete 删除id=4的用户

     int deleteUser( int id);

     //update 将id=2的用户名字改为小龙

     int updateUser(User user);

}

<? 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.example.mapper.UserMapper" >

     < select id = "getUserList" resultType = "user" >

         select *

         from mybatis.user

     </ select >

     < select id = "getUserById" resultType = "user" parameterType = "int" >

         select *

         from mybatis.user

         where id = #{id};

     </ select >

     < insert id = "insertUser" parameterType = "user" >

         insert into mybatis.user (id, name, pwd)

         values (#{id}, #{name}, #{pwd});

     </ insert >

     < delete id = "deleteUser" parameterType = "int" >

         delete

         from mybatis.user

         where id = #{id};

     </ delete >

     < update id = "updateUser" parameterType = "user" >

         update mybatis.user

         set name = #{name},

             pwd = #{pwd}

         where id = #{id};

     </ update >

</ mapper >

mybatis:

   type -aliases-package: com.example.pojo

   mapper-locations: classpath:mybatis /mapper/ *.xml

package com.example.controller;

import com.example.mapper.UserMapper;

import com.example.pojo.User;

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.PathVariable;

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

import java.util.List;

@RestController

public class UserController {

     @Autowired

     private UserMapper userMapper;

     @GetMapping ( "/getUserList" )

     public List<User> getUserList(){

         return userMapper.getUserList();

     }

     @GetMapping ( "/getUserById/{id}" )

     public User getUserById( @PathVariable ( "id" ) int id){

         return userMapper.getUserById(id);

     }

     @GetMapping ( "/insertUser" )

     public String insertUser(){

         userMapper.insertUser( new User( 5 , "xiaoming" , "111" ));

         return "ok" ;

     }

     @GetMapping ( "/deleteUser" )

     public String deleteUser(){

         userMapper.deleteUser( 5 );

         return "ok" ;

     }

     @GetMapping ( "/updateUser" )

     public String updateUser(){

         userMapper.updateUser( new User( 5 , "xx" , "111" ));

         return "ok" ;

     }

}