springboot集成mybatis

一、pom文件中加入mybatis和mysql的依赖：

        <dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!-- mybatis依赖 -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>

</dependency>

二、编写实体类：

public class ChineseEntity {
private int id;
private int score;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getScore() {
return score;
}
public void setScore(int score) {
this.score = score;
}

}

三、编写mapper接口：

public interface TestMapper {
@Select("SELECT * FROM chinese WHERE id = #{id}")
ChineseEntity findById(@Param("id") int id);

}

四、编写controller类：

@RestController
public class MyBatisController {
@Autowired
private TestMapper testMapper;
@RequestMapping("/mybatisTest")
@ResponseBody
public ChineseEntity jdbctemplateTest(int id) {
return testMapper.findById(id);
}

}

五：编写主函数运行类：

@ComponentScan(basePackages={"com.wcj.controller","com.wcj.service"})
@MapperScan(basePackages="com.wcj.mapper") //注：这里必须加入mapper的扫描
@EnableAutoConfiguration
public class App {

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

}

六、运行如图：