第三章 SpringBoot-整合Mybatis

0. 数据库表user

#创建user表
CREATE TABLE `user`(
u_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
u_name VARCHAR(32) NOT NULL,
u_password VARCHAR(32) NOT NULL
)ENGINE=INNODB CHARSET=utf8;
#插入一条数据
INSERT INTO `user`(u_name, u_password) VALUES('root', 'root');

1. 创建Maven项目，导入需要的依赖

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>springboot</groupId>
    <artifactId>3_springboot_restful</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>springboot-restful :: Spsringboot 实现 Restful 服务，基于 HTTP / JSON 传输 Demo</name>

    <!-- Spring Boot 启动父依赖 -->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.1.RELEASE</version>
    </parent>

    <properties>
        <mybatis-spring-boot>1.2.0</mybatis-spring-boot>
        <mysql-connector>5.1.39</mysql-connector>
        <spring-boot-starter-redis-version>1.3.2.RELEASE</spring-boot-starter-redis-version>
    </properties>

    <dependencies>

        <!-- Spring Boot Web 依赖 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!-- Spring Boot Test 依赖 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <!-- Spring Boot Mybatis 依赖 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>${mybatis-spring-boot}</version>
        </dependency>

        <!-- MySQL 连接驱动依赖 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql-connector}</version>
        </dependency>

        <!-- Junit -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>
    </dependencies>
    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

2. 配置application.properties

# 数据源配置
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

# mybatis配置
mybatis.typeAliasesPackage=com.wzw.springboot.model
mybatis.mapperLocations=classpath:mapper/*.xml

3. 编写User.java实体类

public class User {
    private Integer uId;
    private String uName;
    private String uPassword;
    public Integer getuId() {
        return uId;
    }
    public void setuId(Integer uId) {
        this.uId = uId;
    }
    public String getuName() {
        return uName;
    }
    public void setuName(String uName) {
        this.uName = uName;
    }
    public String getuPassword() {
        return uPassword;
    }
    public void setuPassword(String uPassword) {
        this.uPassword = uPassword;
    }
    @Override
    public String toString() {
        return "User [uId=" + uId + ", uName=" + uName + ", uPassword=" + uPassword + "]";
    }

}

4. 编写UserMapper.java接口并配置相对应的映射文件UserMapper.xml

UserMapper.java

import java.util.List;
import com.wzw.springboot.model.User;

public interface UserMapper {

    List<User> getUsers();
    List<User> getUserById(Integer uId);
    Integer addUser(User user);
    Integer deleteUser(Integer uId);
    Integer updateUser(User user);
}

UserMapper.xml

5. 编写UserService.java接口及其实现类UserServiceImpl.java

public interface UserService {

    List<User> getUsers();

    User getUserById(Integer uid);

    Integer saveUser(User user);

    Integer updateUser(User user);

    Integer deleteUser(Integer uid);
}

@Service
public class UserServiceImpl implements UserService{

    @Autowired
    private UserMapper userMapper;

    @Override
    public List<User> getUsers() {
        return userMapper.getUsers();
    }

    @Override
    public User getUserById(Integer uid) {
        return userMapper.getUserById(uid);
    }

    @Override
    public Integer saveUser(User user) {
        return userMapper.saveUser(user);
    }

    @Override
    public Integer updateUser(User user) {
        return userMapper.updateUser(user);
    }

    @Override
    public Integer deleteUser(Integer uid) {
        return userMapper.deleteUser(uid);
    }

}

6. 编写UserController.java

@RestController
public class UserController {

    @Autowired
    private UserService userService;

    @RequestMapping(value="/user/{uid}", method=RequestMethod.GET)
    public User getUserById(@PathVariable("uid") Integer uid) {
        return userService.getUserById(uid);
    }
}

7. 编写启动程序Application.java

//Spring Boot 应用的标识
@SpringBootApplication
//mapper 接口类扫描包配置
@MapperScan("com.wzw.springboot.mapper")
public class Application {
    public static void main(String[] args) {
        // 程序启动入口
        // 启动嵌入式的 Tomcat 并初始化 Spring 环境及其各 Spring 组件
        SpringApplication.run(Application.class, args);
    }
}

8. 运行访问网址：127.0.0.1:8080/user/1