mybatis-plus 基本使用 -1

1.在pom.xml 文件中引入相应的jar 包

---

<!--这是springboot的启动jar-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-freemarker</artifactId>
</dependency>
<!--这是web 模块的jar-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--这是devtools-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-devtools</artifactId>
    <scope>runtime</scope>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter</artifactId>
</dependency>
<!--测试类的jar-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
</dependency>
<!--这是讲Bean类省略get和set方法的jar-->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <scope>provided</scope>
</dependency>
<!--这是mybatis的jar-->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.1.0</version>
</dependency>
<!--mysql数据库的jar-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

---

2.编写实体类

package com.ruanjian.bean;

import lombok.Data;

/**
 * @autohr 任浩,
 * @create 2019-02-26-9:22
 */
@Data
public class Student {
    private Integer id;
    private String name;
    private Integer age;
    private String email;


}

@Data 注解就是将Bean类的Get和Set方法省略

 

---

3.编写相关的Mapper

如查询全部;

package com.ruanjian.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruanjian.bean.Student;

/**
 * @autohr 任浩,
 * @create 2019-02-26-9:24
 */

public interface  UserMapper extends BaseMapper<Student> {
    /*查询所有User*/


}

 

集成的BaseMapper是myBatis-plus特有的,其中他的泛型<Student> 就是数据库的表名

 

---

4.相关的Controller

package com.ruanjian.controller;

import com.ruanjian.bean.Student;
import com.ruanjian.dao.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

/**
 * @autohr 任浩,
 * @create 2019-02-26-9:13
 */
/*用户Controller*/
@Controller
@RequestMapping(value = "/user", method = RequestMethod.GET)
public class UserController {
    @Autowired
    UserMapper userMapper;

    @ResponseBody
    @GetMapping("/all")
    public List<Student> selectAll() {
        System.out.println("进来");
        List<Student> users = userMapper.selectList(null);
        System.out.println("查到的结果为" + users);
        return users;
    }
}

---

5.数据库的配置

spring.datasource.username=root
spring.datasource.url=jdbc:mysql://localhost:3306/user?serverTimezone=GMT%2B8
spring.datasource.password=1234

---

6.这是页面拿到的结果