SpringBoot入门之整合mybatis

傷城~ 2022-07-13 10:09 249阅读 0赞

1.  新建maven项目
2.  配置pom.xml
3.  编写测试代码

> 最近闲的无聊，在热潮的推动下，我也来尝试点新鲜东西

### 新建maven项目 ###

创建后的项目：  
![这里写图片描述][SouthEast]

### 配置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>SpringBootStart</groupId>
      <artifactId>SpringBootStart</artifactId>
      <version>1.0.0</version>
      <packaging>war</packaging>
      <name>SpringBootStart</name>
        <description>Spring Boot project</description>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>1.3.2.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</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.1.1</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
        </dependencies>
      <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-surefire-plugin</artifactId>
                    <configuration>
                        <skip>true</skip>
                    </configuration>
                </plugin>
            </plugins>
        </build>
    </project>

### 编写测试代码 ###

1.程序入口类：Application.java

package com.sjz.stepone;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    public class Application { 
        public static void main(String[] args) {
            SpringApplication.run(Application.class, args);
        }
    }

2.Bean

package com.sjz.stepone;
    public class Userinfor {
        private Integer user_id;
        private String username;
        public Integer getUser_id() {
            return user_id;
        }
        public void setUser_id(Integer user_id) {
            this.user_id = user_id;
        }
        public String getUsername() {
            return username;
        }
        public void setUsername(String username) {
            this.username = username;
        }
    }

3.Mapper类

package com.sjz.stepone;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    @Mapper
    public interface UserinforMapper {
         @Select("SELECT * FROM userinfor WHERE u_sex = #{name}")
         Userinfor findByName(@Param("name") String name);
    }

4.Controller类

package com.sjz.stepone;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    @RequestMapping({ "/home" })
    public class UserController {
        @Autowired
        UserinforMapper userMapper;
    
        @RequestMapping(value = "/user")
        @ResponseBody
        public String user() {
            Userinfor user = userMapper.findByName("n");
            return user.getUsername();
        }
    }

5.测试  
编写好以上4个类之后，运行application.java（spring boot app）,  
页面直接访问  
![这里写图片描述][SouthEast 1]

[SouthEast]: /images/20220713/958ea2300209494396522d541b8e9282.png
[SouthEast 1]: /images/20220713/f4cb48c79e69418aa591490ca7af6f64.png