springboot2.0系列四（整合mybatis）

最新推荐文章于 2024-09-19 13:35:49 发布

Gashina

最新推荐文章于 2024-09-19 13:35:49 发布

阅读量160

点赞数

分类专栏： springboot 文章标签： springboot mybatis

本文链接：https://blog.csdn.net/wota5037/article/details/111410585

版权

springboot 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

springboot整合使用mybatis

4.2.1、pom文件引入

<groupId>org.springframework.boot</groupId>

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

<version>2.0.0.RELEASE</version>

</parent>

<groupId>org.springframework.boot</groupId>

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

</dependency>

<groupId>org.springframework.boot</groupId>

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

</dependency>

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

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

</dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

<groupId>org.springframework.boot</groupId>

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

</dependency>

</dependencies>

4.2.2、配置文件引入

spring.datasource.url=jdbc:mysql://localhost:3306/test

spring.datasource.username=root

spring.datasource.password=root

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

4.2.3、Mapper代码

package com.example.demo.service;

  

  import org.apache.ibatis.annotations.Insert;

  import org.apache.ibatis.annotations.Mapper;

  import org.apache.ibatis.annotations.Param;

  import org.apache.ibatis.annotations.Select;

  

  import java.util.Map;

  @Mapper

  public interface UserMapper {

    @Select("SELECT * FROM USERS WHERE NAME = #{name}")

    Map findByName(@Param("name") String name);

    @Insert("INSERT INTO USERS(NAME, AGE) VALUES(#{name}, #{age})")

    int insert(@Param("name") String name, @Param("age") Integer age);

}

4.2.3、Controller代码

package com.example.demo.controller;

  

  import com.example.demo.service.UserMapper;

  

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

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

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

  

  import java.util.Map;

  

  @RestController

  public class UsersController {

    @Autowired

    UserMapper userMapper;

  

    @RequestMapping("/insertUser")

    public void insertUser(String name,Integer age) {

  

        userMapper.insert(name,age);

  

    }

    @RequestMapping("/user")

    public Map findUser(String name) {

  

      Map<String,Object> result= userMapper.findByName(name);

      return result;

  

    }

}

4.2.4、启动方式

@SpringBootApplication

public class MybatisApp {

public static void main(String[] args) {

SpringApplication.run(MybatisApp.class, args);

}

效果