Spring boot2.0 入门(二)-Spring boot结合mybatis

喜欢ヅ旅行 2022-04-18 05:05 232阅读 0赞

一.整个工程图  
![在这里插入图片描述][20181108195202744.PNG]  
二.pom.xml

<?xml version="1.0" encoding="UTF-8"?>
    <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>com.yxx</groupId>
        <artifactId>springboot_testmybatis</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <packaging>jar</packaging>
    
        <name>springboot_testmybatis</name>
        <description></description>
    
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.0.3.RELEASE</version>
            <relativePath/> 
        </parent>
    
        <properties>
    		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    		<maven.compiler.source>1.8</maven.compiler.source>
    		<maven.compiler.target>1.8</maven.compiler.target>
    	</properties>
    
        <dependencies>
    		<dependency>
    			<groupId>junit</groupId>
    			<artifactId>junit</artifactId>
    			<scope>test</scope>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    		
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.4.4</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.1.1</version>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.0.28</version>
            </dependency>
    	</dependencies>
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    </project>

三.application.yml

# 配置DataSource
    spring:
      datasource:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://192.42.28.48:3306/db_user?useUnicode=true&characterEncoding=utf-8
        username: root
        password: root
        initialSize: 5
        maxActive: 100
        minIdle: 3
        maxWait: 50000
    
    # 配置MyBatis
    mybatis:
      type-aliases-package: com.yxx.domain
      mapper-locations: classpath:mybatis/*.xml

四.代码  
1.MyBatisConfig.java

package com.yxx.config;
    
    import com.alibaba.druid.pool.DruidDataSource;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.context.properties.ConfigurationProperties;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    import javax.sql.DataSource;
    
    @Configuration
    //扫描MyBatis的Mapper接口所在的包
    @MapperScan("com.yxx.dao")
    public class MyBatisConfig { 
    
        @Bean
        @ConfigurationProperties(prefix = "spring.datasource")
        public DataSource dataSource(){ 
            return new DruidDataSource();
        }
    
    }

2.UserController.java

package com.yxx.controller;
    
    import com.yxx.domain.User;
    import com.yxx.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    import java.util.List;
    
    @RestController
    @RequestMapping("/user")
    public class UserController { 
    
        @Autowired
        private UserService userService;
    
        @RequestMapping("/findAll")
        public List<User> findAll(){ 
            return userService.findAll();
        }
    
        @RequestMapping("/findById")
        public User findById(int id){ 
            return userService.findById(id);
        }
    
        @RequestMapping("/add")
        public User add(User user){ 
            userService.add(user);
            return user;
        }
    }

3.UserMapper.java

package com.yxx.dao;
    
    import java.util.List;
    
    import com.yxx.domain.User;
    
    public interface UserMapper { 
    
        public List<User> selectAll();
    
        public User selectById(int id);
    
        public void insert(User user);
    
    }

4.User.java

package com.yxx.domain;
    
    import java.io.Serializable;
    
    public class User implements Serializable { 
    
    	private static final long serialVersionUID = 1L;
    	
    	private Integer id;
        private String username;
        private String password;
    
        public Integer getId() { 
            return id;
        }
    
        public void setId(Integer id) { 
            this.id = id;
        }
    
        public String getUsername() { 
            return username;
        }
    
        public void setUsername(String username) { 
            this.username = username;
        }
    
        public String getPassword() { 
            return password;
        }
    
        public void setPassword(String password) { 
            this.password = password;
        }
    }

5.UserService.java

package com.yxx.service;
    
    import com.yxx.domain.User;
    import java.util.List;
    
    public interface UserService { 
    
        public List<User> findAll();
    
        public User findById(int id);
    
        public void add(User user);
    }

6.UserServiceImpl.java

package com.yxx.service.impl;
    
    import com.yxx.dao.UserMapper;
    import com.yxx.domain.User;
    import com.yxx.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Propagation;
    import org.springframework.transaction.annotation.Transactional;
    
    import java.util.List;
    
    @Service
    @Transactional(propagation = Propagation.REQUIRED,rollbackFor = Exception.class)
    public class UserServiceImpl implements UserService { 
    
        @Autowired
        private UserMapper userMapper;
    
        @Override
        @Transactional(propagation = Propagation.SUPPORTS,readOnly = true)
        public List<User> findAll() { 
            return userMapper.selectAll();
        }
    
        @Override
        @Transactional(propagation = Propagation.SUPPORTS,readOnly = true)
        public User findById(int id) { 
            return userMapper.selectById(id);
        }
    
        @Override
        public void add(User user) { 
            userMapper.insert(user);
        }
    }

五.mybatis xml  
UserMapper.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="com.yxx.dao.UserMapper">
        
        <sql id="userColumn">
            id,
            username,
            password
        </sql>
        
        <select id="selectAll" resultType="User">
          select <include refid="userColumn"/>
          from users
        </select>
    
        <select id="selectById" resultType="User">
            select <include refid="userColumn"/>
            from users
            where id=#{id}
        </select>
    
        <insert id="insert" parameterType="User" useGeneratedKeys="true" keyProperty="id">
          insert into users
            (username,password)
          values
            (#{username},#{password})
        </insert>
        
    </mapper>

[20181108195202744.PNG]: /images/20220418/bdc2018cbfdf44cab1b562ba3d57654f.png