springboot整合mybatis

创建springboot项目请参考  创建基于maven的springboot项目

在pom.xml里添加如下依赖

<dependency>
   <groupId>org.mybatis.spring.boot</groupId>
   <artifactId>mybatis-spring-boot-starter</artifactId>
   <version>1.1.1</version>
</dependency>

<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
</dependency>

<dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-devtools</artifactId>
   <optional>true</optional>
</dependency>

在application.propreties里添加如下属性，其中url和username，password换成自己的数据库

mybatis.type-aliases-package=com.broder.entity

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?SSL=true&useUnicode=true&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=root

 编写代码测试

目录如下：

创建表

DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `productName` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `sale` decimal(10,0) DEFAULT NULL,
  `productId` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8

写入数据

INSERT INTO `products` VALUES ('扬州炒饭', '9.90', '86', '123456789', '/')

编写entity

public class Product {
    private String productName;
    private String productId;
    private Integer price;
    private Integer sale;
    private String image;

    public String getProductName() {
        return productName;
    }

    public void setProductName(String productName) {
        this.productName = productName;
    }

    public String getProductId() {
        return productId;
    }

    public void setProductId(String productId) {
        this.productId = productId;
    }

    public Integer getPrice() {
        return price;
    }

    public void setPrice(Integer price) {
        this.price = price;
    }

    public Integer getSale() {
        return sale;
    }

    public void setSale(Integer sale) {
        this.sale = sale;
    }

    public String getImage() {
        return image;
    }

    public void setImage(String image) {
        this.image = image;
    }
}

编写mapper

public interface ProductsMapper {
    @Select("select * from products")
    List<Product> products();
}

在启动类里添加注解@MapperScan（"mapper包路径"）

@SpringBootApplication
@MapperScan("com.broder.mappers")
public class BroderApplication {

   public static void main(String[] args) {
      SpringApplication.run(BroderApplication.class, args);
   }
}

编写测试类

@RunWith(SpringRunner.class)
@SpringBootTest
public class BroderApplicationTests {
   @Autowired
   private ProductsMapper productsMapper;
   @Test
   public void test(){
      System.out.print(productsMapper.products().get(0).getProductName());
   }
}

 测试 成功将在控制台输出“扬州炒饭”