SpringBoot集成mybatis案例

拼搏现实的明天。 2023-10-18 14:42 4阅读 0赞

第一步首先配置pom.xml文件

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
      <modelVersion>4.0.0</modelVersion>
      <groupId>Ming</groupId>
      <artifactId>SpringBoot</artifactId>
      <version>0.0.1-SNAPSHOT</version>
    
       
      <parent>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-parent</artifactId>
          <version>1.5.4.RELEASE</version>
      </parent>
    
      <properties>
          <mybatis-spring-boot>1.2.0</mybatis-spring-boot>
          <mysql-connector>5.1.39</mysql-connector>
          <druid>1.0.18</druid>
          <java.version>1.8</java.version>
      </properties>
    
      <dependencies>
    
           
           <dependency>
               <groupId>org.springframework.boot</groupId>
               <artifactId>spring-boot-starter-web</artifactId>
           </dependency>
    
           
           <dependency>
               <groupId>org.mybatis.spring.boot</groupId>
               <artifactId>mybatis-spring-boot-starter</artifactId>
               <version>1.1.1</version>
           </dependency>
    
           
           <dependency>
               <groupId>mysql</groupId>
               <artifactId>mysql-connector-java</artifactId>
               <version>${mysql-connector}</version>
           </dependency>
    
           
           <dependency>
               <groupId>com.alibaba</groupId>
               <artifactId>druid</artifactId>
               <version>${druid}</version>
           </dependency>
    
             
           <dependency>  
               <groupId>com.github.pagehelper</groupId>  
               <artifactId>pagehelper</artifactId>  
               <version>4.1.6</version>  
           </dependency>  
    
           <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-freemarker</artifactId>
           </dependency>        
       </dependencies>
    
    </project>

第二步：在src/main/resources目录下新建一个application.yml文件

#配置端口号
    server:
      port: 8080
    
    logging:
      level: 
        learning: trace
    
    spring:
      #数据源配置
      datasource:
        url: jdbc:mysql://localhost:3306/test
        username: root
        password: root
        driver-class-name: com.mysql.jdbc.Driver
        type: com.alibaba.druid.pool.DruidDataSource
        connectionProperties: druid.stat.mergeSql=true
      #模板引擎
      freemarker:
        #关闭缓存
        cache: false
        request-context-attribute: request
        #模板加载的位置
        template-loader-path: classpath:/templates
        #前缀
        suffix: .htm
        #后缀
        prefix: /htm/
    
    mybatis:
      #实体类所做包
      type-aliases-package: learning.model
      #mapper.xml所在位置
      mapper-locations: classpath:mappers/*.xml

第三步：配置类的编写，在conf包下新建一个MybatisConfig类以配置使用PageHelper分页

@Configuration
    public class MybatisConfig {
        @Bean
        public PageHelper pageHelper(){
            PageHelper pageHelper = new PageHelper();  
            //添加配置，也可指定文件路径
            Properties p = new Properties();
            p.setProperty("offsetAsPageNum", "true");
            p.setProperty("rowBoundsWithCount", "true");
            p.setProperty("reasonable", "true");
            pageHelper.setProperties(p);
            return pageHelper;
        }
    }

第四步：实例类的编写

public class Player {
        private Integer id;
        private String name;
        private Double points;
        public Integer getId() {
            return id;
        }
        public void setId(Integer id) {
            this.id = id;
        }
        public String getName() {
            return name;
        }
        public void setName(String name) {
            this.name = name;
        }
        public Double getPoints() {
            return points;
        }
        public void setPoints(Double points) {
            this.points = points;
        }
    }

第五步：dao接口的编写

public interface PlayerDao {
        void save (Player player);
    
        Player findByKey(Integer id);
    
        List<Player> findAll();
    }

第六步：service接口的编写

public interface PlayerService {
        void add(Player player);
    
        List<Player> getAll();
    }

第七步：service接口的实现类进行实现类的编写

@Service
    public class PlayerServiceImpl implements PlayerService{
    
        @Autowired
        private PlayerDao playerDao;
    
        @Override
        public void add(Player player) {
            playerDao.save(player);
        }
    
        @Override
        public List<Player> getAll() {
            PageHelper.startPage(1, 2);
            return playerDao.findAll();
        }
    
    }

第八步：在src/main/resources 下新建一个包mapppers用来存放mybatis的xml文件

<?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="learning.mapper.PlayerDao">
        <insert id="save">
            INSERT INTO player (name,points) VALUES (#{name},#{points})
        </insert>   
    
        <select id="findByKey" resultType="learning.model.Player">
            SELECT * FROM player WHERE id = #{id}
        </select>
    
        <select id="findAll" resultType="learning.model.Player">
            SELECT * FROM player
        </select>   
    </mapper>

第九步：在src/main/resources在新建一个目录templates用来存放freemarker加载的模板

![20190221163535904.png][]

第十步：controller层代码的编写

@Controller
    @RequestMapping("/Test")
    public class TestController {
        @Autowired
        private PlayerService playerService;
    
        @RequestMapping("/getAll")
        @ResponseBody
        public Object getAll(){
            Player player = new Player();
            player.setName("张三丰");
            player.setPoints(15.6);
            player.setId(3);
            return player;              
        }
    
        @RequestMapping("/all")
        @ResponseBody
        public Object get(){
            return playerService.getAll();
        }
    
        @RequestMapping("/add")
        public String add(Player player){
            playerService.add(player);
            return "test/hello";
        }
    
        @RequestMapping("/hello")
        public String hello(Model model) {
            List<Player> list = playerService.getAll();
            model.addAttribute("list",list);
            return "test/hello";
        }

[20190221163535904.png]: https://img-blog.csdnimg.cn/20190221163535904.png