主要是依赖的版本一定要对，版本不对，一堆一堆的问题，真是服了
项目结构（main不用管）
SQL结构和数据
DROP TABLE IF EXISTS `demo`; CREATE TABLE `demo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT INTO `demo` VALUES ('1', '0', 'A'); INSERT INTO `demo` VALUES ('2', '1', 'B'); INSERT INTO `demo` VALUES ('3', '1', 'C'); INSERT INTO `demo` VALUES ('4', '2', 'D'); INSERT INTO `demo` VALUES ('5', '2', 'E'); INSERT INTO `demo` VALUES ('6', '3', 'F'); INSERT INTO `demo` VALUES ('7', '3', 'G');
Pom文件
<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.1</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.39</version> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.2.0</version> </dependency>
application.properties文件
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/tree spring.datasource.username=root spring.datasource.password=1234 spring.datasource.driver-class-name=com.mysql.jdbc.Driver TreeMapper @Mapper public interface TreeMapper { @Select("select * from demo") List<Tree> getAll(); }
TreeController
@Controller public class TreeController { @Resource TreeMapper treeMapper; @RequestMapping(value = "/tree",method = {RequestMethod.GET}) @ResponseBody public List<Tree> getAll(){ List<Tree> list = treeMapper.getAll(); System.out.println(list); return list; } }
启动项目，并在地址栏输入如下地址即可
