spring boot 简单配置 mybatis-优快云博客

本文详细介绍了如何在SpringBoot项目中集成MyBatis框架，包括pom.xml配置依赖、application.properties设置数据库连接参数、编写接口文件实现数据操作、控制台SQL语句打印调试等步骤。

1.pom.xml 加入

<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.45</version>
</dependency>

2.
application.properties 加入

spring.datasource.url=jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
spring.datasource.username=root
spring.datasource.password=密码
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

3.写接口文件

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface TcCodeMapper {
@Select("SELECT * FROM tc_code WHERE code_id = #{id}")
TcCode findByID(@Param("id") Integer id);
}

4.调用:

@Controller
public class HelloController
{
@Autowired
private TcCodeMapper tccode;

@Autowired
private ApplicationContext ctx;

@GetMapping("/hello")
@ResponseBody
public String hello()
{
return "Hello World";

}

@GetMapping("/test")
@ResponseBody
public String test()
{
Logger logger = LoggerFactory.getLogger(MainApp.class);
String result = this.tccode.findByID(10001001).toString();
logger.info(result);
return result;
}