springboot第十三节springboot整合mybatis，postman测试使用

一、数据库导入

-- create table &＃96;account&＃96;
# DROP TABLE &＃96;account&＃96; IF EXISTS
CREATE TABLE &＃96;account&＃96; (&＃96;id&＃96; int(11) NOT NULL AUTO_INCREMENT,&＃96;name&＃96; varchar(20) NOT NULL,&＃96;money&＃96; double DEFAULT NULL,PRIMARY KEY (&＃96;id&＃96;)
) ENGINE&＃61;InnoDB AUTO_INCREMENT&＃61;4 DEFAULT CHARSET&＃61;utf8;
INSERT INTO &＃96;account&＃96; VALUES (&＃39;1&＃39;, &＃39;aaa&＃39;, &＃39;1000&＃39;);
INSERT INTO &＃96;account&＃96; VALUES (&＃39;2&＃39;, &＃39;bbb&＃39;, &＃39;1000&＃39;);
INSERT INTO &＃96;account&＃96; VALUES (&＃39;3&＃39;, &＃39;ccc&＃39;, &＃39;1000&＃39;);

二&＃xff1a;添加依赖

org.mybatis.spring.bootmybatis-spring-boot-starter1.3.0org.springframework.bootspring-boot-starter-webmysqlmysql-connector-javaruntimecom.alibabadruid1.0.29org.springframework.bootspring-boot-starter-testtest


三、controller层

package com.forezp.web;import com.forezp.entity.Account;
import com.forezp.service.AccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;import java.util.List;/*** Created by fangzhipeng on 2017/4/20.*/
&＃64;RestController
&＃64;RequestMapping("/account")
public class AccountController {&＃64;AutowiredAccountService accountService;
/* http://127.0.0.1:8080/account/list*/&＃64;RequestMapping(value &＃61; "/list", method &＃61; RequestMethod.GET)public List getAccounts() {return accountService.findAccountList();}&＃64;RequestMapping(value &＃61; "/{id}", method &＃61; RequestMethod.GET)public Account getAccountById(&＃64;PathVariable("id") int id) {return accountService.findAccount(id);}/* http://127.0.0.1:8080/account/2 输入name和money 然后可以更新&＃xff0c;put方法*/&＃64;RequestMapping(value &＃61; "/{id}", method &＃61; RequestMethod.PUT)public String updateAccount(&＃64;PathVariable("id") int id, &＃64;RequestParam(value &＃61; "name", required &＃61; true) String name,&＃64;RequestParam(value &＃61; "money", required &＃61; true) double money) {int t&＃61; accountService.update(name,money,id);if(t&＃61;&＃61;1) {return "success";}else {return "fail";}}&＃64;RequestMapping(value &＃61; "/{id}", method &＃61; RequestMethod.DELETE)public String delete(&＃64;PathVariable(value &＃61; "id")int id) {int t&＃61; accountService.delete(id);if(t&＃61;&＃61;1) {return "success";}else {return "fail";}}&＃64;RequestMapping(value &＃61; "", method &＃61; RequestMethod.POST)public String postAccount(&＃64;RequestParam(value &＃61; "name") String name,&＃64;RequestParam(value &＃61; "money") double money) {int t&＃61; accountService.add(name,money);if(t&＃61;&＃61;1) {return "success";}else {return "fail";}}}

代码示例&＃xff1a;https://gitee.com/dgx555/springboot.git