springboot+Mybatis+mysql示例

https://start.spring.io

新建项目

spring.png

pom.xml 文件增加mysql和mybatis配置

        <!--mysql数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.0</version>
        </dependency>

删除application.properties，使用yml配置
新增
application-dev.yml、application.ym 文件

dev文件中jdbc:mysql://localhost:3306/ 后跟的是数据库名称

数据中新增user表，并且插入数据

CREATE TABLE `user` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL,
  `password` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT INTO `user` VALUES ('1', 'malone', '007');
INSERT INTO `user` VALUES ('2', 'oyl', '520');

新建User类

public class User {
    private Integer id;
    private String username;
    private String password;
    ...省略get set 
}

新建UserMapper

@Repository
public interface UserMapper {
    User getUser(int id);
}

新建UserService

@Service
public class UserService {
    @Autowired
    UserMapper userMapper;
    public User getUser(int id){
        return userMapper.getUser(id);
    }
}

新建UserController

@RestController
@RequestMapping("/springboot")
public class UserController {

    @Autowired
    private UserService userService;

    @RequestMapping("getUser/{id}")
    public String GetUser(@PathVariable int id){
        return userService.getUser(id).toString();
    }
}

resources目录下新增mapping文件夹，并且新建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.joy.mapper.UserMapper">

    <resultMap id="BaseResultMap" type="com.joy.entity.User">
        <result column="id" jdbcType="INTEGER" property="id" />
        <result column="username" jdbcType="VARCHAR" property="username" />
        <result column="password" jdbcType="VARCHAR" property="password" />
    </resultMap>

    <select id="getUser" resultType="com.joy.entity.User">
        select * from user where id = #{id}
    </select>
</mapper>

启动类Application，新增

@MapperScan("com.joy.mapper") 

浏览器输入访问地址：http://localhost:8080/springboot/getUser/1 即可成功运行。

项目地址：https://github.com/Malone1023/springboot_mybatis