springboot 简单mysql demo配置,mybatis-plus配置使用,PageHelper分页demo

1、按老规矩给出demo 地址:

先给 git 网址:https://github.com/kinber123/mysql.git

也提供免费CSDN 下载地址:https://download.csdn.net/download/wcy18818429914/12458344

2、基本项目框架

 

3、mysql 配置

(1)引入jar 包,pom.xml

        <!-- mysql connector -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.24</version>
            <scope>runtime</scope>
        </dependency>

 (2)application.yml 配置

#端口号
server:
  port: 8082

#mysql 配置
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/oneself?useUnicode=true&characterEncoding=utf8
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
mybatis:
  mapper-locations: classpath:mapper/*.xml
  typeAliasesPackage: com.example.demo.entity

 

(3)在数据库添加数据

INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (1, 'wcy1', 1, 'YsB3ev9tTbAWxSWrtvk43fWMaR08fm9D');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (2, 'wx1', 1, '8SpvZlmoW5SVRkIeFacVsvZv5QBqyEYK');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (3, 'zwh1', 0, 'ZG2GgCaAqBaV68LjOPuHGnZjUuFTcncS');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (4, 'wcy2', 1, 'IPd3BrpcmB4iVoT0nHzA5NseL2Ijf6ae');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (5, 'wx2', 1, 'AxPESVUiQkTi8dhiUU6BPnzAVncV9iye');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (6, 'zwh2', 0, '06rKmbRwUfHLedDOixQfb1aFvuFuITY3');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (7, 'wcy3', 1, 'ajgidvE5A48ISgyIUsCADbuc6mv7sx0C');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (8, 'wx3', 1, '4XoOKEBPx8k6TZ4tb82vWlRfyzX6y62u');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (9, 'zwh3', 0, 'xy5w1YIvyVQFmNnI3tbRJJD0yhciUWyu');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (10, 'wcy4', 1, 'VZhQdOEbXHGZGp1gcGKULzXePLlfuMyj');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (11, 'wx5', 1, 'RLPyWh25WRSJOBo0hF0VUHsmxlwhq2Xu');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (12, 'zwh6', 0, 'wCtkhycsdjo58owwLOPYyqaJOM1KR0yF');

 

(4)实体类,数据库接口,mapper 如下

package com.example.demo.entity;

/**
 * \* @author wcy
 * \* @date: 2020-05-22 17:29
 * \* Description:  类
 * \
 */
public class Student {

    /**
     *     // id 号
     */
    private Integer id ;
    /**
     *     // 名字
     */
    private String name;
    /**
     *     // 性别
     */
    private Byte sex;
    /**
     *     // 学号
     */
    private String numberId;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Byte getSex() {
        return sex;
    }

    public void setSex(Byte sex) {
        this.sex = sex;
    }

    public String getNumberId() {
        return numberId;
    }

    public void setNumberId(String numberId) {
        this.numberId = numberId;
    }
}

 

package com.example.demo.dao;


import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.example.demo.entity.Student;
import com.github.pagehelper.Page;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * \* @author wcy
 * \* @date: 2020-05-22 17:29
 * \* Description: 接口
 * \
 */
@Mapper
public interface StudentDao extends BaseMapper<Student> {

    /**
     * 自己写MAPPER
     * @return
     */
    List<Student> getAllMapper();
}
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.example.demo.dao.StudentDao">
    <resultMap id="BaseResultMap" type="com.example.demo.entity.Student">
        <id column="id" property="id" jdbcType="INTEGER"/>
        <result column="name" property="name" jdbcType="VARCHAR"/>
        <result column="sex" property="sex" jdbcType="INTEGER"/>
        <result column="number_id" property="numberId" jdbcType="VARCHAR"/>
    </resultMap>

    <sql id="Base_Column_List">
        id, name, sex, number_id
    </sql>

    <select id="getAllMapper" resultMap="BaseResultMap">
        SELECT
        <include refid="Base_Column_List"/>
        FROM student
    </select>



</mapper>

 

(5) 写个controller 类测试

package com.example.demo.controller;

