一、建立Springboot的設定檔:application.properties,並加入MyBatis依賴
SpringApplication 會從
application.properties
檔案中載入設定訊息,以下是新增Spring設定資訊的檔案目錄順序:
#目前目錄下的/config子目錄中
目前目錄中
一個classpath 套件下的 /config
目錄中
classpath 根目錄中
大家依照自己習慣來即可。
(1)application.properties 檔案設定如下:
spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.datasource.url=jdbc:mysql://127.0.0.1/test spring.datasource.username=root spring.datasource.password=root
(2)新增MyBatis 以及MYSQL
<!-- SpringBoot - MyBatis --> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.2.0</version> </dependency> <!-- Mysql --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency>
二、建立POJO、Mapper、Service 以及Controler
(1)User.java
package org.rcddup.app.domain;public class User { private Long id; private String name; private Short age; private Short status; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Short getAge() { return age; } public void setAge(Short age) { this.age = age; } public Short getStatus() { return status; } public void setStatus(Short status) { this.status = status; } }
(2)UserMapper .java
package org.rcddup.app.dao; import java.util.List; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; import org.rcddup.app.domain.User; @Mapperpublic interface UserMapper { @Select("select id, name, age, status from user") List<User> listUser(); @Select("select id, name, age, status from user where id=#{id}") User getUserById(Long id); }
(3)IUserService.java
package org.rcddup.app.service; import java.util.List; import org.rcddup.app.domain.User; public interface IUserService { List<User> listUser(); User getUserById(Long id); }
(4)UserService.java
package org.rcddup.app.service.impl; import java.util.List; import org.rcddup.app.dao.UserMapper; import org.rcddup.app.domain.User; import org.rcddup.app.service.IUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @Servicepublic class UserService implements IUserService{ @Autowired private UserMapper userMapper; @Override public List<User> listUser() { return userMapper.listUser(); } @Override public User getUserById(Long id) { return userMapper.getUserById(id); } }
(5)UserController.java
package org.rcddup.app.web.controller; import java.util.List; import org.rcddup.app.domain.User; import org.rcddup.app.service.IUserService;import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; @RestController @RequestMapping("/user")public class UserController { @Autowired private IUserService userService; @RequestMapping("/list") public List<User> list() { return userService.listUser(); } @RequestMapping("/get") public User list(Long id) { return userService.getUserById(id); } }
重新啟動App.java
輸入:http:/ /localhost:8080/user/get?id=1
# 輸入:http://localhost:8080/user/list
## 到此,SpringBoot整合Mybatis就成功了。
以上是Java中SpringBoot與2.SpringBoot整合Mybatis的實例的詳細內容。更多資訊請關注PHP中文網其他相關文章!