devbox
2023面试高手
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

springboot集成MyBatis总结_org.mybatis.spring.boot

作者：2023面试高手 | 2024-04-27 18:47:43

赞

踩

org.mybatis.spring.boot

目录

Springboot集成MyBatis实现架构：

我的目录结构：

一、导入依赖

二、配置文件

三、数据库操作层

四、服务层

五、控制层

六、使用注解操作更方便

Springboot集成MyBatis实现架构：

我的目录结构：

一、导入依赖

  1.         <!--MyBatis整合SpringBoot框架的起步依赖-->
  2.         <dependency>
  3.             <groupId>org.mybatis.spring.boot</groupId>
  4.             <artifactId>mybatis-spring-boot-starter</artifactId>
  5.             <version>2.1.1</version>
  6.         </dependency>
  7.  
  8.         <!--Mysql驱动-->    
  9.         <dependency>
  10.             <groupId>mysql</groupId>
  11.             <artifactId>mysql-connector-java</artifactId>
  12.         </dependency> 
  13.  
  14.         <!--数据库连接池-->
  15.         <dependency>
  16.             <groupId>com.alibaba</groupId>
  17.             <artifactId>druid</artifactId>
  18.             <version>1.2.4</version>
  19.         </dependency>

我的配置文件：

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <modelVersion>4.0.0</modelVersion>
  5.     <parent>
  6.         <groupId>org.springframework.boot</groupId>
  7.         <artifactId>spring-boot-starter-parent</artifactId>
  8.         <version>2.6.3</version>
  9.         <relativePath/> <!-- lookup parent from repository -->
  10.     </parent>
  11.     <groupId>com.wxl</groupId>
  12.     <artifactId>mybatis</artifactId>
  13.     <version>0.0.1-SNAPSHOT</version>
  14.     <name>mybatis</name>
  15.     <description>Demo project for Spring Boot</description>
  16.     <properties>
  17.         <java.version>1.8</java.version>
  18.     </properties>
  19.     <dependencies>
  20.         <dependency>
  21.             <groupId>org.springframework.boot</groupId>
  22.             <artifactId>spring-boot-starter-web</artifactId>
  23.         </dependency>
  24.  
  25.         <dependency>
  26.             <groupId>org.springframework.boot</groupId>
  27.             <artifactId>spring-boot-starter-test</artifactId>
  28.             <scope>test</scope>
  29.         </dependency>
  30.  
  31.         <!--MyBatis整合SpringBoot框架的起步依赖-->
  32.         <dependency>
  33.             <groupId>org.mybatis.spring.boot</groupId>
  34.             <artifactId>mybatis-spring-boot-starter</artifactId>
  35.             <version>2.1.1</version>
  36.         </dependency>
  37.  
  38.         <!--Mysql驱动-->
  39.         <dependency>
  40.             <groupId>mysql</groupId>
  41.             <artifactId>mysql-connector-java</artifactId>
  42.         </dependency>
  43.  
  44.         <!--数据库连接池-->
  45.         <dependency>
  46.             <groupId>com.alibaba</groupId>
  47.             <artifactId>druid</artifactId>
  48.             <version>1.2.4</version>
  49.         </dependency>
  50.         <dependency>
  51.             <groupId>org.projectlombok</groupId>
  52.             <artifactId>lombok</artifactId>
  53.         </dependency>
  54.     </dependencies>
  55.  
  56.     <build>
  57.         <plugins>
  58.             <plugin>
  59.                 <groupId>org.springframework.boot</groupId>
  60.                 <artifactId>spring-boot-maven-plugin</artifactId>
  61.             </plugin>
  62.         </plugins>
  63.     </build>
  64.  
  65. </project>

二、配置文件

