Spring Boot（1）集成MyBatis的简单使用

需要的东西

1.IntelliJ IDEA里面的spring initializer

2.Mysql的实例数据库sakila

3.自己创建几个文件夹

属性配置文件

#application.property

mybatis.type-aliases-package=com.example.boot.domain

spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/sakila
spring.datasource.username = root
spring.datasource.password = 123456

设置MyBatis的自动Mapper扫描

@SpringBootApplication
//使用Java配置，在org.mybatis.spring包下，提供整合
@MapperScan("com.example.boot.dao")
public class BootApplication {

    public static void main(String[] args) {
        SpringApplication.run(BootApplication.class, args);
    }
}

新建一个实体类

public class Actor {

    public Actor() {
    }

    private int id;

    private String firstName;

    private String lastName;

    ...省略getter/setter方法
}

新建Mapper

/*数据格式是这样的，我们省略last_update这一列
+----------+-------------+--------------+---------------------+
| actor_id | first_name  | last_name    | last_update         |
+----------+-------------+--------------+---------------------+
|        1 | PENELOPE    | GUINESS      | 2006-02-15 04:34:33 |
|        2 | NICK        | WAHLBERG     | 2006-02-15 04:34:33 |
*/

public interface ActorMapper {

    @Select("select actor_id,first_name,last_name from actor")
    @Results({
            @Result(id = true, column = "actor_id", property = "id"),
            @Result(column = "first_name", property = "firstName"),
            @Result(column = "last_name", property = "lastName")
    })
    List<Actor> findAllActors();

    @Select("select actor_id,first_name,last_name from actor " +
            "where actor_id = #{id}")
    @Results({
            @Result(id = true, column = "actor_id", property = "id"),
            @Result(column = "first_name", property = "firstName"),
            @Result(column = "last_name", property = "lastName")
    })
    Actor findActorById(int id);

}

写一个单元测试看看效果

@RunWith(SpringRunner.class)
@SpringBootTest
public class BootApplicationTests {

    @Autowired
    private ActorMapper mapper;

    @Test
    public void databaseTest() {
        Actor a = mapper.findActorById(1);
        System.out.println(a.getLastName()+" "+a.getFirstName());
    }

}

Spring boot将DataSource自动注入SqlSessionFactory, 再将SqlSessionFactory自动注入到Mapper里面，所以，这居然就能用了？？！！

最后写个网页看看效果

@RestController //不要写html，就看看
public class TestController {

    @Autowired
    ActorMapper mapper;

    @RequestMapping
    public String hello(){
        Actor actor = mapper.findActorById(2);
        return actor.getFirstName()+"-"+actor.getLastName();
    }

}