一、SpringBoot搭建

①、建模块

Spring Web:集成ssm环境，搭服务器；

MyBatis Framework:集成MyBatis；

MySQL Driver:数据库;

②、yml文件

server:port: 8080

二、MBG逆向工程

1、连接数据库

 2、代码生成

①、导入逆向工程依赖

<!--逆向工程依赖-->
<dependency><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-core</artifactId><version>1.3.7</version>
</dependency><!--插件-->
<plugin><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-maven-plugin</artifactId><version>1.3.7</version><configuration><configurationFile><!--这里是配置generatorConfig.xml的路径 不写默认在resources目录下找generatorConfig.xml文件--></configurationFile><verbose>true</verbose><overwrite>true</overwrite></configuration>
</plugin>

②、导入配置文件

在resource包内：

Generator.properties:userSSL意思是非加密的；serverTimezone：时区；useUnicode：防止乱码；allowPublicKeyRetrieval：允许加密访问

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/aaa?userSSL=false&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&allowPublicKeyRetrieval=true
jdbc.username=root
jdbc.password=123456
jdbc.driverLocation=E:\\MavenCangku\\localCangKu\\mysql\\mysql-connector-java\\8.0.25\\mysql-connector-java-8.0.25.jarmodel.package=com.lv.code.pojo
mapper.package=com.lv.code.dao
xml.mapper.package=mapper

generatorConfig.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfigurationPUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN""http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"><generatorConfiguration><properties resource="generator.properties"/><!--指定数据库jdbc驱动jar包的位置--><classPathEntry location="${jdbc.driverLocation}"/><context id="MySqlContext" targetRuntime="MyBatis3" defaultModelType="flat"><property name="beginningDelimiter" value="`"/><property name="endingDelimiter" value="`"/><property name="javaFileEncoding" value="UTF-8"/><!--生成mapper.xml时覆盖原文件--><plugin type="org.mybatis.generator.plugins.UnmergeableXmlMappersPlugin"/><plugin type="org.mybatis.generator.plugins.MyBatisPlugin"><property name="hasLombok" value="true"/></plugin><!--可以自定义生成model的代码注释--><commentGenerator><property name="suppressAllComments" value="true"/> <!-- 是否取消注释 --><property name="suppressDate" value="true"/> <!-- 是否生成注释代时间戳 --></commentGenerator><!--配置数据库连接--><jdbcConnection driverClass="${jdbc.driver}"connectionURL="${jdbc.url}"userId="${jdbc.username}"password="${jdbc.password}"><!--解决mysql驱动升级到8.0后不生成指定数据库代码的问题--><property name="nullCatalogMeansCurrent" value="true"/></jdbcConnection><!-- 非必需，类型处理器，在数据库类型和java类型之间的转换控制--><javaTypeResolver><property name="forceBigDecimals" value="false"/></javaTypeResolver><!--指定pojo生成位置--><javaModelGenerator targetPackage="${model.package}" targetProject="src\main\java"/><!--指定生成mapper.xml的路径--><sqlMapGenerator targetPackage="${xml.mapper.package}" targetProject="src\main\resources"/><!--指定生成mapper接口的的路径--><javaClientGenerator type="XMLMAPPER"targetPackage="${mapper.package}"targetProject="src\main\java"/><table tableName="student" domainObjectName="Student"><!--<columnOverride column="create_time" javaType="java.sql.Timestamp" jdbcType="timestamp"/>--><!--<columnOverride column="modify_time" javaType="java.sql.Timestamp" jdbcType="timestamp"/>--><property name="enableCountByExample" value="false"/><property name="enableDeleteByExample" value="false"/><property name="enableDeleteByPrimaryKey" value="false"/><property name="enableInsert" value="false"/><property name="enableSelectByPrimaryKey" value="false"/><property name="enableUpdateByExample" value="false"/><property name="enableUpdateByPrimaryKey" value="false"/><property name="selectByExampleQueryId" value="true"/><property name="selectByPrimaryKeyQueryId" value="false"/><!--自动生成主键,可以代替useGeneratedKeys--><generatedKey column="stu_id" sqlStatement="Mysql" type="post" identity="true"/></table></context>
</generatorConfiguration>

