第一步添加注解
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
给一段代码例子
@Select("SELECT * FROM user WHERE id=#{id}")
@Results({
@Result(property = "id", column = "id", id = true),
@Result(property = "name", column = "name"),
@Result(property = "age", column = "age")
})
User getUserById(@Param("id") Long id);
@Insert("INSERT INTO user(name, age) VALUES(#{name}, #{age})")
void saveUser(User user);
@Update("UPDATE user SET name=#{name}, age=#{age} WHERE id=#{id}")
void updateUser(User user);
@Delete("DELETE FROM user WHERE id=#{id}")
void removeUser(@Param("id") Long id);
其中@select()中写的是查询语句,@Result写的是返回语句。property是指的是你entity中的定义的参数,column是指你数据库中字段名,其它的照着写就行。