import com.example.demo.entity.PageEntity;
import com.example.demo.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * \* @author wcy
 * \* @date: 2020-05-22 17:30
 * \* Description:  类
 * \
 */
@RestController
public class StudentController {


    @Autowired
    private StudentService studentService;

    /**
     * 自己写的mapper
     * @return
     */
    @RequestMapping("/getAllMapper")
    public Object getAllMapper(){
        return  studentService.getAllMapper();
    }

    @RequestMapping("/test")
    public  Object test(){
        return "成功了";
    }

}

(6)显示结果:http://localhost:8082/getAllMapper

4、mybatis-plus配置使用

(1)引入jar 包,pom.xml

        <!-- mysql connector -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.24</version>
            <scope>runtime</scope>
        </dependency>
        <!-- mybatis-plus -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>2.3</version>
        </dependency>

 (2)application.yml 配置

#端口号
server:
  port: 8082

#mysql 配置
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/oneself?useUnicode=true&characterEncoding=utf8
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver

#mybatis 配置
mybatis-plus:
   type-aliases-package: com.example.demo.entity
   mapper-locations: classpath*:mapper/*Mapper.xml
  global-config:
    db-config:
      id-type: auto
      field-strategy: not_empty
        #驼峰下划线转换
      column-underline: true
        #逻辑删除配置
      logic-delete-value: 0
      logic-not-delete-value: 1
      db-type: mysql
    refresh: false
  configuration:
    map-underscore-to-camel-case: true
    cache-enabled: false

 

(3)在数据库添加数据

INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (1, 'wcy1', 1, 'YsB3ev9tTbAWxSWrtvk43fWMaR08fm9D');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (2, 'wx1', 1, '8SpvZlmoW5SVRkIeFacVsvZv5QBqyEYK');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (3, 'zwh1', 0, 'ZG2GgCaAqBaV68LjOPuHGnZjUuFTcncS');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (4, 'wcy2', 1, 'IPd3BrpcmB4iVoT0nHzA5NseL2Ijf6ae');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (5, 'wx2', 1, 'AxPESVUiQkTi8dhiUU6BPnzAVncV9iye');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (6, 'zwh2', 0, '06rKmbRwUfHLedDOixQfb1aFvuFuITY3');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (7, 'wcy3', 1, 'ajgidvE5A48ISgyIUsCADbuc6mv7sx0C');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (8, 'wx3', 1, '4XoOKEBPx8k6TZ4tb82vWlRfyzX6y62u');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (9, 'zwh3', 0, 'xy5w1YIvyVQFmNnI3tbRJJD0yhciUWyu');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (10, 'wcy4', 1, 'VZhQdOEbXHGZGp1gcGKULzXePLlfuMyj');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (11, 'wx5', 1, 'RLPyWh25WRSJOBo0hF0VUHsmxlwhq2Xu');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (12, 'zwh6', 0, 'wCtkhycsdjo58owwLOPYyqaJOM1KR0yF');

 

(4)实体类,数据库接口,mapper 如下

package com.example.demo.entity;

/**
 * \* @author wcy
 * \* @date: 2020-05-22 17:29
 * \* Description:  类
 * \
 */
public class Student {

    /**
     *     // id 号
     */
    private Integer id ;
    /**
     *     // 名字
     */
    private String name;
    /**
     *     // 性别
     */
    private Byte sex;
    /**
     *     // 学号
     */
    private String numberId;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Byte getSex() {
        return sex;
    }

    public void setSex(Byte sex) {
        this.sex = sex;
    }

    public String getNumberId() {
        return numberId;
    }

    public void setNumberId(String numberId) {
        this.numberId = numberId;
    }
}

 

package com.example.demo.dao;


import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.example.demo.entity.Student;
import com.github.pagehelper.Page;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * \* @author wcy
 * \* @date: 2020-05-22 17:29
 * \* Description: 接口
 * \
 */
@Mapper
public interface StudentDao extends BaseMapper<Student> {

