转载：SpringBoot非官方教程 | 第六篇：springboot整合mybatis

悠悠 2022-05-08 00:14 252阅读 0赞

转载：[https://blog.csdn.net/forezp/article/details/70768477][https_blog.csdn.net_forezp_article_details_70768477]

本文主要讲解如何在springboot下整合mybatis，并访问数据库。由于mybatis这个框架太过于流行，所以我就不讲解了。

## 引入依赖 ##

在pom文件引入mybatis-spring-boot-starter的依赖：

<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
    			<artifactId>mybatis-spring-boot-starter<artifactId>
    			<version>1.3.0</version>
    		</dependency>
    
     
      
       1
       2
       3
       4
       5
       6

引入数据库连接依赖：

<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<scope>runtime</scope>
    		</dependency>
    		<dependency>
    			<groupId>com.alibaba</groupId>
    			<artifactId>druid</artifactId>
    			<version>1.0.29</version>
    		</dependency>
    
     
      
       1
       2
       3
       4
       5
       6
       7
       8
       9
       10

## 引入数据源 ##

application.properties配置文件中引入数据源：

spring.datasource.url=jdbc:mysql://localhost:3306/test
    spring.datasource.username=root
    spring.datasource.password=123456
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    
     
      
       1
       2
       3
       4

这样，springboot就可以访问数据了。

## 创建数据库表 ##

建表语句：

-- create table `account`
    # DROP TABLE `account` IF EXISTS
    CREATE TABLE `account` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(20) NOT NULL,
      `money` double DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
    INSERT INTO `account` VALUES ('1', 'aaa', '1000');
    INSERT INTO `account` VALUES ('2', 'bbb', '1000');
    INSERT INTO `account` VALUES ('3', 'ccc', '1000');
    
     
      
       1
       2
       3
       4
       5
       6
       7
       8
       9
       10
       11
       12

## 具体实现 ##

这篇文篇通过注解的形式实现。

### 创建实体： ###

public class Account {
       private int id ;
       private String name ;
       private double money;
     setter...
     getter...
    }
    
     
      
       1
       2
       3
       4
       5
       6
       7
       8
       9

### dao层 ###

@Mapper
    public interface AccountMapper {
        @Insert("insert into account(name, money) values(#{name}, #{money})")
        int add(@Param("name") String name, @Param("money") double money);
        @Update("update account set name = #{name}, money = #{money} where id = #{id}")
        int update(@Param("name") String name, @Param("money") double money, @Param("id") int  id);
        @Delete("delete from account where id = #{id}")
        int delete(int id);
        @Select("select id, name as name, money as money from account where id = #{id}")
        Account findAccount(@Param("id") int id);
        @Select("select id, name as name, money as money from account")
        List<Account> findAccountList();
    }
    
     
      
       1
       2
       3
       4
       5
       6
       7
       8
       9
       10
       11
       12
       13
       14
       15
       16
       17
       18

## service层 ##

@Service
    public class AccountService {
        @Autowired
        private AccountMapper accountMapper;
        public int add(String name, double money) {
            return accountMapper.add(name, money);
        }
        public int update(String name, double money, int id) {
            return accountMapper.update(name, money, id);
        }
        public int delete(int id) {
            return accountMapper.delete(id);
        }
        public Account findAccount(int id) {
            return accountMapper.findAccount(id);
        }
        public List<Account> findAccountList() {
            return accountMapper.findAccountList();
        }
    }
    
     
      
       1
       2
       3
       4
       5
       6
       7
       8
       9
       10
       11
       12
       13
       14
       15
       16
       17
       18
       19
       20
       21
       22

## controller层，构建restful API ##

package com.forezp.web;
    import com.forezp.entity.Account;
    import com.forezp.service.AccountService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.*;
    import java.util.List;
    /**
     * Created by fangzhipeng on 2017/4/20.
     */
    @RestController
    @RequestMapping("/account")
    public class AccountController {
        @Autowired
        AccountService accountService;
        @RequestMapping(value = "/list", method = RequestMethod.GET)
        public List<Account> getAccounts() {
            return accountService.findAccountList();
        }
        @RequestMapping(value = "/{id}", method = RequestMethod.GET)
        public Account getAccountById(@PathVariable("id") int id) {
            return accountService.findAccount(id);
        }
        @RequestMapping(value = "/{id}", method = RequestMethod.PUT)
        public String updateAccount(@PathVariable("id") int id, @RequestParam(value = "name", required = true) String name,
                                    @RequestParam(value = "money", required = true) double money) {
            int t= accountService.update(name,money,id);
            if(t==1) {
                return "success";
            }else {
                return "fail";
            }
        }
        @RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
        public String delete(@PathVariable(value = "id")int id) {
            int t= accountService.delete(id);
            if(t==1) {
                return "success";
            }else {
                return "fail";
            }
        }
        @RequestMapping(value = "", method = RequestMethod.POST)
        public String postAccount(@RequestParam(value = "name") String name,
                                  @RequestParam(value = "money") double money) {
           int t= accountService.add(name,money);
           if(t==1) {
               return "success";
           }else {
               return "fail";
           }
        }
    }
    
     
      
       1
       2
       3
       4
       5
       6
       7
       8
       9
       10
       11
       12
       13
       14
       15
       16
       17
       18
       19
       20
       21
       22
       23
       24
       25
       26
       27
       28
       29
       30
       31
       32
       33
       34
       35
       36
       37
       38
       39
       40
       41
       42
       43
       44
       45
       46
       47
       48
       49
       50
       51
       52
       53
       54
       55
       56
       57
       58
       59
       60
       61
       62
       63
       64
       65
       66
       67
       68

通过postman测试通过。

源码下载：[https://github.com/forezp/SpringBootLearning][https_github.com_forezp_SpringBootLearning]

## 参考资料 ##

[mybatis][]

[MyBatis整合][MyBatis]

### 优秀文章推荐： ###

*  更多springboot 教程：[springBoot非官方教程 | 文章汇总][springBoot_ _]

[https_blog.csdn.net_forezp_article_details_70768477]: https://blog.csdn.net/forezp/article/details/70768477
[https_github.com_forezp_SpringBootLearning]: https://github.com/forezp/SpringBootLearning
[mybatis]: http://www.mybatis.org/mybatis-3/zh/configuration.html#properties
[MyBatis]: http://blog.720ui.com/2016/springboot_02_data_mybatis/
[springBoot_ _]: https://blog.csdn.net/yongpole/article/details/82959905