③、生成表对象上的注解以及文档上的注释

在Java包内新建软件包，包名与此一致org.mybatis.generator.plugins

package org.mybatis.generator.plugins;import lombok.extern.slf4j.Slf4j;
import org.mybatis.generator.api.IntrospectedColumn;
import org.mybatis.generator.api.IntrospectedTable;
import org.mybatis.generator.api.Plugin;
import org.mybatis.generator.api.PluginAdapter;
import org.mybatis.generator.api.dom.java.*;import java.time.LocalDateTime;
import java.util.List;/*** @author hgh*/
@Slf4j
public class MyBatisPlugin extends PluginAdapter {@Overridepublic boolean validate(List<String> list) {return true;}//    生成类上面的注释@Overridepublic boolean modelBaseRecordClassGenerated(TopLevelClass topLevelClass, IntrospectedTable introspectedTable) {boolean hasLombok = Boolean.parseBoolean(getProperties().getProperty("hasLombok", "false"));log.warn("hasLombok:\t" + hasLombok);if (hasLombok) {topLevelClass.addImportedType("lombok.Data");topLevelClass.addImportedType("lombok.NoArgsConstructor");topLevelClass.addImportedType("lombok.AllArgsConstructor");topLevelClass.addImportedType("lombok.experimental.Accessors");topLevelClass.addAnnotation("@Data");topLevelClass.addAnnotation("@NoArgsConstructor");topLevelClass.addAnnotation("@AllArgsConstructor");topLevelClass.addAnnotation("@Accessors(chain = true)");}topLevelClass.addJavaDocLine("/**");String remarks = introspectedTable.getRemarks();log.error("@table\t" + remarks);topLevelClass.addJavaDocLine(" * "+remarks + "\t" + introspectedTable.getFullyQualifiedTable());topLevelClass.addJavaDocLine(" * @author lv");topLevelClass.addJavaDocLine(" * @date " + LocalDateTime.now());topLevelClass.addJavaDocLine(" */");return true;}//    生成在每个字段上面的注释@Overridepublic boolean modelFieldGenerated(Field field, TopLevelClass topLevelClass, IntrospectedColumn introspectedColumn, IntrospectedTable introspectedTable, ModelClassType modelClassType) {field.addJavaDocLine("/**");String remarks = introspectedColumn.getRemarks();log.error("@column\t" + remarks);field.addJavaDocLine(" * " + remarks);field.addJavaDocLine(" */");return true;}//    生成接口注解@Overridepublic boolean clientGenerated(Interface interfaze, TopLevelClass topLevelClass, IntrospectedTable introspectedTable) {interfaze.addImportedType(new FullyQualifiedJavaType("org.apache.ibatis.annotations.Mapper"));interfaze.addAnnotation("@Mapper");interfaze.addImportedType(new FullyQualifiedJavaType("org.springframework.stereotype.Repository"));interfaze.addAnnotation("@Repository");interfaze.addJavaDocLine("/**");interfaze.addJavaDocLine(" * @author hgh");interfaze.addJavaDocLine(" * @date " + LocalDateTime.now());interfaze.addJavaDocLine(" */");return true;}//    模型是否需要生成set方法@Overridepublic boolean modelSetterMethodGenerated(Method method, TopLevelClass topLevelClass, IntrospectedColumn introspectedColumn, IntrospectedTable introspectedTable, ModelClassType modelClassType) {boolean hasLombok = Boolean.parseBoolean(getProperties().getProperty("hasLombok", "false"));return !hasLombok;}//    模型是否需要生成get方法@Overridepublic boolean modelGetterMethodGenerated(Method method, TopLevelClass topLevelClass, IntrospectedColumn introspectedColumn, IntrospectedTable introspectedTable, ModelClassType modelClassType) {boolean hasLombok = Boolean.parseBoolean(getProperties().getProperty("hasLombok", "false"));return !hasLombok;}}

将这个类的编译文件丢到pom.xml文件所指的mybatis-generator-core文件内相应版本的jar包里面去：

首先执行一下文件，获得编译文件： 

 将此文件丢到本地仓库中：E:\MavenCangku\localCangKu\org\mybatis\generator\mybatis-generator-core\1.3.7

 放入plugins文件内：

