Spring Boot + MyBatis框架的搭建

短命女 2022-09-30 15:00 170阅读 0赞

spring boot的方便之处在于没有了繁杂的xml配置文件和不需要再自己去安装tomcat等服务器，由于后续工作需要用到spring boot+mybatis来进行工作，将这两天学习的东西记录下来，方便自己查看也避免后来者能避开我碰到的坑。  
**Spring Boot建议使用Maven或Gradle，本文以Maven为例。**  
创建一个maven web项目，可以参考http://blog.csdn.net/chuyuqing/article/details/28879477  
创建maven项目之后需要先引入所需的支持jar包。

**在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>com.test</groupId>
      <artifactId>springboot_mybatis_day1</artifactId>
      <version>0.0.1-SNAPSHOT</version>
      <packaging>war</packaging>
      
      <name>springBoot-mybatis</name>
      <url>http://maven.apache.org</url>
        <description>Spring Boot project</description>
        
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>1.4.1.RELEASE</version>
            <relativePath/>
        </parent>
        <properties>
        	
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            
            <java.version>1.8</java.version>
        </properties>
        <dependencies>
        	
        	<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.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.1.1</version>
            </dependency>
        </dependencies>
    	
    	<dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
        </dependencies>
    	
    	<build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    
                    <artifactId>spring-boot-maven-plugin</artifactId>
                    <dependencies>
                        <dependency>
                        
                            <groupId>org.springframework</groupId>
                            <artifactId>springloaded</artifactId>
                            <version>1.2.5.RELEASE</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>
    </project>

**构建目录结构**

![目录结构][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTcwMzIzMTAxOTUwNTI4]

**先进行数据库连接，创建一个文件application.properties**

spring.datasource.url=jdbc:mysql://localhost:3306/test
    spring.datasource.username=root
    spring.datasource.password=3718900
    spring.datasource.driverClassName=com.mysql.jdbc.Driver
    spring.datasource.max-active=20
    spring.datasource.max-idle=8
    spring.datasource.min-idle=8
    spring.datasource.initial-size=10

**创建一个应用类App.java**

package org.yanling;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    /**
     * Spring Boot 启动类
     * @author yanling
     * @version v.1.0.0
     * @date 2017-3-23
     */
    
    @SpringBootApplication
    @MapperScan("org.yanling.mapper.*")//扫描该包下相应的class，mybatis持久化类
    public class App { 
    	public static void main(String[] args){ 
    		SpringApplication.run(App.class , args);
    	}
    }

**创建一个User.java，定义的变量需要和数据库中字段名一致，否则需要使用别名。**

package org.yanling.entity;
    
    public class User { 
    	private Integer id;
        private String name;
        private Integer age;
    	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 Integer getAge() { 
    		return age;
    	}
    	public void setAge(Integer age) { 
    		this.age = age;
    	}
        
    }

**创建UserMapper .java(注意这是一个接口类)**

package org.yanling.mapper;
    
    import java.util.List;
    
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Select;
    import org.yanling.entity.User;
    
    //@Mapper在启动类里面配置了@MaaperScan注解就不需要这个注解
    public interface UserMapper { 
    	//#{name}:参数占位符
    	@Select("select * from user where name = #{name}")
    	public List<User> findUserByName(String name);
    	
    	@Select("select * from user")
    	public List<User> findUser();
    	
    }

**既然是MVC结构Service是不能少的，创建一个UserService.java**

package org.yanling.service;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.yanling.entity.User;
    import org.yanling.mapper.UserMapper;
    
    @Service
    public class UserService { 
    	
    	@Autowired
    	private UserMapper userMapper;
    	
    	public List<User> likeName(String name){ 
    		return userMapper.findUserByName(name);
    	}
    	
    	public List<User> findUser(String name){ 
    		return userMapper.findUser();
    	}
    	
    }

**再来一个UserContorller.java就可以了**

package org.yanling.controller;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    import org.yanling.entity.User;
    import org.yanling.service.UserService;
    
    @RestController
    public class UserController { 
    	
    	@Autowired
    	private UserService userService;
    	@RequestMapping("/userFind")
    	public List<User> likeName(String name){ 
    		return userService.likeName(name);
    	}
    	@RequestMapping("/user")
    	public List<User> findUser(String name){ 
    		return userService.findUser(name);
    	}
    	
    }

现在就可以来启动项目了，打开**App.java**，右键选择**Run As --> java application**

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTcwMzIzMTAzNzAwMTMx]

打开浏览器，输入http://localhost:8080/user

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTcwMzIzMTAzOTAwNjc4]

恭喜你第一个Spring boot + mybatis框架搭建完成了。

[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTcwMzIzMTAxOTUwNTI4]: /images/20220705/d8aa8d1fe9464f40a7efd45baec8e0ff.png
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTcwMzIzMTAzNzAwMTMx]: /images/20220705/0969482eece44a3ebec56f8d52f5afa7.png
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTcwMzIzMTAzOTAwNjc4]: /images/20220705/adcbfe570fea4e6db18431adeca7d22f.png