    /**
     * 自己写MAPPER
     * @return
     */
    List<Student> getAllMapper();

  
}
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.example.demo.dao.StudentDao">
    <resultMap id="BaseResultMap" type="com.example.demo.entity.Student">
        <id column="id" property="id" jdbcType="INTEGER"/>
        <result column="name" property="name" jdbcType="VARCHAR"/>
        <result column="sex" property="sex" jdbcType="INTEGER"/>
        <result column="number_id" property="numberId" jdbcType="VARCHAR"/>
    </resultMap>

    <sql id="Base_Column_List">
        id, name, sex, number_id
    </sql>

    <select id="getAllMapper" resultMap="BaseResultMap">
        SELECT
        <include refid="Base_Column_List"/>
        FROM student
    </select>



</mapper>

 

(5) 写个controller 类测试

package com.example.demo.controller;

import com.example.demo.entity.PageEntity;
import com.example.demo.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * \* @author wcy
 * \* @date: 2020-05-22 17:30
 * \* Description:  类
 * \
 */
@RestController
public class StudentController {


    @Autowired
    private StudentService studentService;

    /**
     * mybatis-plus 自动调用的
     * @return
     */
    @RequestMapping("/getAll")
    public  Object getAll(){
        return studentService.getAll();
    }

    /**
     * 自己写的mapper
     * @return
     */
    @RequestMapping("/getAllMapper")
    public Object getAllMapper(){
        return  studentService.getAllMapper();
    }

    @RequestMapping("/test")
    public  Object test(){
        return "成功了";
    }

}

(6)显示结果:http://localhost:8082/getAll

 

5、PageHelper分页demo

 

(1)引入jar 包,pom.xml

        <!-- mysql connector -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.24</version>
            <scope>runtime</scope>
        </dependency>
        <!-- mybatis-plus -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>2.3</version>
        </dependency>
        <!-- json 格式-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.60</version>
        </dependency>
        <!--  pagehelper 实现分页-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.13</version>
        </dependency>

 (2)application.yml 配置

#端口号
server:
  port: 8082

#mysql 配置
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/oneself?useUnicode=true&characterEncoding=utf8
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver

#mybatis 配置
mybatis-plus:
   type-aliases-package: com.example.demo.entity
   mapper-locations: classpath*:mapper/*Mapper.xml
  global-config:
    db-config:
      id-type: auto
      field-strategy: not_empty
        #驼峰下划线转换
      column-underline: true
        #逻辑删除配置
      logic-delete-value: 0
      logic-not-delete-value: 1
      db-type: mysql
    refresh: false
  configuration:
    map-underscore-to-camel-case: true
    cache-enabled: false

 

(3)在数据库添加数据

INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (1, 'wcy1', 1, 'YsB3ev9tTbAWxSWrtvk43fWMaR08fm9D');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (2, 'wx1', 1, '8SpvZlmoW5SVRkIeFacVsvZv5QBqyEYK');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (3, 'zwh1', 0, 'ZG2GgCaAqBaV68LjOPuHGnZjUuFTcncS');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (4, 'wcy2', 1, 'IPd3BrpcmB4iVoT0nHzA5NseL2Ijf6ae');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (5, 'wx2', 1, 'AxPESVUiQkTi8dhiUU6BPnzAVncV9iye');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (6, 'zwh2', 0, '06rKmbRwUfHLedDOixQfb1aFvuFuITY3');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (7, 'wcy3', 1, 'ajgidvE5A48ISgyIUsCADbuc6mv7sx0C');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (8, 'wx3', 1, '4XoOKEBPx8k6TZ4tb82vWlRfyzX6y62u');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (9, 'zwh3', 0, 'xy5w1YIvyVQFmNnI3tbRJJD0yhciUWyu');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (10, 'wcy4', 1, 'VZhQdOEbXHGZGp1gcGKULzXePLlfuMyj');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (11, 'wx5', 1, 'RLPyWh25WRSJOBo0hF0VUHsmxlwhq2Xu');
INSERT INTO `student` (`id`, `name`, `sex`, `number_id`) VALUES (12, 'zwh6', 0, 'wCtkhycsdjo58owwLOPYyqaJOM1KR0yF');

 

(4)实体类,数据库接口,mapper 如下

package com.example.demo.entity;

/**
 * \* @author wcy
 * \* @date: 2020-05-22 17:29
 * \* Description:  类
 * \
 */
