Springboot集成MyBatis進行開發

1. 引入相關的依賴

 <dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.11</version>
    <scope>test</scope>
  </dependency>
​
  <!--引⼊springboot的web⽀持-->
  <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
  </dependency>
​
  <!--引入MySQL的依賴-->
  <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.38</version>
  </dependency>
  <!--引入mybatis整合springboot所使用的依賴-->
  <dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.2</version>
  </dependency>
  <!--springboot連接資料庫的驅動jar-->
  <dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.12</version>
  </dependency>
</dependencies>

　　2.配置application.yml

# spring整合MyBatis配置
spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource  #連接所使用的數據源
    driver-class-name: com.mysql.jdbc.Driver #所使用的驅動類
    url: jdbc:mysql://locahost:3306/mybatis1?charsetEncoding=UTF-8
    username: root
    password: root
    
# 配置mapper文件所在的包
mybatis:
  mapper-locations: classpath:com/wd/mapper/*.xml

       application.java

//聲明當前文件是一個springboot應用的入口類
@SpringBootApplication    //修飾範圍：用在類上 標識是springboot的入口類 這個註釋只能出現一次
@MapperScan("com.wd.dao") //用來指定Dao介面所在的位置
public class Application {
        public static void main(String[] args) {
            //運行springboot的核心方式
            SpringApplication.run(Application.class,args);
        }
}

public interface Userdao {
    List<user> findAllUser();
    user findUserById(@Param("id") int id);
}

　　mapper文件：編寫方法的實現

<mapper namespace="com.wd.dao.Userdao">
    <select id="findAllUser" resultType="com.wd.entity.user">
        select * from t_user
    </select>
​
    <select id="findUserById" resultType="com.wd.entity.user">
        select * from t_user where id=#{id}
    </select>
</mapper>

public interface UserService {
    List<user> findAllUser();
    user findUserById(int id);
}

　　serviceImpl：service介面的實現類，實現介面

@Service  //代表在工廠中創建有個service對象
@Transactional //當前類是支持事務的
public class UserServiceImpl implements UserService{
    @Resource
    private Userdao userDao;
​
    @Override
    public List<user> findAllUser() {
        return userDao.findAllUser();
    }
​
    @Override
    public user findUserById(int id) {
        return userDao.findUserById(id);
    }
}

@RestController
@RequestMapping("/user")
public class usercontroller {
    @Resource
    private UserService userService;
​
    @RequestMapping("/users")
    public List<user>  findUsers(){
        System.out.println("************");
        return userService.findAllUser();
    }
​
    /**
     * 查詢單個用戶方法
     * @return：單個用戶對象
     * @PathVaribale:代表接收路徑中所包含的參數
     */
    @RequestMapping("/users/{id}")
    public user findUserById(@PathVariable("id") int id){
        System.out.println("id="+ id);
        return userService.findUserById(id);
    }
}

@RequestMapping("/users/{id}") public user findUserById(@PathVariable("id") int id){ ​ }

本文來自博客園，作者：爾爾er，轉載請註明原文鏈接：https://www.cnblogs.com/erer123/p/17310121.html