本文主要讲解mall整合SpringBoot+MyBatis搭建基本骨架，以商品品牌为例实现基本的CRUD操作及通过PageHelper实现分页查询。

mysql数据库环境搭建

下载并安装mysql5.7版本，下载地址：https://dev.mysql.com/downloads/installer/

设置数据库帐号密码：root root

下载并安装客户端连接工具Navicat,下载地址：http://www.formysql.com/xiazai.html

创建数据库mall

导入mall的数据库脚本，脚本地址：https://github.com/macrozheng/mall-learning/blob/master/document/sql/mall.sql

项目使用框架介绍

SpringBoot

SpringBoot可以让你快速构建基于Spring的Web应用程序，内置多种Web容器(如Tomcat)，通过启动入口程序的main函数即可运行。

PagerHelper

MyBatis分页插件，简单的几行代码就能实现分页，在与SpringBoot整合时，只要整合了PagerHelper就自动整合了MyBatis。

PageHelper.startPage(pageNum,pageSize);//之后进行查询操作将自动进行分页List<PmsBrand>brandList=brandMapper.selectByExample(newPmsBrandExample());//通过构造PageInfo对象获取分页信息，如当前页码，总页数，总条数PageInfo<PmsBrand>pageInfo=newPageInfo<PmsBrand>(list);Copy to clipboardErrorCopied

Druid

alibaba开源的数据库连接池，号称Java语言中最好的数据库连接池。

Mybatis generator

MyBatis的代码生成器，可以根据数据库生成model、mapper.xml、mapper接口和Example，通常情况下的单表查询不用再手写mapper。

项目搭建

使用IDEA初始化一个SpringBoot项目

添加项目依赖

在pom.xml中添加相关依赖。

<parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>2.1.3.RELEASE</version><relativePath/><!-- lookup parent from repository --></parent><dependencies><!--SpringBoot通用依赖模块--><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-actuator</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-aop</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><!--MyBatis分页插件--><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper-spring-boot-starter</artifactId><version>1.2.10</version></dependency><!--集成druid连接池--><dependency><groupId>com.alibaba</groupId><artifactId>druid-spring-boot-starter</artifactId><version>1.1.10</version></dependency><!-- MyBatis 生成器 --><dependency><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-core</artifactId><version>1.3.3</version></dependency><!--Mysql数据库驱动--><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.15</version></dependency></dependencies>Copy to clipboardErrorCopied

修改SpringBoot配置文件

在application.yml中添加数据源配置和MyBatis的mapper.xml的路径配置。

server:

  port: 8080

spring:

  datasource:

    url: jdbc:mysql://localhost:3306/mall?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai

    username: root

    password: root

