【2】SpringBoot集成MyBatis入门案例（Eclipse版本）

我就是我 2022-04-13 06:22 159阅读 0赞

### 1.创建Maven工程 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MzA2MDQx_size_16_color_FFFFFF_t_70][]

### 2.添加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/maven-v4_0_0.xsd">
      <modelVersion>4.0.0</modelVersion>
      <groupId>com.zit</groupId>
      <artifactId>springboot-web-hello</artifactId>
      <packaging>war</packaging>
      <version>0.0.1-SNAPSHOT</version>
      <name>springboot-web-hello Maven Webapp</name>
      <url>http://maven.apache.org</url>
      
      
      	<parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>2.1.0.RELEASE</version>
    		<relativePath/> 
    	</parent>
    	
    	<properties>
    		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    		<java.version>1.8</java.version>
    	</properties>
    	
    	<dependencies>
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-jdbc</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<scope>test</scope>
    		</dependency>
    		<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
      			<artifactId>mybatis-spring-boot-starter</artifactId>
      			<version>1.2.0</version>
    		</dependency>
    	</dependencies>
      <build>
      <plugins>
      	<plugin>
      		<groupId>org.springframework.boot</groupId>
      		<artifactId>spring-boot-maven-plugin</artifactId>
      	</plugin>
      </plugins>
      <finalName>springboot-web-hello</finalName>
      </build>
    </project>

### 3.使用navicat创建数据库 ###

***在这里执行一下脚本即可***

/*
    Navicat MySQL Data Transfer
    
    Source Server         : abc
    Source Server Version : 50724
    Source Host           : localhost:3306
    Source Database       : spring_boot
    
    Target Server Type    : MYSQL
    Target Server Version : 50724
    File Encoding         : 65001
    
    Date: 2018-11-27 21:48:43
    */
    
    SET FOREIGN_KEY_CHECKS=0;
    
    -- ----------------------------
    -- Table structure for user
    -- ----------------------------
    DROP TABLE IF EXISTS `user`;
    CREATE TABLE `user` (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
      `age` int(255) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    
    -- ----------------------------
    -- Records of user
    -- ----------------------------
    INSERT INTO `user` VALUES ('1', 'summer', '12');
    INSERT INTO `user` VALUES ('2', 'xiatian', '13');

### 4.增加application.properties的配置 ###

##Tomcat端口号
    server.port=80
    ##SpringMVC
    spring.mvc.view.prefix=/WEB-INF/jsp/
    spring.mvc.view.suffix=.jsp
    
    ##配置数据源
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    spring.datasource.url=jdbc:mysql://localhost:3306/spring_boot?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
    spring.datasource.username=root
    spring.datasource.password=Rfid123456
    
    ##MyBatis相关配置
    mybatis.mapperLocations=classpath:mapper/*.xml
    mybatis.typeAliasesPackage=com.zit.springboot.entity

### 5.创建实体类 ###

### 6.创建Mapper接口 ###

package com.zit.springboot.mapper;
    
    import java.util.List;
    
    import org.apache.ibatis.annotations.Mapper;
    
    import com.zit.springboot.entity.User;
    
    @Mapper
    public interface UserMapper {
    	
    	/**
    	 * 
    	 * @return
    	 */
    	List<User> selectAll();
    
    }

### 7.创建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.zit.springboot.mapper.UserMapper">
    <select id="selectAll" resultType="User">
    	select id,name from user
    </select>
    </mapper>

**如图：**

![20181127215412374.png][]

### 8.创建启动类测试 ###

package com.zit.springboot;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.CommandLineRunner;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    import com.zit.springboot.entity.User;
    import com.zit.springboot.mapper.UserMapper;
    
    @SpringBootApplication
    public class Application implements CommandLineRunner {
    	@Autowired
    	private UserMapper userMapper;
    	
    	public static void main(String[] args) {
    		SpringApplication.run(Application.class, args);
    	}
    	
    	@Override
    	public void run(String... args) throws Exception {
    		List<User> userList = userMapper.selectAll();
    		
    		for (User user : userList) {
    			
    			System.out.println("用户名："+user.getName());
    			
    		}
    	}
    
    }

### 9.控制台打印结果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MzA2MDQx_size_16_color_FFFFFF_t_70 1][]

### 下载此工程源代码[点击此处下载][Link 1] ###

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MzA2MDQx_size_16_color_FFFFFF_t_70]: /images/20220413/5ab6ba0dd1c14146bd027aff1eae0fd2.png
[20181127215412374.png]: /images/20220413/f445babdb39d4c3f8d30d2c23d1dcb8f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MzA2MDQx_size_16_color_FFFFFF_t_70 1]: /images/20220413/80ee5b3f05fc4c759eb2e7e19a57e77a.png
[Link 1]: https://download.csdn.net/download/qq_37306041/10811606