 ④、执行生成代码

双击：

成功生成：

 3、配置数据源、mybatis

application.yml文件：

server:port: 8080
#  配置数据源
spring:datasource:username: rootpassword: 123456driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/aaa?userSSL=false&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&allowPublicKeyRetrieval=true
#配置mybatis,开启别名,开启驼峰命名法
mybatis:mapper-locations: classpath*:mapper/*.xmltype-aliases-package: com.lv.code.pojoconfiguration:map-underscore-to-camel-case: true
#  日志打印
logging:level:com.lv.code.dao: debug

4、查询表数据

StudentMapper.java:

package com.lv.code.dao;import com.lv.code.pojo.Student;
import com.lv.code.pojo.StudentExample;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;/*** @author lv* @date 2022-01-20T18:59:38.176*/
@Mapper
@Repository
public interface StudentMapper {List<Student> select();}

StudentMapper.xml:

 <select id="select" resultType="com.lv.code.pojo.Student">select * from student</select>

测试：SpringBoot03ApplicationTests.java

package com.lv.code;import com.lv.code.dao.StudentMapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;import javax.sql.DataSource;@SpringBootTest
class SpringBoot03ApplicationTests {@AutowiredDataSource dataSource;@AutowiredStudentMapper mapper;@Testvoid contextLoads() throws Exception{System.out.println(dataSource);
//        得到连接System.out.println(dataSource.getConnection());System.out.println(mapper.select());}}

三、SSM开发

StudentService：

package com.lv.code.service;import com.lv.code.pojo.Student;
import com.lv.code.util.PageBean;import java.util.List;public interface StudentService {List<Student> selectPager(PageBean pageBean);Student selectOne(Student student);int add(Student student);int del(Student student);int upd(Student student);}

StudentServiceImpl：

package com.lv.code.service;import com.lv.code.dao.StudentMapper;
import com.lv.code.pojo.Student;
import com.lv.code.util.PageBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;import java.util.List;@Service
public class StudentServiceImpl implements StudentService {private StudentMapper mapper;@Autowiredpublic StudentServiceImpl(StudentMapper mapper){this.mapper=mapper;}@Override@Transactional(rollbackFor = Exception.class)public List<Student> selectPager(PageBean pageBean) {return mapper.select();}@Override@Transactional(rollbackFor = Exception.class)public Student selectOne(Student student) {return mapper.selectOne(student);}@Override@Transactional(rollbackFor = Exception.class)public int add(Student student) {return mapper.add(student);}@Override@Transactional(rollbackFor = Exception.class)public int del(Student student) {return mapper.del(student);}@Override@Transactional(rollbackFor = Exception.class)public int upd(Student student) {return mapper.upd(student);}
}

StudentMapper.java:

package com.lv.code.dao;import com.lv.code.pojo.Student;import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;/*** @author lv* @date 2022-01-20T18:59:38.176*/@Repository
public interface StudentMapper {List<Student> select();Student selectOne(Student student);int add(Student student);int del(Student student);int upd(Student student);}

StudentController.java:

package com.lv.code.controller;import com.lv.code.pojo.Student;
import com.lv.code.service.StudentService;
import com.lv.code.util.PageBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;import javax.servlet.http.HttpServletRequest;@RestController
@RequestMapping("/stu")
public class StudentController {//    restful架构
//请求：get拿数据；post新增；delete删除；put、patch修改StudentService service;@Autowiredpublic StudentController(StudentService service){this.service=service;}@GetMappingpublic Object select(HttpServletRequest request){PageBean pageBean=new PageBean();pageBean.setRequest(request);return service.selectPager(pageBean);}@GetMapping("/{stuId}")public Object selectOne(@PathVariable Long stuId){return service.selectOne(new Student().setStuId(stuId));}@DeleteMapping("/{stuId}")public Object del(@PathVariable Long stuId){return service.del(new Student().setStuId(stuId));}@PostMappingpublic Object add(Student student){return service.add(student);}@PutMappingpublic Object upd(Student student){return service.upd(student);}}

StudentMapper.xml:

<?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.lv.code.dao.StudentMapper"><resultMap id="BaseResultMap" type="com.lv.code.pojo.Student"><id column="stu_id" jdbcType="BIGINT" property="stuId" /><result column="stu_name" jdbcType="VARCHAR" property="stuName" /><result column="stu_phone" jdbcType="VARCHAR" property="stuPhone" /><result column="stu_class" jdbcType="BIGINT" property="stuClass" /><result column="stu_address" jdbcType="VARCHAR" property="stuAddress" /></resultMap><select id="select" resultType="com.lv.code.pojo.Student">select * from student</select><select id="selectOne" resultType="com.lv.code.pojo.Student">select * from student where stu_id=#{stuId}</select><insert id="add">insert into student(stu_name, stu_phone, stu_class,stu_address)values (#{stuName},#{stuPhone},#{stuClass},#{stuAddress})</insert><delete id="del">delete from student where stu_id=#{stuId}</delete><update id="upd">update student set stu_name=#{stuName} where stu_id=#{stuId}</update></mapper>

SpringBoot03Application：启动事务管理器

@EnableTransactionManagement

四、集成PageHelper

导入依赖：

<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-aop</artifactId>
</dependency>
<dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper-spring-boot-starter</artifactId><version>1.2.10</version>
</dependency>

启动类SpringBoot03Application.java：打开自动代理

@EnableAspectJAutoProxy

PageBean.java:

package com.lv.code.util;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;import javax.servlet.http.HttpServletRequest;
import java.util.Map;/*** @author 银喾*/
@Data
@NoArgsConstructor
@AllArgsConstructor
public class PageBean {private int total;private int page = 1;private int rows = 5;private boolean pagination = true;private String url;private Map<String, String[]> ms;public void setMs(Map<String, String[]> ms) {this.ms = ms;}public int calcStartIndex() {return (page - 1) * rows;}public int calcMaxPage() {return total % rows == 0 ? total / rows : total / rows + 1;}public int nextPage() {return Math.min(page + 1, calcMaxPage());}public int prevPage() {return Math.max(page - 1, 1);}public void setRequest(HttpServletRequest req) {setUrl(req.getRequestURL().toString());setMs(req.getParameterMap());String page = req.getParameter("page");if (page == null) {setPage(1);} else {setPage(Integer.parseInt(page));}String rows = req.getParameter("rows");if (rows == null) {setRows(5);} else {setRows(Integer.parseInt(rows));}String pagination = req.getParameter("pagination");if ("false".equals(pagination)) {setPagination(false);}}}

分页切面：PageAspect.java

package com.lv.code.aspect;import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.yk.code.util.PageBean;
import lombok.extern.slf4j.Slf4j;
import org.aspectj.lang.ProceedingJoinPoint;
import org.aspectj.lang.annotation.Around;
import org.aspectj.lang.annotation.Aspect;
import org.springframework.stereotype.Component;/*** @author yk*/
@Component
@Aspect
@Slf4j
public class PageAspect {@Around(value = "execution(* *..*Service.*Pager(..))")public Object invoke(ProceedingJoinPoint point) throws Throwable {PageBean pageBean = null;for (Object e : point.getArgs()) {if (e instanceof PageBean) {pageBean = (PageBean) e;break;}}if (pageBean != null && pageBean.isPagination()) {PageHelper.startPage(pageBean.getPage(), pageBean.getRows());}Object obj = point.proceed(point.getArgs());if (obj != null) {if (obj instanceof Page) {Page page = (Page) obj;PageInfo pageInfo = new PageInfo(page);pageBean.setTotal(new Long(pageInfo.getTotal()).intValue());return pageInfo.getList();}}return obj;}}

改变方法，使用分页：

StudentServiceImpl：