mybatis:

  mapper-locations:

    - classpath:mapper/*.xml

    - classpath*:com/**/mapper/*.xmlCopy to clipboardErrorCopied

项目结构说明

Mybatis generator 配置文件

配置数据库连接，Mybatis generator生成model、mapper接口及mapper.xml的路径。

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE generatorConfiguration

        PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"

        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"><generatorConfiguration><propertiesresource="generator.properties"/><contextid="MySqlContext"targetRuntime="MyBatis3"defaultModelType="flat"><propertyname="beginningDelimiter"value="`"/><propertyname="endingDelimiter"value="`"/><propertyname="javaFileEncoding"value="UTF-8"/><!-- 为模型生成序列化方法--><plugintype="org.mybatis.generator.plugins.SerializablePlugin"/><!-- 为生成的Java模型创建一个toString方法 --><plugintype="org.mybatis.generator.plugins.ToStringPlugin"/><!--可以自定义生成model的代码注释--><commentGeneratortype="com.macro.mall.tiny.mbg.CommentGenerator"><!-- 是否去除自动生成的注释 true：是 ： false:否 --><propertyname="suppressAllComments"value="true"/><propertyname="suppressDate"value="true"/><propertyname="addRemarkComments"value="true"/></commentGenerator><!--配置数据库连接--><jdbcConnectiondriverClass="${jdbc.driverClass}"connectionURL="${jdbc.connectionURL}"userId="${jdbc.userId}"password="${jdbc.password}"><!--解决mysql驱动升级到8.0后不生成指定数据库代码的问题--><propertyname="nullCatalogMeansCurrent"value="true"/></jdbcConnection><!--指定生成model的路径--><javaModelGeneratortargetPackage="com.macro.mall.tiny.mbg.model"targetProject="mall-tiny-01\src\main\java"/><!--指定生成mapper.xml的路径--><sqlMapGeneratortargetPackage="com.macro.mall.tiny.mbg.mapper"targetProject="mall-tiny-01\src\main\resources"/><!--指定生成mapper接口的的路径--><javaClientGeneratortype="XMLMAPPER"targetPackage="com.macro.mall.tiny.mbg.mapper"targetProject="mall-tiny-01\src\main\java"/><!--生成全部表tableName设为%--><tabletableName="pms_brand"><generatedKeycolumn="id"sqlStatement="MySql"identity="true"/></table></context></generatorConfiguration>Copy to clipboardErrorCopied

运行Generator的main函数生成代码

packagecom.macro.mall.tiny.mbg;importorg.mybatis.generator.api.MyBatisGenerator;importorg.mybatis.generator.config.Configuration;importorg.mybatis.generator.config.xml.ConfigurationParser;importorg.mybatis.generator.internal.DefaultShellCallback;importjava.io.InputStream;importjava.util.ArrayList;importjava.util.List;/**

* 用于生产MBG的代码

* Created by macro on 2018/4/26.

*/publicclassGenerator{publicstaticvoidmain(String[]args)throwsException{//MBG 执行过程中的警告信息List<String>warnings=newArrayList<String>();//当生成的代码重复时，覆盖原代码booleanoverwrite=true;//读取我们的 MBG 配置文件InputStreamis=Generator.class.getResourceAsStream("/generatorConfig.xml");ConfigurationParsercp=newConfigurationParser(warnings);Configurationconfig=cp.parseConfiguration(is);is.close();DefaultShellCallbackcallback=newDefaultShellCallback(overwrite);//创建 MBGMyBatisGeneratormyBatisGenerator=newMyBatisGenerator(config,callback,warnings);//执行生成代码myBatisGenerator.generate(null);//输出警告信息for(Stringwarning:warnings){System.out.println(warning);}}}Copy to clipboardErrorCopied

添加MyBatis的Java配置

用于配置需要动态生成的mapper接口的路径

packagecom.macro.mall.tiny.config;importorg.mybatis.spring.annotation.MapperScan;importorg.springframework.context.annotation.Configuration;/**

* MyBatis配置类

* Created by macro on 2019/4/8.

*/@Configuration@MapperScan("com.macro.mall.tiny.mbg.mapper")publicclassMyBatisConfig{}Copy to clipboardErrorCopied

实现Controller中的接口

实现PmsBrand表中的添加、修改、删除及分页查询接口。

packagecom.macro.mall.tiny.controller;importcom.macro.mall.tiny.common.api.CommonPage;importcom.macro.mall.tiny.common.api.CommonResult;importcom.macro.mall.tiny.mbg.model.PmsBrand;importcom.macro.mall.tiny.service.PmsBrandService;importorg.slf4j.Logger;importorg.slf4j.LoggerFactory;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Controller;importorg.springframework.validation.BindingResult;importorg.springframework.web.bind.annotation.*;importjava.util.List;/**

* 品牌管理Controller

* Created by macro on 2019/4/19.

*/@Controller@RequestMapping("/brand")publicclassPmsBrandController{@AutowiredprivatePmsBrandServicedemoService;privatestaticfinalLoggerLOGGER=LoggerFactory.getLogger(PmsBrandController.class);@RequestMapping(value="listAll",method=RequestMethod.GET)@ResponseBodypublicCommonResult<List<PmsBrand>>getBrandList(){returnCommonResult.success(demoService.listAllBrand());}@RequestMapping(value="/create",method=RequestMethod.POST)@ResponseBodypublicCommonResultcreateBrand(@RequestBodyPmsBrandpmsBrand){CommonResultcommonResult;intcount=demoService.createBrand(pmsBrand);if(count==1){commonResult=CommonResult.success(pmsBrand);LOGGER.debug("createBrand success:{}",pmsBrand);}else{commonResult=CommonResult.failed("操作失败");LOGGER.debug("createBrand failed:{}",pmsBrand);}returncommonResult;}@RequestMapping(value="/update/{id}",method=RequestMethod.POST)@ResponseBodypublicCommonResultupdateBrand(@PathVariable("id")Longid,@RequestBodyPmsBrandpmsBrandDto,BindingResultresult){CommonResultcommonResult;intcount=demoService.updateBrand(id,pmsBrandDto);if(count==1){commonResult=CommonResult.success(pmsBrandDto);LOGGER.debug("updateBrand success:{}",pmsBrandDto);}else{commonResult=CommonResult.failed("操作失败");LOGGER.debug("updateBrand failed:{}",pmsBrandDto);}returncommonResult;}@RequestMapping(value="/delete/{id}",method=RequestMethod.GET)@ResponseBodypublicCommonResultdeleteBrand(@PathVariable("id")Longid){intcount=demoService.deleteBrand(id);if(count==1){LOGGER.debug("deleteBrand success :id={}",id);returnCommonResult.success(null);}else{LOGGER.debug("deleteBrand failed :id={}",id);returnCommonResult.failed("操作失败");}}@RequestMapping(value="/list",method=RequestMethod.GET)@ResponseBodypublicCommonResult<CommonPage<PmsBrand>>listBrand(@RequestParam(value="pageNum",defaultValue="1")IntegerpageNum,@RequestParam(value="pageSize",defaultValue="3")IntegerpageSize){List<PmsBrand>brandList=demoService.listBrand(pageNum,pageSize);returnCommonResult.success(CommonPage.restPage(brandList));}@RequestMapping(value="/{id}",method=RequestMethod.GET)@ResponseBodypublicCommonResult<PmsBrand>brand(@PathVariable("id")Longid){returnCommonResult.success(demoService.getBrand(id));}}Copy to clipboardErrorCopied

添加Service接口

packagecom.macro.mall.tiny.service;importcom.macro.mall.tiny.mbg.model.PmsBrand;importjava.util.List;/**

* PmsBrandService

* Created by macro on 2019/4/19.

*/publicinterfacePmsBrandService{List<PmsBrand>listAllBrand();intcreateBrand(PmsBrandbrand);intupdateBrand(Longid,PmsBrandbrand);intdeleteBrand(Longid);List<PmsBrand>listBrand(intpageNum,intpageSize);PmsBrandgetBrand(Longid);}Copy to clipboardErrorCopied

实现Service接口

packagecom.macro.mall.tiny.service.impl;importcom.github.pagehelper.PageHelper;importcom.macro.mall.tiny.mbg.mapper.PmsBrandMapper;importcom.macro.mall.tiny.mbg.model.PmsBrand;importcom.macro.mall.tiny.mbg.model.PmsBrandExample;importcom.macro.mall.tiny.service.PmsBrandService;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Service;importjava.util.List;/**

* PmsBrandService实现类

* Created by macro on 2019/4/19.

*/@ServicepublicclassPmsBrandServiceImplimplementsPmsBrandService{@AutowiredprivatePmsBrandMapperbrandMapper;@OverridepublicList<PmsBrand>listAllBrand(){returnbrandMapper.selectByExample(newPmsBrandExample());}@OverridepublicintcreateBrand(PmsBrandbrand){returnbrandMapper.insertSelective(brand);}@OverridepublicintupdateBrand(Longid,PmsBrandbrand){brand.setId(id);returnbrandMapper.updateByPrimaryKeySelective(brand);}@OverridepublicintdeleteBrand(Longid){returnbrandMapper.deleteByPrimaryKey(id);}@OverridepublicList<PmsBrand>listBrand(intpageNum,intpageSize){PageHelper.startPage(pageNum,pageSize);returnbrandMapper.selectByExample(newPmsBrandExample());}@OverridepublicPmsBrandgetBrand(Longid){returnbrandMapper.selectByPrimaryKey(id);}}