首頁  >  文章  >  Java  >  Java中SpringBoot與2.SpringBoot整合Mybatis的實例

Java中SpringBoot與2.SpringBoot整合Mybatis的實例

黄舟
黄舟原創
2017-09-16 10:08:132142瀏覽

一、建立Springboot的設定檔:application.properties,並加入MyBatis依賴

SpringApplication 會從 application.properties 檔案中載入設定訊息,以下是新增Spring設定資訊的檔案目錄順序:


  1. #目前目錄下的/config子目錄中

  2. 目前目錄中

  3. 一個classpath 套件下的 /config 目錄中

  4. 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中文網其他相關文章!

陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn