SpringBoot（四）thymeleaf+MyBatis+MySql

接着上一节

1.第一步：在pom文件中添加

 <!--   MyBatis  -->

        <dependency>

            <groupId>org.mybatis.spring.boot</groupId>

            <artifactId>mybatis-spring-boot-starter</artifactId>

            <version>1.3.1</version>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter</artifactId>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-devtools</artifactId>

            <optional>true</optional>

        </dependency>

2.第二步：将userMapper类，改成下面这样

package com.oda.springboot.dao;

import com.oda.springboot.bean.User;

import org.apache.ibatis.annotations.Select;

import org.springframework.stereotype.Repository;

import java.util.List;

//JPA的

/*

public interface UserMapper extends JpaRepository<User,Integer> {

}

*/

public interface UserMapper{

   @Select("select * from user")

    public List<User> findUser();

}

3.第三步：将UserService类改成下面这样

package com.oda.springboot.service;

import com.oda.springboot.bean.User;

import com.oda.springboot.dao.UserMapper;

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

import org.springframework.stereotype.Service;

import javax.annotation.Resource;

import java.util.List;

@Service

public class UserService {

    @Resource

    private UserMapper userMapper;

    //JPA的

    /*public List<User> users() {

        return userMapper.findAll();

    }*/

    public List<User> users(){

        return userMapper.findUser();

    }

}

4.第四步：将SpringbootApplication类改成下面这样

package com.oda.springboot;

import org.mybatis.spring.annotation.MapperScan;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.SpringBootApplication;

import org.springframework.boot.builder.SpringApplicationBuilder;

@SpringBootApplication

@MapperScan("com.oda.springboot.dao")

public class SpringbootApplication {

    protected SpringApplicationBuilder configure(SpringApplicationBuilder application) {

         return application.sources(SpringbootApplication.class);

    }

    public static void main(String[] args) {

        SpringApplication.run(SpringbootApplication.class, args);

    }

}

启动，访问http://localhost:8080/zm/users

极简配置（就是sql用xml文件写）

5.第五步：在resources包下新建mapper包，在其下新建userMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>

        <!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.oda.springboot.dao.UserMapper">

    <select id="findUser" resultType="com.oda.springboot.bean.User">

        select *

        from user

    </select>

</mapper>

6.第六步：在application.yml中添加

mybatis:

  mapper-locations: classpath:mapper/*.xml

启动，访问http://localhost:8080/zm/users