  @Override@Transactional(rollbackFor = Exception.class)public List<Student> selectPager(PageBean pageBean) {return mapper.select();}

StudentService:

List<Student> selectPager(PageBean pageBean);

StudentController:

 @GetMappingpublic Object select(HttpServletRequest request){PageBean pageBean=new PageBean();pageBean.setRequest(request);return service.selectPager(pageBean);}

五、集成通用mapper

1、导入依赖

<dependency><groupId>tk.mybatis</groupId><artifactId>mapper-spring-boot-starter</artifactId><version>2.0.2</version>
</dependency>

2、在启动类启动：直接实现包名，其mapper文件就无需每个都写@mapper注解

//自动扫描mapper文件
@MapperScan("com.lv.code.dao")

 可自动生成方法，将xml内的sql语句去掉，mapper内也无需写方法，只有继承mapper

但可调用方法：

System.out.println(mapper.selectAll());
//查询单个System.out.println(mapper.selectByPrimaryKey(new Student().setStuId(1L)));
//        基准查询System.out.println(mapper.select(new Student().setStuName("马可波罗")));
//        模糊查询Example example=new Example(Student.class);Example.Criteria c=example.createCriteria();c.andLike("stuName","'%马%'");mapper.selectByExample(example);

结果：

 

 基础接口：

setDistinct(boolean distinct) 查询的结果是否要进行唯一性过滤，true表示过滤，false（默
认）表示不过滤。
Criteria
void setOrderByClause(String orderByClause) 查询结果按照某个，或者某些字段进行升序，降
序。
比如参数是 “id asc” 就是按照 id 进行升序，“id asc，age desc” 就是按照 id 升序，在 id 相等
的情况下，按照 age 降序。
Example selectProperties(String... properties) 当利用 example 进行查询时，此方法可以
设置想要查询的字段是哪些
Example.OrderBy orderBy(String property) 排序，与 setOrderByClause 功能一样，只是
用法不同
比如 orderBy("id").asc() 表示按照 id 升序，
orderBy("id").asc().orderBy("age").desc() 表示按照 id 升序，再按照 age 降序
Example.Criteria or() 创建一个 or 方式的、空的criteria
void or(Example.Criteria criteria) 直接以 or 的方式添加一个现有的 criteria
Example.Criteria and() 同上，不过是 and 方式
void and(Example.Criteria criteria) 同上，and 方式

criteria.andIsNull(字段名);
添加字段xx为null的条件
criteria.andIsNotNull(字段名);
添加字段xx不为null的条件
criteria.andEqualTo(字段名,value);
添加xx字段等于value条件
criteria.andNotEqualTo(字段名,value);
添加xx字段不等于value条件
criteria.andGreaterThan(字段名,value);
添加xx字段大于value条件
criteria.andGreaterThanOrEqualTo(字段名,value);
添加xx字段大于等于value条件
criteria.andLessThan(字段名,value);
添加xx字段小于value条件
criteria.andLessThanOrEqualTo(字段名,value);
添加xx字段小于等于value条件
criteria.andIn(字段名,list);
添加xx字段值在List条件
criteria.andNotIn(字段名,list);
添加xx字段值不在List条件
criteria.andLike(字段名,“%”+value+”%”);
添加xx字段值为value的模糊查询条件
criteria.andNotLike(字段名,“%”+value+”%”);
Condition
添加xx字段值不为 value的模糊查询条件
criteria.andBetween(字段名,value1,value2);
添加xx字段值在value1和value2之间条件
criteria.andNotBetween(字段名,value1,value2);
添加xx字段值不在value1和value2之间条件
Example.Criteria orCondition(String condition, Object value) condition参数是个
sql字符串，可以拼接进 sql 语句的，value 是一个值，会拼接到 condition 后面的，此方法的最终结
果为 or condition + value。
Example.Criteria orCondition(String condition) 功能同上，只是更加直接，一个字符串搞
定，只是字符串参数可以写成类似这种 “id = ”+getId()，"( id = "+getId()+")"，一样灵活，此方
法的最终结果为 or condition。
Example.Criteria andCondition(String condition) 同上
Example.Criteria andCondition(String condition, Object value) 同上

3、表注解

①、依赖：

<dependency><groupId>javax.persistence</groupId><artifactId>persistence-api</artifactId><version>1.0</version><scope>compile</scope>
</dependency>

②、在实体类直接指定表的表名、属性名：

@Table(name = "student")
//在对应的属性指定数据库属性名
@Column(name = "stu_id")

@Table(name="tb_brand") 指定要映射的数据库中的哪个表
@Id 表示该成员变量是主键id
@GeneratedValue(strategy = GenerationType.IDENTITY) 标识该主键的策略,自增
@Column(name = "name") 标识该成员变量跟数据库中的name字段映射
@Transient 不是表字段

本期内容结束~~~~~~~~