添加mybatis pom.xml依赖
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.0</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency>
添加application.properties mysql配置
spring.datasource.url=jdbc:mysql://localhost:3306/test?useSSL=false&useUnicode=true&characterEncoding=utf-8 spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=com.mysql.jdbc.Driver
mysql test库中创建account表,springboot添加account model类
@Component public class Account { private int id ; private String name ; private double money; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public double getMoney() { return money; } public void setMoney(double money) { this.money = money; } }
创建DAO层接口
import com.example.demo.domain.Account; import org.apache.ibatis.annotations.*; import org.mapstruct.Mapper; import org.springframework.stereotype.Component; import org.springframework.stereotype.Repository; import java.util.List; /** * @Author 冯战魁 * @Date 2018/1/23 上午9:59 */ @Mapper @Component(value = "accountMapper") public interface AccountMapper { @Insert("insert into account(name, money) values(#{name}, #{money})") int add(@Param("name") String name, @Param("money") double money); @Update("update account set name = #{name}, money = #{money} where id = #{id}") int update(@Param("name") String name, @Param("money") double money, @Param("id") int id); @Delete("delete from account where id = #{id}") int delete(int id); @Select("select id, name as name, money as money from account where id = #{id}") Account findAccount(@Param("id") int id); @Select("select id, name as name, money as money from account") List<Account> findAccountList(); }
入口文件加入@MapperScan扫描接口的路径
@SpringBootApplication @MapperScan("com.example.demo.repository") public class DemoApplication { public static void main(String[] args) { SpringApplication.run(DemoApplication.class, args); } }
添加操作接口
import com.example.demo.repository.AccountMapper; import com.example.demo.domain.Account; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.List; /** * @Author 冯战魁 * @Date 2018/1/23 上午10:12 */ @RestController @RequestMapping("/account") public class AccountController { @Autowired AccountMapper accountMapper; @RequestMapping("list") public List<Account> getAccounts() { return accountMapper.findAccountList(); } @RequestMapping(value = "/{id}", method = RequestMethod.GET) public Account getAccountById(@PathVariable("id") int id) { return accountMapper.findAccount(id); } @RequestMapping(value = "/{id}", method = RequestMethod.PUT) public String updateAccount(@PathVariable("id") int id, @RequestParam(value = "name", required = true) String name, @RequestParam(value = "money", required = true) double money) { int t= accountMapper.update(name,money,id); if(t==1) { return "success"; }else { return "fail"; } } @RequestMapping(value = "/{id}", method = RequestMethod.DELETE) public String delete(@PathVariable(value = "id")int id) { int t= accountMapper.delete(id); if(t==1) { return "success"; }else { return "fail"; } } @RequestMapping(value = "", method = RequestMethod.POST) public String postAccount(@RequestParam(value = "name") String name, @RequestParam(value = "money") double money) { int t= accountMapper.add(name,money); if(t==1) { return "success"; }else { return "fail"; } } }
springboot整合mybatis
原创文章标签 springboot mybatis 文章分类 前端开发
-
MyBatis-Plus整合SpringBoot及使用
MyBatis-Plus整合SpringBoot及使用
MyBatis-Plus MyBatis-Plus的简单使用 -
springboot整合mybatis
1.使用数据库是mysql,首先是在application.properties配置文件中添加mysql的配置文件#mysqlspring.datasource.url=jdbc:mysql://127.0.0.1:3306/sshespring.datasource.username=rootspring.datasource.password=rootspring.data
springboot mybatis springboot和mybatis整合 springboot整合mybatis mybatis整合springboot spring