application.yaml

  1. #端口号
  2. server:
  3.   port: 8080
  4.  
  5. #设置链接数据库的配置
  6. spring:
  7.   datasource:
  8.     driver-class-name: com.mysql.cj.jdbc.Driver
  9.     url: jdbc:mysql://localhost:3306/admin?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=GMT
  10.     username: root
  11.     password: root
  12.     type: com.alibaba.druid.pool.DruidDataSource
  13.  
  14. mybatis:
  15.   type-aliases-package: com.wxl.mybatis.pojo # 实体类文件夹路径
  16.   mapper-locations: classpath:/mybatis/mapper/*.xml # 资源文件夹下对应的映射xml路径
  17.  
  18. #设置显示日志，查看sql时用
  19. logging:
  20.   file:
  21.     name: log/log.log
  22.   level:
  23.     root: info
  24.     com.wxl.mybatis: debug #自己的包名也可不写

三、数据库操作层

  1. package com.wxl.mybatis.dao;
  2.  
  3. import com.wxl.mybatis.pojo.Person;
  4. import com.wxl.mybatis.pojo.query.PersonQuery;
  5. import org.apache.ibatis.annotations.Mapper;
  6. import org.springframework.stereotype.Repository;
  7.  
  8. import java.util.List;
  9.  
  10. @Mapper //告诉springboot这是一个mapper类
  11. @Repository //将PersonDao交给spring容器管理
  12. public interface PersonDao {
  13.     //查询所有
  14.     public List<Person> listPerson();
  15.  
  16.     //模糊查询
  17.     public List<Person> listPersonByName(String name);
  18.  
  19.     //多参数查询
  20.     public List<Person> listPersonByMultiParam(String name, Integer age);
  21.  
  22.     //分页查询
  23.     public List<Person> listPersonByPage(PersonQuery personQuery);
  24.  
  25.     public int insertPerson(Person person);
  26.  
  27.     public int updatePersonById(Person person);
  28.  
  29.     public int deletePersonById(int id);
  30. }

这里的@Mapper也可以换种写法，就是不写@Mapper直接到application启动页配置如下：

  1. package com.wxl.mybatis;
  2.  
  3. import org.mybatis.spring.annotation.MapperScan;
  4. import org.springframework.boot.SpringApplication;
  5. import org.springframework.boot.autoconfigure.SpringBootApplication;
  6.  
  7. @SpringBootApplication
  8. @MapperScan("com.wxl.mybatis.dao")
  9. public class MybatisApplication {
  10.  
  11.     public static void main(String[] args) {
  12.         SpringApplication.run(MybatisApplication.class, args);
  13.     }
  14.  
  15. }

使用MapperScan和Mapper注解任意一个即可。

Mapper对应的Mybatis的xml文件如下：

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  3.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  4. <mapper namespace="com.wxl.mybatis.dao.PersonDao">
  5.     <select id="listPerson" resultType="com.wxl.mybatis.pojo.Person">
  6.         select * from person;
  7.     </select>
  8.  
  9.     <select id="listPersonByName" parameterType="String" resultType="com.wxl.mybatis.pojo.Person">
  10.         select * from person where name like concat("%",#{name},"%");
  11.     </select>
  12.  
  13.     <select id="listPersonByMultiParam" resultType="Person">
  14.         select * from person where name like concat("%",#{name},"%")
  15.          and age like concat("%",#{age},"%");
  16.     </select>
  17.  
  18.     <select id="listPersonByPage" parameterType="com.wxl.mybatis.pojo.query.PersonQuery" resultType="Person">
  19.         select * from person limit #{start},#{end};
  20.     </select>
  21.  
  22.     <!--useGeneratedKeys="true"表示使用数据库的自动增长策略-->
  23.     <insert id="insertPerson" parameterType="Person" useGeneratedKeys="true">
  24.         insert into person(name,age,address) values(#{name},#{age},#{address});
  25.     </insert>
  26.  
  27.     <update id="updatePersonById" parameterType="Person">
  28.         update person set name=#{name},age=#{age},address=#{address} where id=#{id};
  29.     </update>
  30.  
  31.     <delete id="deletePersonById" parameterType="int">
  32.         delete from person where id=#{id};
  33.     </delete>
  34. </mapper>

其中，每个id与dao层接口方法同名，namespace为dao文件的路径。

四、服务层

接口

  1. package com.wxl.mybatis.service;
  2.  
  3. import com.wxl.mybatis.pojo.Person;
  4. import java.util.List;
  5.  
  6. public interface PersonService {
  7.     public List<Person> listPerson();
  8.  
  9.     public List<Person> listPersonByName(String name);
  10.  
  11.     public List<Person> listPersonByMultiParam(String name, Integer age);
  12.  
  13.     public List<Person> listPersonByPage(Integer pageNum, Integer pageSize);
  14.  
  15.     public int insertPerson(Person person);
  16.  
  17.     public int updatePersonById(Person person);
  18.  
  19.     public int deletePersonById(int id);
  20. }

实现类

  1. package com.wxl.mybatis.service;
  2.  
  3. import com.wxl.mybatis.dao.PersonDao;
  4. import com.wxl.mybatis.pojo.Person;
  5. import com.wxl.mybatis.pojo.query.PersonQuery;
  6. import org.springframework.beans.factory.annotation.Autowired;
  7. import org.springframework.stereotype.Service;
  8.  
  9. import java.util.List;
  10.  
  11. @Service
  12. public class PersonServiceImpl implements PersonService {
  13.     @Autowired
  14.     PersonDao personDao;
  15.  
  16.     @Override
  17.     public List<Person> listPerson() {
  18.         return personDao.listPerson();
  19.     }
  20.  
  21.     @Override
  22.     public List<Person> listPersonByName(String name) {
  23.         return personDao.listPersonByName(name);
  24.     }
  25.  
  26.     @Override
  27.     public List<Person> listPersonByMultiParam(String name, Integer age) {
  28.         return personDao.listPersonByMultiParam(name, age);
  29.     }
  30.  
  31.     @Override
  32.     public List<Person> listPersonByPage(Integer pageNum, Integer pageSize) {
  33.         PersonQuery personQuery = new PersonQuery(pageNum, pageSize);
  34.         return personDao.listPersonByPage(personQuery);
  35.     }
  36.  
  37.     @Override
  38.     public int insertPerson(Person person) {
  39.         return personDao.insertPerson(person);
  40.     }
  41.  
  42.     @Override
  43.     public int updatePersonById(Person person) {
  44.         return personDao.updatePersonById(person);
  45.     }
  46.  
  47.     @Override
  48.     public int deletePersonById(int id) {
  49.         return personDao.deletePersonById(id);
  50.     }
  51. }

五、控制层

  1. package com.wxl.mybatis.controller;
  2.  
  3. import com.wxl.mybatis.pojo.Person;
  4. import com.wxl.mybatis.service.PersonServiceImpl;
  5. import org.springframework.beans.factory.annotation.Autowired;
  6. import org.springframework.web.bind.annotation.RequestMapping;
  7. import org.springframework.web.bind.annotation.RestController;
  8.  
  9. import java.util.List;
  10.  
  11. @RestController
  12. public class PersonController {
  13.     @Autowired
  14.     PersonServiceImpl personService;
  15.  
  16.     @RequestMapping("/person")
  17.     public List<Person> listPerson(){
  18.         return personService.listPerson();
  19.     }
  20.  
  21.     @RequestMapping("person2")
  22.     public List<Person> listPersonByName(String name){
  23.         return personService.listPersonByName(name);
  24.     }
  25.  
  26.     @RequestMapping("/person3")
  27.     public List<Person> listPersonByMultiParam(String name,Integer age){
  28.         return personService.listPersonByMultiParam(name,age);
  29.     }
  30.  
  31.     @RequestMapping("/person4")
  32.     public List<Person> listPersonByPage(Integer pageNum, Integer pageSize){
  33.         return personService.listPersonByPage(pageNum, pageSize);
  34.     }
  35.  
  36.     @RequestMapping("/person5")
  37.     public String insertPerson(String name,Integer age,String address){
  38.         Person person=new Person(name,age,address);
  39.         if(personService.insertPerson(person)==1){
  40.             return "添加成功";
  41.         }else{
  42.             return "添加失败";
  43.         }
  44.     }
  45.  
  46.     @RequestMapping("/person6")
  47.     public String updatePerson(){
  48.         Person person=new Person(4,"Kite",12,"US");
  49.         if(personService.updatePersonById(person)==1){
  50.             return "修改成功";
  51.         }else{
  52.             return "修改失败";
  53.         }
  54.     }
  55.  
  56.     @RequestMapping("/person7")
  57.     public String deletePerson(int id){
  58.         if(personService.deletePersonById(id)==1){
  59.             return "删除成功";
  60.         }else{
  61.             return "删除失败";
  62.         }
  63.     }
  64. }

六、使用注解操作更方便

  1. package com.wxl.redistest.dao;
  2.  
  3. import com.wxl.redistest.pojo.Person;
  4. import org.apache.ibatis.annotations.*;
  5. import org.springframework.stereotype.Repository;
  6.  
  7. import java.util.List;
  8.  
  9. @Mapper
  10. @Repository
  11. public interface PersonDao {
  12.     @Select("select * from person")
  13.     List<Person> selectAll();
  14.  
  15.     @Delete("delete from person where id=#{id}")
  16.     Integer delete(Integer id);
  17.  
  18.     @Update("update person set name=#{name},age=#{age} where id=#{id}")
  19.     Integer update(Person person);
  20.  
  21.     @Insert("insert into person(name,age,address) values(#{name},#{age},#{address})")
  22.     Integer insert(Person person);
  23. }
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/2023面试高手/article/detail/498169
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号