Spring boot整合Mybatis

作为web项目怎么能不连接数据库呢，下面将说说如何在Spring boot中整合Mybaits

1. 添加pom依赖：

     <!--mysql驱动包  -->
        <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
        </dependency>
    <!-- mybatis依赖 -->
    <!--boot整合mybatis的关键包annotation  -->
            <dependency>
               <groupId>org.mybatis.spring.boot</groupId>
               <artifactId>mybatis-spring-boot-starter</artifactId>
           <version>1.1.1</version>
    </dependency>

然后就是配置文件了：

jdbc连接配置：

spring.datasource.driver-class-name: com.mysql.jdbc.Driver
spring.datasource.url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=CTT&allowMultiQueries=true
spring.datasource.username: root
spring.datasource.password: root

Mybaits配置：

mybatis.configuration.map-underscore-to-camel-case: true
mybatis.configuration.log-impl: org.apache.ibatis.logging.slf4j.Slf4jImpl
mybatis.configuration.call-setters-on-nulls: true
mybatis.configuration.default-fetch-size: 100
mybatis.configuration.default-statement-timeout: 30
mybatis.mapper-locations: classpath:mapper/**/**/*.xml
mybatis.type-handlers-package: org.apache.ibatis.type.LocalDateTypeHandler

下面测试配置是否正确：

在你连接是数据库下创建一张测试使用的表：

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `sex` varchar(10) DEFAULT NULL,
  `age` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

很简单的一张表
然后是创建这张表的对象：
UserDao

public class UserDao {

    private int id;
    private int age;
    private String name;
    private String sex;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    @Override
    public String toString() {
        return "UserDao{" +
                "id=" + id +
                ", age=" + age +
                ", name='" + name + '\'' +
                ", sex='" + sex + '\'' +
                '}';
    }
}

创建Controller：

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
@Controller
@RequestMapping()
public class test {
    @RequestMapping("/userId")
    @ResponseBody
    public UserDao userId(int id){
        return service.selectId(id);
    }
}

创建UserService 以及UserServiceImpl

public interface UserService {
    public UserDao selectId(int id);
}



import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    UserMapper userMapper;
    @Override
    public UserDao selectId(int id) {
        return userMapper.selectId(id);
    }
}

创建UserMapper

import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface UserMapper {

    public UserDao selectId(int id);
}

最后是userMapper.xml：

 <select id="selectId" parameterType="int" resultType="com.example.demo.model.dao.UserDao">
      SELECT id,name,sex,age FROM user WHERE id = #{id}
    </select>

记得在表中填充数据！！！记得在表中填充数据！！！记得在表中填充数据！！！
然后就可以访问你的项目
因为我配置了端口号的，所以是9100，如果你们没有配置端口号就是默认的8080

我也只是个新人，有什么不对的地方希望大佬提出来，我好加以修正。
有兴趣的小伙伴也可以加QQ群，一起交流：606278528