public class Student {

    /**
     *     // id 号
     */
    private Integer id ;
    /**
     *     // 名字
     */
    private String name;
    /**
     *     // 性别
     */
    private Byte sex;
    /**
     *     // 学号
     */
    private String numberId;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Byte getSex() {
        return sex;
    }

    public void setSex(Byte sex) {
        this.sex = sex;
    }

    public String getNumberId() {
        return numberId;
    }

    public void setNumberId(String numberId) {
        this.numberId = numberId;
    }
}

 

package com.example.demo.dao;


import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.example.demo.entity.Student;
import com.github.pagehelper.Page;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * \* @author wcy
 * \* @date: 2020-05-22 17:29
 * \* Description: 接口
 * \
 */
@Mapper
public interface StudentDao extends BaseMapper<Student> {

    /**
     * 自己写MAPPER
     * @return
     */
    List<Student> getAllMapper();

    /**
     * 分页查询
     * @return
     */
    List<Student> getUserList();

    /**
     * 分页查询
     * @return
     */
    Page<Student> getUserListPage();
}
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.example.demo.dao.StudentDao">
    <resultMap id="BaseResultMap" type="com.example.demo.entity.Student">
        <id column="id" property="id" jdbcType="INTEGER"/>
        <result column="name" property="name" jdbcType="VARCHAR"/>
        <result column="sex" property="sex" jdbcType="INTEGER"/>
        <result column="number_id" property="numberId" jdbcType="VARCHAR"/>
    </resultMap>

    <sql id="Base_Column_List">
        id, name, sex, number_id
    </sql>

    <select id="getAllMapper" resultMap="BaseResultMap">
        SELECT
        <include refid="Base_Column_List"/>
        FROM student
    </select>

    <select id="getUserList" resultMap="BaseResultMap">
        SELECT
        <include refid="Base_Column_List"/>
        FROM student
    </select>

    <select id="getUserListPage" resultMap="BaseResultMap">
        SELECT
        <include refid="Base_Column_List"/>
        FROM student
    </select>


</mapper>

 

(5) 实现PageEntity 类

package com.example.demo.entity;

/**
 * \* @author wcy
 * \* @date: 2020-05-25 16:22
 * \* Description:  类
 * \
 */
public class PageEntity {

    private Integer page;

    private Integer rows;

    public Integer getPage() {
        return page;
    }

    public void setPage(Integer page) {
        this.page = page;
    }

    public Integer getRows() {
        return rows;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }
}

(6) 写个controller 类测试

package com.example.demo.controller;

import com.example.demo.entity.PageEntity;
import com.example.demo.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * \* @author wcy
 * \* @date: 2020-05-22 17:30
 * \* Description:  类
 * \
 */
@RestController
public class StudentController {


    @Autowired
    private StudentService studentService;

    /**
     * mybatis-plus 自动调用的
     * @return
     */
    @RequestMapping("/getAll")
    public  Object getAll(){
        return studentService.getAll();
    }

    /**
     * 自己写的mapper
     * @return
     */
    @RequestMapping("/getAllMapper")
    public Object getAllMapper(){
        return  studentService.getAllMapper();
    }

    /**
     * pagehelper 分页查询1
     * @return
     */
    @RequestMapping("/getUserList")
    public Object getUserList(PageEntity page){
        return  studentService.getUserList(page);
    }

    /**
     * pagehelper 分页查询2
     * @return
     */
    @RequestMapping("/getUserListPage")
    public Object getUserListPage(PageEntity page ){
        return  studentService.getUserListPage(page);
    }

    @RequestMapping("/test")
    public  Object test(){
        return "成功了";
    }

}

(6)显示结果:http://localhost:8082/getUserListPage?page=1&rows=5

 

 

 

注:有疑问,请留言。谢谢

 

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值