add sql

houko · houko · commit 04f3e40d9bef · 2017-09-06T17:47:00.000+08:00
diff --git a/mybatis/USER.sql b/mybatis/USER.sql
@@ -0,0 +1,31 @@
+/*
+Navicat MySQL Data Transfer
+
+Source Server         : xiaomo2017(106.15.188.160)
+Source Server Version : 50717
+Source Host           : 106.15.188.160:3306
+Source Database       : xiaomo
+
+Target Server Type    : MYSQL
+Target Server Version : 50717
+File Encoding         : 65001
+
+Date: 2017-09-06 17:45:51
+*/
+
+SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+-- Table structure for USER
+-- ----------------------------
+DROP TABLE IF EXISTS `USER`;
+CREATE TABLE `USER` (
+  `id` bigint(20) DEFAULT NULL,
+  `name` varchar(255) DEFAULT NULL,
+  `age` int(11) DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- ----------------------------
+-- Records of USER
+-- ----------------------------
+INSERT INTO `USER` VALUES ('1', 'xiaomo', '25');
diff --git a/mybatis/src/main/java/info/xiaomo/mybatis/controller/MybatisUserController.java b/mybatis/src/main/java/info/xiaomo/mybatis/controller/MybatisUserController.java
@@ -35,7 +35,7 @@ public MybatisUserController(UserMapper userMapper) {
     }
 
 
-    @RequestMapping("findAll")
+    @RequestMapping("/")
     public Result<List<User>> findAll() {
         List<User> all = userMapper.findAll();
         return new Result<>(all);

Original file line number	Diff line number	Diff line change
`@@ -35,7 +35,7 @@ public MybatisUserController(UserMapper userMapper) {`
`35`	`35`	`}`
`36`	`36`
`37`	`37`
`38`		`- @RequestMapping("findAll")`
	`38`	`+ @RequestMapping("/")`
`39`	`39`	`public Result<List<User>> findAll() {`
`40`	`40`	`List<User> all = userMapper.findAll();`
`41`	`41`	`return new Result<>(all);`