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

本文主要是介绍Spring boot2.0 入门(二)-Spring boot结合mybatis，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

一.整个工程图
在这里插入图片描述
二.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/> <!-- lookup parent from repository --></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><!-- 用于创建web工程 --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><!--mybatis --><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><!--druid --><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.Driverurl: jdbc:mysql://192.42.28.48:3306/db_user?useUnicode=true&characterEncoding=utf-8username: rootpassword: rootinitialSize: 5maxActive: 100minIdle: 3maxWait: 50000# 配置MyBatis
mybatis:type-aliases-package: com.yxx.domainmapper-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 {@Autowiredprivate 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 {@Autowiredprivate 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);}@Overridepublic void add(User user) {userMapper.insert(user);}
}

五.mybatis xml
UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapperPUBLIC "-//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 userswhere id=#{id}</select><insert id="insert" parameterType="User" useGeneratedKeys="true" keyProperty="id">insert into users(username,password)values(#{username},#{password})</insert></mapper>