Spring boot集成mybatis和MySQL实现基础服务

1、首先，需要准备好相关的数据库环境如我准备的mysql数据库信息如下1）创建数据库DB名：videoDBmysql> create database videoDB;2）数据库表： video_infocreate table video_info(id INT NOT NULL AUTO_INCREMENT,fileName varchar(255) NOT NULL,filePath varchar(255) ,author varchar(128) ,createDate datetime ,PRIMARY KEY (id))ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

3、在工程中添加mybatis的库依赖mybatis-spring-boot-startermybatis-spring-boot-start髫潋啜缅er可以自动检测DataSource------------------------- <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.1</version> </dependency>

5、创建一个Service服务类：VideoServicepackage image.dao挢旗扦渌;import org.spri荏鱿胫协ngframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;@Service("videoService")public class VideoService { //自动绑定mapper @Autowired private VideoInfoMapper videoInfoMapper; //查询数据 public VideoInfo getVideoInfo(int id) { return videoInfoMapper.findById(id); }}